# 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