Database Properties
Database Type: PostgreSQL - 17.4 (Debian 17.4-1.pgdg110+2)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| published_project_sdg | 0 | 1 | 2 | -1 | Table | Sustainable Development Goals for published projects. |
| published_report_challenges | 0 | 1 | 4 | -1 | Table | Challenges and mitigation plans of published reports. |
| published_project_carbon_certs | 0 | 1 | 2 | -1 | Table | Carbon Certifications for published projects. |
| published_project_land_use | 0 | 2 | 3 | -1 | Table | Land Use Model Types and hectares of each for published projects. |
| published_reports | 6 | 5 | 11 | -1 | Table | Published reports visible to funders. |
| funding_entity_users | 0 | 2 | 2 | -1 | Table | Funding Entity membership. |
| published_activities | 1 | 4 | 8 | -1 | Table | Published project activities visible to funders. |
| published_report_project_metrics | 0 | 3 | 7 | -1 | Table | Project-specific metrics of published reports. |
| published_report_achievements | 0 | 1 | 3 | -1 | Table | Achievements of published reports. |
| published_report_system_metrics | 0 | 3 | 7 | -1 | Table | System metrics of published reports. |
| funding_entities | 2 | 2 | 6 | -1 | Table | Top-level information about Funding Entities for Funders. |
| published_report_photos | 0 | 4 | 3 | -1 | Table | Photos for the published accelerator project report. |
| published_report_standard_metrics | 0 | 3 | 7 | -1 | Table | Standard metrics of published reports. |
| published_project_details | 0 | 5 | 20 | -1 | Table | Published Project Data visible to funders. |
| funding_entity_projects | 0 | 2 | 2 | -1 | Table | Which funding entities are associated with which projects. |
| published_activity_media_files | 0 | 3 | 7 | -1 | Table | Media files for published project activities visible to funders. It is possible for a file to continue to appear here after it has been removed from the activity if the removal has not been published yet. |