32 rows


This table stores block instances. The type of block this is is given by the blockname column. The places this block instance appears is controlled by the parentcontexid, showinsubcontexts, pagetypepattern and subpagepattern fields. Where the block a


Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_block_instances_id_seq'::regclass)
app_block_positions.blockinstanceid Defined in XMLR
app_block_totara_featured_links_tiles.blockid Defined in XMLR
blockname varchar 40 ''::character varying
parentcontextid int8 19 null Defined in XMLR
showinsubcontexts int2 5 null
requiredbytheme int2 5 0
pagetypepattern varchar 64 ''::character varying
subpagepattern varchar 16 null
defaultregion varchar 16 ''::character varying
defaultweight int8 19 null
configdata text 2147483647 null
common_config text 2147483647 null
timecreated int8 19 null
timemodified int8 19 null


Constraint Name Type Sort Column(s)
app_blocinst_id_pk Primary key Asc id
app_blocinst_blo_ix Performance Asc blockname
app_blocinst_par_ix Performance Asc parentcontextid
app_blocinst_parshopagsub_ix Performance Asc/Asc/Asc/Asc parentcontextid + showinsubcontexts + pagetypepattern + subpagepattern
app_blocinst_tim_ix Performance Asc timemodified