Course Info Data Table Schema (course_info_data)


Description

Custom course fields data

course_info_data table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
course_info_data_param.dataid courinfodatapara_dat2_fk R
fieldid BIGINT 19 null
course_info_field.id courinfodata_fie2_fk R
courseid BIGINT 19 null
course.id courinfodata_cou2_fk R
data LONGTEXT 2147483647 √ null

Table contained -1 rows

course_info_data table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
courinfodata_cou_ix Performance Asc courseid
courinfodata_fie_ix Performance Asc fieldid
courinfodata_fiecou_uix Must be unique Asc/Asc fieldid + courseid

course_info_data table relationships

Close relationships within degrees of separation