course_completion_crit_compl

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

userid

BIGINT

19

0

course

BIGINT

19

0

course.id

course_completion_crit_compl_erd_course_idR

criteriaid

BIGINT

19

0

gradefinal

DECIMAL

10,5

√

null

unenroled

BIGINT

19

√

null

timecompleted

BIGINT

19

√

null

Showing 1 to 7 of 7 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
courcompcritcomp_cou2_ix	Performance	Asc	course
courcompcritcomp_cri2_ix	Performance	Asc	criteriaid
courcompcritcomp_tim2_ix	Performance	Asc	timecompleted
courcompcritcomp_use2_ix	Performance	Asc	userid
courcompcritcomp_usecoucr2_uix	Must be unique	Asc/Asc/Asc	userid + course + criteriaid

Showing 1 to 6 of 6 entries

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation