draft_course

377 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 8 null
draft_course_content.course_id draft_course_content_course_id_fkey R
name varchar 128 √ null
group_ids _varchar 2147483647 √ null
start_time timestamptz 35,6 √ null
end_time timestamptz 35,6 √ null
status varchar 16 null
description varchar 512 √ null
varchar 512 √ null
total_score int4 10 √ null
passing_score_percentage int4 10 √ null
created_by varchar 64 null
user.userid draft_course_created_by_fkey R
customer_id varchar 8 null
customer.id draft_course_customer_id_fkey R
course_category varchar 128 null
completion_criteria varchar 128 √ null
reveal_answers bool 1 √ null
number_of_attempts int4 10 √ null
created_at timestamptz 35,6 √ now()
updated_at timestamptz 35,6 √ now()

Indexes

Constraint Name Type Sort Column(s)
draft_course_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation