block_instances

0 rows


Description

This table stores block instances. The type of block this is

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
block_positions.blockinstanceid blocposi_blo2_fkR
blockname VARCHAR 40
block.name block_instances_erd_block_nameR
parentcontextid BIGINT 19 null
context.id blocinst_par2_fkR
showinsubcontexts SMALLINT 5 null
requiredbytheme SMALLINT 5 0
pagetypepattern VARCHAR 64
subpagepattern VARCHAR 16 √ null
defaultregion VARCHAR 16
defaultweight BIGINT 19 null
configdata LONGTEXT 2147483647 √ null
timecreated BIGINT 19 null
timemodified BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
blocinst_par4_ix Performance Asc parentcontextid
blocinst_parshopagsub2_ix Performance Asc/Asc/Asc/Asc parentcontextid + showinsubcontexts + pagetypepattern + subpagepattern
blocinst_tim2_ix Performance Asc timemodified
block_instances_erd_block_name Performance Asc blockname

Relationships

Close relationships within degrees of separation