app_notification_log

0 rows


Description

A table to store the notification logs which is used in centralized notification reporting.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_notification_log_id_seq'::regclass)
app_notification_delivery_log.notification_log_id Defined in XML R
notification_event_log_id int8 19 null
app_notification_event_log.id Defined in XML R
preference_id int8 19 null
app_notification_preference.id Defined in XML R
recipient_user_id int8 19 0
app_user.id Defined in XML R
time_created int8 19 0
has_error int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_notilog_id_pk Primary key Asc id
app_notilog_has_ix Performance Asc has_error
app_notilog_not_ix Performance Asc notification_event_log_id
app_notilog_pre_ix Performance Asc preference_id
app_notilog_rec_ix Performance Asc recipient_user_id
app_notilog_tim_ix Performance Asc time_created

Relationships

Close relationships within degrees of separation