Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| blockname | VARCHAR | 40 |
|
|
The type of block this is. Foreign key, references block.name. |
|||||
| parentcontextid | BIGINT | 19 | null |
|
|
The context within which this block appears. Foreign key, references context.id. |
||||
| showinsubcontexts | SMALLINT | 5 | null |
|
|
If 1, this block appears on all matching pages in subcontexts of parentcontextid, as well in pages belonging to parentcontextid. |
||||
| requiredbytheme | SMALLINT | 5 | 0 |
|
|
If 1, this block was created because it was required by the theme and did not exist. |
||||
| pagetypepattern | VARCHAR | 64 |
|
|
The types of page this block appears on. Either an exact page type like mod-quiz-view, or a pattern like mod-quiz-* or course-view-. Note that course-view- will match course-view. |
|||||
| subpagepattern | VARCHAR | 16 | √ | null |
|
|
Further restrictions on where this block appears. In some places, e.g. during a quiz or lesson attempt, different pages have different subpage ids. If this field is not null, the block only appears on that particular subpage. |
|||
| defaultregion | VARCHAR | 16 |
|
|
Which block region this block should appear in on each page, in the absence of a specific position in the block_positions table. |
|||||
| defaultweight | BIGINT | 19 | null |
|
|
Used to order the blocks within a block region. Again, may be overridden by the block_positions table for a specific page where this block appears. |
||||
| configdata | LONGTEXT | 2147483647 | √ | null |
|
|
A serialized blob of configuration data for this block instance. |
|||
| timecreated | BIGINT | 19 | null |
|
|
Time at which this block instance was originally created |
||||
| timemodified | BIGINT | 19 | null |
|
|
Time at which block instance was last modified. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| blocinst_blo_ix | Performance | Asc | blockname |
| blocinst_par_ix | Performance | Asc | parentcontextid |
| blocinst_parshopagsub_ix | Performance | Asc/Asc/Asc/Asc | parentcontextid + showinsubcontexts + pagetypepattern + subpagepattern |
| blocinst_tim_ix | Performance | Asc | timemodified |