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  √ 
GENETICCODESET.MATRIX_ID FK6A12F7DCA414944F
MATRIXROW.MATRIX_ID FKE4688E59A414944F
SUB_MATRIX.MATRIX_ID FK5F26A2C055961AEE
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
15 ANCSTATESET_ID bigint 8  √  null
16 CODONPOSITIONSET_ID bigint 8  √  null
17 CHARSET_ID bigint 8  √  null
18 TYPESET_ID bigint 8  √  null
19 CHARWEIGHTSET_ID bigint 8  √  null
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 Sat Nov 15 02:48 EST 2008

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

Close relationships  within of separation: