projects

0 rows


Description

Distinguishes among an organization’s projects.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
applications.project_id applications_project_id_fkeyC
deliverable_project_due_dates.project_id deliverable_project_due_dates_project_id_fkeyC
event_projects.project_id event_projects_project_id_fkeyC
participant_project_species.project_id participant_project_species_project_id_fkeyC
project_accelerator_details.project_id project_accelerator_details_project_id_fkeyR
project_overall_scores.project_id project_overall_scores_project_id_fkeyC
project_scores.project_id project_scores_project_id_fkeyC
project_vote_decisions.project_id project_vote_decisions_project_id_fkeyC
project_votes.project_id project_votes_project_id_fkeyC
submission_documents.project_id submission_documents_project_id_fkeyR
submissions.project_id submissions_project_id_fkeyC
documents.project_id documents_project_id_fkeyR
variable_owners.project_id variable_owners_project_id_fkeyC
variable_values.project_id variable_values_project_id_fkeyC
variable_workflow_history.project_id variable_workflow_history_project_id_fkeyC
batch_details_history.project_id batch_details_history_project_id_fkeyN
batches.project_id batches_project_id_fkeyN
project_land_use_model_types.project_id project_land_use_model_types_project_id_fkeyC
project_report_settings.project_id project_report_settings_project_id_fkeyC
reports.project_id reports_project_id_fkeyN
accessions.project_id accessions_project_id_fkeyN
draft_planting_sites.project_id draft_planting_sites_project_id_fkeyN
planting_sites.project_id planting_sites_project_id_fkeyN
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_fkeyR
organizations.id projects_organization_id_fkeyR
name text 2147483647 null
description text 2147483647 √ null
participant_id int8 19 √ null
participants.id projects_participant_id_fkeyR
country_code text 2147483647 √ null
countries.code projects_country_code_fkeyR

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
projects_participant_id_idx Performance Asc participant_id

Relationships

Close relationships within degrees of separation