AnnouncementDetails

1511 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"AnnouncementDetails_id_seq"'::regclass)
uuid uuid 2147483647 null
organizationId int4 10 √ null
Organization.id Implied Constraint R
announcementId int4 10 null
Announcement.id Implied Constraint R
programMasterId int4 10 √ null
programId int4 10 √ null
Program.id Implied Constraint R
isDeleted bool 1 √ false
createdBy int4 10 null
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
termId int4 10 √ null
sectionAnnoucementJson jsonb 2147483647 √ null
courseAnnoucementJSon jsonb 2147483647 √ null
editsectionAnnoucemtJson jsonb 2147483647 √ null
editCourseAnnoucementJson jsonb 2147483647 √ null
editTermId varchar 255 √ null
editCohortId jsonb 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
AnnouncementDetails_pkey Primary key Asc id
AnnouncementDetails_id_idx Performance Asc id
AnnouncementDetails_uuid_idx Performance Asc uuid
AnnouncementDetails_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation