Table TBASE2.TBASE2.TAXONVARIANT 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 TAXONVARIANT_ID bigint 8  √ 
TAXONLABEL.TAXONVARIANT_ID FK5F548A6A3C1B6F7
1 VERSION integer 4  √  null
2 FULLNAME varchar 255  √  null
3 LEXICALQUALIFIER varchar 50  √  null
4 NAME varchar 255  √  null
5 NAMEBANKID bigint 8  √  null
6 TAXON_ID bigint 8
TAXON.TAXON_ID FKEE3D127B1DE2FCDD

Table contained 114,396 rows at Fri Nov 14 16:57 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
1 TAXONVARIANT_ID Must be unique Asc SQL080501230723720
2 NAMEBANKID Performance Asc TVARI_NBID_IDX
3 TAXON_ID Performance Asc TVARI_TAXON_IDX
4 FULLNAME Performance Asc TVARI_FNAME_IDX

Close relationships  within of separation: