tbl_enrollment

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
enrollment_id bigserial 19 √ nextval('tbl_enrollment_enrollment_id_seq'::regclass)
tbl_chapter_progress.enrollment_id tbl_chapter_progress_enrollment_id_fkey C
course_id int8 19 null
tbl_course.course_id tbl_enrollment_course_id_fkey C
enrollment_date timestamp 29,6 √ null
status varchar 20 √ null
progress numeric 5,2 √ 0.0
expiry_date timestamp 29,6 √ null
employee_id varchar 50 √ null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
is_mandatory bool 1 √ null
completed_date timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_enrollment_pkey Primary key Asc enrollment_id

Check Constraints

Constraint Name Constraint
tbl_enrollment_status_check (((status)::text = ANY (ARRAY[('ENROLLED'::character varying)::text, ('IN_PROGRESS'::character varying)::text, ('COMPLETED'::character varying)::text, ('FAILED'::character varying)::text])))

Relationships

Close relationships within degrees of separation