Table clean.public.user_role_access Generated by
SchemaSpy
Legend: SourceForge.net
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
id serial 10  √  nextval('user_role_access_id_seq'::regclass)
study_module_status.id Implied Constraint R
role_id int4 10  √  null
role.id usr_role_access_fk_role_id R
user_id int4 10  √  null
user_account.user_id usr_role_access_fk_user_id C
group_id int4 10  √  null
group_auth_definition.id usr_role_access_fk_group_id R
status_id int4 10  √  null
status.status_id usr_role_access_fk_status_id C
owner_id int4 10  √  null
date_created date 13  √  '2012-02-01'::date
date_updated date 13  √  null
update_id int4 10  √  null
version int4 10  √  0

Table contained 2 rows at Wed Feb 01 09:18 EST 2012

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc pk_user_role_access

Close relationships  within of separation: