user_enrolments

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

status

BIGINT

19

0

0..9 are system constants, 0 means active participation, see ENROL_PARTICIPATION_* constants, plugins may define own status greater than 10

enrolid

BIGINT

19

null

enrol.id

userenro_enr2_fkR

userid

BIGINT

19

null

user.id

userenro_use2_fkR

timestart

BIGINT

19

0

timeend

BIGINT

19

2147483647

modifierid

BIGINT

19

0

user.id

userenro_mod2_fkR

timecreated

BIGINT

19

0

timemodified

BIGINT

19

0

Showing 1 to 9 of 9 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
userenro_enr4_ix	Performance	Asc	enrolid
userenro_enruse2_uix	Must be unique	Asc/Asc	enrolid + userid
userenro_mod4_ix	Performance	Asc	modifierid
userenro_use4_ix	Performance	Asc	userid

Showing 1 to 5 of 5 entries

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation