Table iliasRelease_5_0_x_branch.obj_stat 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
obj_id int 10
obj_type varchar 10
yyyy smallint 5  √  null
mm tinyint 3  √  null
dd tinyint 3  √  null
hh tinyint 3  √  null
read_count int 10  √  null
childs_read_count int 10  √  null
spent_seconds int 10  √  null
childs_spent_seconds int 10  √  null
tstamp int 10

Table contained 0 rows at Thu Apr 28 00:43 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
obj_id + yyyy + mm Performance Asc/Asc/Asc i1_idx
tstamp + obj_id Performance Asc/Asc i2_idx