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
GENETICCODESET FORMAT varchar 255  √  null
GENETICCODESET GENETICCODESET_ID bigint 8  √ 
GENETICCODESET MATRIX_ID bigint 8  √  null
MATRIX
GENETICCODESET TITLE varchar 255  √  null
GENETICCODESET VERSION integer 4  √  null
MATRIX ALIGNED smallint 2  √  null
MATRIX ANCSTATESET_ID bigint 8  √  null
MATRIX CASESENSITIVE smallint 2  √  null
MATRIX CHARSET_ID bigint 8  √  null
MATRIX CHARWEIGHTSET_ID bigint 8  √  null
MATRIX CODONPOSITIONSET_ID bigint 8  √  null
MATRIX DESCRIPTION varchar 2000  √  null
MATRIX DIAGONAL smallint 2  √  null
MATRIX GAPSYMBOL varchar 255  √  null
MATRIX MATRIX_ID bigint 8  √ 
GENETICCODESET
MATRIXROW
SUB_MATRIX
MATRIX MATRIXDATATYPE_ID bigint 8  √  null
MATRIXDATATYPE
MATRIX MATRIXKIND_ID bigint 8  √  null
MATRIXKIND
MATRIX MATRIXTYPE char 1
MATRIX MISSINGSYMBOL varchar 255  √  null
MATRIX NEXUSFILENAME varchar 255  √  null
MATRIX PUBLISHED smallint 2  √  null
MATRIX STUDY_ID bigint 8  √  null
MATRIX SYMBOLS varchar 255  √  null
MATRIX TAXONLABELSET_ID bigint 8  √  null
TAXONLABELSET
MATRIX TB_MATRIXID varchar 30  √  null
MATRIX TITLE varchar 255  √  null
MATRIX TRIANGLE varchar 255  √  null
MATRIX TYPESET_ID bigint 8  √  null
MATRIX VERSION integer 4  √  null
MATRIXDATATYPE DESCRIPTION varchar 255  √  null
MATRIXDATATYPE MATRIXDATATYPE_ID bigint 8  √ 
MATRIX
MATRIXDATATYPE PHYLOCHAR_ID bigint 8  √  null
MATRIXDATATYPE VERSION integer 4  √  null
MATRIXKIND DESCRIPTION varchar 100  √  null
MATRIXKIND MATRIXKIND_ID bigint 8  √ 
MATRIX
MATRIXKIND VERSION integer 4  √  null
MATRIXROW MATRIX_ID bigint 8  √  null
MATRIX
MATRIXROW MATRIXROW_ID bigint 8  √ 
ROWSEGMENT
MATRIXROW ROW_ORDER integer 4  √  null
MATRIXROW SYMBOLSTRING clob 524288  √  null
MATRIXROW TAXONLABEL_ID bigint 8
TAXONLABEL
MATRIXROW VERSION integer 4  √  null
ROWSEGMENT CATALOGNUM varchar 50  √  null
ROWSEGMENT COLLECTIONCODE varchar 50  √  null
ROWSEGMENT COLLECTOR varchar 255  √  null
ROWSEGMENT COUNTRY varchar 50  √  null
ROWSEGMENT ELEVATION double 8  √  null
ROWSEGMENT ENDINDEX integer 4  √  null
ROWSEGMENT GENBACCESSION varchar 30  √  null
ROWSEGMENT INSTACRONYM varchar 50  √  null
ROWSEGMENT LATITUDE double 8  √  null
ROWSEGMENT LOCALITY varchar 255  √  null
ROWSEGMENT LONGITUDE double 8  √  null
ROWSEGMENT MATRIXROW_ID bigint 8
MATRIXROW
ROWSEGMENT NOTES varchar 2000  √  null
ROWSEGMENT OTHERACCESSION varchar 50  √  null
ROWSEGMENT ROWSEGMENT_ID bigint 8  √ 
ROWSEGMENT SAMPLEDATE date 6  √  null
ROWSEGMENT STARTINDEX integer 4  √  null
ROWSEGMENT STATE varchar 50  √  null
ROWSEGMENT TAXONLABEL_ID bigint 8  √  null
TAXONLABEL
ROWSEGMENT TITLE varchar 255  √  null
ROWSEGMENT VERSION integer 4  √  null
SUB_MATRIX COLLECTION_ID bigint 8
SUB_MATRIX MATRIX_ID bigint 8
MATRIX
SUB_MATRIX SUBMISSION_ID bigint 8
TAXONLABEL LINKED smallint 2  √  null
TAXONLABEL STUDY_ID bigint 8  √  null
TAXONLABEL TAXONLABEL varchar 255  √  null
TAXONLABEL TAXONLABEL_ID bigint 8  √ 
MATRIXROW
ROWSEGMENT
TAXONLABELROUP_TAXONLABEL
TAXONLABELSET_TAXONLABEL
TAXONLABEL TAXONVARIANT_ID bigint 8  √  null
TAXONLABEL VERSION integer 4  √  null
TAXONLABELGROUP TAXONLABELGROUP_ID bigint 8  √ 
TAXONLABELROUP_TAXONLABEL
TAXONLABELGROUP TAXONLABELPARTITION_ID bigint 8  √  null
TAXONLABELPARTITION
TAXONLABELGROUP TITLE varchar 255  √  null
TAXONLABELGROUP VERSION integer 4  √  null
TAXONLABELPARTITION TAXONLABELPARTITION_ID bigint 8  √ 
TAXONLABELGROUP
TAXONLABELPARTITION TITLE varchar 255  √  null
TAXONLABELPARTITION VERSION integer 4  √  null
TAXONLABELROUP_TAXONLABEL TAXONLABEL_ID bigint 8
TAXONLABEL
TAXONLABELROUP_TAXONLABEL TAXONLABELGROUP_ID bigint 8
TAXONLABELGROUP
TAXONLABELSET STUDY_ID bigint 8  √  null
TAXONLABELSET TAXA smallint 2  √  null
TAXONLABELSET TAXONLABELSET_ID bigint 8  √ 
MATRIX
TAXONLABELSET_TAXONLABEL
TAXONLABELSET TITLE varchar 255  √  null
TAXONLABELSET VERSION integer 4  √  null
TAXONLABELSET_TAXONLABEL TAXONLABEL_ID bigint 8
TAXONLABEL
TAXONLABELSET_TAXONLABEL TAXONLABEL_ORDER integer 4
TAXONLABELSET_TAXONLABEL TAXONLABELSET_ID bigint 8
TAXONLABELSET