SchemaSpy Analysis of TBASE2.TBASE2 - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Fri Nov 14 16:57 EST 2008
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

TBASE2.TBASE2 contains 751 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
EXPLAIN_OBJECT ACTIVE_BLOCKS bigint 8
ANALYSISSTEP ALGORITHM_ID bigint 8  √  null
ALGORITHM.ALGORITHM_ID FK21F853A848A2817C
MATRIX ALIGNED smallint 2  √  null
ANALYSISSTEP ANALYSIS_ID bigint 8  √  null
ANALYSIS.ANALYSIS_ID FK21F853A8D1884DD8
ANALYSIS ANALYSIS_ORDER integer 4  √  null
ANALYZEDDATA ANALYSISSTEP_ID bigint 8
ANALYSISSTEP.ANALYSISSTEP_ID FK8C9618424BA97F78
ANALYZEDDATA ANALYZEDDATA_ID bigint 8  √ 
DISCRETECHARSTATE ANCESTRALSTATE_ID bigint 8  √  null
ANCESTRALSTATE.ANCESTRALSTATE_ID FK2EEF2802C7BEAAFE
CONTANCSTATE_VALUE ANCSTATE_ID bigint 8
ANCESTRALSTATE.ANCESTRALSTATE_ID FKA84B8C3FD450D2BD
ANCESTRALSTATE ANCSTATESET_ID bigint 8  √  null
ANCSTATESET.ANCSTATESET_ID FK3FA14284684F6406
MATRIX ANCSTATESET_ID bigint 8  √  null
ANCSTATESET.ANCSTATESET_ID FK87208BC1684F6406
ANCESTRALSTATE ANCVALUE varchar 255  √  null
MATRIXELEMENT ANDLOGIC smallint 2  √  null
TEST_ELEMENT ANDLOGIC smallint 2  √  null
EXPLAIN_ARGUMENT ARGUMENT_TYPE char 8
EXPLAIN_ARGUMENT ARGUMENT_VALUE varchar 1024  √  null
CITATION_AUTHOR AUTHOR_ORDER integer 4
PERSON AUTHORID varchar 50  √  null
USERROLE AUTHORITY varchar 255
CITATION_AUTHOR AUTHORS_PERSON_ID bigint 8
PERSON.PERSON_ID FK24AA55E36707573B
EXPLAIN_OBJECT AVERAGE_RANDOM_FETCH_PAGES double 8
EXPLAIN_OBJECT AVERAGE_RANDOM_PAGES double 8
EXPLAIN_OBJECT AVERAGE_SEQUENCE_FETCH_GAP double 8
EXPLAIN_OBJECT AVERAGE_SEQUENCE_FETCH_PAGES double 8
EXPLAIN_OBJECT AVERAGE_SEQUENCE_GAP double 8
EXPLAIN_OBJECT AVERAGE_SEQUENCE_PAGES double 8
EXPLAIN_INSTANCE AVG_APPLS integer 4
PHYLOTREE BIGTREE smallint 2  √  null
TESTTREE BIGTREE smallint 2  √  null
EXPLAIN_INSTANCE BLOCK char 1
CITATION BOOKTITLE varchar 255  √  null
PHYLOTREENODE BRANCHLENGTH double 8  √  null
TESTNODE BRANCHLENGTH double 8  √  null
EXPLAIN_OPERATOR BUFFERS double 8
EXPLAIN_INSTANCE BUFFPAGE integer 4
MATRIX CASESENSITIVE smallint 2  √  null
ROWSEGMENT CATALOGNUM varchar 50  √  null
CHARGROUP_COLRANGE CHARGROUP_ID bigint 8
CHARGROUP.CHARGROUP_ID FKB2D8C293971FFFA6
CHARGROUP_PHYLOCHAR CHARGROUP_ID bigint 8
CHARGROUP.CHARGROUP_ID Implied Constraint
CHARGROUP CHARPARTITION_ID bigint 8  √  null
CHARPARTITION.CHARPARTITION_ID FK3AF18C91AA11DC6
CHARSET_COLRANGE CHARSET_ID bigint 8
CHARSET.CHARSET_ID FK2CBD90416D5B50
CHARSET_PHYLOCHAR CHARSET_ID bigint 8
CHARSET.CHARSET_ID Implied Constraint
MATRIX CHARSET_ID bigint 8  √  null
CHARSET.CHARSET_ID FK87208BC145534A9C
CHARWEIGHT_COLRANGE CHARWEIGHT_ID bigint 8
CHARWEIGHT.CHARWEIGHT_ID FK54CA674EF9A75EE
CHARWEIGHT CHARWEIGHTSET_ID bigint 8  √  null
CHARWEIGHTSET.CHARWEIGHTSET_ID FK8CC7694EE9B425A6
MATRIX CHARWEIGHTSET_ID bigint 8  √  null
CHARWEIGHTSET.CHARWEIGHTSET_ID FK87208BC1E9B425A6
PHYLOTREENODE CHILD_ID bigint 8  √  null
PHYLOTREENODE.PHYLOTREENODE_ID FK3EA79944434FDCCB
TREENODEEDGE CHILDNODE_ID bigint 8
PHYLOTREENODE.PHYLOTREENODE_ID FK7767285D27FD0589
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
CITATION CITY varchar 255  √  null
EXPLAIN_OBJECT CLUSTER double 8
ADVISE_INDEX CLUSTERFACTOR double 8 0
ADVISE_INDEX CLUSTERRATIO smallint 2 0
GENETICCODE CODEDESCRIPTION varchar 1000  √  null
GENETICCODE CODEORDER varchar 255  √  null
CODONCHAR1_COLRANGE CODONPOSITIONSET_ID bigint 8
CODONPOSITIONSET.CODONPOSITIONSET_ID FKDA5AD4F8491DB20E
CODONCHAR2_COLRANGE CODONPOSITIONSET_ID bigint 8
CODONPOSITIONSET.CODONPOSITIONSET_ID FKCEA44617491DB20E
CODONCHAR3_COLRANGE CODONPOSITIONSET_ID bigint 8
CODONPOSITIONSET.CODONPOSITIONSET_ID FKC2EDB736491DB20E
CODONNONCODING_COLRANGE CODONPOSITIONSET_ID bigint 8
CODONPOSITIONSET.CODONPOSITIONSET_ID FK307897FC491DB20E
MATRIX CODONPOSITIONSET_ID bigint 8  √  null
CODONPOSITIONSET.CODONPOSITIONSET_ID FK87208BC1491DB20E
ADVISE_INDEX COLCOUNT smallint 2 0
SUB_MATRIX COLLECTION_ID bigint 8
SUB_PHYLOTREE.COLLECTION_ID Implied Constraint
SUB_TREEBLOCK.COLLECTION_ID Implied Constraint
SUB_PHYLOTREE COLLECTION_ID bigint 8  √ 
SUB_MATRIX.COLLECTION_ID Implied Constraint
SUB_TREEBLOCK COLLECTION_ID bigint 8
SUB_MATRIX.COLLECTION_ID Implied Constraint
ROWSEGMENT COLLECTIONCODE varchar 50  √  null
ROWSEGMENT COLLECTOR varchar 255  √  null
ADVISE_INDEX COLNAMES clob 2097152
EXPLAIN_OBJECT COLUMN_COUNT smallint 2
EXPLAIN_STREAM COLUMN_COUNT smallint 2
EXPLAIN_STREAM COLUMN_NAMES clob 2097152  √  null
MATRIXCOLUMN COLUMN_ORDER integer 4  √  null
DISTANCEMATRIXELEMENT COLUMNLABEL_ID bigint 8  √  null
TAXONLABEL.TAXONLABEL_ID FK92D3DDE6C1429863
CHARGROUP_COLRANGE COLUMNRANGE_ID bigint 8
COLUMNRANGE.COLUMNRANGE_ID FKB2D8C29379A523E6
CHARSET_COLRANGE COLUMNRANGE_ID bigint 8
COLUMNRANGE.COLUMNRANGE_ID FK2CBD9079A523E6
CHARWEIGHT_COLRANGE COLUMNRANGE_ID bigint 8
COLUMNRANGE.COLUMNRANGE_ID FK54CA674E79A523E6
CODERECORD_COLRANGE COLUMNRANGE_ID bigint 8
COLUMNRANGE.COLUMNRANGE_ID FKA3E6C61E79A523E6
CODONCHAR1_COLRANGE COLUMNRANGE_ID bigint 8
COLUMNRANGE.COLUMNRANGE_ID FKDA5AD4F879A523E6
CODONCHAR2_COLRANGE COLUMNRANGE_ID bigint 8
COLUMNRANGE.COLUMNRANGE_ID FKCEA4461779A523E6
CODONCHAR3_COLRANGE COLUMNRANGE_ID bigint 8
COLUMNRANGE.COLUMNRANGE_ID FKC2EDB73679A523E6
CODONNONCODING_COLRANGE COLUMNRANGE_ID bigint 8
COLUMNRANGE.COLUMNRANGE_ID FK307897FC79A523E6
USERTYPERRD_COLRANGE COLUMNRANGE_ID bigint 8
COLUMNRANGE.COLUMNRANGE_ID FK405805DD79A523E6
EXPLAIN_OPERATOR COMM_COST double 8
EXPLAIN_INSTANCE COMM_SPEED double 8
ANALYSISSTEP COMMANDS varchar 2000  √  null
ADVISE_WORKLOAD COMPILABLE char 17  √  null
COMPOUND_ELEMENT COMPOUND_ID bigint 8
MATRIXELEMENT.MATRIXELEMENT_ID FK311830485F4F7CEB
MATRIXELEMENT COMPOUNDVALUE varchar 1000  √  null
TEST_ELEMENT COMPOUNDVALUE varchar 1000  √  null
TAXONAUTHORITY CONNECTIONSTR varchar 1000  √  null
ADVISE_INDEX CONVERTED char 1 ''
ADVISE_WORKLOAD COST_AFTER double 8  √  null
ADVISE_WORKLOAD COST_BEFORE double 8  √  null
STATEMODIFIER COUNT integer 4  √  null
ROWSEGMENT COUNTRY varchar 50  √  null
EXPLAIN_OPERATOR CPU_COST double 8
EXPLAIN_INSTANCE CPU_SPEED double 8
ADVISE_INDEX CREATE_TIME timestamp 16,6 now
EXPLAIN_OBJECT CREATE_TIME timestamp 16,6  √  null
SUBMISSION CREATEDATE date 6  √  null
ADVISE_INDEX CREATION_TEXT clob 2097152 ''
ADVISE_INDEX CREATOR varchar 128 ''
CSTREENODE CSTREE_ID bigint 8
USERTYPE.USERTYPE_ID FK82B9AB10C6999FCE
EXPLAIN_INSTANCE DATAJOINER char 1
EXPLAIN_INSTANCE DB2_VERSION char 7
EXPLAIN_INSTANCE DBHEAP integer 4
ADVISE_INDEX DEFINER varchar 128 ''
EXPLAIN_STATEMENT DELETABLE char 1
ADVISE_INDEX DENSITY integer 4 0
EXPLAIN_OBJECT DENSITY integer 4
ALGORITHM DESCRIPTION varchar 2000  √  null
CITATIONSTATUS DESCRIPTION varchar 50  √  null
DISCRETECHARSTATE DESCRIPTION varchar 255  √  null
GAPMODE DESCRIPTION varchar 255  √  null
ITEMDEFINITION DESCRIPTION varchar 255  √  null
MATRIX DESCRIPTION varchar 2000  √  null
MATRIXDATATYPE DESCRIPTION varchar 255  √  null
MATRIXKIND DESCRIPTION varchar 100  √  null
NEXUSFILEOBJECT DESCRIPTION varchar 255  √  null
PHYLOCHAR DESCRIPTION varchar 255  √  null
POLYTCOUNT DESCRIPTION varchar 255  √  null
SOFTWARE DESCRIPTION varchar 2000  √  null
STATEFORMAT DESCRIPTION varchar 255  √  null
STUDYSTATUS DESCRIPTION varchar 255  √  null
TAXON DESCRIPTION varchar 2000  √  null
TAXONAUTHORITY DESCRIPTION varchar 2000  √  null
TREEKIND DESCRIPTION varchar 100  √  null
TREEQUALITY DESCRIPTION varchar 255  √  null
TREETYPE DESCRIPTION varchar 255  √  null
MATRIX DIAGONAL smallint 2  √  null
ANCESTRALSTATE DISCRETECHARSTATE_ID bigint 8  √  null
DISCRETECHARSTATE.DISCRETECHARSTATE_ID FK3FA14284F4803CE6
CSTREENODE DISCRETECHARSTATE_ID bigint 8  √  null
DISCRETECHARSTATE.DISCRETECHARSTATE_ID FK82B9AB10F4803CE6
LEFTCHANGESET_CHARSTATE DISCRETECHARSTATE_ID bigint 8
DISCRETECHARSTATE.DISCRETECHARSTATE_ID FKC8877207F4803CE6
MATRIXELEMENT DISCRETECHARSTATE_ID bigint 8  √  null
DISCRETECHARSTATE.DISCRETECHARSTATE_ID FK90AE93FBF4803CE6
RIGHTCHANGESET_CHARSTATE DISCRETECHARSTATE_ID bigint 8
DISCRETECHARSTATE.DISCRETECHARSTATE_ID FKC8AFC9F2F4803CE6
STATEMODIFIER DISCRETECHARSTATE_ID bigint 8  √  null
DISCRETECHARSTATE.DISCRETECHARSTATE_ID FKD157BE48F4803CE6
STEPMATRIXELEMENT DISCRETECHARSTATE_ID bigint 8  √ 
DISCRETECHARSTATE.DISCRETECHARSTATE_ID Implied Constraint
TEST_ELEMENT.DISCRETECHARSTATE_ID Implied Constraint
TEST_ELEMENT DISCRETECHARSTATE_ID bigint 8  √  null
STEPMATRIXELEMENT.DISCRETECHARSTATE_ID Implied Constraint
DISTANCEMATRIXELEMENT DISTANCE double 8  √  null
DISTANCEMATRIXELEMENT DISTANCEMATRIXELEMENT_ID bigint 8  √ 
EXPLAIN_OBJECT DISTINCT char 1
CITATION DOI varchar 255  √  null
CITATION_EDITOR EDITOR_ORDER integer 4
CITATION_EDITOR EDITORS_PERSON_ID bigint 8
PERSON.PERSON_ID FK2A8955C568F6F619
CONTANCSTATE_VALUE ELEMENT varchar 255  √  null
COMPOUND_ELEMENT ELEMENT_ID bigint 8
MATRIXELEMENT.MATRIXELEMENT_ID FK31183048459091E5
ITEMVALUE ELEMENT_ID bigint 8
MATRIXELEMENT.MATRIXELEMENT_ID FK27B41A1E459091E5
STATEMODIFIER ELEMENT_ID bigint 8
MATRIXELEMENT.MATRIXELEMENT_ID FKD157BE48459091E5
MATRIXELEMENT ELEMENT_ORDER integer 4  √  null
TEST_ELEMENT ELEMENT_ORDER integer 4  √  null
GEOSPOT ELEVATION double 8  √  null
ROWSEGMENT ELEVATION double 8  √  null
PERSON EMAIL varchar 255  √  null
COLUMNRANGE ENDCOLINDEX integer 4  √  null
ROWSEGMENT ENDINDEX integer 4  √  null
EVENTS EVENT_DATE timestamp 16,6  √  null
EVENTS EVENT_ID bigint 8  √ 
ADVISE_INDEX EXPLAIN_LEVEL char 1 ''
EXPLAIN_ARGUMENT EXPLAIN_LEVEL char 1
EXPLAIN_STATEMENT.EXPLAIN_LEVEL SQL070118163138060
EXPLAIN_OBJECT EXPLAIN_LEVEL char 1
EXPLAIN_STATEMENT.EXPLAIN_LEVEL SQL070118163138030
EXPLAIN_OPERATOR EXPLAIN_LEVEL char 1
EXPLAIN_STATEMENT.EXPLAIN_LEVEL SQL070118163138000
EXPLAIN_PREDICATE EXPLAIN_LEVEL char 1
EXPLAIN_STATEMENT.EXPLAIN_LEVEL SQL070118163138050
EXPLAIN_STREAM EXPLAIN_LEVEL char 1
EXPLAIN_STATEMENT.EXPLAIN_LEVEL SQL070118163138080
EXPLAIN_INSTANCE EXPLAIN_OPTION char 1
ADVISE_INDEX EXPLAIN_REQUESTER varchar 128 ''
EXPLAIN_ARGUMENT EXPLAIN_REQUESTER varchar 128
EXPLAIN_STATEMENT.EXPLAIN_REQUESTER SQL070118163138060
EXPLAIN_OBJECT EXPLAIN_REQUESTER varchar 128
EXPLAIN_STATEMENT.EXPLAIN_REQUESTER SQL070118163138030
EXPLAIN_OPERATOR EXPLAIN_REQUESTER varchar 128
EXPLAIN_STATEMENT.EXPLAIN_REQUESTER SQL070118163138000
EXPLAIN_PREDICATE EXPLAIN_REQUESTER varchar 128
EXPLAIN_STATEMENT.EXPLAIN_REQUESTER SQL070118163138050
EXPLAIN_STREAM EXPLAIN_REQUESTER varchar 128
EXPLAIN_STATEMENT.EXPLAIN_REQUESTER SQL070118163138080
ADVISE_INDEX EXPLAIN_TIME timestamp 16,6 now
EXPLAIN_ARGUMENT EXPLAIN_TIME timestamp 16,6
EXPLAIN_STATEMENT.EXPLAIN_TIME SQL070118163138060
EXPLAIN_OBJECT EXPLAIN_TIME timestamp 16,6
EXPLAIN_STATEMENT.EXPLAIN_TIME SQL070118163138030
EXPLAIN_OPERATOR EXPLAIN_TIME timestamp 16,6
EXPLAIN_STATEMENT.EXPLAIN_TIME SQL070118163138000
EXPLAIN_PREDICATE EXPLAIN_TIME timestamp 16,6
EXPLAIN_STATEMENT.EXPLAIN_TIME SQL070118163138050
EXPLAIN_STREAM EXPLAIN_TIME timestamp 16,6
EXPLAIN_STATEMENT.EXPLAIN_TIME SQL070118163138080
GENETICCODE EXTENSIONS varchar 255  √  null
EXPLAIN_OBJECT EXTENTSIZE integer 4
STUDY_NEXUSFILE FILENAME varchar 255
EXPLAIN_PREDICATE FILTER_FACTOR double 8
ADVISE_INDEX FIRST2KEYCARD bigint 8 0
EXPLAIN_OBJECT FIRST2KEYCARD bigint 8
ADVISE_INDEX FIRST3KEYCARD bigint 8 0
EXPLAIN_OBJECT FIRST3KEYCARD bigint 8
ADVISE_INDEX FIRST4KEYCARD bigint 8 0
EXPLAIN_OBJECT FIRST4KEYCARD bigint 8
EXPLAIN_OPERATOR FIRST_COMM_COST double 8
EXPLAIN_OPERATOR FIRST_ROW_COST double 8
ADVISE_INDEX FIRSTKEYCARD bigint 8 0
EXPLAIN_OBJECT FIRSTKEYCARD bigint 8
PERSON FIRSTNAME varchar 255  √  null
TAXONLINK FOREIGNTAXONID varchar 255  √  null
GENETICCODESET FORMAT varchar 255  √  null
ADVISE_WORKLOAD FREQUENCY integer 4 1
STATEMODIFIER FREQUENCY double 8  √  null
ADVISE_INDEX FULLKEYCARD bigint 8 0
EXPLAIN_OBJECT FULLKEYCARD bigint 8
TAXONVARIANT FULLNAME varchar 255  √  null
MATRIXELEMENT GAP smallint 2  √  null
TEST_ELEMENT GAP smallint 2  √  null
ALGORITHM GAPMODE_ID bigint 8  √  null
GAPMODE.GAPMODE_ID FKB388C44FC6E814E6
MATRIX GAPSYMBOL varchar 255  √  null
ROWSEGMENT GENBACCESSION varchar 30  √  null
SPECIMENLABEL GENBANKID varchar 255  √  null
GENETICCODERECORD GENETICCODE_ID bigint 8  √  null
GENETICCODE.GENETICCODE_ID FK237932B76CB73FC6
CODERECORD_COLRANGE GENETICCODERECORD_ID bigint 8
GENETICCODERECORD.GENETICCODERECORD_ID FKA3E6C61EDC51C546
GENETICCODERECORD GENETICCODESET_ID bigint 8
GENETICCODESET.GENETICCODESET_ID FK237932B782D8ECCE
SPECIMENLABEL GEOSPOT_ID bigint 8  √  null
GEOSPOT.GEOSPOT_ID FK1E8F38CCA2039B9D
TAXON GROUPCODE integer 4  √  null
EXPLAIN_PREDICATE HOW_APPLIED char 5
ADVISE_INDEX IID smallint 2 0
ADVISE_WORKLOAD IMPORTANCE double 8 1
ANALYZEDDATA INPUT smallint 2  √  null
ROWSEGMENT INSTACRONYM varchar 50  √  null
EXPLAIN_OPERATOR IO_COST double 8
CITATION ISBN varchar 255  √  null
EXPLAIN_INSTANCE ISOLATION char 2
CITATION ISSUE varchar 255  √  null
MATRIX_ITEMDEFINITION ITEMDEFINITION_ID bigint 8
ITEMDEFINITION.ITEMDEFINITION_ID FK5717E0E4405A7CEE
MATRIXCOLUMN_ITEMDEFINITION ITEMDEFINITION_ID bigint 8
ITEMDEFINITION.ITEMDEFINITION_ID FKB556F8E405A7CEE
MATRIXELEMENT ITEMDEFINITION_ID bigint 8  √  null
ITEMDEFINITION.ITEMDEFINITION_ID FK90AE93FB405A7CEE
TEST_ELEMENT ITEMDEFINITION_ID bigint 8  √  null
ITEMDEFINITION.ITEMDEFINITION_ID Implied Constraint
ITEMVALUE ITEMVALUE_ID bigint 8  √ 
CITATION JOURNAL varchar 255  √  null
CITATION KEYWORDS varchar 255  √  null
PHYLOTREE LABEL varchar 255  √  null
STUDY LASTMODIFIEDDATE date 6  √  null
PERSON LASTNAME varchar 255
GEOSPOT LATITUDE double 8  √  null
ROWSEGMENT LATITUDE double 8  √  null
PHYLOTREENODE LEFTNODE bigint 8  √  null
TAXONVARIANT LEXICALQUALIFIER varchar 50  √  null
TAXONLABEL LINKED smallint 2  √  null
TAXONLINK LINKTYPE char 1
ROWSEGMENT LOCALITY varchar 255  √  null
EXPLAIN_INSTANCE LOCKLIST integer 4
EXPLAIN_INSTANCE LOCKS_AVAIL integer 4
EXPLAIN_ARGUMENT LONG_ARGUMENT_VALUE clob 2097152  √  null
GEOSPOT LONGITUDE double 8  √  null
ROWSEGMENT LONGITUDE double 8  √  null
PHYLOCHAR LOWERLIMIT double 8  √  null
ANALYZEDDATA MATRIX_ID bigint 8  √  null
MATRIX.MATRIX_ID FK8C96184255961AEE
ANCSTATESET MATRIX_ID bigint 8  √  null
MATRIX.MATRIX_ID FK879339E7A414944F
CHARPARTITION MATRIX_ID bigint 8  √  null
MATRIX.MATRIX_ID FKDEA9F834A414944F
CHARSET MATRIX_ID bigint 8  √  null
MATRIX.MATRIX_ID FK56D8ED2CA414944F
CHARWEIGHTSET MATRIX_ID bigint 8  √  null
MATRIX.MATRIX_ID FK99B8AC34A414944F
CODONPOSITIONSET MATRIX_ID bigint 8  √  null
MATRIX.MATRIX_ID FK4E501CC2A414944F
DISTANCEMATRIXELEMENT MATRIX_ID bigint 8
MATRIX.MATRIX_ID FK92D3DDE64B8EF343
GENETICCODESET MATRIX_ID bigint 8  √  null
MATRIX.MATRIX_ID FK6A12F7DCA414944F
MATRIX_ITEMDEFINITION MATRIX_ID bigint 8
MATRIX.MATRIX_ID FK5717E0E4AC5C19DD
MATRIXCOLUMN MATRIX_ID bigint 8  √  null
MATRIX.MATRIX_ID FK9B0BE57A414944F
MATRIXROW MATRIX_ID bigint 8  √  null
MATRIX.MATRIX_ID FKE4688E59A414944F
STATESET MATRIX_ID bigint 8  √  null
MATRIX.MATRIX_ID FK7D38523150CBAB47
SUB_MATRIX MATRIX_ID bigint 8
MATRIX.MATRIX_ID FK5F26A2C055961AEE
TYPESET MATRIX_ID bigint 8  √  null
MATRIX.MATRIX_ID FKF7F2B6C8A414944F
MATRIXCOLUMN_ITEMDEFINITION MATRIXCOLUMN_ID bigint 8
MATRIXCOLUMN.MATRIXCOLUMN_ID FKB556F8E8B2E884E
MATRIXELEMENT MATRIXCOLUMN_ID bigint 8  √  null
MATRIXCOLUMN.MATRIXCOLUMN_ID FK90AE93FB8B2E884E
TEST_ELEMENT MATRIXCOLUMN_ID bigint 8  √  null
MATRIXCOLUMN.MATRIXCOLUMN_ID Implied Constraint
MATRIX MATRIXDATATYPE_ID bigint 8  √  null
MATRIXDATATYPE.MATRIXDATATYPE_ID FK87208BC14CE484AE
TEST_ELEMENT MATRIXELEMENT_ID bigint 8  √ 
MATRIXELEMENT.MATRIXELEMENT_ID Implied Constraint
MATRIX MATRIXKIND_ID bigint 8  √  null
MATRIXKIND.MATRIXKIND_ID FK87208BC191BD3C8E
MATRIXELEMENT MATRIXROW_ID bigint 8  √  null
MATRIXROW.MATRIXROW_ID FK90AE93FBE7B3CDA6
ROWSEGMENT MATRIXROW_ID bigint 8
MATRIXROW.MATRIXROW_ID FKEE9AE819E7B3CDA6
TEST_ELEMENT MATRIXROW_ID bigint 8  √  null
MATRIXROW.MATRIXROW_ID Implied Constraint
MATRIX MATRIXTYPE char 1
EXPLAIN_INSTANCE MAXLOCKS smallint 2
ADVISE_INDEX MINPCTUSED smallint 2 0
MATRIX MISSINGSYMBOL varchar 255  √  null
PERSON MNAME varchar 255  √  null
SPECIMENLABEL MUSEUMNUMBER varchar 255  √  null
ADVISE_INDEX NAME varchar 128
ANALYSIS NAME varchar 255  √  null
ANALYSISSTEP NAME varchar 255  √  null
GEOSPOT NAME varchar 255  √  null
PHYLOTREENODE NAME varchar 255  √  null
SOFTWARE NAME varchar 255  √  null
STUDY NAME varchar 255  √  null
TAXON NAME varchar 255  √  null
TAXONAUTHORITY NAME varchar 255  √  null
TAXONVARIANT NAME varchar 255  √  null
TESTNODE NAME varchar 255  √  null
TAXONVARIANT NAMEBANKID bigint 8  √  null
TAXON NCBITAXID integer 4  √  null
PHYLOTREE NEWICKSTRING clob 4194304  √  null
TESTTREE NEWICKSTRING clob 4194304  √  null
STUDY_NEXUSFILE NEXUS clob 4194304
NEXUSFILEOBJECT NEXUSCONTENT clob 4194304  √  null
MATRIX NEXUSFILENAME varchar 255  √  null
PHYLOTREE NEXUSFILENAME varchar 255  √  null
NEXUSFILEOBJECT NEXUSFILEOBJECT_ID bigint 8  √ 
ADVISE_INDEX NLEAF integer 4 0
EXPLAIN_OBJECT NLEAF integer 4
ADVISE_INDEX NLEVELS smallint 2 0
EXPLAIN_OBJECT NLEVELS integer 4
PHYLOTREENODE NODEATTRIBUTE_ID bigint 8  √  null
NODEATTRIBUTE.NODEATTRIBUTE_ID FK3EA79944271A5763
PHYLOTREENODE NODEDEPTH integer 4  √  null
TESTNODE NODEDEPTH integer 4  √  null
ANALYSIS NOTES varchar 2000  √  null
ANALYSISSTEP NOTES varchar 2000  √  null
ANALYZEDDATA NOTES varchar 2000  √  null
DISCRETECHARSTATE NOTES varchar 255  √  null
GEOSPOT NOTES varchar 2000  √  null
ROWSEGMENT NOTES varchar 2000  √  null
STUDY NOTES varchar 2000  √  null
GENETICCODE NUCORDER varchar 255  √  null
EXPLAIN_OBJECT NUM_EMPTY_LEAFS bigint 8
EXPLAIN_OBJECT NUMRIDS bigint 8
EXPLAIN_OBJECT NUMRIDS_DELETED bigint 8
EXPLAIN_OBJECT OBJECT_NAME varchar 128
EXPLAIN_STREAM OBJECT_NAME varchar 128  √  null
EXPLAIN_OBJECT OBJECT_SCHEMA varchar 128
EXPLAIN_STREAM OBJECT_SCHEMA varchar 128  √  null
EXPLAIN_OBJECT OBJECT_TYPE char 2
EXPLAIN_ARGUMENT OPERATOR_ID integer 4
EXPLAIN_OPERATOR OPERATOR_ID integer 4
EXPLAIN_PREDICATE OPERATOR_ID integer 4
EXPLAIN_OPERATOR OPERATOR_TYPE char 6
ROWSEGMENT OTHERACCESSION varchar 50  √  null
EXPLAIN_OBJECT OVERFLOW integer 4
EXPLAIN_OBJECT OVERHEAD double 8
ADVISE_INDEX PACKED_DESC blob 1048576  √  null
ADVISE_INDEX PAGE_FETCH_PAIRS varchar 254 ''
CITATION PAGES varchar 255  √  null
EXPLAIN_OBJECT PAGES integer 4
EXPLAIN_INSTANCE PARALLELISM char 2
PHYLOTREENODE PARENT_ID bigint 8  √  null
PHYLOTREENODE.PHYLOTREENODE_ID FK3EA799445BCC767D
CSTREENODE PARENTNODE_ID bigint 8  √  null
CSTREENODE.CSTREENODE_ID FK82B9AB10F572A92
TREENODEEDGE PARENTNODE_ID bigint 8
PHYLOTREENODE.PHYLOTREENODE_ID FK7767285D1851763B
EXPLAIN_STREAM PARTITION_COLUMNS clob 2097152  √  null
USER PASSWORD varchar 100
ADVISE_INDEX PCTFREE smallint 2 -1
USER PERSON_ID bigint 8
PERSON.PERSON_ID FK27E3CBE3910672
PERSON PHONE varchar 50  √  null
CHARGROUP_PHYLOCHAR PHYLOCHAR_ID bigint 8
PHYLOCHAR.PHYLOCHAR_ID Implied Constraint
CHARSET_PHYLOCHAR PHYLOCHAR_ID bigint 8
PHYLOCHAR.PHYLOCHAR_ID Implied Constraint
DISCRETECHARSTATE PHYLOCHAR_ID bigint 8
PHYLOCHAR.PHYLOCHAR_ID FK2EEF2802FE41A723
MATRIXCOLUMN PHYLOCHAR_ID bigint 8  √  null
PHYLOCHAR.PHYLOCHAR_ID FK9B0BE57F5DECA46
MATRIXDATATYPE PHYLOCHAR_ID bigint 8  √  null
PHYLOCHAR.PHYLOCHAR_ID FKF054C4A5F5DECA46
ANALYZEDDATA PHYLOTREE_ID bigint 8  √  null
PHYLOTREE.PHYLOTREE_ID FK8C961842B710CB23
PHYLOTREENODE PHYLOTREE_ID bigint 8
PHYLOTREE.PHYLOTREE_ID FK3EA79944B710CB23
SUB_PHYLOTREE PHYLOTREE_ID bigint 8
PHYLOTREE.PHYLOTREE_ID Implied Constraint
TREEGROUP_PHYLOTREE PHYLOTREE_ID bigint 8
PHYLOTREE.PHYLOTREE_ID FKFB7D704B710CB23
TREESET_PHYLOTREE PHYLOTREE_ID bigint 8
PHYLOTREE.PHYLOTREE_ID FK31FC19A7B710CB23
CITATION PMID varchar 255  √  null
EXPLAIN_STREAM PMID smallint 2
ALGORITHM POLYTCOUNT_ID bigint 8  √  null
POLYTCOUNT.POLYTCOUNT_ID FKB388C44F9698D32E
GENETICCODE PREDEFINED smallint 2  √  null
EXPLAIN_PREDICATE PREDICATE_ID integer 4
EXPLAIN_STREAM PREDICATE_ID integer 4
EXPLAIN_PREDICATE PREDICATE_TEXT clob 2097152  √  null
EXPLAIN_OBJECT PREFETCHSIZE integer 4
ALGORITHM PROPERTYNAME varchar 255  √  null
ALGORITHM PROPERTYVALUE varchar 255  √  null
CITATION PUBLISHED smallint 2  √  null
MATRIX PUBLISHED smallint 2  √  null
PHYLOTREE PUBLISHED smallint 2  √  null
TESTTREE PUBLISHED smallint 2  √  null
CITATION PUBLISHER varchar 255  √  null
CITATION PUBLISHYEAR integer 4  √  null
EXPLAIN_STATEMENT QUERY_DEGREE integer 4
ADVISE_INDEX QUERYNO integer 4 0
EXPLAIN_STATEMENT QUERYNO integer 4
EXPLAIN_INSTANCE QUERYOPT integer 4
ADVISE_INDEX QUERYTAG char 20 ''
EXPLAIN_STATEMENT QUERYTAG char 20
EXPLAIN_OPERATOR RE_CPU_COST double 8
EXPLAIN_OPERATOR RE_IO_COST double 8
EXPLAIN_OPERATOR RE_TOTAL_COST double 8
CHARWEIGHT REALWEIGHT double 8  √  null
STUDY RELEASEDATE date 6  √  null
EXPLAIN_PREDICATE RELOP_TYPE char 2
ADVISE_INDEX REMARKS varchar 254  √  ''
EXPLAIN_INSTANCE REMARKS varchar 254  √  null
EXPLAIN_OPERATOR REMOTE_COMM_COST double 8
EXPLAIN_OPERATOR REMOTE_TOTAL_COST double 8
COLUMNRANGE REPEATINTERVAL integer 4  √  null
ADVISE_INDEX REVERSE_SCANS char 1 'N'
STATECHANGESET REVERSIBLE smallint 2  √  null
PHYLOTREENODE RIGHTNODE bigint 8  √  null
PHYLOTREE ROOTEDTREE smallint 2  √  null
TESTTREE ROOTEDTREE smallint 2  √  null
PHYLOTREE ROOTNODE_ID bigint 8  √  null
PHYLOTREENODE.PHYLOTREENODE_ID FK76F2E442F3D1CF03
TESTTREE ROOTNODE_ID bigint 8  √  null
TESTNODE.TESTNODE_ID FKEA5A0F30E9CB4961
EXPLAIN_OBJECT ROW_COUNT bigint 8
MATRIXROW ROW_ORDER integer 4  √  null
DISTANCEMATRIXELEMENT ROWLABEL_ID bigint 8
TAXONLABEL.TAXONLABEL_ID FK92D3DDE61F08BAE7
ROWSEGMENT ROWSEGMENT_ID bigint 8  √ 
ROWSEGMENT SAMPLEDATE date 6  √  null
ADVISE_INDEX SECTNO integer 4 0
EXPLAIN_ARGUMENT SECTNO integer 4
EXPLAIN_STATEMENT.SECTNO SQL070118163138060
EXPLAIN_OBJECT SECTNO integer 4
EXPLAIN_STATEMENT.SECTNO SQL070118163138030
EXPLAIN_OPERATOR SECTNO integer 4
EXPLAIN_STATEMENT.SECTNO SQL070118163138000
EXPLAIN_PREDICATE SECTNO integer 4
EXPLAIN_STATEMENT.SECTNO SQL070118163138050
EXPLAIN_STREAM SECTNO integer 4
EXPLAIN_STATEMENT.SECTNO SQL070118163138080
ADVISE_INDEX SEQUENTIAL_PAGES integer 4 0
EXPLAIN_OBJECT SEQUENTIAL_PAGES integer 4
PHYLOTREENODE SIBLING_ID bigint 8  √  null
PHYLOTREENODE.PHYLOTREENODE_ID FK3EA799443C348165
EXPLAIN_STREAM SINGLE_NODE char 5  √  null
EXPLAIN_STATEMENT SNAPSHOT blob 10485760  √  null
EXPLAIN_INSTANCE SNAPSHOT_TAKEN char 1
ANALYSISSTEP SOFTWARE_ID bigint 8  √  null
SOFTWARE.SOFTWARE_ID FK21F853A865EDD5F8
SOFTWARE SOFTWAREURL varchar 500  √  null
SOFTWARE SOFTWAREVERSION varchar 255  √  null
EXPLAIN_INSTANCE SORTHEAP integer 4
EXPLAIN_STREAM SOURCE_ID integer 4
ADVISE_INDEX SOURCE_NAME varchar 128 ''
EXPLAIN_ARGUMENT SOURCE_NAME varchar 128
EXPLAIN_STATEMENT.SOURCE_NAME SQL070118163138060
EXPLAIN_OBJECT SOURCE_NAME varchar 128
EXPLAIN_STATEMENT.SOURCE_NAME SQL070118163138030
EXPLAIN_OPERATOR SOURCE_NAME varchar 128
EXPLAIN_STATEMENT.SOURCE_NAME SQL070118163138000
EXPLAIN_PREDICATE SOURCE_NAME varchar 128
EXPLAIN_STATEMENT.SOURCE_NAME SQL070118163138050
EXPLAIN_STREAM SOURCE_NAME varchar 128
EXPLAIN_STATEMENT.SOURCE_NAME SQL070118163138080
ADVISE_INDEX SOURCE_SCHEMA varchar 128 ''
EXPLAIN_ARGUMENT SOURCE_SCHEMA varchar 128
EXPLAIN_STATEMENT.SOURCE_SCHEMA SQL070118163138060
EXPLAIN_OBJECT SOURCE_SCHEMA varchar 128
EXPLAIN_STATEMENT.SOURCE_SCHEMA SQL070118163138030
EXPLAIN_OPERATOR SOURCE_SCHEMA varchar 128
EXPLAIN_STATEMENT.SOURCE_SCHEMA SQL070118163138000
EXPLAIN_PREDICATE SOURCE_SCHEMA varchar 128
EXPLAIN_STATEMENT.SOURCE_SCHEMA SQL070118163138050
EXPLAIN_STREAM SOURCE_SCHEMA varchar 128
EXPLAIN_STATEMENT.SOURCE_SCHEMA SQL070118163138080
EXPLAIN_STREAM SOURCE_TYPE char 1
ADVISE_INDEX SOURCE_VERSION varchar 64 ''
EXPLAIN_ARGUMENT SOURCE_VERSION varchar 64
EXPLAIN_STATEMENT.SOURCE_VERSION SQL070118163138060
EXPLAIN_OBJECT SOURCE_VERSION varchar 64
EXPLAIN_STATEMENT.SOURCE_VERSION SQL070118163138030
EXPLAIN_OPERATOR SOURCE_VERSION varchar 64
EXPLAIN_STATEMENT.SOURCE_VERSION SQL070118163138000
EXPLAIN_PREDICATE SOURCE_VERSION varchar 64
EXPLAIN_STATEMENT.SOURCE_VERSION SQL070118163138050
EXPLAIN_STREAM SOURCE_VERSION varchar 64
EXPLAIN_STATEMENT.SOURCE_VERSION SQL070118163138080
SPECIMENLABEL SPECIMENLABEL_ID bigint 8  √ 
EXPLAIN_INSTANCE SQL_TYPE char 1
COLUMNRANGE STARTCOLINDEX integer 4  √  null
ROWSEGMENT STARTINDEX integer 4  √  null
ROWSEGMENT STATE varchar 50  √  null
STEPMATRIXELEMENT STATE1_ID bigint 8  √  null
DISCRETECHARSTATE.DISCRETECHARSTATE_ID FK891100AF6E972A88
STEPMATRIXELEMENT STATE2_ID bigint 8  √  null
DISCRETECHARSTATE.DISCRETECHARSTATE_ID FK891100AF6E979EE7
LEFTCHANGESET_CHARSTATE STATECHANGESET_ID bigint 8
STATECHANGESET.STATECHANGESET_ID FKC887720775763EAE
RIGHTCHANGESET_CHARSTATE STATECHANGESET_ID bigint 8
STATECHANGESET.STATECHANGESET_ID FKC8AFC9F275763EAE
MATRIXCOLUMN STATEFORMAT_ID bigint 8  √  null
STATEFORMAT.STATEFORMAT_ID FK9B0BE57BED40086
STATEMODIFIER STATEFORMAT_ID bigint 8
STATEFORMAT.STATEFORMAT_ID FKD157BE48BED40086
ADVISE_WORKLOAD STATEMENT_NO integer 4 1
ADVISE_WORKLOAD STATEMENT_TAG varchar 256 ''
ADVISE_WORKLOAD STATEMENT_TEXT clob 2097152
EXPLAIN_STATEMENT STATEMENT_TEXT clob 2097152
EXPLAIN_STATEMENT STATEMENT_TYPE char 2
STATEMODIFIER STATEMODIFIER_ID bigint 8  √ 
DISCRETECHARSTATE STATESET_ID bigint 8  √  null
STATESET.STATESET_ID FK2EEF2802163C67CE
EXPLAIN_OBJECT STATISTICS_TIME timestamp 16,6  √  null
EXPLAIN_OBJECT STATS_SRC char 1
ADVISE_INDEX STATS_TIME timestamp 16,6  √  now
ANALYSISSTEP STEP_ORDER integer 4  √  null
STEPMATRIXELEMENT STEPMATRIX_ID bigint 8
USERTYPE.USERTYPE_ID FK891100AF9E8198E
ADVISE_INDEX STMTNO integer 4 0
EXPLAIN_ARGUMENT STMTNO integer 4
EXPLAIN_STATEMENT.STMTNO SQL070118163138060
EXPLAIN_OBJECT STMTNO integer 4
EXPLAIN_STATEMENT.STMTNO SQL070118163138030
EXPLAIN_OPERATOR STMTNO integer 4
EXPLAIN_STATEMENT.STMTNO SQL070118163138000
EXPLAIN_PREDICATE STMTNO integer 4
EXPLAIN_STATEMENT.STMTNO SQL070118163138050
EXPLAIN_STREAM STMTNO integer 4
EXPLAIN_STATEMENT.STMTNO SQL070118163138080
EXPLAIN_STREAM STREAM_COUNT double 8
EXPLAIN_STREAM STREAM_ID integer 4
ANALYSIS STUDY_ID bigint 8  √  null
STUDY.STUDY_ID FKF19622DC3C572C3C
MATRIX STUDY_ID bigint 8  √  null
STUDY.STUDY_ID FK87208BC13C572C3C
NEXUSFILEOBJECT STUDY_ID bigint 8  √  null
STUDY.STUDY_ID Implied Constraint
PHYLOTREE STUDY_ID bigint 8  √  null
STUDY.STUDY_ID FK76F2E4423C572C3C
SPECIMENLABEL STUDY_ID bigint 8
STUDY.STUDY_ID Implied Constraint
STUDY_NEXUSFILE STUDY_ID bigint 8
STUDY.STUDY_ID FK47FC1EE53C572C3C
SUBMISSION STUDY_ID bigint 8
STUDY.STUDY_ID FKA120274C3C572C3C
TAXONLABEL STUDY_ID bigint 8  √  null
STUDY.STUDY_ID FK5F548A6A3C572C3C
TAXONLABELSET STUDY_ID bigint 8  √  null
STUDY.STUDY_ID FK28D3A5983C572C3C
TESTTREE STUDY_ID bigint 8  √  null
STUDY.STUDY_ID Implied Constraint
STUDY STUDYSTATUS_ID bigint 8  √  null
STUDYSTATUS.STUDYSTATUS_ID FK4B915A9255A519C
SUB_MATRIX SUBMISSION_ID bigint 8
SUBMISSION.SUBMISSION_ID FK5F26A2C08DFE4858
SUB_PHYLOTREE SUBMISSION_ID bigint 8
SUBMISSION.SUBMISSION_ID Implied Constraint
SUB_TAXONLABEL SUBMISSION_ID bigint 8
SUBMISSION.SUBMISSION_ID FK86909E98DFE4858
SUB_TREEBLOCK SUBMISSION_ID bigint 8
SUBMISSION.SUBMISSION_ID FK94D508308DFE4858
SUBMISSION SUBMISSIONNUMBER varchar 255  √  null
EXPLAIN_PREDICATE SUBQUERY char 1
DISCRETECHARSTATE SYMBOL char 1  √  null
MATRIX SYMBOLS varchar 255  √  null
MATRIXROW SYMBOLSTRING clob 524288  √  null
ADVISE_INDEX SYSTEM_REQUIRED smallint 2 0
EXPLAIN_OBJECT TABLESPACE_NAME varchar 128  √  null
EXPLAIN_STREAM TARGET_ID integer 4
EXPLAIN_STREAM TARGET_TYPE char 1
TAXONLABELSET TAXA smallint 2  √  null
SPECIMENLABEL TAXON_ID bigint 8  √  null
TAXON.TAXON_ID Implied Constraint
TAXONLINK TAXON_ID bigint 8
TAXON.TAXON_ID FKC102D9A41DE2FCDD
TAXONSET_TAXON TAXON_ID bigint 8
TAXON.TAXON_ID FKC656C9031DE2FCDD
TAXONVARIANT TAXON_ID bigint 8
TAXON.TAXON_ID FKEE3D127B1DE2FCDD
TAXONSET_TAXON TAXON_ORDER integer 4
TAXONLINK TAXONAUTHORITY_ID bigint 8
TAXONAUTHORITY.TAXONAUTHORITY_ID FKC102D9A43BF5F2F7
TAXONLABEL TAXONLABEL varchar 255  √  null
MATRIXROW TAXONLABEL_ID bigint 8
TAXONLABEL.TAXONLABEL_ID FKE4688E5963AB9FD7
PHYLOTREENODE TAXONLABEL_ID bigint 8  √  null
TAXONLABEL.TAXONLABEL_ID FK3EA7994463AB9FD7
ROWSEGMENT TAXONLABEL_ID bigint 8  √  null
TAXONLABEL.TAXONLABEL_ID FKEE9AE81963AB9FD7
SUB_TAXONLABEL TAXONLABEL_ID bigint 8
TAXONLABEL.TAXONLABEL_ID FK86909E963AB9FD7
TAXONLABELROUP_TAXONLABEL TAXONLABEL_ID bigint 8
TAXONLABEL.TAXONLABEL_ID FK4B1D0BC763AB9FD7
TAXONLABELSET_TAXONLABEL TAXONLABEL_ID bigint 8
TAXONLABEL.TAXONLABEL_ID FK2EB54B7163AB9FD7
TAXONLABELSET_TAXONLABEL TAXONLABEL_ORDER integer 4
TAXONLABELROUP_TAXONLABEL TAXONLABELGROUP_ID bigint 8
TAXONLABELGROUP.TAXONLABELGROUP_ID FK4B1D0BC7294B993D
TAXONLABELGROUP TAXONLABELPARTITION_ID bigint 8  √  null
TAXONLABELPARTITION.TAXONLABELPARTITION_ID FK4AE2663513A813DD
MATRIX TAXONLABELSET_ID bigint 8  √  null
TAXONLABELSET.TAXONLABELSET_ID FK87208BC1E310471D
TAXONLABELSET_TAXONLABEL TAXONLABELSET_ID bigint 8
TAXONLABELSET.TAXONLABELSET_ID FK2EB54B71E310471D
TREEBLOCK TAXONLABELSET_ID bigint 8  √  null
TAXONLABELSET.TAXONLABELSET_ID FKA826F38FE310471D
TAXONLINK TAXONLINK_ID bigint 8  √ 
TAXONSET_TAXON TAXONSET_ID bigint 8
TAXONSET.TAXONSET_ID FKC656C90313C28457
TAXONLABEL TAXONVARIANT_ID bigint 8  √  null
TAXONVARIANT.TAXONVARIANT_ID FK5F548A6A3C1B6F7
PHYLOTREE TB1_TREEID varchar 30  √  null
ANALYSISSTEP TB_ANALYSISID varchar 34  √  null
MATRIX TB_MATRIXID varchar 30  √  null
CITATION TB_STUDYID varchar 30  √  null
STUDY TB_STUDYID varchar 30  √  null
ADVISE_INDEX TBCREATOR varchar 128 ''
ADVISE_INDEX TBNAME varchar 128
TESTNODE TESTTREE_ID bigint 8
TESTTREE.TESTTREE_ID FKEA5749941C5CCA31
SPECIMENLABEL TISSUE varchar 255  √  null
ANCESTRALSTATE TITLE varchar 255  √  null
ANCSTATESET TITLE varchar 255  √  null
CHARGROUP TITLE varchar 255  √  null
CHARPARTITION TITLE varchar 255  √  null
CHARSET TITLE varchar 255  √  null
CHARWEIGHTSET TITLE varchar 255  √  null
CITATION TITLE varchar 255  √  null
CODONPOSITIONSET TITLE varchar 255  √  null
EVENTS TITLE varchar 255  √  null
GENETICCODE TITLE varchar 255  √  null
GENETICCODESET TITLE varchar 255  √  null
MATRIX TITLE varchar 255  √  null
PHYLOTREE TITLE varchar 255  √  null
ROWSEGMENT TITLE varchar 255  √  null
STATECHANGESET TITLE varchar 255  √  null
STATESET TITLE varchar 255  √  null
TAXONLABELGROUP TITLE varchar 255  √  null
TAXONLABELPARTITION TITLE varchar 255  √  null
TAXONLABELSET TITLE varchar 255  √  null
TAXONSET TITLE varchar 255  √  null
TESTTREE TITLE varchar 255  √  null
TREEBLOCK TITLE varchar 255  √  null
TREEGROUP TITLE varchar 255  √  null
TREEPARTITION TITLE varchar 255  √  null
TREESET TITLE varchar 255  √  null
TYPESET TITLE varchar 255  √  null
USERTYPE TITLE varchar 255  √  null
EXPLAIN_OPERATOR TOTAL_COST double 8
EXPLAIN_STATEMENT TOTAL_COST double 8
STEPMATRIXELEMENT TRANSCOST double 8  √  null
EXPLAIN_OBJECT TRANSFER_RATE double 8
TREESET_PHYLOTREE TREE_ORDER integer 4
PHYLOTREE TREEATTRIBUTE_ID bigint 8  √  null
TREEATTRIBUTE.TREEATTRIBUTE_ID FK76F2E442A3015CE3
TESTTREE TREEATTRIBUTE_ID bigint 8  √  null
TREEATTRIBUTE.TREEATTRIBUTE_ID Implied Constraint
PHYLOTREE TREEBLOCK_ID bigint 8  √  null
TREEBLOCK.TREEBLOCK_ID FK76F2E442BFD107C3
SUB_TREEBLOCK TREEBLOCK_ID bigint 8
TREEBLOCK.TREEBLOCK_ID FK94D50830BFD107C3
TREEGROUP_PHYLOTREE TREEGROUP_ID bigint 8
TREEGROUP.TREEGROUP_ID FKFB7D7045E56A83
PHYLOTREE TREEKIND_ID bigint 8  √  null
TREEKIND.TREEKIND_ID FK76F2E442FE2812F1
ANALYZEDDATA TREELENGTH integer 4  √  null
TREENODEEDGE TREENODEEDGE_ID bigint 8  √ 
TREEGROUP TREEPARTITION_ID bigint 8  √  null
TREEPARTITION.TREEPARTITION_ID FKA870258180CBD223
PHYLOTREE TREEQUALITY_ID bigint 8  √  null
TREEQUALITY.TREEQUALITY_ID FK76F2E442EA08B443
TESTTREE TREEQUALITY_ID bigint 8  √  null
TREEQUALITY.TREEQUALITY_ID Implied Constraint
TREESET_PHYLOTREE TREESET_ID bigint 8
TREESET.TREESET_ID FK31FC19A7EC59B1E3
PHYLOTREE TREETYPE_ID bigint 8  √  null
TREETYPE.TREETYPE_ID FK76F2E442F5AEA931
TESTTREE TREETYPE_ID bigint 8  √  null
TREETYPE.TREETYPE_ID Implied Constraint
MATRIX TRIANGLE varchar 255  √  null
ALGORITHM TYPE char 1
ANALYZEDDATA TYPE char 1
ANCESTRALSTATE TYPE char 1
CHARSET TYPE char 1
CHARWEIGHT TYPE char 1
CITATION TYPE char 1
MATRIXELEMENT TYPE char 1
PHYLOCHAR TYPE char 1
TEST_ELEMENT TYPE char 1
USERTYPE TYPE char 1
MATRIX TYPESET_ID bigint 8  √  null
TYPESET.TYPESET_ID FK87208BC14D737E46
USERTYPERECORD TYPESET_ID bigint 8  √  null
TYPESET.TYPESET_ID FK136AF6164D737E46
TAXON UBIONAMEBANKID bigint 8  √  null
ADVISE_INDEX UNIQUE_COLCOUNT smallint 2 -1
ADVISE_INDEX UNIQUERULE char 1 ''
EXPLAIN_STATEMENT UPDATABLE char 1
PHYLOCHAR UPPERLIMIT double 8  √  null
CITATION URL varchar 255  √  null
ADVISE_INDEX USE_INDEX char 1  √  null
STUDY USER_ID bigint 8  √  null
USER.USER_ID FK4B915A9BEF300B2
SUBMISSION USER_ID bigint 8  √  null
USER.USER_ID FKA120274CBEF300B2
ADVISE_INDEX USERDEFINED smallint 2 0
USER USERNAME varchar 100
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
ANALYSIS VALIDATED smallint 2  √  null
ITEMVALUE VALUE varchar 255  √  null
MATRIXELEMENT VALUE double 8  √  null
TEST_ELEMENT VALUE double 8  √  null
ALGORITHM VERSION integer 4  √  null
ANALYSIS VERSION integer 4  √  null
ANALYSISSTEP VERSION integer 4  √  null
ANALYZEDDATA VERSION integer 4  √  null
ANCESTRALSTATE VERSION integer 4  √  null
ANCSTATESET VERSION integer 4  √  null
CHARGROUP VERSION integer 4  √  null
CHARPARTITION VERSION integer 4  √  null
CHARSET VERSION integer 4  √  null
CHARWEIGHT VERSION integer 4  √  null
CHARWEIGHTSET VERSION integer 4  √  null
CITATION VERSION integer 4  √  null
CITATIONSTATUS VERSION integer 4  √  null
CODONPOSITIONSET VERSION integer 4  √  null
COLUMNRANGE VERSION integer 4  √  null
CSTREENODE VERSION integer 4  √  null
DISCRETECHARSTATE VERSION integer 4  √  null
DISTANCEMATRIXELEMENT VERSION integer 4  √  null
GAPMODE VERSION integer 4  √  null
GENETICCODE VERSION integer 4  √  null
GENETICCODERECORD VERSION integer 4  √  null
GENETICCODESET VERSION integer 4  √  null
GEOSPOT VERSION integer 4  √  null
ITEMDEFINITION VERSION integer 4  √  null
ITEMVALUE VERSION integer 4  √  null
MATRIX VERSION integer 4  √  null
MATRIXCOLUMN VERSION integer 4  √  null
MATRIXDATATYPE VERSION integer 4  √  null
MATRIXELEMENT VERSION integer 4  √  null
MATRIXKIND VERSION integer 4  √  null
MATRIXROW VERSION integer 4  √  null
NEXUSFILEOBJECT VERSION integer 4  √  null
NODEATTRIBUTE VERSION integer 4  √  null
PERSON VERSION integer 4  √  null
PHYLOCHAR VERSION integer 4  √  null
PHYLOTREE VERSION integer 4  √  null
PHYLOTREENODE VERSION integer 4  √  null
POLYTCOUNT VERSION integer 4  √  null
ROWSEGMENT VERSION integer 4  √  null
SOFTWARE VERSION integer 4  √  null
SPECIMENLABEL VERSION integer 4  √  null
STATECHANGESET VERSION integer 4  √  null
STATEFORMAT VERSION integer 4  √  null
STATEMODIFIER VERSION integer 4  √  null
STATESET VERSION integer 4  √  null
STEPMATRIXELEMENT VERSION integer 4  √  null
STUDY VERSION integer 4  √  null
STUDYSTATUS VERSION integer 4  √  null
SUBMISSION VERSION integer 4  √  null
TAXON VERSION integer 4  √  null
TAXONAUTHORITY VERSION integer 4  √  null
TAXONLABEL VERSION integer 4  √  null
TAXONLABELGROUP VERSION integer 4  √  null
TAXONLABELPARTITION VERSION integer 4  √  null
TAXONLABELSET VERSION integer 4  √  null
TAXONLINK VERSION integer 4  √  null
TAXONSET VERSION integer 4  √  null
TAXONVARIANT VERSION integer 4  √  null
TEST_ELEMENT VERSION integer 4  √  null
TESTNODE VERSION integer 4  √  null
TESTTREE VERSION integer 4  √  null
TREEATTRIBUTE VERSION integer 4  √  null
TREEBLOCK VERSION integer 4  √  null
TREEGROUP VERSION integer 4  √  null
TREEKIND VERSION integer 4  √  null
TREENODEEDGE VERSION integer 4  √  null
TREEPARTITION VERSION integer 4  √  null
TREEQUALITY VERSION integer 4  √  null
TREESET VERSION integer 4  √  null
TREETYPE VERSION integer 4  √  null
TYPESET 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
ADVISE_WORKLOAD WEIGHT double 8 1
CHARWEIGHT WEIGHT integer 4  √  null
EXPLAIN_PREDICATE WHEN_EVALUATED char 3
EXPLAIN_OBJECT WIDTH integer 4
ADVISE_WORKLOAD WORKLOAD_NAME char 128 'WK0'
USERTYPE USERTYPE_ID bigint 8  √ 
ALGORITHM.USERTYPE_ID FKB388C44F92E6A38E
CSTREENODE.CSTREE_ID FK82B9AB10C6999FCE
STEPMATRIXELEMENT.STEPMATRIX_ID FK891100AF9E8198E
USERTYPERECORD.USERTYPE_ID FK136AF61692E6A38E
GAPMODE GAPMODE_ID bigint 8  √ 
ALGORITHM.GAPMODE_ID FKB388C44FC6E814E6
POLYTCOUNT POLYTCOUNT_ID bigint 8  √ 
ALGORITHM.POLYTCOUNT_ID FKB388C44F9698D32E
STUDY 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
ALGORITHM ALGORITHM_ID bigint 8  √ 
ANALYSISSTEP.ALGORITHM_ID FK21F853A848A2817C
ANALYSIS ANALYSIS_ID bigint 8  √ 
ANALYSISSTEP.ANALYSIS_ID FK21F853A8D1884DD8
SOFTWARE SOFTWARE_ID bigint 8  √ 
ANALYSISSTEP.SOFTWARE_ID FK21F853A865EDD5F8
MATRIX MATRIX_ID bigint 8  √ 
ANALYZEDDATA.MATRIX_ID FK8C96184255961AEE
ANCSTATESET.MATRIX_ID FK879339E7A414944F
CHARPARTITION.MATRIX_ID FKDEA9F834A414944F
CHARSET.MATRIX_ID FK56D8ED2CA414944F
CHARWEIGHTSET.MATRIX_ID FK99B8AC34A414944F
CODONPOSITIONSET.MATRIX_ID FK4E501CC2A414944F
DISTANCEMATRIXELEMENT.MATRIX_ID FK92D3DDE64B8EF343
GENETICCODESET.MATRIX_ID FK6A12F7DCA414944F
MATRIX_ITEMDEFINITION.MATRIX_ID FK5717E0E4AC5C19DD
MATRIXCOLUMN.MATRIX_ID FK9B0BE57A414944F
MATRIXROW.MATRIX_ID FKE4688E59A414944F
STATESET.MATRIX_ID FK7D38523150CBAB47
SUB_MATRIX.MATRIX_ID FK5F26A2C055961AEE
TYPESET.MATRIX_ID FKF7F2B6C8A414944F
PHYLOTREE PHYLOTREE_ID bigint 8  √ 
ANALYZEDDATA.PHYLOTREE_ID FK8C961842B710CB23
PHYLOTREENODE.PHYLOTREE_ID FK3EA79944B710CB23
SUB_PHYLOTREE.PHYLOTREE_ID Implied Constraint
TREEGROUP_PHYLOTREE.PHYLOTREE_ID FKFB7D704B710CB23
TREESET_PHYLOTREE.PHYLOTREE_ID FK31FC19A7B710CB23
ANALYSISSTEP ANALYSISSTEP_ID bigint 8  √ 
ANALYZEDDATA.ANALYSISSTEP_ID FK8C9618424BA97F78
DISCRETECHARSTATE DISCRETECHARSTATE_ID bigint 8  √ 
ANCESTRALSTATE.DISCRETECHARSTATE_ID FK3FA14284F4803CE6
CSTREENODE.DISCRETECHARSTATE_ID FK82B9AB10F4803CE6
LEFTCHANGESET_CHARSTATE.DISCRETECHARSTATE_ID FKC8877207F4803CE6
MATRIXELEMENT.DISCRETECHARSTATE_ID FK90AE93FBF4803CE6
RIGHTCHANGESET_CHARSTATE.DISCRETECHARSTATE_ID FKC8AFC9F2F4803CE6
STATEMODIFIER.DISCRETECHARSTATE_ID FKD157BE48F4803CE6
STEPMATRIXELEMENT.STATE1_ID FK891100AF6E972A88
STEPMATRIXELEMENT.STATE2_ID FK891100AF6E979EE7
STEPMATRIXELEMENT.DISCRETECHARSTATE_ID Implied Constraint
ANCSTATESET ANCSTATESET_ID bigint 8  √ 
ANCESTRALSTATE.ANCSTATESET_ID FK3FA14284684F6406
MATRIX.ANCSTATESET_ID FK87208BC1684F6406
CHARPARTITION CHARPARTITION_ID bigint 8  √ 
CHARGROUP.CHARPARTITION_ID FK3AF18C91AA11DC6
COLUMNRANGE COLUMNRANGE_ID bigint 8  √ 
CHARGROUP_COLRANGE.COLUMNRANGE_ID FKB2D8C29379A523E6
CHARSET_COLRANGE.COLUMNRANGE_ID FK2CBD9079A523E6
CHARWEIGHT_COLRANGE.COLUMNRANGE_ID FK54CA674E79A523E6
CODERECORD_COLRANGE.COLUMNRANGE_ID FKA3E6C61E79A523E6
CODONCHAR1_COLRANGE.COLUMNRANGE_ID FKDA5AD4F879A523E6
CODONCHAR2_COLRANGE.COLUMNRANGE_ID FKCEA4461779A523E6
CODONCHAR3_COLRANGE.COLUMNRANGE_ID FKC2EDB73679A523E6
CODONNONCODING_COLRANGE.COLUMNRANGE_ID FK307897FC79A523E6
USERTYPERRD_COLRANGE.COLUMNRANGE_ID FK405805DD79A523E6
CHARGROUP CHARGROUP_ID bigint 8  √ 
CHARGROUP_COLRANGE.CHARGROUP_ID FKB2D8C293971FFFA6
CHARGROUP_PHYLOCHAR.CHARGROUP_ID Implied Constraint
CHARSET CHARSET_ID bigint 8  √ 
CHARSET_COLRANGE.CHARSET_ID FK2CBD90416D5B50
CHARSET_PHYLOCHAR.CHARSET_ID Implied Constraint
MATRIX.CHARSET_ID FK87208BC145534A9C
CHARWEIGHTSET CHARWEIGHTSET_ID bigint 8  √ 
CHARWEIGHT.CHARWEIGHTSET_ID FK8CC7694EE9B425A6
MATRIX.CHARWEIGHTSET_ID FK87208BC1E9B425A6
CHARWEIGHT CHARWEIGHT_ID bigint 8  √ 
CHARWEIGHT_COLRANGE.CHARWEIGHT_ID FK54CA674EF9A75EE
CITATIONSTATUS CITATIONSTATUS_ID bigint 8  √ 
CITATION.CITATIONSTATUS_ID FKD8A7FAE74C983658
CITATION CITATION_ID bigint 8  √ 
CITATION_AUTHOR.CITATION_ID FK24AA55E38E1E4DF8
CITATION_EDITOR.CITATION_ID FK2A8955C5EC93F501
STUDY.CITATION_ID FK4B915A98E1E4DF8
PERSON PERSON_ID bigint 8  √ 
CITATION_AUTHOR.AUTHORS_PERSON_ID FK24AA55E36707573B
CITATION_EDITOR.EDITORS_PERSON_ID FK2A8955C568F6F619
USER.PERSON_ID FK27E3CBE3910672
GENETICCODERECORD GENETICCODERECORD_ID bigint 8  √ 
CODERECORD_COLRANGE.GENETICCODERECORD_ID FKA3E6C61EDC51C546
CODONPOSITIONSET CODONPOSITIONSET_ID bigint 8  √ 
CODONCHAR1_COLRANGE.CODONPOSITIONSET_ID FKDA5AD4F8491DB20E
CODONCHAR2_COLRANGE.CODONPOSITIONSET_ID FKCEA44617491DB20E
CODONCHAR3_COLRANGE.CODONPOSITIONSET_ID FKC2EDB736491DB20E
CODONNONCODING_COLRANGE.CODONPOSITIONSET_ID FK307897FC491DB20E
MATRIX.CODONPOSITIONSET_ID FK87208BC1491DB20E
MATRIXELEMENT MATRIXELEMENT_ID bigint 8  √ 
COMPOUND_ELEMENT.COMPOUND_ID FK311830485F4F7CEB
COMPOUND_ELEMENT.ELEMENT_ID FK31183048459091E5
ITEMVALUE.ELEMENT_ID FK27B41A1E459091E5
STATEMODIFIER.ELEMENT_ID FKD157BE48459091E5
TEST_ELEMENT.MATRIXELEMENT_ID Implied Constraint
ANCESTRALSTATE ANCESTRALSTATE_ID bigint 8  √ 
CONTANCSTATE_VALUE.ANCSTATE_ID FKA84B8C3FD450D2BD
DISCRETECHARSTATE.ANCESTRALSTATE_ID FK2EEF2802C7BEAAFE
CSTREENODE CSTREENODE_ID bigint 8  √ 
CSTREENODE.PARENTNODE_ID FK82B9AB10F572A92
PHYLOCHAR PHYLOCHAR_ID bigint 8  √ 
CHARGROUP_PHYLOCHAR.PHYLOCHAR_ID Implied Constraint
CHARSET_PHYLOCHAR.PHYLOCHAR_ID Implied Constraint
DISCRETECHARSTATE.PHYLOCHAR_ID FK2EEF2802FE41A723
MATRIXCOLUMN.PHYLOCHAR_ID FK9B0BE57F5DECA46
MATRIXDATATYPE.PHYLOCHAR_ID FKF054C4A5F5DECA46
STATESET STATESET_ID bigint 8  √ 
DISCRETECHARSTATE.STATESET_ID FK2EEF2802163C67CE
TAXONLABEL TAXONLABEL_ID bigint 8  √ 
DISTANCEMATRIXELEMENT.COLUMNLABEL_ID FK92D3DDE6C1429863
DISTANCEMATRIXELEMENT.ROWLABEL_ID FK92D3DDE61F08BAE7
MATRIXROW.TAXONLABEL_ID FKE4688E5963AB9FD7
PHYLOTREENODE.TAXONLABEL_ID FK3EA7994463AB9FD7
ROWSEGMENT.TAXONLABEL_ID FKEE9AE81963AB9FD7
SUB_TAXONLABEL.TAXONLABEL_ID FK86909E963AB9FD7
TAXONLABELROUP_TAXONLABEL.TAXONLABEL_ID FK4B1D0BC763AB9FD7
TAXONLABELSET_TAXONLABEL.TAXONLABEL_ID FK2EB54B7163AB9FD7
EXPLAIN_STATEMENT EXPLAIN_LEVEL char 1
EXPLAIN_ARGUMENT.EXPLAIN_LEVEL SQL070118163138060
EXPLAIN_OBJECT.EXPLAIN_LEVEL SQL070118163138030
EXPLAIN_OPERATOR.EXPLAIN_LEVEL SQL070118163138000
EXPLAIN_PREDICATE.EXPLAIN_LEVEL SQL070118163138050
EXPLAIN_STREAM.EXPLAIN_LEVEL SQL070118163138080
EXPLAIN_STATEMENT EXPLAIN_REQUESTER varchar 128
EXPLAIN_ARGUMENT.EXPLAIN_REQUESTER SQL070118163138060
EXPLAIN_OBJECT.EXPLAIN_REQUESTER SQL070118163138030
EXPLAIN_OPERATOR.EXPLAIN_REQUESTER SQL070118163138000
EXPLAIN_PREDICATE.EXPLAIN_REQUESTER SQL070118163138050
EXPLAIN_STREAM.EXPLAIN_REQUESTER SQL070118163138080
EXPLAIN_INSTANCE.EXPLAIN_REQUESTER SQL070118163137990
EXPLAIN_STATEMENT EXPLAIN_TIME timestamp 16,6
EXPLAIN_ARGUMENT.EXPLAIN_TIME SQL070118163138060
EXPLAIN_OBJECT.EXPLAIN_TIME SQL070118163138030
EXPLAIN_OPERATOR.EXPLAIN_TIME SQL070118163138000
EXPLAIN_PREDICATE.EXPLAIN_TIME SQL070118163138050
EXPLAIN_STREAM.EXPLAIN_TIME SQL070118163138080
EXPLAIN_INSTANCE.EXPLAIN_TIME SQL070118163137990
EXPLAIN_STATEMENT SECTNO integer 4
EXPLAIN_ARGUMENT.SECTNO SQL070118163138060
EXPLAIN_OBJECT.SECTNO SQL070118163138030
EXPLAIN_OPERATOR.SECTNO SQL070118163138000
EXPLAIN_PREDICATE.SECTNO SQL070118163138050
EXPLAIN_STREAM.SECTNO SQL070118163138080
EXPLAIN_STATEMENT SOURCE_NAME varchar 128
EXPLAIN_ARGUMENT.SOURCE_NAME SQL070118163138060
EXPLAIN_OBJECT.SOURCE_NAME SQL070118163138030
EXPLAIN_OPERATOR.SOURCE_NAME SQL070118163138000
EXPLAIN_PREDICATE.SOURCE_NAME SQL070118163138050
EXPLAIN_STREAM.SOURCE_NAME SQL070118163138080
EXPLAIN_INSTANCE.SOURCE_NAME SQL070118163137990
EXPLAIN_STATEMENT SOURCE_SCHEMA varchar 128
EXPLAIN_ARGUMENT.SOURCE_SCHEMA SQL070118163138060
EXPLAIN_OBJECT.SOURCE_SCHEMA SQL070118163138030
EXPLAIN_OPERATOR.SOURCE_SCHEMA SQL070118163138000
EXPLAIN_PREDICATE.SOURCE_SCHEMA SQL070118163138050
EXPLAIN_STREAM.SOURCE_SCHEMA SQL070118163138080
EXPLAIN_INSTANCE.SOURCE_SCHEMA SQL070118163137990
EXPLAIN_STATEMENT SOURCE_VERSION varchar 64
EXPLAIN_ARGUMENT.SOURCE_VERSION SQL070118163138060
EXPLAIN_OBJECT.SOURCE_VERSION SQL070118163138030
EXPLAIN_OPERATOR.SOURCE_VERSION SQL070118163138000
EXPLAIN_PREDICATE.SOURCE_VERSION SQL070118163138050
EXPLAIN_STREAM.SOURCE_VERSION SQL070118163138080
EXPLAIN_INSTANCE.SOURCE_VERSION SQL070118163137990
EXPLAIN_STATEMENT STMTNO integer 4
EXPLAIN_ARGUMENT.STMTNO SQL070118163138060
EXPLAIN_OBJECT.STMTNO SQL070118163138030
EXPLAIN_OPERATOR.STMTNO SQL070118163138000
EXPLAIN_PREDICATE.STMTNO SQL070118163138050
EXPLAIN_STREAM.STMTNO SQL070118163138080
EXPLAIN_INSTANCE EXPLAIN_REQUESTER varchar 128
EXPLAIN_STATEMENT.EXPLAIN_REQUESTER SQL070118163137990
EXPLAIN_INSTANCE EXPLAIN_TIME timestamp 16,6
EXPLAIN_STATEMENT.EXPLAIN_TIME SQL070118163137990
EXPLAIN_INSTANCE SOURCE_NAME varchar 128
EXPLAIN_STATEMENT.SOURCE_NAME SQL070118163137990
EXPLAIN_INSTANCE SOURCE_SCHEMA varchar 128
EXPLAIN_STATEMENT.SOURCE_SCHEMA SQL070118163137990
EXPLAIN_INSTANCE SOURCE_VERSION varchar 64
EXPLAIN_STATEMENT.SOURCE_VERSION SQL070118163137990
GENETICCODE GENETICCODE_ID bigint 8  √ 
GENETICCODERECORD.GENETICCODE_ID FK237932B76CB73FC6
GENETICCODESET GENETICCODESET_ID bigint 8  √ 
GENETICCODERECORD.GENETICCODESET_ID FK237932B782D8ECCE
STATECHANGESET STATECHANGESET_ID bigint 8  √ 
LEFTCHANGESET_CHARSTATE.STATECHANGESET_ID FKC887720775763EAE
RIGHTCHANGESET_CHARSTATE.STATECHANGESET_ID FKC8AFC9F275763EAE
TAXONLABELSET TAXONLABELSET_ID bigint 8  √ 
MATRIX.TAXONLABELSET_ID FK87208BC1E310471D
TAXONLABELSET_TAXONLABEL.TAXONLABELSET_ID FK2EB54B71E310471D
TREEBLOCK.TAXONLABELSET_ID FKA826F38FE310471D
TYPESET TYPESET_ID bigint 8  √ 
MATRIX.TYPESET_ID FK87208BC14D737E46
USERTYPERECORD.TYPESET_ID FK136AF6164D737E46
MATRIXDATATYPE MATRIXDATATYPE_ID bigint 8  √ 
MATRIX.MATRIXDATATYPE_ID FK87208BC14CE484AE
MATRIXKIND MATRIXKIND_ID bigint 8  √ 
MATRIX.MATRIXKIND_ID FK87208BC191BD3C8E
STATEFORMAT STATEFORMAT_ID bigint 8  √ 
MATRIXCOLUMN.STATEFORMAT_ID FK9B0BE57BED40086
STATEMODIFIER.STATEFORMAT_ID FKD157BE48BED40086
ITEMDEFINITION ITEMDEFINITION_ID bigint 8  √ 
MATRIX_ITEMDEFINITION.ITEMDEFINITION_ID FK5717E0E4405A7CEE
MATRIXCOLUMN_ITEMDEFINITION.ITEMDEFINITION_ID FKB556F8E405A7CEE
MATRIXELEMENT.ITEMDEFINITION_ID FK90AE93FB405A7CEE
TEST_ELEMENT.ITEMDEFINITION_ID Implied Constraint
MATRIXCOLUMN MATRIXCOLUMN_ID bigint 8  √ 
MATRIXCOLUMN_ITEMDEFINITION.MATRIXCOLUMN_ID FKB556F8E8B2E884E
MATRIXELEMENT.MATRIXCOLUMN_ID FK90AE93FB8B2E884E
TEST_ELEMENT.MATRIXCOLUMN_ID Implied Constraint
MATRIXROW MATRIXROW_ID bigint 8  √ 
MATRIXELEMENT.MATRIXROW_ID FK90AE93FBE7B3CDA6
ROWSEGMENT.MATRIXROW_ID FKEE9AE819E7B3CDA6
TEST_ELEMENT.MATRIXROW_ID Implied Constraint
PHYLOTREENODE PHYLOTREENODE_ID bigint 8  √ 
PHYLOTREE.ROOTNODE_ID FK76F2E442F3D1CF03
PHYLOTREENODE.CHILD_ID FK3EA79944434FDCCB
PHYLOTREENODE.PARENT_ID FK3EA799445BCC767D
PHYLOTREENODE.SIBLING_ID FK3EA799443C348165
TREENODEEDGE.CHILDNODE_ID FK7767285D27FD0589
TREENODEEDGE.PARENTNODE_ID FK7767285D1851763B
TREEBLOCK TREEBLOCK_ID bigint 8  √ 
PHYLOTREE.TREEBLOCK_ID FK76F2E442BFD107C3
SUB_TREEBLOCK.TREEBLOCK_ID FK94D50830BFD107C3
TREEATTRIBUTE TREEATTRIBUTE_ID bigint 8  √ 
PHYLOTREE.TREEATTRIBUTE_ID FK76F2E442A3015CE3
TESTTREE.TREEATTRIBUTE_ID Implied Constraint
TREEKIND TREEKIND_ID bigint 8  √ 
PHYLOTREE.TREEKIND_ID FK76F2E442FE2812F1
TREEQUALITY TREEQUALITY_ID bigint 8  √ 
PHYLOTREE.TREEQUALITY_ID FK76F2E442EA08B443
TESTTREE.TREEQUALITY_ID Implied Constraint
TREETYPE TREETYPE_ID bigint 8  √ 
PHYLOTREE.TREETYPE_ID FK76F2E442F5AEA931
TESTTREE.TREETYPE_ID Implied Constraint
NODEATTRIBUTE NODEATTRIBUTE_ID bigint 8  √ 
PHYLOTREENODE.NODEATTRIBUTE_ID FK3EA79944271A5763
GEOSPOT GEOSPOT_ID bigint 8  √ 
SPECIMENLABEL.GEOSPOT_ID FK1E8F38CCA2039B9D
USER USER_ID bigint 8  √ 
STUDY.USER_ID FK4B915A9BEF300B2
SUBMISSION.USER_ID FKA120274CBEF300B2
STUDYSTATUS STUDYSTATUS_ID bigint 8  √ 
STUDY.STUDYSTATUS_ID FK4B915A9255A519C
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
TAXONVARIANT TAXONVARIANT_ID bigint 8  √ 
TAXONLABEL.TAXONVARIANT_ID FK5F548A6A3C1B6F7
TAXONLABELPARTITION TAXONLABELPARTITION_ID bigint 8  √ 
TAXONLABELGROUP.TAXONLABELPARTITION_ID FK4AE2663513A813DD
TAXONLABELGROUP TAXONLABELGROUP_ID bigint 8  √ 
TAXONLABELROUP_TAXONLABEL.TAXONLABELGROUP_ID FK4B1D0BC7294B993D
TAXON TAXON_ID bigint 8  √ 
SPECIMENLABEL.TAXON_ID Implied Constraint
TAXONLINK.TAXON_ID FKC102D9A41DE2FCDD
TAXONSET_TAXON.TAXON_ID FKC656C9031DE2FCDD
TAXONVARIANT.TAXON_ID FKEE3D127B1DE2FCDD
TAXONAUTHORITY TAXONAUTHORITY_ID bigint 8  √ 
TAXONLINK.TAXONAUTHORITY_ID FKC102D9A43BF5F2F7
TAXONSET TAXONSET_ID bigint 8  √ 
TAXONSET_TAXON.TAXONSET_ID FKC656C90313C28457
TESTTREE TESTTREE_ID bigint 8  √ 
TESTNODE.TESTTREE_ID FKEA5749941C5CCA31
TESTNODE TESTNODE_ID bigint 8  √ 
TESTTREE.ROOTNODE_ID FKEA5A0F30E9CB4961
TREEPARTITION TREEPARTITION_ID bigint 8  √ 
TREEGROUP.TREEPARTITION_ID FKA870258180CBD223
TREEGROUP TREEGROUP_ID bigint 8  √ 
TREEGROUP_PHYLOTREE.TREEGROUP_ID FKFB7D7045E56A83
TREESET TREESET_ID bigint 8  √ 
TREESET_PHYLOTREE.TREESET_ID FK31FC19A7EC59B1E3
USERROLE USERROLE_ID bigint 8  √ 
USER.USERROLE_ID FK27E3CBF59DD12
USERTYPERECORD USERTYPERECORD_ID bigint 8  √ 
USERTYPERRD_COLRANGE.USERTYPERECORD_ID FK405805DDC009330E