notifications

0 rows


Description

User notifications created during certain operations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
notification_id bigserial 19 nextval('notifications_notification_id_seq'::regclass)
notification_settings.notification_id notification_settings_notification_id_foreignC
context_id int8 19 null
user_id int8 19 null
level int8 19 null
type int8 19 null
date_created timestamp 22 null
date_read timestamp 22 null
assoc_type int8 19 null
assoc_id int8 19 null

Indexes

Constraint Name Type Sort Column(s)
notifications_pkey Primary key Asc notification_id
notifications_assoc Performance Asc/Asc assoc_type + assoc_id
notifications_context_id Performance Asc/Asc context_id + level
notifications_context_id_user_id Performance Asc/Asc/Asc context_id + user_id + level
notifications_user_id_level Performance Asc/Asc user_id + level

Relationships