Table TBASE2.TBASE2.TESTTREE 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 TESTTREE_ID bigint 8  √ 
TESTNODE.TESTTREE_ID FKEA5749941C5CCA31
1 VERSION integer 4  √  null
2 PUBLISHED smallint 2  √  null
3 NEWICKSTRING clob 4194304  √  null
4 BIGTREE smallint 2  √  null
5 ROOTEDTREE smallint 2  √  null
6 TITLE varchar 255  √  null
7 TREEATTRIBUTE_ID bigint 8  √  null
TREEATTRIBUTE.TREEATTRIBUTE_ID Implied Constraint
8 TREEQUALITY_ID bigint 8  √  null
TREEQUALITY.TREEQUALITY_ID Implied Constraint
9 STUDY_ID bigint 8  √  null
STUDY.STUDY_ID Implied Constraint
10 TREETYPE_ID bigint 8  √  null
TREETYPE.TREETYPE_ID Implied Constraint
11 ROOTNODE_ID bigint 8  √  null
TESTNODE.TESTNODE_ID FKEA5A0F30E9CB4961

Table contained 0 rows at Fri Nov 14 16:57 EST 2008

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

Close relationships: