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  √ 
MATRIXROW.TAXONLABEL_ID FKE4688E5963AB9FD7
ROWSEGMENT.TAXONLABEL_ID FKEE9AE81963AB9FD7
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
5 TAXONVARIANT_ID bigint 8  √  null

Table contained 205,800 rows at Sat Nov 15 02:48 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: