UserNotification

289401 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"UserNotification_id_seq"'::regclass)
uuid uuid 2147483647 null
title varchar 255 √ null
message text 2147483647 null
isRead bool 1 √ false
userId int4 10 √ null
User.id Implied Constraint R
isDeleted bool 1 √ false
type varchar 255 null
notificationJson jsonb 2147483647 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
adminRead bool 1 √ false
studentId int4 10 √ null
pushNotificationSend bool 1 √ false
deletedAt timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
UserNotification_pkey Primary key Asc id
UserNotification_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation