Table TBASE2.TBASE2.SUB_MATRIX 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 SUBMISSION_ID bigint 8
SUBMISSION.SUBMISSION_ID FK5F26A2C08DFE4858
1 MATRIX_ID bigint 8
MATRIX.MATRIX_ID FK5F26A2C055961AEE
2 COLLECTION_ID bigint 8
SUB_PHYLOTREE.COLLECTION_ID Implied Constraint
SUB_TREEBLOCK.COLLECTION_ID Implied Constraint

Table contained 2,769 rows at Fri Nov 14 16:57 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
2 MATRIX_ID Primary key Asc SQL080501230723400
1 COLLECTION_ID Must be unique Asc SQL080501230723390

Close relationships  within of separation: