Skip to content

Live Sessions Schema

Live session definitions.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
course_iduuidYES—
instructor_iduuidNO—
titletextNO—
descriptiontextYES—
starts_attimestamptzNO—
duration_minutesintegerNO60
ended_attimestamptzYES—
providertextNO'link'
room_idtextYES—
join_urltextYES—
host_urltextYES—
statustextNO'scheduled'
capacityintegerYES—
attendee_countintegerNO0
recording_urltextYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Session attendance records.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
session_iduuidNO—
user_iduuidNO—
joined_attimestamptzNOnow()
left_attimestamptzYES—
duration_secondsintegerYES—
statustextNO'present'
created_attimestamptzNOnow()

Available time slots for 1:1 meetings.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
instructor_iduuidNO—
day_of_weekintegerNO—
start_timetimeNO—
end_timetimeNO—
duration_minutesintegerNO30
pricenumericNO0
is_activebooleanNOtrue
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Booked meetings between instructors and students.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
instructor_iduuidNO—
student_iduuidNO—
slot_iduuidYES—
payment_iduuidYES—
starts_attimestamptzNO—
duration_minutesintegerNO30
join_urltextYES—
statustextNO'pending'
notetextYES—
cancelled_byuuidYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()