app_course_completions

0 rows

Description

Course completion records

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

bigserial

19

√

nextval('app_course_completions_id_seq'::regclass)

app_dp_plan_course_assign.completionstatus

Defined in XMLR

userid

int8

19

0

course

int8

19

0

organisationid

int8

19

√

null

positionid

int8

19

√

null

timeenrolled

int8

19

0

timestarted

int8

19

0

timecompleted

int8

19

√

null

reaggregate

int8

19

0

rpl

varchar

255

√

null

Showing 1 to 10 of 14 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
app_courcomp_id_pk	Primary key	Asc	id
app_courcomp_cou_ix	Performance	Asc	course
app_courcomp_sta_ix	Performance	Asc	status
app_courcomp_tim_ix	Performance	Asc	timecompleted
app_courcomp_use_ix	Performance	Asc	userid
app_courcomp_usecou_uix	Must be unique	Asc/Asc	userid + course

Showing 1 to 6 of 6 entries

Relationships

Close relationships within degrees of separation

One
Two degrees