Table TBASE2.TBASE2.MATRIXELEMENT 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  √ 
COMPOUND_ELEMENT.COMPOUND_ID FK311830485F4F7CEB
COMPOUND_ELEMENT.ELEMENT_ID FK31183048459091E5
ITEMVALUE.ELEMENT_ID FK27B41A1E459091E5
STATEMODIFIER.ELEMENT_ID FKD157BE48459091E5
TEST_ELEMENT.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 FK90AE93FB8B2E884E
8 MATRIXROW_ID bigint 8  √  null
MATRIXROW.MATRIXROW_ID FK90AE93FBE7B3CDA6
9 ITEMDEFINITION_ID bigint 8  √  null
ITEMDEFINITION.ITEMDEFINITION_ID FK90AE93FB405A7CEE
10 DISCRETECHARSTATE_ID bigint 8  √  null
DISCRETECHARSTATE.DISCRETECHARSTATE_ID FK90AE93FBF4803CE6
11 ELEMENT_ORDER integer 4  √  null

Table contained 176,323,456 rows at Fri Nov 14 16:57 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
1 MATRIXELEMENT_ID Must be unique Asc SQL080501230722920
2 MATRIXROW_ID Performance Asc ELEMENT_ROW_IDX
3 MATRIXCOLUMN_ID Performance Asc ELEMENT_COL_IDX

Close relationships  within of separation: