Table TBASE2.TBASE2.TAXONLABEL 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 TAXONLABEL_ID bigint 8  √ 
DISTANCEMATRIXELEMENT.COLUMNLABEL_ID FK92D3DDE6C1429863
DISTANCEMATRIXELEMENT.ROWLABEL_ID FK92D3DDE61F08BAE7
MATRIXROW.TAXONLABEL_ID FKE4688E5963AB9FD7
PHYLOTREENODE.TAXONLABEL_ID FK3EA7994463AB9FD7
ROWSEGMENT.TAXONLABEL_ID FKEE9AE81963AB9FD7
SUB_TAXONLABEL.TAXONLABEL_ID FK86909E963AB9FD7
TAXONLABELROUP_TAXONLABEL.TAXONLABEL_ID FK4B1D0BC763AB9FD7
TAXONLABELSET_TAXONLABEL.TAXONLABEL_ID FK2EB54B7163AB9FD7
1 VERSION integer 4  √  null
2 LINKED smallint 2  √  null
3 TAXONLABEL varchar 255  √  null
4 STUDY_ID bigint 8  √  null
STUDY.STUDY_ID FK5F548A6A3C572C3C
5 TAXONVARIANT_ID bigint 8  √  null
TAXONVARIANT.TAXONVARIANT_ID FK5F548A6A3C1B6F7

Table contained 205,800 rows at Fri Nov 14 16:57 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
1 TAXONLABEL_ID Must be unique Asc SQL080501230723570
2 STUDY_ID Performance Asc TLABEL_STUDY_IDX

Close relationships  within of separation: