Announcement

27 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"Announcement_id_seq"'::regclass)
AnnouncementDetails.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 Implied Constraint 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
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
PinUntil timestamptz 35,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation