Table TBASE2.TBASE2.SUB_TREEBLOCK 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 FK94D508308DFE4858
1 TREEBLOCK_ID bigint 8
2 COLLECTION_ID bigint 8
SUB_MATRIX.COLLECTION_ID Implied Constraint
SUB_PHYLOTREE.COLLECTION_ID Implied Constraint

Table contained 5,056 rows at Sat Nov 15 02:37 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
2 TREEBLOCK_ID Primary key Asc SQL080501230723460
1 COLLECTION_ID Must be unique Asc SQL080501230723450

Close relationships  within of separation: