Table TBASE2.TBASE2.MATRIXROW 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 MATRIXROW_ID bigint 8  √ 
MATRIXELEMENT.MATRIXROW_ID FK90AE93FBE7B3CDA6
ROWSEGMENT.MATRIXROW_ID FKEE9AE819E7B3CDA6
TEST_ELEMENT.MATRIXROW_ID Implied Constraint
1 VERSION integer 4  √  null
2 MATRIX_ID bigint 8  √  null
MATRIX.MATRIX_ID FKE4688E59A414944F
3 TAXONLABEL_ID bigint 8
TAXONLABEL.TAXONLABEL_ID FKE4688E5963AB9FD7
4 ROW_ORDER integer 4  √  null
5 SYMBOLSTRING clob 524288  √  null

Table contained 116,740 rows at Fri Nov 14 16:57 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
1 MATRIXROW_ID Must be unique Asc SQL080501230722950
2 MATRIX_ID Performance Asc ROW_M_IDX

Close relationships  within of separation: