moped_project

3 rows


Description

Moped Project Table – Parent entity of most in the database, primary key is foreign key for many entities

Columns

Column Type Size Nulls Auto Default Children Parents Comments
project_name text 2147483647 null
project_description text 2147483647 null
ecapris_subproject_id text 2147483647 √ null
project_id serial 10 √ nextval('moped_project_project_id_simple_seq'::regclass)
moped_proj_components.project_id moped_proj_components_project_id_fkeyC
moped_proj_entities.project_id moped_proj_entities_project_id_fkeyR
moped_proj_funding.project_id moped_proj_fund_source_project_id_fkeyC
moped_proj_milestones.project_id moped_project_milestone_project_id_fkeyC
moped_proj_notes.project_id moped_proj_notes_project_id_fkeyC
moped_proj_partners.project_id moped_proj_partners_project_id_fkeyC
moped_proj_personnel.project_id moped_proj_personnel_project_id_fkeyC
moped_proj_phases.project_id moped_phase_history_project_id_fkeyC
moped_proj_tags.project_id moped_proj_tags_project_id_fkeyC
moped_proj_work_activity.project_id moped_proj_contract_project_id_fkeyC
moped_project.parent_project_id moped_project_parent_project_id_fkeyN
moped_project_files.project_id moped_project_files_project_id_fkeyC
moped_project_types.project_id moped_project_types_project_id_fkeyC
moped_user_followed_projects.project_id moped_user_followed_projects_project_id_fkeyC
date_added timestamptz 35,6 √ clock_timestamp()
added_by int4 10 √ null
moped_users.user_id moped_project_added_by_fkeyN
is_deleted bool 1 false

Indicates soft deletion
updated_at timestamptz 35,6 √ now()
project_sponsor int4 10 √ null
moped_entity.entity_id moped_project_project_sponsor_fkeyC
project_website text 2147483647 √ null
knack_project_id text 2147483647 √ null
parent_project_id int4 10 √ null
moped_project.project_id moped_project_parent_project_id_fkeyN
interim_project_id int4 10 √ null
project_lead_id int4 10 √ null
moped_entity.entity_id moped_project_project_lead_id_fkeyN
public_process_status_id int4 10 √ null
moped_public_process_statuses.id moped_project_public_process_status_id_fkeyN
is_migrated_from_access_db bool 1 false
updated_by_user_id int4 10 √ null
moped_users.user_id updated_by_user_fkeyR

User ID of the person who last updated the project
project_name_secondary text 2147483647 √ null
project_name_full text 2147483647 √ COALESCE(((project_name || ' - '::text) || project_name_secondary), project_name)

Indexes

Constraint Name Type Sort Column(s)
moped_project_pkey Primary key Asc project_id
moped_project_is_retired_index Performance Asc is_deleted
moped_project_name_idx Performance Asc project_name
moped_project_parent_id_idx Performance Asc parent_project_id
moped_project_project_id_simple_key Must be unique Asc project_id
moped_project_updated_at_idx Performance Asc updated_at

Relationships

Close relationships within degrees of separation