Table TBASE2.TBASE2.MATRIXCOLUMN 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 MATRIXCOLUMN_ID bigint 8  √ 
MATRIXCOLUMN_ITEMDEFINITION.MATRIXCOLUMN_ID FKB556F8E8B2E884E
MATRIXELEMENT.MATRIXCOLUMN_ID FK90AE93FB8B2E884E
TEST_ELEMENT.MATRIXCOLUMN_ID Implied Constraint
1 VERSION integer 4  √  null
2 PHYLOCHAR_ID bigint 8  √  null
PHYLOCHAR.PHYLOCHAR_ID FK9B0BE57F5DECA46
3 MATRIX_ID bigint 8  √  null
MATRIX.MATRIX_ID FK9B0BE57A414944F
4 STATEFORMAT_ID bigint 8  √  null
STATEFORMAT.STATEFORMAT_ID FK9B0BE57BED40086
5 COLUMN_ORDER integer 4  √  null

Table contained 3,758,902 rows at Fri Nov 14 16:57 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
1 MATRIXCOLUMN_ID Must be unique Asc SQL080501230722860
2 MATRIX_ID Performance Asc COLUMN_M_IDX

Close relationships  within of separation: