Table TBASE2.TBASE2.GEOSPOT 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 GEOSPOT_ID bigint 8  √ 
SPECIMENLABEL.GEOSPOT_ID FK1E8F38CCA2039B9D
1 VERSION integer 4  √  null
2 ELEVATION double 8  √  null
3 LATITUDE double 8  √  null
4 LONGITUDE double 8  √  null
5 NAME varchar 255  √  null
6 NOTES varchar 2000  √  null

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

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

Close relationships: