Table TBASE2.TBASE2.TAXON 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 TAXON_ID bigint 8  √ 
SPECIMENLABEL.TAXON_ID Implied Constraint
TAXONLINK.TAXON_ID FKC102D9A41DE2FCDD
TAXONSET_TAXON.TAXON_ID FKC656C9031DE2FCDD
TAXONVARIANT.TAXON_ID FKEE3D127B1DE2FCDD
1 VERSION integer 4  √  null
2 UBIONAMEBANKID bigint 8  √  null
3 DESCRIPTION varchar 2000  √  null
4 GROUPCODE integer 4  √  null
5 NAME varchar 255  √  null
6 NCBITAXID integer 4  √  null

Table contained 48,465 rows at Fri Nov 14 16:57 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
1 TAXON_ID Must be unique Asc SQL080501230723510
2 NAME Performance Asc TAXON_NAME_IDX

Close relationships  within of separation: