Table TBASE2.TBASE2.MATRIX Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
ID Column Type Size Nulls Auto Default Children Parents Comments
0 MATRIXTYPE char 1
1 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
2 VERSION integer 4  √  null
3 DESCRIPTION varchar 2000  √  null
4 GAPSYMBOL varchar 255  √  null
5 MISSINGSYMBOL varchar 255  √  null
6 NEXUSFILENAME varchar 255  √  null
7 PUBLISHED smallint 2  √  null
8 TITLE varchar 255  √  null
9 ALIGNED smallint 2  √  null
10 DIAGONAL smallint 2  √  null
11 TRIANGLE varchar 255  √  null
12 CASESENSITIVE smallint 2  √  null
13 MATRIXDATATYPE_ID bigint 8  √  null
MATRIXDATATYPE.MATRIXDATATYPE_ID FK87208BC14CE484AE
14 STUDY_ID bigint 8  √  null
STUDY.STUDY_ID FK87208BC13C572C3C
15 ANCSTATESET_ID bigint 8  √  null
ANCSTATESET.ANCSTATESET_ID FK87208BC1684F6406
16 CODONPOSITIONSET_ID bigint 8  √  null
CODONPOSITIONSET.CODONPOSITIONSET_ID FK87208BC1491DB20E
17 CHARSET_ID bigint 8  √  null
CHARSET.CHARSET_ID FK87208BC145534A9C
18 TYPESET_ID bigint 8  √  null
TYPESET.TYPESET_ID FK87208BC14D737E46
19 CHARWEIGHTSET_ID bigint 8  √  null
CHARWEIGHTSET.CHARWEIGHTSET_ID FK87208BC1E9B425A6
20 TB_MATRIXID varchar 30  √  null
21 SYMBOLS varchar 255  √  null
22 MATRIXKIND_ID bigint 8  √  null
MATRIXKIND.MATRIXKIND_ID FK87208BC191BD3C8E
23 TAXONLABELSET_ID bigint 8  √  null
TAXONLABELSET.TAXONLABELSET_ID FK87208BC1E310471D

Table contained 2,771 rows at Fri Nov 14 16:57 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
1 MATRIX_ID Must be unique Asc SQL080501230722840

Close relationships  within of separation: