Table oc312.public.audit_log_event 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 serial 10  √  nextval('audit_log_event_audit_id_seq'::regclass)
audit_event.audit_id Implied Constraint R
audit_date timestamptz 35,6
audit_table varchar 500
user_id int4 10  √  null
entity_id int4 10  √  null
entity_name varchar 500  √  null
reason_for_change varchar 1000  √  null
audit_log_event_type_id int4 10  √  null
old_value varchar 4000  √  null
new_value varchar 4000  √  null
event_crf_id int4 10  √  null
study_event_id int4 10  √  null
event_crf_version_id int4 10  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
audit_id Primary key Asc pk_audit_log_event
audit_log_event_type_id Performance Asc i_audit_log_event_audit_log_event_type_id
audit_table Performance Asc i_audit_log_event_audit_table
entity_id Performance Asc i_audit_log_event_entity_id
event_crf_id Performance Asc i_audit_log_event_event_crf_id
event_crf_version_id Performance Asc i_audit_log_event_event_crf_version_id
study_event_id Performance Asc i_audit_log_event_study_event_id
user_id Performance Asc i_audit_log_event_user_id

Close relationships: