Table TBASE2.TBASE2.DISCRETECHARSTATE 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 DISCRETECHARSTATE_ID bigint 8  √ 
ANCESTRALSTATE.DISCRETECHARSTATE_ID FK3FA14284F4803CE6
CSTREENODE.DISCRETECHARSTATE_ID FK82B9AB10F4803CE6
LEFTCHANGESET_CHARSTATE.DISCRETECHARSTATE_ID FKC8877207F4803CE6
MATRIXELEMENT.DISCRETECHARSTATE_ID FK90AE93FBF4803CE6
RIGHTCHANGESET_CHARSTATE.DISCRETECHARSTATE_ID FKC8AFC9F2F4803CE6
STATEMODIFIER.DISCRETECHARSTATE_ID FKD157BE48F4803CE6
STEPMATRIXELEMENT.STATE1_ID FK891100AF6E972A88
STEPMATRIXELEMENT.STATE2_ID FK891100AF6E979EE7
STEPMATRIXELEMENT.DISCRETECHARSTATE_ID Implied Constraint
1 VERSION integer 4  √  null
2 DESCRIPTION varchar 255  √  null
3 NOTES varchar 255  √  null
4 PHYLOCHAR_ID bigint 8
PHYLOCHAR.PHYLOCHAR_ID FK2EEF2802FE41A723
5 STATESET_ID bigint 8  √  null
STATESET.STATESET_ID FK2EEF2802163C67CE
6 ANCESTRALSTATE_ID bigint 8  √  null
ANCESTRALSTATE.ANCESTRALSTATE_ID FK2EEF2802C7BEAAFE
7 SYMBOL char 1  √  null

Table contained 143,585 rows at Fri Nov 14 16:57 EST 2008

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

Close relationships  within of separation: