Table oc312.public.audit_event_context 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
audit_id int4 10  √  null
audit_event.audit_id fk_audit_ev_reference_audit_ev R
study_id int4 10  √  null
subject_id int4 10  √  null
study_subject_id int4 10  √  null
role_name varchar 200  √  null
event_crf_id int4 10  √  null
study_event_id int4 10  √  null
study_event_definition_id int4 10  √  null
crf_id int4 10  √  null
crf_version_id int4 10  √  null
study_crf_id int4 10  √  null
item_id int4 10  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
study_id Performance Asc i_audit_event_context_study_id

Close relationships  within of separation: