SchemaSpy Analysis of TBASE2.TBASE2 - Constraints Generated by
SchemaSpy
33 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column
FK136AF6164D737E46 USERTYPERECORD.TYPESET_ID
FK136AF61692E6A38E USERTYPERECORD.USERTYPE_ID USERTYPE.USERTYPE_ID
FK21F853A848A2817C ANALYSISSTEP.ALGORITHM_ID ALGORITHM.ALGORITHM_ID
FK21F853A865EDD5F8 ANALYSISSTEP.SOFTWARE_ID SOFTWARE.SOFTWARE_ID
FK21F853A8D1884DD8 ANALYSISSTEP.ANALYSIS_ID ANALYSIS.ANALYSIS_ID
FK24AA55E36707573B CITATION_AUTHOR.AUTHORS_PERSON_ID PERSON.PERSON_ID
FK24AA55E38E1E4DF8 CITATION_AUTHOR.CITATION_ID CITATION.CITATION_ID
FK27E3CBE3910672 USER.PERSON_ID PERSON.PERSON_ID
FK27E3CBF59DD12 USER.USERROLE_ID USERROLE.USERROLE_ID
FK2A8955C568F6F619 CITATION_EDITOR.EDITORS_PERSON_ID PERSON.PERSON_ID
FK2A8955C5EC93F501 CITATION_EDITOR.CITATION_ID CITATION.CITATION_ID
FK405805DD79A523E6 USERTYPERRD_COLRANGE.COLUMNRANGE_ID
FK405805DDC009330E USERTYPERRD_COLRANGE.USERTYPERECORD_ID USERTYPERECORD.USERTYPERECORD_ID
FK47FC1EE53C572C3C STUDY_NEXUSFILE.STUDY_ID STUDY.STUDY_ID
FK4B915A9255A519C STUDY.STUDYSTATUS_ID STUDYSTATUS.STUDYSTATUS_ID
FK4B915A98E1E4DF8 STUDY.CITATION_ID CITATION.CITATION_ID
FK4B915A9BEF300B2 STUDY.USER_ID USER.USER_ID
FK5F26A2C055961AEE SUB_MATRIX.MATRIX_ID
FK5F26A2C08DFE4858 SUB_MATRIX.SUBMISSION_ID SUBMISSION.SUBMISSION_ID
FK86909E963AB9FD7 SUB_TAXONLABEL.TAXONLABEL_ID
FK86909E98DFE4858 SUB_TAXONLABEL.SUBMISSION_ID SUBMISSION.SUBMISSION_ID
FK8C9618424BA97F78 ANALYZEDDATA.ANALYSISSTEP_ID ANALYSISSTEP.ANALYSISSTEP_ID
FK8C96184255961AEE ANALYZEDDATA.MATRIX_ID
FK8C961842B710CB23 ANALYZEDDATA.PHYLOTREE_ID
FK94D508308DFE4858 SUB_TREEBLOCK.SUBMISSION_ID SUBMISSION.SUBMISSION_ID
FK94D50830BFD107C3 SUB_TREEBLOCK.TREEBLOCK_ID
FKA120274C3C572C3C SUBMISSION.STUDY_ID STUDY.STUDY_ID
FKA120274CBEF300B2 SUBMISSION.USER_ID USER.USER_ID
FKB388C44F92E6A38E ALGORITHM.USERTYPE_ID USERTYPE.USERTYPE_ID
FKB388C44F9698D32E ALGORITHM.POLYTCOUNT_ID POLYTCOUNT.POLYTCOUNT_ID
FKB388C44FC6E814E6 ALGORITHM.GAPMODE_ID GAPMODE.GAPMODE_ID
FKD8A7FAE74C983658 CITATION.CITATIONSTATUS_ID CITATIONSTATUS.CITATIONSTATUS_ID
FKF19622DC3C572C3C ANALYSIS.STUDY_ID STUDY.STUDY_ID

Check Constraints:

Table Constraint Name Constraint
None detected