Table oc312.public.user_role Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
role_id serial 10  √  nextval('user_role_role_id_seq'::regclass)
role_privilege_map.role_id fk_role_id R
role_name varchar 50
parent_id int4 10  √  null
role_desc varchar 2000  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
role_id Primary key Asc pk_user_role

Close relationships  within of separation: