Table oc312.public.audit_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_event_audit_id_seq'::regclass)
audit_event_context.audit_id fk_audit_ev_reference_audit_ev R
audit_event_values.audit_id fk_audit_lo_ref_audit_lo R
audit_log_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
reason_for_change varchar 1000  √  null
action_message varchar 4000  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
audit_id Primary key Asc pk_audit_event
audit_table Performance Asc i_audit_event_audit_table
entity_id Performance Asc i_audit_event_entity_id
user_id Performance Asc i_audit_event_user_id

Close relationships: