Table iliasRelease_4_2_x_branch.object_data 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 0
type char 4  √  none
title char 128  √  null
description char 128  √  null
owner int 10 0
create_date datetime 19  √  null
last_update datetime 19  √  null
import_id char 50  √  null

Table contained 146 rows at Fri Apr 22 21:41 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
obj_id Primary key Asc PRIMARY
type Performance Asc i1_idx
title Performance Asc i2_idx
title + description Performance Asc/Asc i3_idx
import_id Performance Asc i4_idx