Table TBASE2.TBASE2.SPECIMENLABEL 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 SPECIMENLABEL_ID bigint 8  √ 
1 VERSION integer 4  √  null
2 GENBANKID varchar 255  √  null
3 MUSEUMNUMBER varchar 255  √  null
4 TISSUE varchar 255  √  null
5 STUDY_ID bigint 8
STUDY.STUDY_ID Implied Constraint
6 GEOSPOT_ID bigint 8  √  null
GEOSPOT.GEOSPOT_ID FK1E8F38CCA2039B9D
7 TAXON_ID bigint 8  √  null
TAXON.TAXON_ID Implied Constraint

Table contained 0 rows at Fri Nov 14 16:57 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
1 SPECIMENLABEL_ID Must be unique Asc SQL070830094850500

Close relationships: