t18release
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
app_notification_log
0
rows
Description
A table to store the notification logs which is used in centralized notification reporting.
Columns
Related columns
Constraint
Comments
Search:
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
Showing 1 to 6 of 6 entries
Previous
1
Next
Indexes
Search:
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
Showing 1 to 6 of 6 entries
Previous
1
Next
Relationships
Close relationships within degrees of separation
One
Two degrees
