Table clean.public.role 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('role_id_seq'::regclass)
role.parent_id parent_id_fk_role_id R
role_permission.role_id role_permission_fk_role_id R
user_role_access.role_id usr_role_access_fk_role_id R
study_module_status.id Implied Constraint R
role_name varchar 255  √  null
parent_id int4 10  √  null
role.id parent_id_fk_role_id R
version int4 10  √  0
is_locked bool 1 false
owner_id int4 10  √  null
user_account.user_id fk_role_owner_id_user_acc R
update_id int4 10  √  null
user_account.user_id fk_role_update_id_user_acc R
status_id int4 10  √  1
date_created date 13  √  '2012-02-01'::date
date_updated date 13  √  '2012-02-01'::date
is_used_with_auth_group_study bool 1  √  false
is_used_with_auth_group_site bool 1  √  false
is_used_with_auth_group_crf bool 1  √  false
is_used_with_auth_group_eventcrf bool 1  √  false
is_used_with_auth_group_allstudies bool 1  √  false

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

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

Close relationships  within of separation: