app_course_completion_crit_compl

0 rows


Description

Course completion user records

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_course_completion_crit_compl_id_seq'::regclass)
userid int8 19 0
course int8 19 0
criteriaid int8 19 0
gradefinal numeric 10,5 null
unenroled int8 19 null
rpl varchar 255 null
timecompleted int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_courcompcritcomp_id_pk Primary key Asc id
app_courcompcritcomp_cou_ix Performance Asc course
app_courcompcritcomp_cri_ix Performance Asc criteriaid
app_courcompcritcomp_tim_ix Performance Asc timecompleted
app_courcompcritcomp_use_ix Performance Asc userid
app_courcompcritcomp_useco_uix Must be unique Asc/Asc/Asc userid + course + criteriaid

Relationships