projects

-1 rows


Description

Distinguishes among an organization’s projects.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
activities.project_id activities_project_id_fkey C
applications.project_id applications_project_id_fkey C
deliverable_project_due_dates.project_id deliverable_project_due_dates_project_id_fkey C
event_projects.project_id event_projects_project_id_fkey C
participant_project_species.project_id participant_project_species_project_id_fkey C
project_accelerator_details.project_id project_accelerator_details_project_id_fkey R
project_metrics.project_id project_metrics_project_id_fkey C
project_modules.project_id project_modules_project_id_fkey C
project_overall_scores.project_id project_overall_scores_project_id_fkey C
project_report_configs.project_id project_report_configs_project_id_fkey C
project_scores.project_id project_scores_project_id_fkey C
project_vote_decisions.project_id project_vote_decisions_project_id_fkey C
project_votes.project_id project_votes_project_id_fkey C
report_project_metric_targets.project_id report_project_metric_targets_project_id_fkey C
report_standard_metric_targets.project_id report_standard_metric_targets_project_id_fkey C
report_system_metric_targets.project_id report_system_metric_targets_project_id_fkey C
reports.project_id reports_project_id_fkey C
submission_documents.project_id submission_documents_project_id_fkey R
submissions.project_id submissions_project_id_fkey C
documents.project_id documents_project_id_fkey R
variable_owners.project_id variable_owners_project_id_fkey C
variable_values.project_id variable_values_project_id_fkey C
variable_workflow_history.project_id variable_workflow_history_project_id_fkey C
funding_entity_projects.project_id funding_entity_projects_project_id_fkey C
published_activities.project_id published_activities_project_id_fkey C
published_project_carbon_certs.project_id published_project_carbon_certs_project_id_fkey C
published_project_details.project_id published_project_details_project_id_fkey C
published_project_land_use.project_id published_project_land_use_project_id_fkey C
published_project_metric_targets.project_id published_project_metric_targets_project_id_fkey C
published_project_sdg.project_id published_project_sdg_project_id_fkey C
published_reports.project_id published_reports_project_id_fkey C
published_standard_metric_targets.project_id published_standard_metric_targets_project_id_fkey C
published_system_metric_targets.project_id published_system_metric_targets_project_id_fkey C
batch_details_history.project_id batch_details_history_project_id_fkey N
batches.project_id batches_project_id_fkey N
project_internal_users.project_id project_internal_users_project_id_fkey C
project_land_use_model_types.project_id project_land_use_model_types_project_id_fkey C
project_report_settings.project_id project_report_settings_project_id_fkey C
seed_fund_reports.project_id reports_project_id_fkey N
accessions.project_id accessions_project_id_fkey N
draft_planting_sites.project_id draft_planting_sites_project_id_fkey N
planting_sites.project_id planting_sites_project_id_fkey N
created_by int8 19 '-1'::integer
users.id projects_created_by_fkey
created_time timestamptz 35,6 null
modified_by int8 19 '-1'::integer
users.id projects_modified_by_fkey
modified_time timestamptz 35,6 null
organization_id int8 19 null
draft_planting_sites.organization_id draft_planting_sites_organization_id_project_id_fkey R
organizations.id projects_organization_id_fkey C
name text 2147483647 null
description text 2147483647 √ null
country_code text 2147483647 √ null
countries.code projects_country_code_fkey R
cohort_id int8 19 √ null
cohorts.id projects_cohort_id_fkey R
phase_id int4 10 √ null
cohort_phases.id projects_phase_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
projects_pkey Primary key Asc id
projects_created_by_idx Performance Asc created_by
projects_modified_by_idx Performance Asc modified_by
projects_organization_id_id_key Must be unique Asc/Asc organization_id + id
projects_organization_id_name_key Must be unique Asc/Asc organization_id + name

Relationships

Close relationships within degrees of separation