Table TBASE2.TBASE2.USERROLE 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 USERROLE_ID bigint 8  √ 
USER.USERROLE_ID FK27E3CBF59DD12
1 VERSION integer 4  √  null
2 AUTHORITY varchar 255

Table contained 7 rows at Sat Nov 15 02:37 EST 2008

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

Close relationships  within of separation: