notifications

-1 rows


Description

Notifications for application users.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
notification_type_id int4 10 null
notification_types.id notifications_notification_type_id_fkey R
user_id int8 19 null
users.id notifications_user_id_fkey R
organization_id int8 19 √ null
organizations.id notifications_organization_id_fkey C
title text 2147483647 null
body text 2147483647 null
local_url text 2147483647 null
created_time timestamptz 35,6 null
is_read bool 1 false

Indexes

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

Relationships

Close relationships within degrees of separation