Announcement

2084 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"Announcement_id_seq"'::regclass)
AnnouncementDetails.announcementId Implied Constraint R
AnnouncementView.announcementId Implied Constraint R
uuid uuid 2147483647 null
title varchar 255 √ null
message text 2147483647 null
image varchar 255 √ null
cta varchar 255 √ null
isDeleted bool 1 √ false
organizationId int4 10 null
Organization.id Announcement_organizationId_fkey R
announcementType varchar 255 null
showUntill timestamptz 35,6 √ null
isPermanent bool 1 √ null
addLink varchar 255 √ null
details text 2147483647 √ null
sendType varchar 255 √ null
filetype varchar 255 √ null
fileSize varchar 255 √ null
fileName varchar 255 √ null
createdBy int4 10 null
User.id Announcement_createdBy_fkey R
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
PinUntil timestamptz 35,6 √ null
linkName text 2147483647 √ null
SendDate timestamptz 35,6 √ null
SendTime varchar 255 √ null
WhatsAppToggle bool 1 √ false
isForceAnnouncement bool 1 √ false
isReadAnnouncement bool 1 √ false
isAllyAnnouncement bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
Announcement_pkey Primary key Asc id
Announcement_id_idx Performance Asc id
Announcement_uuid_idx Performance Asc uuid
Announcement_uuid_key Must be unique Asc uuid
Announcement_uuid_key1 Must be unique Asc uuid
Announcement_uuid_key2 Must be unique Asc uuid

Relationships

Close relationships within degrees of separation