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

TBASE2.TBASE2 contains 89 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Children Parents Comments
MATRIX ANCSTATESET_ID bigint 8  √  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
GENETICCODESET GENETICCODESET_ID bigint 8  √ 
GENETICCODESET MATRIX_ID bigint 8  √  null
MATRIX.MATRIX_ID FK6A12F7DCA414944F
MATRIX MATRIX_ID bigint 8  √ 
GENETICCODESET.MATRIX_ID FK6A12F7DCA414944F
MATRIXROW.MATRIX_ID FKE4688E59A414944F
SUB_MATRIX.MATRIX_ID FK5F26A2C055961AEE
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
MATRIXDATATYPE MATRIXDATATYPE_ID bigint 8  √ 
MATRIX.MATRIXDATATYPE_ID FK87208BC14CE484AE
MATRIX MATRIXKIND_ID bigint 8  √  null
MATRIXKIND.MATRIXKIND_ID FK87208BC191BD3C8E
MATRIXKIND MATRIXKIND_ID bigint 8  √ 
MATRIX.MATRIXKIND_ID FK87208BC191BD3C8E
MATRIXROW MATRIXROW_ID bigint 8  √ 
ROWSEGMENT.MATRIXROW_ID FKEE9AE819E7B3CDA6
ROWSEGMENT MATRIXROW_ID bigint 8
MATRIXROW.MATRIXROW_ID FKEE9AE819E7B3CDA6
MATRIXDATATYPE PHYLOCHAR_ID bigint 8  √  null
ROWSEGMENT ROWSEGMENT_ID bigint 8  √ 
MATRIX STUDY_ID bigint 8  √  null
TAXONLABEL STUDY_ID bigint 8  √  null
TAXONLABELSET STUDY_ID bigint 8  √  null
SUB_MATRIX SUBMISSION_ID bigint 8
MATRIXROW TAXONLABEL_ID bigint 8
TAXONLABEL.TAXONLABEL_ID FKE4688E5963AB9FD7
ROWSEGMENT TAXONLABEL_ID bigint 8  √  null
TAXONLABEL.TAXONLABEL_ID FKEE9AE81963AB9FD7
TAXONLABEL TAXONLABEL_ID bigint 8  √ 
MATRIXROW.TAXONLABEL_ID FKE4688E5963AB9FD7
ROWSEGMENT.TAXONLABEL_ID FKEE9AE81963AB9FD7
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
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
TAXONLABELSET_TAXONLABEL TAXONLABELSET_ID bigint 8
TAXONLABELSET.TAXONLABELSET_ID FK2EB54B71E310471D
TAXONLABEL TAXONVARIANT_ID bigint 8  √  null
MATRIX TYPESET_ID bigint 8  √  null
MATRIX MATRIXTYPE char 1
MATRIXROW SYMBOLSTRING clob 524288  √  null
ROWSEGMENT SAMPLEDATE date 6  √  null
ROWSEGMENT ELEVATION double 8  √  null
ROWSEGMENT LATITUDE double 8  √  null
ROWSEGMENT LONGITUDE double 8  √  null
ROWSEGMENT ENDINDEX integer 4  √  null
MATRIXROW ROW_ORDER integer 4  √  null
ROWSEGMENT STARTINDEX integer 4  √  null
TAXONLABELSET_TAXONLABEL TAXONLABEL_ORDER integer 4
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
MATRIX ALIGNED smallint 2  √  null
MATRIX CASESENSITIVE smallint 2  √  null
MATRIX DIAGONAL smallint 2  √  null
TAXONLABEL LINKED smallint 2  √  null
MATRIX PUBLISHED smallint 2  √  null
TAXONLABELSET TAXA smallint 2  √  null
ROWSEGMENT GENBACCESSION varchar 30  √  null
MATRIX TB_MATRIXID varchar 30  √  null
ROWSEGMENT CATALOGNUM varchar 50  √  null
ROWSEGMENT COLLECTIONCODE varchar 50  √  null
ROWSEGMENT COUNTRY varchar 50  √  null
ROWSEGMENT INSTACRONYM varchar 50  √  null
ROWSEGMENT OTHERACCESSION varchar 50  √  null
ROWSEGMENT STATE varchar 50  √  null
MATRIXKIND DESCRIPTION varchar 100  √  null
ROWSEGMENT COLLECTOR varchar 255  √  null
MATRIXDATATYPE DESCRIPTION varchar 255  √  null
GENETICCODESET FORMAT varchar 255  √  null
MATRIX GAPSYMBOL varchar 255  √  null
ROWSEGMENT LOCALITY varchar 255  √  null
MATRIX MISSINGSYMBOL varchar 255  √  null
MATRIX NEXUSFILENAME varchar 255  √  null
MATRIX SYMBOLS varchar 255  √  null
TAXONLABEL TAXONLABEL varchar 255  √  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 DESCRIPTION varchar 2000  √  null
ROWSEGMENT NOTES varchar 2000  √  null