Database Properties
Database Type: PostgreSQL - 17.4 (Debian 17.4-1.pgdg110+2)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| events | 1 | 5 | 14 | -1 | Table | Events with meeting links and time within an acclerator module. |
| vote_options | 2 | 0 | 2 | -1 | Table | (Enum) Available vote options. |
| deliverable_variables | 0 | 2 | 3 | -1 | Table | Which variables are associated with which deliverables. Note that this includes variables that have been replaced by newer versions, and the newer versions might be associated with different deliverables. |
| indicator_levels | 3 | 0 | 2 | -1 | Table | (Enum) Levels of indicators for reports. |
| project_indicator_targets | 0 | 2 | 4 | -1 | Table | Project-level baseline and end-of-project target values for project-specific indicators. |
| modules | 4 | 3 | 15 | -1 | Table | Possible steps in the workflow of an accelerator phase. |
| report_auto_calculated_indicators | 0 | 4 | 10 | -1 | Table | Report entries of targets and values for auto-calculated indicators. |
| project_scores | 0 | 5 | 9 | -1 | Table | Scores assigned to project by scorers. |
| hubspot_token | 0 | 0 | 1 | -1 | Table | If the server has been authorized to make HubSpot API requests, the refresh token to use to generate new access tokens. |
| reports | 7 | 9 | 19 | -1 | Table | Accelerator project reports. |
| report_statuses | 1 | 0 | 2 | -1 | Table | (Enum) Statuses of accelerator project reports. |
| event_types | 1 | 0 | 2 | -1 | Table | (Enum) Types of events for an accelerator module |
| project_accelerator_details | 0 | 3 | 26 | -1 | Table | Details about projects that are only relevant for accelerator applicants. The values here are for internal use, not exposed to end users. |
| project_modules | 0 | 2 | 5 | -1 | Table | Which modules are assigned to which projects. |
| score_categories | 1 | 0 | 2 | -1 | Table | (Enum) Project score categories. |
| indicator_classes | 3 | 0 | 2 | -1 | Table | (Enum) Classes of accelerator project report indicators. |
| accelerator_phases | 5 | 0 | 2 | -1 | Table | (Enum) Phases that accelerator projects go through. |
| deliverable_documents | 0 | 4 | 3 | -1 | Table | Information about expected deliverables of type Document that isn’t relevant for other deliverable types. |
| application_statuses | 2 | 0 | 2 | -1 | Table | (Enum) Possible statuses for an application to the accelerator program. |
| indicator_categories | 3 | 0 | 2 | -1 | Table | (Enum) Categories of indicators for reports. |
| project_overall_scores | 0 | 3 | 8 | -1 | Table | Overall scores assigned to project by scorers. |
| submission_snapshots | 0 | 2 | 3 | -1 | Table | Snapshot files associated to submissions |
| report_common_indicator_targets | 0 | 2 | 4 | -1 | Table | Project targets for standard indicators by year |
| report_challenges | 0 | 1 | 4 | -1 | Table | List of challenges and mitigation plans for accelerator project reports. |
| application_module_statuses | 1 | 0 | 2 | -1 | Table | (Enum) Possible statuses of individual modules in an application. |
| report_quarters | 2 | 0 | 2 | -1 | Table | (Enum) Quarters of accelerator project reports. |
| deliverables | 6 | 5 | 13 | -1 | Table | Information about expected deliverables. This describes what we request from users; the data we get back from users in response is recorded in |
| default_voters | 0 | 1 | 1 | -1 | Table | Users to automatically be assigned as voters on accelerator projects. |
| submission_documents | 0 | 4 | 10 | -1 | Table | Information about documents uploaded by users to satisfy deliverables. A deliverable can have multiple documents. |
| report_photos | 2 | 2 | 4 | -1 | Table | Photos for the accelerator project report. |
| common_indicator_targets | 0 | 2 | 4 | -1 | Table | Project-level baseline and end-of-project target values for common indicators. |
| project_indicators | 6 | 5 | 16 | -1 | Table | Indicators specific to one project to report on. |
| activity_types | 2 | 0 | 2 | -1 | Table | (Enum) Types of entries in the activity log. |
| auto_calculated_indicators | 6 | 4 | 15 | -1 | Table | (Enum) Accelerator report auto-calculated indicators, for which data are collected from Terraware. |
| activity_media_files | 0 | 3 | 7 | -1 | Table | Information about activity-related media such as photos and videos. |
| report_auto_calculated_indicator_targets | 0 | 2 | 4 | -1 | Table | Project targets for auto-calculated indicators by year |
| submission_statuses | 2 | 0 | 2 | -1 | Table | (Enum) Statuses of submissions of deliverables by specific projects. |
| report_achievements | 0 | 1 | 3 | -1 | Table | List of achievements for accelerator project reports. |
| activity_statuses | 1 | 0 | 2 | -1 | Table | (Enum) Statuses of entries in the activity log. |
| deliverable_project_due_dates | 0 | 2 | 3 | -1 | Table | Deliverable due dates overrides for projects. |
| internal_interests | 2 | 0 | 2 | -1 | Table | (Enum) Types of notification categories for internal users. |
| report_project_indicator_targets | 0 | 2 | 4 | -1 | Table | Project targets for project-specific indicators by year |
| activity_media_types | 2 | 0 | 2 | -1 | Table | (Enum) Types of media that can be associated with entries in the activity log. |
| report_project_indicators | 0 | 4 | 8 | -1 | Table | Report entries of targets and values for project indicators. |
| project_report_configs | 3 | 1 | 4 | -1 | Table | Configurations for accelerator project reports, including reporting dates and reporting frequencies. |
| applications | 2 | 5 | 12 | -1 | Table | Information about projects that are applying for the accelerator program. |
| report_indicator_statuses | 6 | 0 | 2 | -1 | Table | (Enum) Statuses of accelerator project report indicators. |
| application_histories | 0 | 3 | 8 | -1 | Table | Change histories for accelerator applications. Only includes changes to top-level metadata, not things like changes to variable values. |
| deliverable_categories | 1 | 1 | 3 | -1 | Table | (Enum) High-level groups for organizing deliverables. |
| event_statuses | 1 | 0 | 2 | -1 | Table | (Enum) Statuses of events for an accelerator module |
| submissions | 2 | 5 | 10 | -1 | Table | Information about the current states of the information supplied by specific projects in response to deliverables. |
| user_internal_interests | 0 | 3 | 4 | -1 | Table | Which internal interest categories are assigned to which internal users. This affects things like which accelerator admins are notified. |
| event_projects | 0 | 2 | 2 | -1 | Table | Projects that are participants of an event. |
| report_common_indicators | 0 | 4 | 8 | -1 | Table | Report entries of targets and values for standard indicators. |
| activities | 2 | 6 | 13 | -1 | Table | User-supplied descriptions of project activities. |
| participant_project_species | 0 | 6 | 12 | -1 | Table | Species that are associated to a participant project |
| deliverable_types | 2 | 0 | 2 | -1 | Table | (Enum) Types of deliverables for an accelerator module. |
| pipelines | 2 | 0 | 2 | -1 | Table | (Enum) Deal pipelines for accelerator projects. |
| auto_calculated_indicator_targets | 0 | 2 | 4 | -1 | Table | Project-level baseline and end-of-project target values for auto-calculated indicators. |
| project_votes | 0 | 6 | 9 | -1 | Table | Vote selected by voters. |
| common_indicators | 6 | 4 | 15 | -1 | Table | Standard non-system indicators for every project to measure in accelerator reports. |
| project_vote_decisions | 0 | 3 | 4 | -1 | Table | Calculated vote decisions for project. |
| indicator_frequencies | 3 | 0 | 2 | -1 | Table | (Enum) Reporting frequencies of accelerator project report indicators. |
| deal_stages | 1 | 1 | 3 | -1 | Table | (Enum) Stages in the deal workflow that a project progresses through. |
| document_stores | 1 | 0 | 2 | -1 | Table | (Enum) Locations where uploaded documents are stored. |
| application_modules | 0 | 3 | 3 | -1 | Table | Current states of the modules for individual applications. |