Table ezp54_community.ezm_pool 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
block_id char 32
ezm_block.id ezm_pool_ibfk_1 R
object_id int unsigned 10
node_id int unsigned 10
priority int unsigned 10  √  0
ts_publication int 10  √  0
ts_visible int unsigned 10  √  0
ts_hidden int unsigned 10  √  0
rotation_until int unsigned 10  √  0
moved_to char 32  √  null
ezm_block.id ezm_pool_ibfk_2 R

Analyzed at ? 7 07 11:43 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
block_id + object_id Primary key Asc/Asc PRIMARY
block_id + ts_hidden Performance Asc/Asc ezm_pool__block_id__ts_hidden
block_id + ts_publication + priority Performance Asc/Asc/Asc ezm_pool__block_id__ts_publication__priority
block_id + ts_visible Performance Asc/Asc ezm_pool__block_id__ts_visible
moved_to Performance Asc moved_to

Close relationships: