Table TBASE2.TBASE2.SUBMISSION 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 SUBMISSION_ID bigint 8  √ 
SUB_MATRIX.SUBMISSION_ID FK5F26A2C08DFE4858
SUB_PHYLOTREE.SUBMISSION_ID Implied Constraint
SUB_TAXONLABEL.SUBMISSION_ID FK86909E98DFE4858
SUB_TREEBLOCK.SUBMISSION_ID FK94D508308DFE4858
1 VERSION integer 4  √  null
2 CREATEDATE date 6  √  null
3 SUBMISSIONNUMBER varchar 255  √  null
4 STUDY_ID bigint 8
STUDY.STUDY_ID FKA120274C3C572C3C
5 USER_ID bigint 8  √  null
USER.USER_ID FKA120274CBEF300B2

Table contained 7,110 rows at Sat Nov 15 02:37 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
2 STUDY_ID Primary key Asc SQL080501230723370
1 SUBMISSION_ID Must be unique Asc SQL080501230723360

Close relationships  within of separation: