Table TBASE2.TBASE2.PHYLOTREE 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 PHYLOTREE_ID bigint 8  √ 
ANALYZEDDATA.PHYLOTREE_ID FK8C961842B710CB23
PHYLOTREENODE.PHYLOTREE_ID FK3EA79944B710CB23
SUB_PHYLOTREE.PHYLOTREE_ID Implied Constraint
TREEGROUP_PHYLOTREE.PHYLOTREE_ID FKFB7D704B710CB23
TREESET_PHYLOTREE.PHYLOTREE_ID FK31FC19A7B710CB23
1 VERSION integer 4  √  null
2 BIGTREE smallint 2  √  null
3 LABEL varchar 255  √  null
4 NEWICKSTRING clob 4194304  √  null
5 NEXUSFILENAME varchar 255  √  null
6 PUBLISHED smallint 2  √  null
7 ROOTEDTREE smallint 2  √  null
8 TITLE varchar 255  √  null
9 ROOTNODE_ID bigint 8  √  null
PHYLOTREENODE.PHYLOTREENODE_ID FK76F2E442F3D1CF03
10 STUDY_ID bigint 8  √  null
STUDY.STUDY_ID FK76F2E4423C572C3C
11 TREEATTRIBUTE_ID bigint 8  √  null
TREEATTRIBUTE.TREEATTRIBUTE_ID FK76F2E442A3015CE3
12 TREEBLOCK_ID bigint 8  √  null
TREEBLOCK.TREEBLOCK_ID FK76F2E442BFD107C3
13 TREEQUALITY_ID bigint 8  √  null
TREEQUALITY.TREEQUALITY_ID FK76F2E442EA08B443
14 TREETYPE_ID bigint 8  √  null
TREETYPE.TREETYPE_ID FK76F2E442F5AEA931
15 TB1_TREEID varchar 30  √  null
16 TREEKIND_ID bigint 8  √  null
TREEKIND.TREEKIND_ID FK76F2E442FE2812F1

Table contained 4,255 rows at Fri Nov 14 16:57 EST 2008

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

Close relationships  within of separation: