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_cat2_ix Performance Asc categoryid
toolbricarea_cmi2_ix Performance Asc cmid
toolbricarea_con2_ix Performance Asc contextid
toolbricarea_cou2_ix Performance Asc courseid
toolbricarea_coucmi2_ix Performance Asc/Asc courseid + cmid
toolbricarea_refreftyp2_ix Performance Asc/Asc/Asc reftable + refid + type
toolbricarea_typconcomfiei2_ix Performance Asc/Asc/Asc/Asc/Asc type + contextid + component + fieldorarea + itemid
toolbricarea_typtabitefie2_ix Performance Asc/Asc/Asc/Asc type + tablename + itemid + fieldorarea

Relationships

Close relationships within degrees of separation