Database Properties
Database Type: PostgreSQL - 17.4 (Debian 17.4-1.pgdg110+2)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| published_project_indicator_targets | 0 | 2 | 4 | -1 | Table | Published project targets for project-specific indicators by year |
| published_auto_calculated_indicator_targets | 0 | 2 | 4 | -1 | Table | Published project targets for auto-calculated indicators by year |
| published_auto_calculated_indicator_baselines | 0 | 2 | 4 | -1 | Table | Published project-level baseline and end-of-project target values for auto-calculated indicators. |
| 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_common_indicator_baselines | 0 | 2 | 4 | -1 | Table | Published project-level baseline and end-of-project target values for common indicators. |
| published_report_project_indicators | 0 | 3 | 6 | -1 | Table | Project-specific indicators 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 | 4 | 10 | -1 | Table | Published reports visible to funders. |
| funding_entity_users | 0 | 2 | 2 | -1 | Table | Funding Entity membership. |
| published_report_common_indicators | 0 | 3 | 6 | -1 | Table | Standard indicators of published reports. |
| published_activities | 1 | 4 | 8 | -1 | Table | Published project activities visible to funders. |
| published_report_achievements | 0 | 1 | 3 | -1 | Table | Achievements 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_project_indicator_baselines | 0 | 2 | 4 | -1 | Table | Published project-level baseline and end-of-project target values for project-specific indicators. |
| published_report_auto_calculated_indicators | 0 | 3 | 6 | -1 | Table | Auto-calculated indicators 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. |
| published_common_indicator_targets | 0 | 2 | 4 | -1 | Table | Published project targets for standard indicators by year |