| id |
int4 |
10 |
|
√ |
null |
|
|
Unique ID for the Community Report excel data |
| application_id |
int4 |
10 |
√ |
|
null |
|
| application.id |
application_community_report_excel_data_application_id_fkey |
R |
|
ID of the application this Community Report belongs to |
| json_data |
jsonb |
2147483647 |
|
|
'{}'::jsonb |
|
|
The data imported from the excel filled by the respondent |
| created_by |
int4 |
10 |
√ |
|
null |
|
| ccbc_user.id |
application_community_report_excel_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_report_excel_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_report_excel_data_archived_by_fkey |
R |
|
archived by user id |
| archived_at |
timestamptz |
35,6 |
√ |
|
null |
|
|
archived at timestamp |
