0 rows


Stores courses assigned to a particular plan


Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_dp_plan_course_assign_id_seq'::regclass)
planid int8 19 null Defined in XMLR
courseid int8 19 null Defined in XMLR
priority int8 19 null Defined in XMLR
duedate int8 19 null
approved int2 5 0
reasonfordecision text 2147483647 null
completionstatus int8 19 null Defined in XMLR
grade numeric 10,5 null
manual int2 5 0


Constraint Name Type Sort Column(s)
app_dpplancourassi_id_pk Primary key Asc id
app_dpplancourassi_com_ix Performance Asc completionstatus
app_dpplancourassi_cou_ix Performance Asc courseid
app_dpplancourassi_pla_ix Performance Asc planid
app_dpplancourassi_placou_uix Must be unique Asc/Asc planid + courseid
app_dpplancourassi_pri_ix Performance Asc priority