Table TBASE2.TBASE2.STUDY 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 STUDY_ID bigint 8  √ 
ANALYSIS.STUDY_ID FKF19622DC3C572C3C
MATRIX.STUDY_ID FK87208BC13C572C3C
NEXUSFILEOBJECT.STUDY_ID Implied Constraint
PHYLOTREE.STUDY_ID FK76F2E4423C572C3C
SPECIMENLABEL.STUDY_ID Implied Constraint
STUDY_NEXUSFILE.STUDY_ID FK47FC1EE53C572C3C
SUBMISSION.STUDY_ID FKA120274C3C572C3C
TAXONLABEL.STUDY_ID FK5F548A6A3C572C3C
TAXONLABELSET.STUDY_ID FK28D3A5983C572C3C
TESTTREE.STUDY_ID Implied Constraint
1 VERSION integer 4  √  null
2 ACCESSIONNUMBER varchar 255  √  null
3 NAME varchar 255  √  null
4 NOTES varchar 2000  √  null
5 RELEASEDATE date 6  √  null
6 CITATION_ID bigint 8  √  null
CITATION.CITATION_ID FK4B915A98E1E4DF8
7 USER_ID bigint 8  √  null
USER.USER_ID FK4B915A9BEF300B2
8 STUDYSTATUS_ID bigint 8  √  null
STUDYSTATUS.STUDYSTATUS_ID FK4B915A9255A519C
9 TB_STUDYID varchar 30  √  null
10 LASTMODIFIEDDATE date 6  √  null

Table contained 7,110 rows at Fri Nov 14 16:57 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
1 STUDY_ID Must be unique Asc SQL080501230723300
2 NAME Performance Asc STUDY_NAME_IDX

Close relationships  within of separation: