app_prog_courseset

0 rows


Description

Stores details of the sets of courses and competencies contained within a program

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_prog_courseset_id_seq'::regclass)
app_prog_completion.coursesetid Defined in XMLR
app_prog_completion_history.coursesetid Defined in XMLR
app_prog_courseset_course.coursesetid Defined in XMLR
app_prog_messagelog.coursesetid Defined in XMLR
programid int8 19 0
app_prog.id Defined in XMLR
sortorder int8 19 0
competencyid int8 19 0
nextsetoperator int2 5 0
completiontype int2 5 0
mincourses int2 5 0
coursesumfield int8 19 0
app_course_info_field.id Defined in XMLR
coursesumfieldtotal int2 5 0
timeallowed int8 19 0
recurrencetime int8 19 0
recurcreatetime int8 19 0
contenttype int2 5 0
label varchar 255 √ ''::character varying
certifpath int2 5 √ 1

Indexes

Constraint Name Type Sort Column(s)
app_progcour_id_pk Primary key Asc id
app_progcour_cou_ix Performance Asc coursesumfield
app_progcour_pro2_ix Performance Asc programid
app_progcour_pro_ix Performance Asc programid

Relationships

Close relationships within degrees of separation