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
STUDY_NEXUSFILE.STUDY_ID FK47FC1EE53C572C3C
SUBMISSION.STUDY_ID FKA120274C3C572C3C
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 Sat Nov 15 02:37 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: