Constraints

99 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

moped_entity_organization_id_fkey

moped_entity.organization_id

moped_organization.organization_id

Restrict delete

moped_entity_department_id_fkey

moped_entity.department_id

moped_department.department_id

Restrict delete

moped_entity_workgroup_id_fkey

moped_entity.workgroup_id

moped_workgroup.workgroup_id

Restrict delete

moped_proj_component_tags_component_tag_id_fkey

moped_proj_component_tags.component_tag_id

moped_component_tags.id

Cascade on delete

project_component_tags_updated_by_fkey

moped_proj_component_tags.updated_by_user_id

moped_users.user_id

Restrict delete

project_component_tags_created_by_fkey

moped_proj_component_tags.created_by_user_id

moped_users.user_id

Restrict delete

moped_proj_component_tags_project_component_id_fkey

moped_proj_component_tags.project_component_id

moped_proj_components.project_component_id

Cascade on delete

moped_proj_notes_phase_id_fkey

moped_proj_notes.phase_id

moped_phases.phase_id

Null on delete

moped_proj_notes_type_fkey

moped_proj_notes.project_note_type

moped_note_types.id

Restrict delete

moped_proj_notes_project_id_fkey

moped_proj_notes.project_id

moped_project.project_id

Cascade on delete

moped_proj_notes_added_by_user_id_fkey

moped_proj_notes.created_by_user_id

moped_users.user_id

Null on delete

moped_components_feature_layer_id_fkey

moped_components.feature_layer_id

feature_layers.id

Restrict delete

moped_components_asset_feature_layer_id_fkey

moped_components.asset_feature_layer_id

feature_layers.id

Null on delete

moped_users_workgroup_id_fkey

moped_users.workgroup_id

moped_workgroup.workgroup_id

Restrict delete

moped_proj_entities_project_id_fkey

moped_proj_entities.project_id

moped_project.project_id

Restrict delete

project_component_subcomponent_created_by_fkey

moped_proj_components_subcomponents.created_by_user_id

moped_users.user_id

Restrict delete

moped_proj_components_subcomponents_project_component_id_fkey

moped_proj_components_subcomponents.project_component_id

moped_proj_components.project_component_id

Cascade on delete

project_component_subcomponent_updated_by_fkey

moped_proj_components_subcomponents.updated_by_user_id

moped_users.user_id

Restrict delete

moped_proj_components_subcomponents_subcomponent_id_fkey

moped_proj_components_subcomponents.subcomponent_id

moped_subcomponents.subcomponent_id

Cascade on delete

moped_proj_milestones_milestone_id_fkey

moped_proj_milestones.milestone_id

moped_milestones.milestone_id

Null on delete

moped_project_milestone_project_id_fkey

moped_proj_milestones.project_id

moped_project.project_id

Cascade on delete

created_by_user_fkey

moped_proj_phases.created_by_user_id

moped_users.user_id

Restrict delete

moped_proj_phases_subphase_id_fkey

moped_proj_phases.subphase_id

moped_subphases.subphase_id

Null on delete

moped_phase_history_project_id_fkey

moped_proj_phases.project_id

moped_project.project_id

Cascade on delete

moped_proj_phases_moped_phases_phase_id_fk

moped_proj_phases.phase_id

moped_phases.phase_id

Restrict delete

updated_by_user_fkey

moped_proj_phases.updated_by_user_id

moped_users.user_id

Restrict delete

moped_proj_personnel_user_id_fkey

moped_proj_personnel.user_id

moped_users.user_id

Restrict delete

moped_proj_personnel_project_id_fkey

moped_proj_personnel.project_id

moped_project.project_id

Cascade on delete

project_personnel_created_by_fkey

moped_proj_personnel.created_by_user_id

moped_users.user_id

Restrict delete

project_personnel_updated_by_fkey

moped_proj_personnel.updated_by_user_id

moped_users.user_id

Restrict delete

moped_user_followed_projects_project_id_fkey

moped_user_followed_projects.project_id

moped_project.project_id

Cascade on delete

moped_component_work_types_component_id_fkey

moped_component_work_types.component_id

moped_components.component_id

Cascade on delete

moped_component_work_types_work_type_id_fkey

moped_component_work_types.work_type_id

moped_work_types.id

Cascade on delete

created_by_user_fkey

