Table TBASE2.TBASE2.ROWSEGMENT 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 ROWSEGMENT_ID bigint 8  √ 
1 VERSION integer 4  √  null
2 ENDINDEX integer 4  √  null
3 CATALOGNUM varchar 50  √  null
4 COLLECTIONCODE varchar 50  √  null
5 COLLECTOR varchar 255  √  null
6 COUNTRY varchar 50  √  null
7 ELEVATION double 8  √  null
8 GENBACCESSION varchar 30  √  null
9 INSTACRONYM varchar 50  √  null
10 LATITUDE double 8  √  null
11 LOCALITY varchar 255  √  null
12 LONGITUDE double 8  √  null
13 NOTES varchar 2000  √  null
14 SAMPLEDATE date 6  √  null
15 STATE varchar 50  √  null
16 STARTINDEX integer 4  √  null
17 TITLE varchar 255  √  null
18 MATRIXROW_ID bigint 8
MATRIXROW.MATRIXROW_ID FKEE9AE819E7B3CDA6
19 TAXONLABEL_ID bigint 8  √  null
TAXONLABEL.TAXONLABEL_ID FKEE9AE81963AB9FD7
20 OTHERACCESSION varchar 50  √  null

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

Indexes:
ID Column(s) Type Sort Constraint Name
1 ROWSEGMENT_ID Must be unique Asc SQL080501230723130
2 INSTACRONYM Performance Asc SPECIM_INST_IDX

Close relationships  within of separation: