application_community_progress_report_data

-1 rows


Description

Table containing the Community Progress Report data for the given application

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null

Unique ID for the Community Progress Report
application_id int4 10 √ null
application.id application_community_progress_report_data_application_id_fkey R

ID of the application this Community Progress Report belongs to
json_data jsonb 2147483647 '{}'::jsonb

The due date, date received and the file information of the Community Progress Report Excel file
created_by int4 10 √ null
ccbc_user.id application_community_progress_report_data_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_community_progress_report_data_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_community_progress_report_data_archived_by_fkey R

archived by user id
archived_at timestamptz 35,6 √ null

archived at timestamp
excel_data_id int4 10 √ null

The id of the excel data that this record is associated with
history_operation varchar 1000 √ 'created'::character varying

History operation

Indexes

Constraint Name Type Sort Column(s)
application_community_progress_report_data_pkey Primary key Asc id
application_community_progress_report_data_application_id_index Performance Asc application_id
ccbc_public_application_community_progress_report_data_archived Performance Asc archived_by
ccbc_public_application_community_progress_report_data_created_ Performance Asc created_by
ccbc_public_application_community_progress_report_data_updated_ Performance Asc updated_by

Relationships

Close relationships within degrees of separation