moped_proj_funding.created_by_user_id

moped_users.user_id

Restrict delete

moped_proj_funding_funding_status_id_fkey

moped_proj_funding.funding_status_id

moped_fund_status.funding_status_id

Restrict delete

moped_proj_funding_funding_program_id_fkey

moped_proj_funding.funding_program_id

moped_fund_programs.funding_program_id

Restrict delete

moped_proj_fund_source_project_id_fkey

moped_proj_funding.project_id

moped_project.project_id

Cascade on delete

moped_proj_funding_funding_source_id_fkey

moped_proj_funding.funding_source_id

moped_fund_sources.funding_source_id

Restrict delete

updated_by_user_fkey

moped_proj_funding.updated_by_user_id

moped_users.user_id

Restrict delete

moped_activity_log_updated_by_user_id_fkey

moped_activity_log.updated_by_user_id

moped_users.user_id

Null on delete

moped_components_subcomponents_subcomponent_id_fkey

moped_components_subcomponents.subcomponent_id

moped_subcomponents.subcomponent_id

Restrict delete

moped_components_subcomponents_component_id_fkey

moped_components_subcomponents.component_id

moped_components.component_id

Cascade on delete

moped_project_files_created_by_fkey

moped_project_files.created_by_user_id

moped_users.user_id

Restrict delete

moped_project_files_type_fkey

moped_project_files.file_type

moped_file_types.id

Restrict delete

moped_project_files_project_id_fkey

moped_project_files.project_id

moped_project.project_id

Cascade on delete

updated_by_user_fkey

moped_project_files.updated_by_user_id

moped_users.user_id

Restrict delete

fk_feature_school_beacons_created_by

feature_school_beacons.created_by_user_id

moped_users.user_id

Restrict delete

fk_feature_school_beacons_updated_by

feature_school_beacons.updated_by_user_id

moped_users.user_id

Restrict delete

created_by_user_fkey

moped_proj_work_activity.created_by_user_id

moped_users.user_id

Null on delete

status_id_fkey

moped_proj_work_activity.status_id

moped_proj_work_activity_status.id

Null on delete

moped_proj_contract_project_id_fkey

moped_proj_work_activity.project_id

moped_project.project_id

Cascade on delete

updated_by_user_fkey

moped_proj_work_activity.updated_by_user_id

moped_users.user_id

Null on delete

features_council_districts_council_district_id_fkey

features_council_districts.council_district_id

layer_council_district.council_district

Cascade on delete

moped_proj_components_phase_id_fkey

moped_proj_components.phase_id

moped_phases.phase_id

Null on delete

moped_proj_components_subphase_id_fkey

moped_proj_components.subphase_id

moped_subphases.subphase_id

Null on delete

moped_proj_components_component_id_fkey

moped_proj_components.component_id

moped_components.component_id

Null on delete

moped_proj_components_project_id_fkey

moped_proj_components.project_id

moped_project.project_id

Cascade on delete

fk_feature_intersections_updated_by

feature_intersections.updated_by_user_id

moped_users.user_id

Restrict delete

fk_feature_intersections_created_by

feature_intersections.created_by_user_id

moped_users.user_id

Restrict delete

fk_feature_drawn_lines_updated_by

feature_drawn_lines.updated_by_user_id

moped_users.user_id

Restrict delete

fk_feature_drawn_lines_created_by

feature_drawn_lines.created_by_user_id

moped_users.user_id

Restrict delete

moped_proj_partners_created_by_fkey

moped_proj_partners.created_by_user_id

moped_users.user_id

Restrict delete

moped_proj_partners_project_id_fkey

moped_proj_partners.project_id

moped_project.project_id

Cascade on delete

moped_proj_partners_updated_by_fkey

moped_proj_partners.updated_by_user_id

moped_users.user_id

Restrict delete

moped_proj_partners_entity_id_fkey

moped_proj_partners.entity_id

moped_entity.entity_id

Restrict delete

fk_feature_street_segments_created_by

feature_street_segments.created_by_user_id

moped_users.user_id

Restrict delete

fk_feature_street_segments_updated_by

feature_street_segments.updated_by_user_id

moped_users.user_id

Restrict delete

moped_project_added_by_fkey

moped_project.added_by

moped_users.user_id

Null on delete

