Database Properties
Database Type: PostgreSQL - 17.4 (Debian 17.4-1.pgdg110+2)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| organization_managed_location_types | 0 | 2 | 2 | -1 | Table | Per-organization information about managed location types for business analytics purposes. |
| global_roles | 1 | 0 | 2 | -1 | Table | (Enum) System-wide roles that can be assigned to users. Global roles are not tied to organizations. These are generally for system or business administration; most users have no global roles. |
| upload_types | 1 | 0 | 3 | -1 | Table | (Enum) Types of user-uploaded files whose progress can be tracked in the uploads table. |
| notification_types | 2 | 1 | 3 | -1 | Table | (Enum) Types of notifications in the application. |
| seed_fund_report_files | 0 | 2 | 2 | -1 | Table | Linking table between |
| upload_statuses | 1 | 0 | 3 | -1 | Table | (Enum) Available statuses of user-uploaded files. Uploads progress through these statuses as the system processes the files. |
| managed_location_types | 1 | 0 | 2 | -1 | Table | (Enum) Type of managed location for business analytics purposes. |
| user_preferences | 0 | 2 | 3 | -1 | Table | Client-defined preferences that should persist across browser sessions. |
| organization_media_files | 0 | 2 | 3 | -1 | Table | Media files (photos, videos, etc.) associated with organizations. |
| seed_fund_reports | 2 | 6 | 14 | -1 | Table | Partner-submitted reports about their organizations and projects. |
| notification_criticalities | 1 | 0 | 2 | -1 | Table | (Enum) Criticality information of notifications in the application. |
| seed_fund_report_statuses | 1 | 0 | 2 | -1 | Table | (Enum) Describes where in the workflow each partner report is. |
| organization_report_settings | 0 | 1 | 2 | -1 | Table | Organization-level settings for quarterly reports. Project-level settings are in |
| upload_problem_types | 1 | 0 | 2 | -1 | Table | (Enum) Specific types of problems encountered while processing a user-uploaded file. |
| project_report_settings | 0 | 1 | 2 | -1 | Table | Which projects require reports to be submitted each quarter. Organization-level settings are in |
| user_types | 1 | 0 | 2 | -1 | Table | (Enum) Types of users. Most users are of type 1, “Individual.” |
| email_notification_categories | 1 | 0 | 2 | -1 | Table | (Enum) Categories of email notifications that users can individually opt into or out of. |
| project_land_use_model_types | 0 | 2 | 2 | -1 | Table | Which projects have which types of land use models. |
| project_internal_users | 0 | 5 | 8 | -1 | Table | Which users have which internal roles on a project. |
| organizations | 16 | 5 | 15 | -1 | Table | Top-level information about organizations. |
| regions | 1 | 0 | 2 | -1 | Table | (Enum) Parts of the world where countries are located. |
| notifications | 0 | 3 | 9 | -1 | Table | Notifications for application users. |
| user_disclaimers | 0 | 2 | 3 | -1 | Table | Records of user acceptance of disclaimers. |
| organization_users | 0 | 5 | 7 | -1 | Table | Organization membership and role information. |
| countries | 8 | 1 | 5 | -1 | Table | Country information per ISO-3166. |
| facility_connection_states | 1 | 0 | 2 | -1 | Table | (Enum) Progress of the configuration of a device manager for a facility. |
| disclaimers | 1 | 0 | 3 | -1 | Table | Disclaimers content and effective dates. |
| land_use_model_types | 2 | 0 | 2 | -1 | Table | (Enum) Types of ways a project’s land can be used. |
| projects | 50 | 4 | 11 | -1 | Table | Distinguishes among an organization’s projects. |
| app_versions | 0 | 0 | 4 | -1 | Table | Minimum and recommended versions for Terraware mobile apps. |
| facilities | 7 | 5 | 23 | -1 | Table | Physical locations at a site. For example, each seed bank and each nursery is a facility. |
| device_managers | 0 | 2 | 13 | -1 | Table | Information about device managers. This is a combination of information from the Balena API and locally-generated values. |
| files | 14 | 2 | 12 | -1 | Table | Generic information about individual files. Files are associated with application entities using linking tables such as |
| project_internal_roles | 1 | 0 | 2 | -1 | Table | (Enum) Roles a user is allowed to have on a project. |
| roles | 1 | 0 | 2 | -1 | Table | (Enum) Roles a user is allowed to have in an organization. |
| country_subdivisions | 1 | 1 | 3 | -1 | Table | Country subdivision (state, province, region, etc.) information per ISO-3166-2. |
| user_global_roles | 0 | 2 | 2 | -1 | Table | Which users have which global roles. |
| upload_problems | 0 | 2 | 8 | -1 | Table | Details about problems (validation failures, etc.) in user-uploaded files. |
| internal_tags | 1 | 2 | 8 | -1 | Table | Internal (non-user-facing) tags. Low-numbered tags are defined by the system; the rest may be edited by super admins. |
| uploads | 1 | 5 | 11 | -1 | Table | Information about the status of files uploaded by users. This is used to track the progress of file processing such as importing datafiles; contents of this table may expire and be deleted after a certain amount of time. |
| seed_fund_report_photos | 0 | 2 | 3 | -1 | Table | Linking table between |
| users | 125 | 2 | 16 | -1 | Table | User identities. A user can be associated with organizations via |
| facility_types | 1 | 0 | 2 | -1 | Table | (Enum) Types of facilities that can be represented in the data model. |
| organization_types | 1 | 0 | 2 | -1 | Table | (Enum) Type of forestry organization for business analytics purposes. |
| organization_internal_tags | 0 | 3 | 4 | -1 | Table | Which internal (non-user-facing) tags apply to which organizations. |
| user_email_notification_categories | 0 | 2 | 2 | -1 | Table | Which categories of email notifications each user has opted into. Users only receive categorized email notifications if they have opted into the category and have also enabled email notifications in |