Table TBASE2.TBASE2.PHYLOTREENODE 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 PHYLOTREENODE_ID bigint 8  √ 
PHYLOTREE.ROOTNODE_ID FK76F2E442F3D1CF03
PHYLOTREENODE.CHILD_ID FK3EA79944434FDCCB
PHYLOTREENODE.PARENT_ID FK3EA799445BCC767D
PHYLOTREENODE.SIBLING_ID FK3EA799443C348165
TREENODEEDGE.CHILDNODE_ID FK7767285D27FD0589
TREENODEEDGE.PARENTNODE_ID FK7767285D1851763B
1 VERSION integer 4  √  null
2 BRANCHLENGTH double 8  √  null
3 LEFTNODE bigint 8  √  null
4 NAME varchar 255  √  null
5 NODEDEPTH integer 4  √  null
6 RIGHTNODE bigint 8  √  null
7 CHILD_ID bigint 8  √  null
PHYLOTREENODE.PHYLOTREENODE_ID FK3EA79944434FDCCB
8 NODEATTRIBUTE_ID bigint 8  √  null
NODEATTRIBUTE.NODEATTRIBUTE_ID FK3EA79944271A5763
9 PARENT_ID bigint 8  √  null
PHYLOTREENODE.PHYLOTREENODE_ID FK3EA799445BCC767D
10 SIBLING_ID bigint 8  √  null
PHYLOTREENODE.PHYLOTREENODE_ID FK3EA799443C348165
11 TAXONLABEL_ID bigint 8  √  null
TAXONLABEL.TAXONLABEL_ID FK3EA7994463AB9FD7
12 PHYLOTREE_ID bigint 8
PHYLOTREE.PHYLOTREE_ID FK3EA79944B710CB23

Table contained 294,101 rows at Fri Nov 14 16:57 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
1 PHYLOTREENODE_ID Must be unique Asc SQL080501230723070
2 PHYLOTREE_ID Performance Asc TNODE_TREE_IDX
3 TAXONLABEL_ID Performance Asc TNODE_TAXLABEL_IDX

Close relationships  within of separation: