# block_positions

0 rows

### Description

Stores the position of a sticky block_instance on a another page than the one where it was added.

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |  |  |
blockinstanceid | BIGINT | 19 |  |  | null |  |
block_instances.id | blocposi_blo2_fkR
| The block_instance this position relates to.
contextid | BIGINT | 19 |  |  | null |  |
context.id | blocposi_con2_fkR
| With pagetype and subpage, defines the page we are setting the position for.
pagetype | VARCHAR | 64 |  |  |  |  |  | With contextid and subpage, defines the page we are setting the position for.
subpage | VARCHAR | 16 |  |  |  |  |  | With contextid and pagetype, defines the page we are setting the position for.
visible | SMALLINT | 5 |  |  | null |  |  | Whether this block instance is visible on this page.
region | VARCHAR | 16 |  |  |  |  |  | Which block region on this page this block should appear in.
weight | BIGINT | 19 |  |  | null |  |  | Used to order the blocks within a block region.

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
blocposi_blo_ix | Performance | Asc | blockinstanceid
blocposi_bloconpagsub_uix | Must be unique | Asc/Asc/Asc/Asc | blockinstanceid + contextid + pagetype + subpage
blocposi_con_ix | Performance | Asc | contextid

### Relationships