enrol_flatfile

0 rows


Description

enrol_flatfile table retrofitted from MySQL

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
action VARCHAR 30
roleid BIGINT 19 null
role.id enroflat_rol2_fkR
userid BIGINT 19 null
user.id enroflat_use2_fkR
courseid BIGINT 19 null
course.id enroflat_cou2_fkR
timestart BIGINT 19 0
timeend BIGINT 19 0
timemodified BIGINT 19 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
enroflat_cou4_ix Performance Asc courseid
enroflat_rol4_ix Performance Asc roleid
enroflat_use4_ix Performance Asc userid

Relationships