moped_project_project_lead_id_fkey

moped_project.project_lead_id

moped_entity.entity_id

Null on delete

moped_project_public_process_status_id_fkey

moped_project.public_process_status_id

moped_public_process_statuses.id

Null on delete

moped_project_parent_project_id_fkey

moped_project.parent_project_id

moped_project.project_id

Null on delete

moped_project_project_sponsor_fkey

moped_project.project_sponsor

moped_entity.entity_id

Cascade on delete

updated_by_user_fkey

moped_project.updated_by_user_id

moped_users.user_id

Restrict delete

ecapris_subproject_statuses_created_by_user_id_fkey

ecapris_subproject_statuses.created_by_user_id

moped_users.user_id

Restrict delete

ecapris_subproject_statuses_updated_by_user_id_fkey

ecapris_subproject_statuses.updated_by_user_id

moped_users.user_id

Restrict delete

moped_user_events_user_id_fkey

moped_user_events.user_id

moped_users.user_id

Cascade on delete

fk_feature_signals_created_by

feature_signals.created_by_user_id

moped_users.user_id

Restrict delete

fk_feature_signals_updated_by

feature_signals.updated_by_user_id

moped_users.user_id

Restrict delete

moped_milestones_related_phase_id_fkey

moped_milestones.related_phase_id

moped_phases.phase_id

Null on delete

moped_subphases_related_phase_id_fkey

moped_subphases.related_phase_id

moped_phases.phase_id

Null on delete

features_component_id_fkey

features.component_id

moped_proj_components.project_component_id

Restrict delete

moped_workgroup_department_id_fkey

moped_workgroup.department_id

moped_department.department_id

Restrict delete

fk_feature_drawn_points_created_by

feature_drawn_points.created_by_user_id

moped_users.user_id

Restrict delete

fk_feature_drawn_points_updated_by

feature_drawn_points.updated_by_user_id

moped_users.user_id

Restrict delete

moped_proj_tags_tag_id_fkey

moped_proj_tags.tag_id

Cascade on delete

moped_proj_tags_project_id_fkey

moped_proj_tags.project_id

moped_project.project_id

Cascade on delete

project_tags_updated_by_fkey

moped_proj_tags.updated_by_user_id

moped_users.user_id

Restrict delete

project_tags_created_by_fkey

moped_proj_tags.created_by_user_id

moped_users.user_id

Restrict delete

moped_proj_personnel_roles_project_role_id_fkey

moped_proj_personnel_roles.project_role_id

moped_project_roles.project_role_id

Null on delete

project_personnel_roles_updated_by_fkey

moped_proj_personnel_roles.updated_by_user_id

moped_users.user_id

Restrict delete

project_personnel_roles_created_by_fkey

moped_proj_personnel_roles.created_by_user_id

moped_users.user_id

Restrict delete

moped_proj_personnel_roles_project_personnel_id_fkey

moped_proj_personnel_roles.project_personnel_id

moped_proj_personnel.project_personnel_id

Cascade on delete

project_component_work_types_created_by_fkey

moped_proj_component_work_types.created_by_user_id

moped_users.user_id

Restrict delete

project_component_work_types_updated_by_fkey

moped_proj_component_work_types.updated_by_user_id

moped_users.user_id

Restrict delete

moped_proj_component_work_types_work_type_id_fkey

moped_proj_component_work_types.work_type_id

moped_work_types.id

Cascade on delete

moped_proj_component_work_types_project_component_id_fkey

moped_proj_component_work_types.project_component_id

moped_proj_components.project_component_id

Cascade on delete

fk_moped_user_saved_views_updated_by

moped_user_saved_views.updated_by_user_id

moped_users.user_id

Restrict delete

fk_moped_user_saved_views_created_by

moped_user_saved_views.created_by_user_id

moped_users.user_id

Restrict delete

moped_department_organization_id_fkey

moped_department.organization_id

moped_organization.organization_id

Restrict delete

Check Constraints

Table	Constraint Name	Constraint
spatial_ref_sys	spatial_ref_sys_srid_check	((srid > 0) AND (srid <= 998999))
moped_user_events	moped_user_events_event_name_check	(event_name = ANY (ARRAY['app_load'::text, 'dashboard_load'::text, 'projects_map_load'::text, 'projects_saved_view'::text]))