SchemaSpy Analysis of TBASE2.TBASE2 - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Sat Nov 15 02:37 EST 2008
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

TBASE2.TBASE2 contains 138 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Children Parents Comments
CITATION ABSTRACT varchar 5000  √  null
STUDY ACCESSIONNUMBER varchar 255  √  null
ALGORITHM ALGORITHM_ID bigint 8  √ 
ANALYSISSTEP.ALGORITHM_ID FK21F853A848A2817C
ANALYSIS ANALYSIS_ID bigint 8  √ 
ANALYSISSTEP.ANALYSIS_ID FK21F853A8D1884DD8
ANALYSIS ANALYSIS_ORDER integer 4  √  null
ANALYSISSTEP ANALYSISSTEP_ID bigint 8  √ 
ANALYZEDDATA.ANALYSISSTEP_ID FK8C9618424BA97F78
ANALYZEDDATA ANALYZEDDATA_ID bigint 8  √ 
CITATION_AUTHOR AUTHOR_ORDER integer 4
PERSON AUTHORID varchar 50  √  null
USERROLE AUTHORITY varchar 255
CITATION BOOKTITLE varchar 255  √  null
CITATION CITATION_ID bigint 8  √ 
CITATION_AUTHOR.CITATION_ID FK24AA55E38E1E4DF8
CITATION_EDITOR.CITATION_ID FK2A8955C5EC93F501
STUDY.CITATION_ID FK4B915A98E1E4DF8
CITATIONSTATUS CITATIONSTATUS_ID bigint 8  √ 
CITATION.CITATIONSTATUS_ID FKD8A7FAE74C983658
CITATION CITY varchar 255  √  null
SUB_MATRIX COLLECTION_ID bigint 8
SUB_TREEBLOCK.COLLECTION_ID Implied Constraint
SUB_PHYLOTREE COLLECTION_ID bigint 8  √ 
SUB_TREEBLOCK.COLLECTION_ID Implied Constraint
SUB_TREEBLOCK COLLECTION_ID bigint 8
SUB_MATRIX.COLLECTION_ID Implied Constraint
SUB_PHYLOTREE.COLLECTION_ID Implied Constraint
USERTYPERRD_COLRANGE COLUMNRANGE_ID bigint 8
ANALYSISSTEP COMMANDS varchar 2000  √  null
SUBMISSION CREATEDATE date 6  √  null
ALGORITHM DESCRIPTION varchar 2000  √  null
CITATIONSTATUS DESCRIPTION varchar 50  √  null
GAPMODE DESCRIPTION varchar 255  √  null
POLYTCOUNT DESCRIPTION varchar 255  √  null
SOFTWARE DESCRIPTION varchar 2000  √  null
STUDYSTATUS DESCRIPTION varchar 255  √  null
CITATION DOI varchar 255  √  null
CITATION_EDITOR EDITOR_ORDER integer 4
PERSON EMAIL varchar 255  √  null
STUDY_NEXUSFILE FILENAME varchar 255
PERSON FIRSTNAME varchar 255  √  null
GAPMODE GAPMODE_ID bigint 8  √ 
ALGORITHM.GAPMODE_ID FKB388C44FC6E814E6
ANALYZEDDATA INPUT smallint 2  √  null
CITATION ISBN varchar 255  √  null
CITATION ISSUE varchar 255  √  null
CITATION JOURNAL varchar 255  √  null
CITATION KEYWORDS varchar 255  √  null
STUDY LASTMODIFIEDDATE date 6  √  null
PERSON LASTNAME varchar 255
ANALYZEDDATA MATRIX_ID bigint 8  √  null
SUB_MATRIX MATRIX_ID bigint 8
PERSON MNAME varchar 255  √  null
ANALYSIS NAME varchar 255  √  null
ANALYSISSTEP NAME varchar 255  √  null
SOFTWARE NAME varchar 255  √  null
STUDY NAME varchar 255  √  null
STUDY_NEXUSFILE NEXUS clob 4194304
ANALYSIS NOTES varchar 2000  √  null
ANALYSISSTEP NOTES varchar 2000  √  null
ANALYZEDDATA NOTES varchar 2000  √  null
STUDY NOTES varchar 2000  √  null
CITATION PAGES varchar 255  √  null
USER PASSWORD varchar 100
PERSON PERSON_ID bigint 8  √ 
CITATION_AUTHOR.AUTHORS_PERSON_ID FK24AA55E36707573B
CITATION_EDITOR.EDITORS_PERSON_ID FK2A8955C568F6F619
USER.PERSON_ID FK27E3CBE3910672
PERSON PHONE varchar 50  √  null
ANALYZEDDATA PHYLOTREE_ID bigint 8  √  null
SUB_PHYLOTREE PHYLOTREE_ID bigint 8
CITATION PMID varchar 255  √  null
POLYTCOUNT POLYTCOUNT_ID bigint 8  √ 
ALGORITHM.POLYTCOUNT_ID FKB388C44F9698D32E
ALGORITHM PROPERTYNAME varchar 255  √  null
ALGORITHM PROPERTYVALUE varchar 255  √  null
CITATION PUBLISHED smallint 2  √  null
CITATION PUBLISHER varchar 255  √  null
CITATION PUBLISHYEAR integer 4  √  null
STUDY RELEASEDATE date 6  √  null
SOFTWARE SOFTWARE_ID bigint 8  √ 
ANALYSISSTEP.SOFTWARE_ID FK21F853A865EDD5F8
SOFTWARE SOFTWAREURL varchar 500  √  null
SOFTWARE SOFTWAREVERSION varchar 255  √  null
ANALYSISSTEP STEP_ORDER integer 4  √  null
STUDY STUDY_ID bigint 8  √ 
ANALYSIS.STUDY_ID FKF19622DC3C572C3C
STUDY_NEXUSFILE.STUDY_ID FK47FC1EE53C572C3C
SUBMISSION.STUDY_ID FKA120274C3C572C3C
STUDYSTATUS STUDYSTATUS_ID bigint 8  √ 
STUDY.STUDYSTATUS_ID FK4B915A9255A519C
SUB_PHYLOTREE SUBMISSION_ID bigint 8
SUBMISSION.SUBMISSION_ID Implied Constraint
SUBMISSION 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
SUBMISSION SUBMISSIONNUMBER varchar 255  √  null
SUB_TAXONLABEL TAXONLABEL_ID bigint 8
ANALYSISSTEP TB_ANALYSISID varchar 34  √  null
CITATION TB_STUDYID varchar 30  √  null
STUDY TB_STUDYID varchar 30  √  null
CITATION TITLE varchar 255  √  null
USERTYPE TITLE varchar 255  √  null
SUB_TREEBLOCK TREEBLOCK_ID bigint 8
ANALYZEDDATA TREELENGTH integer 4  √  null
ALGORITHM TYPE char 1
ANALYZEDDATA TYPE char 1
CITATION TYPE char 1
USERTYPE TYPE char 1
USERTYPERECORD TYPESET_ID bigint 8  √  null
CITATION URL varchar 255  √  null
USER USER_ID bigint 8  √ 
STUDY.USER_ID FK4B915A9BEF300B2
SUBMISSION.USER_ID FKA120274CBEF300B2
USER USERNAME varchar 100
USERROLE USERROLE_ID bigint 8  √ 
USER.USERROLE_ID FK27E3CBF59DD12
USERTYPE USERTYPE_ID bigint 8  √ 
ALGORITHM.USERTYPE_ID FKB388C44F92E6A38E
USERTYPERECORD.USERTYPE_ID FK136AF61692E6A38E
USERTYPERECORD USERTYPERECORD_ID bigint 8  √ 
USERTYPERRD_COLRANGE.USERTYPERECORD_ID FK405805DDC009330E
ANALYSIS VALIDATED smallint 2  √  null
ALGORITHM VERSION integer 4  √  null
ANALYSIS VERSION integer 4  √  null
ANALYSISSTEP VERSION integer 4  √  null
ANALYZEDDATA VERSION integer 4  √  null
CITATION VERSION integer 4  √  null
CITATIONSTATUS VERSION integer 4  √  null
GAPMODE VERSION integer 4  √  null
PERSON VERSION integer 4  √  null
POLYTCOUNT VERSION integer 4  √  null
SOFTWARE VERSION integer 4  √  null
STUDY VERSION integer 4  √  null
STUDYSTATUS VERSION integer 4  √  null
SUBMISSION VERSION integer 4  √  null
USER VERSION integer 4  √  null
USERROLE VERSION integer 4  √  null
USERTYPE VERSION integer 4  √  null
USERTYPERECORD VERSION integer 4  √  null
CITATION VOLUME varchar 255  √  null
ANALYSISSTEP ALGORITHM_ID bigint 8  √  null
ALGORITHM.ALGORITHM_ID FK21F853A848A2817C
ANALYSISSTEP ANALYSIS_ID bigint 8  √  null
ANALYSIS.ANALYSIS_ID FK21F853A8D1884DD8
ANALYZEDDATA ANALYSISSTEP_ID bigint 8
ANALYSISSTEP.ANALYSISSTEP_ID FK8C9618424BA97F78
CITATION_AUTHOR CITATION_ID bigint 8
CITATION.CITATION_ID FK24AA55E38E1E4DF8
CITATION_EDITOR CITATION_ID bigint 8
CITATION.CITATION_ID FK2A8955C5EC93F501
STUDY CITATION_ID bigint 8  √  null
CITATION.CITATION_ID FK4B915A98E1E4DF8
CITATION CITATIONSTATUS_ID bigint 8  √  null
CITATIONSTATUS.CITATIONSTATUS_ID FKD8A7FAE74C983658
ALGORITHM GAPMODE_ID bigint 8  √  null
GAPMODE.GAPMODE_ID FKB388C44FC6E814E6
CITATION_AUTHOR AUTHORS_PERSON_ID bigint 8
PERSON.PERSON_ID FK24AA55E36707573B
CITATION_EDITOR EDITORS_PERSON_ID bigint 8
PERSON.PERSON_ID FK2A8955C568F6F619
USER PERSON_ID bigint 8
PERSON.PERSON_ID FK27E3CBE3910672
ALGORITHM POLYTCOUNT_ID bigint 8  √  null
POLYTCOUNT.POLYTCOUNT_ID FKB388C44F9698D32E
ANALYSISSTEP SOFTWARE_ID bigint 8  √  null
SOFTWARE.SOFTWARE_ID FK21F853A865EDD5F8
ANALYSIS STUDY_ID bigint 8  √  null
STUDY.STUDY_ID FKF19622DC3C572C3C
STUDY_NEXUSFILE STUDY_ID bigint 8
STUDY.STUDY_ID FK47FC1EE53C572C3C
SUBMISSION STUDY_ID bigint 8
STUDY.STUDY_ID FKA120274C3C572C3C
STUDY STUDYSTATUS_ID bigint 8  √  null
STUDYSTATUS.STUDYSTATUS_ID FK4B915A9255A519C
SUB_MATRIX SUBMISSION_ID bigint 8
SUBMISSION.SUBMISSION_ID FK5F26A2C08DFE4858
SUB_TAXONLABEL SUBMISSION_ID bigint 8
SUBMISSION.SUBMISSION_ID FK86909E98DFE4858
SUB_TREEBLOCK SUBMISSION_ID bigint 8
SUBMISSION.SUBMISSION_ID FK94D508308DFE4858
STUDY USER_ID bigint 8  √  null
USER.USER_ID FK4B915A9BEF300B2
SUBMISSION USER_ID bigint 8  √  null
USER.USER_ID FKA120274CBEF300B2
USER USERROLE_ID bigint 8
USERROLE.USERROLE_ID FK27E3CBF59DD12
ALGORITHM USERTYPE_ID bigint 8  √  null
USERTYPE.USERTYPE_ID FKB388C44F92E6A38E
USERTYPERECORD USERTYPE_ID bigint 8  √  null
USERTYPE.USERTYPE_ID FK136AF61692E6A38E
USERTYPERRD_COLRANGE USERTYPERECORD_ID bigint 8
USERTYPERECORD.USERTYPERECORD_ID FK405805DDC009330E