event_log

0 rows


Description

A log of all events related to an object like a submission.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
log_id bigserial 19 √ nextval('event_log_log_id_seq'::regclass)
event_log_settings.log_id event_log_settings_log_idC
assoc_type int8 19 null
assoc_id int8 19 null
user_id int8 19 null
users.user_id event_log_user_id_foreignC
date_logged timestamp 22 null
event_type int8 19 √ null
message text 2147483647 √ null
is_translated int2 5 √ null

Indexes

Constraint Name Type Sort Column(s)
event_log_pkey Primary key Asc log_id
event_log_assoc Performance Asc/Asc assoc_type + assoc_id
event_log_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation