Table oc312.public.study_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_name varchar 40  √  null
study_id int4 10  √  null
study.study_id fk_person_role_study_id R
status_id int4 10  √  null
status.status_id fk_study_us_fk_study__status R
owner_id int4 10  √  null
user_account.user_id fk_study_us_study_use_user_acc R
date_created date 13  √  null
date_updated date 13  √  null
update_id int4 10  √  null
user_name varchar 40  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
user_name Performance Asc i_study_user_role_user_name

Close relationships  within of separation: