Enrol Flatfile Table Schema (enrol_flatfile)


Description

enrol_flatfile table retrofitted from MySQL

enrol_flatfile table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
action varchar 30
roleid bigint 10 null
role.id enroflat_rol2_fk R
userid bigint 10 null
user.id enroflat_use2_fk R
courseid bigint 10 null
course.id enroflat_cou2_fk R
timestart bigint 10 0
timeend bigint 10 0
timemodified bigint 10 0

Table contained -1 rows

enrol_flatfile table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
enroflat_cou_ix Performance Asc courseid
enroflat_rol_ix Performance Asc roleid
enroflat_use_ix Performance Asc userid

enrol_flatfile table relationships