Table TBASE2.TBASE2.USER 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 USER_ID bigint 8  √ 
STUDY.USER_ID FK4B915A9BEF300B2
SUBMISSION.USER_ID FKA120274CBEF300B2
1 VERSION integer 4  √  null
2 PASSWORD varchar 100
3 USERNAME varchar 100
4 PERSON_ID bigint 8
PERSON.PERSON_ID FK27E3CBE3910672
5 USERROLE_ID bigint 8
USERROLE.USERROLE_ID FK27E3CBF59DD12

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

Indexes:
ID Column(s) Type Sort Constraint Name
2 USERNAME Primary key Asc SQL080501230724090
1 USER_ID Must be unique Asc SQL080501230724080

Close relationships  within of separation: