Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
page_id | INT | 10 | 0 |
|
|
|||
parent_id | INT | 10 | √ | null |
|
|
||
content | LONGTEXT | 2147483647 | √ | null |
|
|
||
parent_type | VARCHAR | 4 | lm |
|
|
|||
last_change_user | INT | 10 | √ | null |
|
|
||
view_cnt | INT | 10 | √ | 0 |
|
|
||
last_change | DATETIME | 19 | √ | null |
|
|
||
created | DATETIME | 19 | √ | null |
|
|
||
create_user | INT | 10 | √ | null |
|
|
||
render_md5 | VARCHAR | 32 | √ | null |
|
|
||
rendered_content | LONGTEXT | 2147483647 | √ | null |
|
|
||
rendered_time | DATETIME | 19 | √ | null |
|
|
||
activation_start | DATETIME | 19 | √ | null |
|
|
||
activation_end | DATETIME | 19 | √ | null |
|
|
||
active | TINYINT | 3 | 1 |
|
|
|||
is_empty | TINYINT | 3 | 0 |
|
|
|||
inactive_elements | TINYINT | 3 | √ | 0 |
|
|
||
int_links | TINYINT | 3 | √ | 0 |
|
|
||
show_activation_info | TINYINT | 3 | 0 |
|
|
|||
lang | VARCHAR | 2 | - |
|
|
|||
edit_lock_user | INT | 10 | √ | null |
|
|
||
edit_lock_ts | INT | 10 | 0 |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc/Asc/Asc | page_id + parent_type + lang |
i3_idx | Performance | Asc/Asc/Asc | parent_id + parent_type + last_change |
Diagram producer might be missing
No diagrams were produced please see application output for any errors