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
ALGORITHM	ALGORITHM_ID	bigint	8		√		ANALYSISSTEP.ALGORITHM_ID FK21F853A848A2817C
ANALYSISSTEP	ALGORITHM_ID	bigint	8	√		null		ALGORITHM.ALGORITHM_ID FK21F853A848A2817C
MATRIX	ALIGNED	smallint	2	√		null
ANALYSIS	ANALYSIS_ID	bigint	8		√		ANALYSISSTEP.ANALYSIS_ID FK21F853A8D1884DD8
ANALYSISSTEP	ANALYSIS_ID	bigint	8	√		null		ANALYSIS.ANALYSIS_ID FK21F853A8D1884DD8
ANALYSIS	ANALYSIS_ORDER	integer	4	√		null
ANALYSISSTEP	ANALYSISSTEP_ID	bigint	8		√		ANALYZEDDATA.ANALYSISSTEP_ID FK8C9618424BA97F78
ANALYZEDDATA	ANALYSISSTEP_ID	bigint	8					ANALYSISSTEP.ANALYSISSTEP_ID FK8C9618424BA97F78
ANALYZEDDATA	ANALYZEDDATA_ID	bigint	8		√
ANCESTRALSTATE	ANCESTRALSTATE_ID	bigint	8		√		CONTANCSTATE_VALUE.ANCSTATE_ID FKA84B8C3FD450D2BD DISCRETECHARSTATE.ANCESTRALSTATE_ID FK2EEF2802C7BEAAFE
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
ANCSTATESET	ANCSTATESET_ID	bigint	8		√		ANCESTRALSTATE.ANCSTATESET_ID FK3FA14284684F6406 MATRIX.ANCSTATESET_ID FK87208BC1684F6406
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	CHARGROUP_ID	bigint	8		√		CHARGROUP_COLRANGE.CHARGROUP_ID FKB2D8C293971FFFA6 CHARGROUP_PHYLOCHAR.CHARGROUP_ID Implied Constraint
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
CHARPARTITION	CHARPARTITION_ID	bigint	8		√		CHARGROUP.CHARPARTITION_ID FK3AF18C91AA11DC6
CHARSET	CHARSET_ID	bigint	8		√		CHARSET_COLRANGE.CHARSET_ID FK2CBD90416D5B50 CHARSET_PHYLOCHAR.CHARSET_ID Implied Constraint MATRIX.CHARSET_ID FK87208BC145534A9C
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	CHARWEIGHT_ID	bigint	8		√		CHARWEIGHT_COLRANGE.CHARWEIGHT_ID FK54CA674EF9A75EE
CHARWEIGHT_COLRANGE	CHARWEIGHT_ID	bigint	8					CHARWEIGHT.CHARWEIGHT_ID FK54CA674EF9A75EE
CHARWEIGHT	CHARWEIGHTSET_ID	bigint	8	√		null		CHARWEIGHTSET.CHARWEIGHTSET_ID FK8CC7694EE9B425A6
CHARWEIGHTSET	CHARWEIGHTSET_ID	bigint	8		√		CHARWEIGHT.CHARWEIGHTSET_ID FK8CC7694EE9B425A6 MATRIX.CHARWEIGHTSET_ID FK87208BC1E9B425A6
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	CITATION_ID	bigint	8		√		CITATION_AUTHOR.CITATION_ID FK24AA55E38E1E4DF8 CITATION_EDITOR.CITATION_ID FK2A8955C5EC93F501 STUDY.CITATION_ID FK4B915A98E1E4DF8
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
CITATIONSTATUS	CITATIONSTATUS_ID	bigint	8		√		CITATION.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
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
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
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
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
CSTREENODE	CSTREENODE_ID	bigint	8		√		CSTREENODE.PARENTNODE_ID FK82B9AB10F572A92
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
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
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_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_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_INSTANCE	EXPLAIN_REQUESTER	varchar	128				EXPLAIN_STATEMENT.EXPLAIN_REQUESTER SQL070118163137990
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_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_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_INSTANCE	EXPLAIN_TIME	timestamp	16,6				EXPLAIN_STATEMENT.EXPLAIN_TIME SQL070118163137990
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_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_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
GAPMODE	GAPMODE_ID	bigint	8		√		ALGORITHM.GAPMODE_ID FKB388C44FC6E814E6
MATRIX	GAPSYMBOL	varchar	255	√		null
ROWSEGMENT	GENBACCESSION	varchar	30	√		null
SPECIMENLABEL	GENBANKID	varchar	255	√		null
GENETICCODE	GENETICCODE_ID	bigint	8		√		GENETICCODERECORD.GENETICCODE_ID FK237932B76CB73FC6
GENETICCODERECORD	GENETICCODE_ID	bigint	8	√		null		GENETICCODE.GENETICCODE_ID FK237932B76CB73FC6
CODERECORD_COLRANGE	GENETICCODERECORD_ID	bigint	8					GENETICCODERECORD.GENETICCODERECORD_ID FKA3E6C61EDC51C546
GENETICCODERECORD	GENETICCODERECORD_ID	bigint	8		√		CODERECORD_COLRANGE.GENETICCODERECORD_ID FKA3E6C61EDC51C546
GENETICCODERECORD	GENETICCODESET_ID	bigint	8					GENETICCODESET.GENETICCODESET_ID FK237932B782D8ECCE
GENETICCODESET	GENETICCODESET_ID	bigint	8		√		GENETICCODERECORD.GENETICCODESET_ID FK237932B782D8ECCE
GEOSPOT	GEOSPOT_ID	bigint	8		√		SPECIMENLABEL.GEOSPOT_ID FK1E8F38CCA2039B9D
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
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
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	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
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	MATRIXCOLUMN_ID	bigint	8		√		MATRIXCOLUMN_ITEMDEFINITION.MATRIXCOLUMN_ID FKB556F8E8B2E884E MATRIXELEMENT.MATRIXCOLUMN_ID FK90AE93FB8B2E884E TEST_ELEMENT.MATRIXCOLUMN_ID Implied Constraint
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
MATRIXDATATYPE	MATRIXDATATYPE_ID	bigint	8		√		MATRIX.MATRIXDATATYPE_ID FK87208BC14CE484AE
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
TEST_ELEMENT	MATRIXELEMENT_ID	bigint	8		√			MATRIXELEMENT.MATRIXELEMENT_ID Implied Constraint
MATRIX	MATRIXKIND_ID	bigint	8	√		null		MATRIXKIND.MATRIXKIND_ID FK87208BC191BD3C8E
MATRIXKIND	MATRIXKIND_ID	bigint	8		√		MATRIX.MATRIXKIND_ID FK87208BC191BD3C8E
MATRIXELEMENT	MATRIXROW_ID	bigint	8	√		null		MATRIXROW.MATRIXROW_ID FK90AE93FBE7B3CDA6
MATRIXROW	MATRIXROW_ID	bigint	8		√		MATRIXELEMENT.MATRIXROW_ID FK90AE93FBE7B3CDA6 ROWSEGMENT.MATRIXROW_ID FKEE9AE819E7B3CDA6 TEST_ELEMENT.MATRIXROW_ID Implied Constraint
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
NODEATTRIBUTE	NODEATTRIBUTE_ID	bigint	8		√		PHYLOTREENODE.NODEATTRIBUTE_ID FK3EA79944271A5763
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
PERSON	PERSON_ID	bigint	8		√		CITATION_AUTHOR.AUTHORS_PERSON_ID FK24AA55E36707573B CITATION_EDITOR.EDITORS_PERSON_ID FK2A8955C568F6F619 USER.PERSON_ID FK27E3CBE3910672
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
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
ANALYZEDDATA	PHYLOTREE_ID	bigint	8	√		null		PHYLOTREE.PHYLOTREE_ID FK8C961842B710CB23
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
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
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
CITATION	PMID	varchar	255	√		null
EXPLAIN_STREAM	PMID	smallint	2
ALGORITHM	POLYTCOUNT_ID	bigint	8	√		null		POLYTCOUNT.POLYTCOUNT_ID FKB388C44F9698D32E
POLYTCOUNT	POLYTCOUNT_ID	bigint	8		√		ALGORITHM.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_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_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	SOFTWARE_ID	bigint	8		√		ANALYSISSTEP.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_INSTANCE	SOURCE_NAME	varchar	128				EXPLAIN_STATEMENT.SOURCE_NAME SQL070118163137990
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_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_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_INSTANCE	SOURCE_SCHEMA	varchar	128				EXPLAIN_STATEMENT.SOURCE_SCHEMA SQL070118163137990
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_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_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_INSTANCE	SOURCE_VERSION	varchar	64				EXPLAIN_STATEMENT.SOURCE_VERSION SQL070118163137990
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_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_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
STATECHANGESET	STATECHANGESET_ID	bigint	8		√		LEFTCHANGESET_CHARSTATE.STATECHANGESET_ID FKC887720775763EAE RIGHTCHANGESET_CHARSTATE.STATECHANGESET_ID FKC8AFC9F275763EAE
MATRIXCOLUMN	STATEFORMAT_ID	bigint	8	√		null		STATEFORMAT.STATEFORMAT_ID FK9B0BE57BED40086
STATEFORMAT	STATEFORMAT_ID	bigint	8		√		MATRIXCOLUMN.STATEFORMAT_ID FK9B0BE57BED40086 STATEMODIFIER.STATEFORMAT_ID FKD157BE48BED40086
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
STATESET	STATESET_ID	bigint	8		√		DISCRETECHARSTATE.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_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_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	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
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
STUDYSTATUS	STUDYSTATUS_ID	bigint	8		√		STUDY.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	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
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
TAXON	TAXON_ID	bigint	8		√		SPECIMENLABEL.TAXON_ID Implied Constraint TAXONLINK.TAXON_ID FKC102D9A41DE2FCDD TAXONSET_TAXON.TAXON_ID FKC656C9031DE2FCDD TAXONVARIANT.TAXON_ID FKEE3D127B1DE2FCDD
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
TAXONAUTHORITY	TAXONAUTHORITY_ID	bigint	8		√		TAXONLINK.TAXONAUTHORITY_ID FKC102D9A43BF5F2F7
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
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
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
TAXONLABELGROUP	TAXONLABELGROUP_ID	bigint	8		√		TAXONLABELROUP_TAXONLABEL.TAXONLABELGROUP_ID FK4B1D0BC7294B993D
TAXONLABELROUP_TAXONLABEL	TAXONLABELGROUP_ID	bigint	8					TAXONLABELGROUP.TAXONLABELGROUP_ID FK4B1D0BC7294B993D
TAXONLABELGROUP	TAXONLABELPARTITION_ID	bigint	8	√		null		TAXONLABELPARTITION.TAXONLABELPARTITION_ID FK4AE2663513A813DD
TAXONLABELPARTITION	TAXONLABELPARTITION_ID	bigint	8		√		TAXONLABELGROUP.TAXONLABELPARTITION_ID FK4AE2663513A813DD
MATRIX	TAXONLABELSET_ID	bigint	8	√		null		TAXONLABELSET.TAXONLABELSET_ID FK87208BC1E310471D
TAXONLABELSET	TAXONLABELSET_ID	bigint	8		√		MATRIX.TAXONLABELSET_ID FK87208BC1E310471D TAXONLABELSET_TAXONLABEL.TAXONLABELSET_ID FK2EB54B71E310471D TREEBLOCK.TAXONLABELSET_ID FKA826F38FE310471D
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	TAXONSET_ID	bigint	8		√		TAXONSET_TAXON.TAXONSET_ID FKC656C90313C28457
TAXONSET_TAXON	TAXONSET_ID	bigint	8					TAXONSET.TAXONSET_ID FKC656C90313C28457
TAXONLABEL	TAXONVARIANT_ID	bigint	8	√		null		TAXONVARIANT.TAXONVARIANT_ID FK5F548A6A3C1B6F7
TAXONVARIANT	TAXONVARIANT_ID	bigint	8		√		TAXONLABEL.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	TESTNODE_ID	bigint	8		√		TESTTREE.ROOTNODE_ID FKEA5A0F30E9CB4961
TESTNODE	TESTTREE_ID	bigint	8					TESTTREE.TESTTREE_ID FKEA5749941C5CCA31
TESTTREE	TESTTREE_ID	bigint	8		√		TESTNODE.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
TREEATTRIBUTE	TREEATTRIBUTE_ID	bigint	8		√		PHYLOTREE.TREEATTRIBUTE_ID FK76F2E442A3015CE3 TESTTREE.TREEATTRIBUTE_ID Implied Constraint
PHYLOTREE	TREEBLOCK_ID	bigint	8	√		null		TREEBLOCK.TREEBLOCK_ID FK76F2E442BFD107C3
SUB_TREEBLOCK	TREEBLOCK_ID	bigint	8					TREEBLOCK.TREEBLOCK_ID FK94D50830BFD107C3
TREEBLOCK	TREEBLOCK_ID	bigint	8		√		PHYLOTREE.TREEBLOCK_ID FK76F2E442BFD107C3 SUB_TREEBLOCK.TREEBLOCK_ID FK94D50830BFD107C3
TREEGROUP	TREEGROUP_ID	bigint	8		√		TREEGROUP_PHYLOTREE.TREEGROUP_ID FKFB7D7045E56A83
TREEGROUP_PHYLOTREE	TREEGROUP_ID	bigint	8					TREEGROUP.TREEGROUP_ID FKFB7D7045E56A83
PHYLOTREE	TREEKIND_ID	bigint	8	√		null		TREEKIND.TREEKIND_ID FK76F2E442FE2812F1
TREEKIND	TREEKIND_ID	bigint	8		√		PHYLOTREE.TREEKIND_ID FK76F2E442FE2812F1
ANALYZEDDATA	TREELENGTH	integer	4	√		null
TREENODEEDGE	TREENODEEDGE_ID	bigint	8		√
TREEGROUP	TREEPARTITION_ID	bigint	8	√		null		TREEPARTITION.TREEPARTITION_ID FKA870258180CBD223
TREEPARTITION	TREEPARTITION_ID	bigint	8		√		TREEGROUP.TREEPARTITION_ID FKA870258180CBD223
PHYLOTREE	TREEQUALITY_ID	bigint	8	√		null		TREEQUALITY.TREEQUALITY_ID FK76F2E442EA08B443
TESTTREE	TREEQUALITY_ID	bigint	8	√		null		TREEQUALITY.TREEQUALITY_ID Implied Constraint
TREEQUALITY	TREEQUALITY_ID	bigint	8		√		PHYLOTREE.TREEQUALITY_ID FK76F2E442EA08B443 TESTTREE.TREEQUALITY_ID Implied Constraint
TREESET	TREESET_ID	bigint	8		√		TREESET_PHYLOTREE.TREESET_ID FK31FC19A7EC59B1E3
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
TREETYPE	TREETYPE_ID	bigint	8		√		PHYLOTREE.TREETYPE_ID FK76F2E442F5AEA931 TESTTREE.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
TYPESET	TYPESET_ID	bigint	8		√		MATRIX.TYPESET_ID FK87208BC14D737E46 USERTYPERECORD.TYPESET_ID FK136AF6164D737E46
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
USER	USER_ID	bigint	8		√		STUDY.USER_ID FK4B915A9BEF300B2 SUBMISSION.USER_ID FKA120274CBEF300B2
ADVISE_INDEX	USERDEFINED	smallint	2			0
USER	USERNAME	varchar	100
USER	USERROLE_ID	bigint	8					USERROLE.USERROLE_ID FK27E3CBF59DD12
USERROLE	USERROLE_ID	bigint	8		√		USER.USERROLE_ID FK27E3CBF59DD12
ALGORITHM	USERTYPE_ID	bigint	8	√		null		USERTYPE.USERTYPE_ID FKB388C44F92E6A38E
USERTYPE	USERTYPE_ID	bigint	8		√		ALGORITHM.USERTYPE_ID FKB388C44F92E6A38E CSTREENODE.CSTREE_ID FK82B9AB10C6999FCE STEPMATRIXELEMENT.STEPMATRIX_ID FK891100AF9E8198E USERTYPERECORD.USERTYPE_ID FK136AF61692E6A38E
USERTYPERECORD	USERTYPE_ID	bigint	8	√		null		USERTYPE.USERTYPE_ID FK136AF61692E6A38E
USERTYPERECORD	USERTYPERECORD_ID	bigint	8		√		USERTYPERRD_COLRANGE.USERTYPERECORD_ID FK405805DDC009330E
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'