Live Sessions Schema

sessions

Live session definitions.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
course_id	uuid	YES	—
instructor_id	uuid	NO	—
title	text	NO	—
description	text	YES	—
starts_at	timestamptz	NO	—
duration_minutes	integer	NO	60
ended_at	timestamptz	YES	—
provider	text	NO	'link'
room_id	text	YES	—
join_url	text	YES	—
host_url	text	YES	—
status	text	NO	'scheduled'
capacity	integer	YES	—
attendee_count	integer	NO	0
recording_url	text	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

attendance

Session attendance records.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
session_id	uuid	NO	—
user_id	uuid	NO	—
joined_at	timestamptz	NO	now()
left_at	timestamptz	YES	—
duration_seconds	integer	YES	—
status	text	NO	'present'
created_at	timestamptz	NO	now()

meeting_slots

Available time slots for 1:1 meetings.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
instructor_id	uuid	NO	—
day_of_week	integer	NO	—
start_time	time	NO	—
end_time	time	NO	—
duration_minutes	integer	NO	30
price	numeric	NO	0
is_active	boolean	NO	true
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

meeting_bookings

Booked meetings between instructors and students.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
instructor_id	uuid	NO	—
student_id	uuid	NO	—
slot_id	uuid	YES	—
payment_id	uuid	YES	—
starts_at	timestamptz	NO	—
duration_minutes	integer	NO	30
join_url	text	YES	—
status	text	NO	'pending'
note	text	YES	—
cancelled_by	uuid	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()