93 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| moped_proj_component_tags_component_tag_id_fkey |
|
|
Cascade on delete | ||
| project_component_tags_updated_by_fkey |
|
|
Restrict delete | ||
| project_component_tags_created_by_fkey |
|
|
Restrict delete | ||
| moped_proj_component_tags_project_component_id_fkey |
|
|
Cascade on delete | ||
| moped_proj_notes_phase_id_fkey |
|
|
Null on delete | ||
| moped_proj_notes_project_id_fkey |
|
|
Cascade on delete | ||
| moped_proj_notes_added_by_user_id_fkey |
|
|
Null on delete | ||
| moped_components_feature_layer_id_fkey |
|
|
Restrict delete | ||
| moped_components_asset_feature_layer_id_fkey |
|
|
Null on delete | ||
| moped_users_workgroup_id_fkey |
|
|
Restrict delete | ||
| moped_proj_entities_project_id_fkey |
|
|
Restrict delete | ||
| project_component_subcomponent_created_by_fkey |
|
|
Restrict delete | ||
| moped_proj_components_subcomponents_project_component_id_fkey |
|
|
Cascade on delete | ||
| project_component_subcomponent_updated_by_fkey |
|
|
Restrict delete | ||
| moped_proj_components_subcomponents_subcomponent_id_fkey |
|
|
Cascade on delete | ||
| moped_proj_milestones_milestone_id_fkey |
|
|
Null on delete | ||
| moped_project_milestone_project_id_fkey |
|
|
Cascade on delete | ||
| created_by_user_fkey |
|
|
Restrict delete | ||
| moped_proj_phases_subphase_id_fkey |
|
|
Null on delete | ||
| moped_phase_history_project_id_fkey |
|
|
Cascade on delete | ||
| moped_proj_phases_moped_phases_phase_id_fk |
|
|
Restrict delete | ||
| updated_by_user_fkey |
|
|
Restrict delete | ||
| moped_proj_personnel_user_id_fkey |
|
|
Restrict delete | ||
| moped_proj_personnel_project_id_fkey |
|
|
Cascade on delete | ||
| project_personnel_created_by_fkey |
|
|
Restrict delete | ||
| project_personnel_updated_by_fkey |
|
|
Restrict delete | ||
| moped_user_followed_projects_project_id_fkey |
|
|
Cascade on delete | ||
| moped_component_work_types_component_id_fkey |
|
|
Cascade on delete | ||
| moped_component_work_types_work_type_id_fkey |
|
|
Cascade on delete | ||
| created_by_user_fkey |
|
|
Restrict delete | ||
| moped_proj_funding_funding_status_id_fkey |
|
|
Restrict delete | ||
| moped_proj_funding_funding_program_id_fkey |
|
|
Restrict delete | ||
| moped_proj_fund_source_project_id_fkey |
|
|
Cascade on delete | ||
| moped_proj_funding_funding_source_id_fkey |
|
|
Restrict delete | ||
| updated_by_user_fkey |
|
|
Restrict delete | ||
| moped_activity_log_updated_by_user_id_fkey |
|
|
Null on delete | ||
| moped_components_subcomponents_subcomponent_id_fkey |
|
|
Restrict delete | ||
| moped_components_subcomponents_component_id_fkey |
|
|
Cascade on delete | ||
| moped_project_files_created_by_fkey |
|
|
Restrict delete | ||
| moped_project_files_project_id_fkey |
|
|
Cascade on delete | ||
| updated_by_user_fkey |
|
|
Restrict delete | ||
| fk_feature_school_beacons_created_by |
|
|
Restrict delete | ||
| fk_feature_school_beacons_updated_by |
|
|
Restrict delete | ||
| created_by_user_fkey |
|
|
Null on delete | ||
| status_id_fkey |
|
|
Null on delete | ||
| moped_proj_contract_project_id_fkey |
|
|
Cascade on delete | ||
| updated_by_user_fkey |
|
|
Null on delete | ||
| features_council_districts_council_district_id_fkey |
|
|
Cascade on delete | ||
| moped_proj_components_phase_id_fkey |
|
|
Null on delete | ||
| moped_proj_components_subphase_id_fkey |
|
|
Null on delete | ||
| moped_proj_components_component_id_fkey |
|
|
Null on delete | ||
| moped_proj_components_project_id_fkey |
|
|
Cascade on delete | ||
| fk_feature_intersections_updated_by |
|
|
Restrict delete | ||
| fk_feature_intersections_created_by |
|
|
Restrict delete | ||
| fk_feature_drawn_lines_updated_by |
|
|
Restrict delete | ||
| fk_feature_drawn_lines_created_by |
|
|
Restrict delete | ||
| moped_proj_partners_created_by_fkey |
|
|
Restrict delete | ||
| moped_proj_partners_project_id_fkey |
|
|
Cascade on delete | ||
| moped_proj_partners_updated_by_fkey |
|
|
Restrict delete | ||
| moped_proj_partners_entity_id_fkey |
|
|
Restrict delete | ||
| fk_feature_street_segments_created_by |
|
|
Restrict delete | ||
| fk_feature_street_segments_updated_by |
|
|
Restrict delete | ||
| moped_project_added_by_fkey |
|
|
Null on delete | ||
| moped_project_project_lead_id_fkey |
|
|
Null on delete | ||
| moped_project_public_process_status_id_fkey |
|
|
Null on delete | ||
| moped_project_parent_project_id_fkey |
|
|
Null on delete | ||
| moped_project_project_sponsor_fkey |
|
|
Cascade on delete | ||
| updated_by_user_fkey |
|
|
Restrict delete | ||
| moped_user_events_user_id_fkey |
|
|
Cascade on delete | ||
| fk_feature_signals_created_by |
|
|
Restrict delete | ||
| fk_feature_signals_updated_by |
|
|
Restrict delete | ||
| project_types_created_by_fkey |
|
|
Restrict delete | ||
| project_types_updated_by_fkey |
|
|
Restrict delete | ||
| moped_project_types_project_id_fkey |
|
|
Cascade on delete | ||
| moped_project_types_project_type_id_fkey |
|
|
Restrict delete | ||
| moped_milestones_related_phase_id_fkey |
|
|
Null on delete | ||
| moped_subphases_related_phase_id_fkey |
|
|
Null on delete | ||
| features_component_id_fkey |
|
|
Restrict delete | ||
| moped_workgroup_department_id_fkey |
|
|
Restrict delete | ||
| fk_feature_drawn_points_created_by |
|
|
Restrict delete | ||
| fk_feature_drawn_points_updated_by |
|
|
Restrict delete | ||
| moped_proj_tags_tag_id_fkey |
|
|
Cascade on delete | ||
| moped_proj_tags_project_id_fkey |
|
|
Cascade on delete | ||
| project_tags_updated_by_fkey |
|
|
Restrict delete | ||
| project_tags_created_by_fkey |
|
|
Restrict delete | ||
| moped_proj_personnel_roles_project_role_id_fkey |
|
|
Null on delete | ||
| project_personnel_roles_updated_by_fkey |
|
|
Restrict delete | ||
| project_personnel_roles_created_by_fkey |
|
|
Restrict delete | ||
| moped_proj_personnel_roles_project_personnel_id_fkey |
|
|
Cascade on delete | ||
| project_component_work_types_created_by_fkey |
|
|
Restrict delete | ||
| project_component_work_types_updated_by_fkey |
|
|
Restrict delete | ||
| moped_proj_component_work_types_work_type_id_fkey |
|
|
Cascade on delete | ||
| moped_proj_component_work_types_project_component_id_fkey |
|
|
Cascade on 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]))) |