application_announcement

-1 rows


Description

Table to pair an application to RFI data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
announcement_id int4 10 null
announcement.id application_announcement_announcement_id_fkey R

The foreign key of a form
application_id int4 10 null
application.id application_announcement_application_id_fkey R

The foreign key of an application
created_by int4 10 √ null
ccbc_user.id application_announcement_created_by_fkey R

created by user id
created_at timestamptz 35,6 now()

created at timestamp
updated_by int4 10 √ null
ccbc_user.id application_announcement_updated_by_fkey R

updated by user id
updated_at timestamptz 35,6 now()

updated at timestamp
archived_by int4 10 √ null
ccbc_user.id application_announcement_archived_by_fkey R

archived by user id
archived_at timestamptz 35,6 √ null

archived at timestamp
is_primary bool 1 √ false

Flag to identify either announcement is primary or secondary
history_operation varchar 1000 √ 'created'::character varying

Column describing the operation (created, updated, deleted) for context on the history page

Indexes

Constraint Name Type Sort Column(s)
application_announcement_pkey Primary key Asc/Asc announcement_id + application_id
application_announcement_announcement_id_idx Performance Asc announcement_id
application_announcement_application_id_idx Performance Asc application_id
ccbc_public_application_announcement_archived_by_foreign_key Performance Asc archived_by
ccbc_public_application_announcement_created_by_foreign_key Performance Asc created_by
ccbc_public_application_announcement_updated_by_foreign_key Performance Asc updated_by

Relationships

Close relationships within degrees of separation