Database Properties
Database Type: PostgreSQL - 14.1
Schema ccbc_public
The public API schema for the ccbc intake.
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| assessment_type | 1 | 0 | 2 | -1 | Table | Table containing the different assessment types that can be assigned to an assessment |
| project_information_data | 0 | 4 | 9 | -1 | Table | Table to store project information data |
| email_record | 1 | 3 | 13 | -1 | Table | Table containing list of application email_records |
| assessment_data | 0 | 5 | 10 | -1 | Table | |
| application_gis_assessment_hh | 0 | 4 | 10 | -1 | Table | Table containing data for the gis assessment hh numbers |
| application_sow_data | 4 | 4 | 11 | -1 | Table | Table containing the SoW data for the given application |
| rfi_data | 1 | 4 | 10 | -1 | Table | Table to hold RFI form data |
| application_form_data | 0 | 2 | 2 | -1 | Table | Table to pair an application to form data |
| application_status_type | 1 | 0 | 5 | 13 | Table | Table containing the different statuses that can be assigned to an application |
| history_item | 0 | 0 | 12 | -1 | Table | This is a type used to return records of history data in the application_history computed column |
| gapless_counter | 1 | 0 | 2 | -1 | Table | Table to hold counter for creating gapless sequences |
| application_claims_excel_data | 0 | 4 | 9 | -1 | Table | Table containing the claims excel data for the given application |
| analyst | 1 | 3 | 11 | -1 | Table | Table containing list of analysts |
| intake | 1 | 4 | 15 | -1 | Table | Table containing intake numbers and their respective open and closing dates |
| application_pending_change_request | 0 | 4 | 10 | -1 | Table | Table containing the pending change request details of the application |
| announcement | 1 | 3 | 9 | -1 | Table | Table to hold the announcement data |
| application_milestone_excel_data | 0 | 4 | 9 | -1 | Table | Table containing the milestone excel data for the given application |
| application_internal_description | 0 | 4 | 9 | -1 | Table | Table containing the internal description for the given application |
| record_version | 0 | 1 | 12 | -1 | Table | Table for tracking history records on tables that auditing is enabled on |
| cbc_data | 1 | 5 | 11 | -1 | Table | Table containing the json data for cbc applications |
| attachment | 0 | 5 | 14 | -1 | Table | Table containing information about uploaded attachments |
| ccbc_user | 121 | 3 | 12 | -1 | Table | Table containing information about the application’s users, this is business contact information not personally identifiable information |
| cbc | 3 | 3 | 9 | -1 | Table | Table containing the data imported from the CBC projects excel file, by rows |
| application | 24 | 4 | 10 | -1 | Table | Table containing the data associated with the CCBC respondents application |
| rfi_data_status_type | 1 | 0 | 2 | -1 | Table | The statuses applicable to an RFI |
| application_analyst_lead | 0 | 5 | 9 | -1 | Table | Table containing the analyst lead for the given application |
| form_data_status_type | 1 | 0 | 2 | -1 | Table | The statuses applicable to a form |
| application_milestone_data | 0 | 4 | 11 | -1 | Table | Table containing the milestone data for the given application |
| change_request_data | 0 | 4 | 10 | -1 | Table | Table to store change request data |
| cbc_data_change_reason | 0 | 4 | 9 | -1 | Table | Table containing the reasons for changes to cbc_data |
| conditional_approval_data | 0 | 4 | 9 | -1 | Table | Table to store conditional approval data |
| application_community_report_excel_data | 0 | 4 | 9 | -1 | Table | Table containing the Community Report excel data for the given application |
| cbc_project | 0 | 3 | 9 | -1 | Table | Table containing the data imported from the CBC projects excel file |
| application_gis_data | 0 | 5 | 10 | -1 | Table | |
| sow_tab_2 | 0 | 4 | 9 | -1 | Table | Table containing the detailed budget data for the given SoW |
| application_status | 1 | 5 | 10 | -1 | Table | Table containing information about possible application statuses |
| application_announcement | 0 | 5 | 10 | -1 | Table | Table to pair an application to RFI data |
| form | 1 | 1 | 5 | -1 | Table | Table to hold the json_schema for forms |
| sow_tab_1 | 0 | 4 | 9 | -1 | Table | |
| cbc_application_pending_change_request | 0 | 4 | 10 | -1 | Table | Table containing the pending change request details of the application |
| application_rfi_data | 0 | 2 | 2 | -1 | Table | Table to pair an application to RFI data |
| form_type | 1 | 0 | 2 | -1 | Table | Table containing the different types of forms used in the application |
| sow_tab_7 | 0 | 4 | 9 | -1 | Table | |
| application_project_type | 0 | 4 | 9 | -1 | Table | Table containing the project type of the application |
| application_community_progress_report_data | 0 | 4 | 11 | -1 | Table | Table containing the Community Progress Report data for the given application |
| gis_data | 1 | 3 | 8 | -1 | Table | Table containing the uploaded GIS data in JSON format |
| sow_tab_8 | 0 | 4 | 9 | -1 | Table | Table containing the detailed budget data for the given SoW |
| application_claims_data | 0 | 4 | 11 | -1 | Table | Table containing the claims data for the given application |
| notification | 0 | 5 | 11 | -1 | Table | Table containing list of application notifications |
| application_package | 0 | 4 | 9 | -1 | Table | Table containing the package the application is assigned to |
| form_data | 1 | 5 | 12 | -1 | Table | Table to hold applicant form data |