notifications

14 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('notifications_id_seq'::regclass)
member_notifications.notification_id fk_autog808c2ef24 R
title varchar 255 √ null
body text 2147483647 √ null
url varchar 255 √ null
image varchar 255 √ null
created_at timestamp 29,6 √ null
updated_at timestamp 29,6 √ null
list_id int4 10 √ null
lists.id fk_autog808c2ef217 R
sent_at timestamp 29,6 √ null
finished_sending_at timestamp 29,6 √ null
total_clicks int4 10 √ null
total_unsubscribes int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
notifications_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation