Table ilias4_3.page_object Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
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

Table contained 5 rows at Sun May 01 00:15 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
page_id + parent_type Primary key Asc/Asc PRIMARY
content Performance Asc i1_idx
parent_id Performance Asc i2_idx
parent_id + parent_type + last_change Performance Asc/Asc/Asc i3_idx