form_data

-1 rows


Description

Table to hold applicant form data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
application_form_data.form_data_id application_form_data_form_data_id_fkey R

The unique id of the form data
json_data jsonb 2147483647 '{}'::jsonb

The json form data of the project information form. See schema
last_edited_page varchar 100 √ null

Column saving the key of the last edited form page
form_data_status_type_id varchar 1000 √ 'pending'::character varying
form_data_status_type.name form_data_form_data_status_type_id_fkey R

Column referencing the form data status type, defaults to draft
created_by int4 10 √ null
ccbc_user.id form_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 form_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 form_data_archived_by_fkey R

archived by user id
archived_at timestamptz 35,6 √ null

archived at timestamp
form_schema_id int4 10 √ null
form.id form_data_form_schema_id_fkey R

Schema for the respective form_data
reason_for_change varchar 1000 √ null

Column to track analysts reason for changing form data

Indexes

Constraint Name Type Sort Column(s)
form_data_pkey Primary key Asc id
ccbc_public_form_data_archived_by_foreign_key Performance Asc archived_by
ccbc_public_form_data_created_by_foreign_key Performance Asc created_by
ccbc_public_form_data_updated_by_foreign_key Performance Asc updated_by

Relationships

Close relationships within degrees of separation