TBASE2.TBASE2 contains 89 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
GENETICCODESET	GENETICCODESET_ID	bigint	8		√
MATRIX	MATRIX_ID	bigint	8		√		GENETICCODESET.MATRIX_ID FK6A12F7DCA414944F MATRIXROW.MATRIX_ID FKE4688E59A414944F SUB_MATRIX.MATRIX_ID FK5F26A2C055961AEE
MATRIXDATATYPE	MATRIXDATATYPE_ID	bigint	8		√		MATRIX.MATRIXDATATYPE_ID FK87208BC14CE484AE
MATRIXKIND	MATRIXKIND_ID	bigint	8		√		MATRIX.MATRIXKIND_ID FK87208BC191BD3C8E
MATRIXROW	MATRIXROW_ID	bigint	8		√		ROWSEGMENT.MATRIXROW_ID FKEE9AE819E7B3CDA6
ROWSEGMENT	ROWSEGMENT_ID	bigint	8		√
TAXONLABEL	TAXONLABEL_ID	bigint	8		√		MATRIXROW.TAXONLABEL_ID FKE4688E5963AB9FD7 ROWSEGMENT.TAXONLABEL_ID FKEE9AE81963AB9FD7 TAXONLABELROUP_TAXONLABEL.TAXONLABEL_ID FK4B1D0BC763AB9FD7 TAXONLABELSET_TAXONLABEL.TAXONLABEL_ID FK2EB54B7163AB9FD7
TAXONLABELGROUP	TAXONLABELGROUP_ID	bigint	8		√		TAXONLABELROUP_TAXONLABEL.TAXONLABELGROUP_ID FK4B1D0BC7294B993D
TAXONLABELPARTITION	TAXONLABELPARTITION_ID	bigint	8		√		TAXONLABELGROUP.TAXONLABELPARTITION_ID FK4AE2663513A813DD
TAXONLABELSET	TAXONLABELSET_ID	bigint	8		√		MATRIX.TAXONLABELSET_ID FK87208BC1E310471D TAXONLABELSET_TAXONLABEL.TAXONLABELSET_ID FK2EB54B71E310471D
MATRIX	ALIGNED	smallint	2	√		null
MATRIX	ANCSTATESET_ID	bigint	8	√		null
MATRIX	CASESENSITIVE	smallint	2	√		null
ROWSEGMENT	CATALOGNUM	varchar	50	√		null
MATRIX	CHARSET_ID	bigint	8	√		null
MATRIX	CHARWEIGHTSET_ID	bigint	8	√		null
MATRIX	CODONPOSITIONSET_ID	bigint	8	√		null
SUB_MATRIX	COLLECTION_ID	bigint	8
ROWSEGMENT	COLLECTIONCODE	varchar	50	√		null
ROWSEGMENT	COLLECTOR	varchar	255	√		null
ROWSEGMENT	COUNTRY	varchar	50	√		null
MATRIX	DESCRIPTION	varchar	2000	√		null
MATRIXDATATYPE	DESCRIPTION	varchar	255	√		null
MATRIXKIND	DESCRIPTION	varchar	100	√		null
MATRIX	DIAGONAL	smallint	2	√		null
ROWSEGMENT	ELEVATION	double	8	√		null
ROWSEGMENT	ENDINDEX	integer	4	√		null
GENETICCODESET	FORMAT	varchar	255	√		null
MATRIX	GAPSYMBOL	varchar	255	√		null
ROWSEGMENT	GENBACCESSION	varchar	30	√		null
ROWSEGMENT	INSTACRONYM	varchar	50	√		null
ROWSEGMENT	LATITUDE	double	8	√		null
TAXONLABEL	LINKED	smallint	2	√		null
ROWSEGMENT	LOCALITY	varchar	255	√		null
ROWSEGMENT	LONGITUDE	double	8	√		null
GENETICCODESET	MATRIX_ID	bigint	8	√		null		MATRIX.MATRIX_ID FK6A12F7DCA414944F
MATRIXROW	MATRIX_ID	bigint	8	√		null		MATRIX.MATRIX_ID FKE4688E59A414944F
SUB_MATRIX	MATRIX_ID	bigint	8					MATRIX.MATRIX_ID FK5F26A2C055961AEE
MATRIX	MATRIXDATATYPE_ID	bigint	8	√		null		MATRIXDATATYPE.MATRIXDATATYPE_ID FK87208BC14CE484AE
MATRIX	MATRIXKIND_ID	bigint	8	√		null		MATRIXKIND.MATRIXKIND_ID FK87208BC191BD3C8E
ROWSEGMENT	MATRIXROW_ID	bigint	8					MATRIXROW.MATRIXROW_ID FKEE9AE819E7B3CDA6
MATRIX	MATRIXTYPE	char	1
MATRIX	MISSINGSYMBOL	varchar	255	√		null
MATRIX	NEXUSFILENAME	varchar	255	√		null
ROWSEGMENT	NOTES	varchar	2000	√		null
ROWSEGMENT	OTHERACCESSION	varchar	50	√		null
MATRIXDATATYPE	PHYLOCHAR_ID	bigint	8	√		null
MATRIX	PUBLISHED	smallint	2	√		null
MATRIXROW	ROW_ORDER	integer	4	√		null
ROWSEGMENT	SAMPLEDATE	date	6	√		null
ROWSEGMENT	STARTINDEX	integer	4	√		null
ROWSEGMENT	STATE	varchar	50	√		null
MATRIX	STUDY_ID	bigint	8	√		null
TAXONLABEL	STUDY_ID	bigint	8	√		null
TAXONLABELSET	STUDY_ID	bigint	8	√		null
SUB_MATRIX	SUBMISSION_ID	bigint	8
MATRIX	SYMBOLS	varchar	255	√		null
MATRIXROW	SYMBOLSTRING	clob	524288	√		null
TAXONLABELSET	TAXA	smallint	2	√		null
TAXONLABEL	TAXONLABEL	varchar	255	√		null
MATRIXROW	TAXONLABEL_ID	bigint	8					TAXONLABEL.TAXONLABEL_ID FKE4688E5963AB9FD7
ROWSEGMENT	TAXONLABEL_ID	bigint	8	√		null		TAXONLABEL.TAXONLABEL_ID FKEE9AE81963AB9FD7
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
TAXONLABEL	TAXONVARIANT_ID	bigint	8	√		null
MATRIX	TB_MATRIXID	varchar	30	√		null
GENETICCODESET	TITLE	varchar	255	√		null
MATRIX	TITLE	varchar	255	√		null
ROWSEGMENT	TITLE	varchar	255	√		null
TAXONLABELGROUP	TITLE	varchar	255	√		null
TAXONLABELPARTITION	TITLE	varchar	255	√		null
TAXONLABELSET	TITLE	varchar	255	√		null
MATRIX	TRIANGLE	varchar	255	√		null
MATRIX	TYPESET_ID	bigint	8	√		null
GENETICCODESET	VERSION	integer	4	√		null
MATRIX	VERSION	integer	4	√		null
MATRIXDATATYPE	VERSION	integer	4	√		null
MATRIXKIND	VERSION	integer	4	√		null
MATRIXROW	VERSION	integer	4	√		null
ROWSEGMENT	VERSION	integer	4	√		null
TAXONLABEL	VERSION	integer	4	√		null
TAXONLABELGROUP	VERSION	integer	4	√		null
TAXONLABELPARTITION	VERSION	integer	4	√		null
TAXONLABELSET	VERSION	integer	4	√		null