tool_brickfield_areas

0 rows


Description

Areas that have been checked for accessibility problems

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
tool_brickfield_content.areaid toolbriccont_are2_fkR
type TINYINT 3 0
contextid BIGINT 19 √ NULL
context.id toolbricarea_con2_fkR
component VARCHAR 100 √ NULL
tablename VARCHAR 40 √ NULL
fieldorarea VARCHAR 50 √ NULL
itemid BIGINT 19 √ NULL
filename VARCHAR 1333 √ NULL
reftable VARCHAR 40 √ NULL
refid BIGINT 19 √ NULL
cmid BIGINT 19 √ NULL
course_modules.id toolbricarea_cmi2_fkR
courseid BIGINT 19 √ NULL
course.id toolbricarea_cou2_fkR
categoryid BIGINT 19 √ NULL
course_categories.id toolbricarea_cat2_fkR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
toolbricarea_cat_ix Performance Asc categoryid
toolbricarea_cmi_ix Performance Asc cmid
toolbricarea_con_ix Performance Asc contextid
toolbricarea_cou_ix Performance Asc courseid
toolbricarea_coucmi_ix Performance Asc/Asc courseid + cmid
toolbricarea_refreftyp_ix Performance Asc/Asc/Asc reftable + refid + type
toolbricarea_typconcomfieit_ix Performance Asc/Asc/Asc/Asc/Asc type + contextid + component + fieldorarea + itemid
toolbricarea_typtabitefie_ix Performance Asc/Asc/Asc/Asc type + tablename + itemid + fieldorarea

Relationships