notification

63730 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
notification_id uuid 2147483647 uuid_generate_v4()
notification_user.notification_id notification_user_notification_id_foreign R
farm_id uuid 2147483647 √ null
farm.farm_id notification_farm_id_foreign R
deleted bool 1 √ false
created_by_user_id varchar 255 √ null
users.user_id notification_created_by_user_id_foreign R
updated_by_user_id varchar 255 √ null
users.user_id notification_updated_by_user_id_foreign R
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
variables jsonb 2147483647 √ null
context jsonb 2147483647 √ null
title jsonb 2147483647 √ null
body jsonb 2147483647 √ null
ref jsonb 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
notification_pkey Primary key Asc notification_id

Relationships

Close relationships within degrees of separation