Table TBASE2.TBASE2.TEST_ELEMENT 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 TYPE char 1
1 MATRIXELEMENT_ID bigint 8  √ 
MATRIXELEMENT.MATRIXELEMENT_ID Implied Constraint
2 VERSION integer 4  √  null
3 ANDLOGIC smallint 2  √  null
4 COMPOUNDVALUE varchar 1000  √  null
5 VALUE double 8  √  null
6 GAP smallint 2  √  null
7 MATRIXCOLUMN_ID bigint 8  √  null
MATRIXCOLUMN.MATRIXCOLUMN_ID Implied Constraint
8 MATRIXROW_ID bigint 8  √  null
MATRIXROW.MATRIXROW_ID Implied Constraint
9 ITEMDEFINITION_ID bigint 8  √  null
ITEMDEFINITION.ITEMDEFINITION_ID Implied Constraint
10 DISCRETECHARSTATE_ID bigint 8  √  null
STEPMATRIXELEMENT.DISCRETECHARSTATE_ID Implied Constraint
11 ELEMENT_ORDER integer 4  √  null

Table contained 5,007,397 rows at Fri Nov 14 16:57 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
1 MATRIXELEMENT_ID Primary key Asc SQL080501230722999
2 MATRIXROW_ID Performance Asc TST_E_ROW_IDX
3 MATRIXCOLUMN_ID Performance Asc TST_E_COL_IDX
4 MATRIXCOLUMN_ID + MATRIXELEMENT_ID Performance Asc/Asc e_column_IDX

Close relationships: