Table TBASE2.TBASE2.ITEMDEFINITION Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
ID Column Type Size Nulls Auto Default Children Parents Comments
0 ITEMDEFINITION_ID bigint 8  √ 
MATRIX_ITEMDEFINITION.ITEMDEFINITION_ID FK5717E0E4405A7CEE
MATRIXCOLUMN_ITEMDEFINITION.ITEMDEFINITION_ID FKB556F8E405A7CEE
MATRIXELEMENT.ITEMDEFINITION_ID FK90AE93FB405A7CEE
TEST_ELEMENT.ITEMDEFINITION_ID Implied Constraint
1 VERSION integer 4  √  null
2 DESCRIPTION varchar 255  √  null

Table contained 8 rows at Fri Nov 14 16:57 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
1 ITEMDEFINITION_ID Must be unique Asc SQL080501230722780

Close relationships  within of separation: