Database Properties
Database Type: PostgreSQL - 13.1 (Debian 13.1-1.pgdg100+1)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| deliverable_project_due_dates | 0 | 2 | 3 | 0 | Table | Deliverable due dates overrides for projects. |
| events | 1 | 5 | 14 | 0 | Table | Events with meeting links and time within an acclerator module. |
| vote_options | 2 | 0 | 2 | 3 | Table | (Enum) Available vote options. |
| internal_interests | 2 | 0 | 2 | 9 | Table | (Enum) Types of notification categories for internal users. |
| deliverable_variables | 0 | 2 | 3 | 0 | 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. |
| cohorts | 3 | 3 | 7 | 0 | Table | Accelerator cohort details. |
| cohort_phases | 5 | 0 | 2 | 6 | Table | (Enum) Available cohort phases |
| deliverable_cohort_due_dates | 0 | 2 | 3 | 0 | Table | Deliverable due dates overrides for cohorts. Can be overridden at the project level. |
| modules | 4 | 3 | 15 | 0 | Table | Possible steps in the workflow of a cohort phase. |
| project_scores | 0 | 5 | 9 | 0 | Table | Scores assigned to project by scorers. |
| hubspot_token | 0 | 0 | 1 | 0 | Table | If the server has been authorized to make HubSpot API requests, the refresh token to use to generate new access tokens. |
| applications | 2 | 5 | 12 | 0 | Table | Information about projects that are applying for the accelerator program. |
| event_types | 1 | 0 | 2 | 4 | Table | (Enum) Types of events for an accelerator module |
| project_accelerator_details | 0 | 3 | 23 | 0 | Table | Details about projects that are only relevant for accelerator applicants. The values here are for internal use, not exposed to end users. |
| score_categories | 1 | 0 | 2 | 12 | Table | (Enum) Project score categories. |
| application_histories | 0 | 3 | 8 | 0 | 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 | 8 | Table | (Enum) High-level groups for organizing deliverables. |
| event_statuses | 1 | 0 | 2 | 4 | Table | (Enum) Statuses of events for an accelerator module |
| cohort_modules | 0 | 2 | 5 | 0 | Table | Which modules are assigned to which cohorts. |
| deliverable_documents | 0 | 4 | 3 | 0 | Table | Information about expected deliverables of type Document that isn’t relevant for other deliverable types. |
| application_statuses | 2 | 0 | 2 | 14 | Table | (Enum) Possible statuses for an application to the accelerator program. |
| submissions | 2 | 5 | 10 | 0 | Table | Information about the current states of the information supplied by specific projects in response to deliverables. |
| submission_snapshots | 0 | 2 | 3 | 0 | Table | Snapshot files associated to submissions |
| user_internal_interests | 0 | 3 | 4 | 0 | 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 | 0 | Table | Projects that are participants of an event. |
| participant_project_species | 0 | 6 | 12 | 0 | Table | Species that are associated to a participant project |
| deliverable_types | 2 | 0 | 2 | 3 | Table | (Enum) Types of deliverables for an accelerator module. |
| application_module_statuses | 1 | 0 | 2 | 2 | Table | (Enum) Possible statuses of individual modules in an application. |
| pipelines | 2 | 0 | 2 | 3 | Table | (Enum) Deal pipelines for accelerator projects. |
| deliverables | 7 | 5 | 13 | 0 | 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 | 0 | Table | Users to automatically be assigned as voters on accelerator projects. |
| default_project_leads | 0 | 1 | 2 | 0 | Table | Default project leads to use at application submission time based on project region. |
| project_votes | 0 | 6 | 9 | 0 | Table | Vote selected by voters. |
| submission_documents | 0 | 4 | 10 | 0 | Table | Information about documents uploaded by users to satisfy deliverables. A deliverable can have multiple documents. |
| project_vote_decisions | 0 | 3 | 4 | 0 | Table | Calculated vote decisions for project. |
| deal_stages | 1 | 1 | 3 | 16 | Table | (Enum) Stages in the deal workflow that a project progresses through. |
| submission_statuses | 2 | 0 | 2 | 7 | Table | (Enum) Statuses of submissions of deliverables by specific projects. |
| document_stores | 1 | 0 | 2 | 3 | Table | (Enum) Locations where uploaded documents are stored. |
| participants | 1 | 3 | 7 | 0 | Table | Accelerator participant details. |
| application_modules | 0 | 3 | 3 | 0 | Table | Current states of the modules for individual applications. |