Constraints

750 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
FK568862466D9E1076
site_item_subtype.site_item_type_id
site_item_type.id
Restrict delete
fk_intake_attachment_field
intake_attachment.field_id
intake_field.id
Restrict delete
fk_intake_attachment_intake
intake_attachment.ticket_id
intake.id
Restrict delete
fk_intake_attachment_user
intake_attachment.user_id
sys_users.user_id
Restrict delete
FK_bfd55mv84uxtqwuj6x57o9uiv
workflow_type.vendor_quote_vendor_type_id
sys_company_types.type_id
Restrict delete
FK44116FBA82389340
workflow_type.form_id
project_form.id
Restrict delete
FK_ie87dpl8hxk68iepaev4v1rds
program_site_design.program_end_designs_id
program.id
Restrict delete
FK_nx6a0fl83vk7ae6i6uayml3e5
program_site_design.program_start_designs_id
program.id
Restrict delete
FK3EB8C6242B40DAE6
site_pack_action.trigger_id
site_pack_action_trigger.id
Restrict delete
FK_692v62ie46mebyc1kq3w8r6a9
program_workflow_type_history.proxy_user_id
sys_users.user_id
Restrict delete
FK_lxmo578rqafhent5ng933brg8
program_workflow_type_history.user_id
sys_users.user_id
Restrict delete
FK_9htg2o1x8iasgep9ux22wxixj
program_workflow_type_history.workflow_type_id
program_workflow_type.id
Restrict delete
FK_hl813fpda46detm96hy4cw9t4
feed_encryption_key.feed_export_id
feed_export.id
Restrict delete
FKC983815FD8C28DAF
notification_group_user.group_email_id
notification_group_email.id
Restrict delete
FKC983815F28C762A3
notification_group_user.user_id
sys_users.user_id
Restrict delete
FK52DE8658BD960DE9
projectlist_filter_fields.custom_id
projectlist_custom.id
Restrict delete
FK52DE865871369034
projectlist_filter_fields.field_id
project_field.id
Restrict delete
FKAA3EC8E1FE2B983
project_message.project_id
project.id
Restrict delete
FK_project_messge_site
project_message.site_id
site.id
Restrict delete
FKAA3EC8E19E84C785
project_message.message_id
message.id
Restrict delete
FKAA3EC8E1801340C3
project_message.notification_id
notification.id
Restrict delete
fk_fav_wiki_page_id
user_favorite.wiki_page_id
wiki_page.id
Restrict delete
fk_fav_user_id
user_favorite.user_id
sys_users.user_id
Restrict delete
FK406CC36547BEFA5E
scheduled_notification_attachment.notification_id
notification_scheduled.id
Restrict delete
FK_8d9o4xvhashai2g3tad53mwus
punch_list_item_history.item_id
punch_list_item.id
Restrict delete
FK_41da01jis0i8wpyxlkwiwjpfp
punch_list_item_history.user_id
sys_users.user_id
Restrict delete
FK_m8ls0xyo42a6wjfp8mvrko72p
punch_list_item_history.proxy_user_id
sys_users.user_id
Restrict delete
FK_smqpikec6m62sx16l491kuvlq
action_trigger_log.proxy_user_id
sys_users.user_id
Restrict delete
FK_k3ah5v112nc8vh7wsxgkdwtq5
action_trigger_log.user_id
sys_users.user_id
Restrict delete
FK5D8D5A591EE1B683
notification_scheduled.complete_on_send_id
milestone_tasks.task_id
Restrict delete
FK_ctg40om1eemknmfvieoe4quc9
notification_scheduled.footer_id
notification_template.id
Restrict delete
FK_6ehdtpn8lajfu5bgssnpxu1o3
notification_scheduled.header_id
notification_template.id
Restrict delete
FK5B9741D428C762A3
sys_company_users.user_id
sys_users.user_id
Restrict delete
FK5B9741D416D99B31
sys_company_users.company_id
sys_companies.company_id
Restrict delete
FKA92ADDF167DEC566
process_library_record_consulted.record_id
process_library_record.id
Restrict delete
FKA92ADDF1839C9EC3
process_library_record_consulted.role_id
sys_roles.role_id
Restrict delete
FKF0375FBABD960DE9
projectlist_display.custom_id
projectlist_custom.id
Restrict delete
FKF0375FBA71369034
projectlist_display.field_id
project_field.id
Restrict delete
FK1F80E3E569BC731
milestone_action.milestone_task_id
milestone_tasks.task_id
Restrict delete
FK_17vlf0i8pm8wrfyvhuvtxge73
asset_type_file.asset_type_id
asset_type.id
Restrict delete
FK_project_field_pending_change_site
project_field_pending_change_request.site_id
site.id
Restrict delete
FK_project_field_pending_change_project
project_field_pending_change_request.project_id
project.id
Restrict delete
FK_project_field_pending_change_field
project_field_pending_change_request.field_id
project_field.id
Restrict delete
FK_project_field_pending_change_requestor
project_field_pending_change_request.requestor_id
sys_users.user_id
Restrict delete
FK_project_field_pending_change_subcategory
project_field_pending_change_request.subcategory_id
project_note_subcategory.id
Restrict delete
fk_sys_user_proxies_assigner_id
sys_user_proxies.assigner_id
sys_users.user_id
Restrict delete
FKF032F4AA1B485D2
sys_user_proxies.proxy_user_id
sys_users.user_id
Restrict delete
FKF032F4A28C762A3
sys_user_proxies.user_id
sys_users.user_id
Restrict delete
FK_vglog_site_visibility_group_id
visibility_group_log.site_visibility_group_id
site_visibility_group.id
Cascade on delete
FK_vglog_user_id
visibility_group_log.user_id
sys_users.user_id
Restrict delete
FK_vglog_project_visibility_group_id
visibility_group_log.project_visibility_group_id
project_visibility_group.id
Cascade on delete
FK_vglog_proxy_user_id
visibility_group_log.proxy_user_id
sys_users.user_id
Restrict delete
FK_d1n2dy2fq6y0udj5bnnvx8v1g
projectlist_group.user_id
sys_users.user_id
Restrict delete
FK_53gugjjxm7hxar0d3fysuu0xa
vendor_task_comment.proxy_user_id
sys_users.user_id
Restrict delete
FK_ov4ry1kdhtaebrudra9n1vpga
vendor_task_comment.user_id
sys_users.user_id
Restrict delete
FK_r3bcas8i5w9gwfmw6k953gdsv
vendor_task_comment.vendor_task_id
vendor_task.id
Restrict delete
FK_ssskysfqo2289kpj82xtm2eot
company_subcontractor.subcontractor_id
subcontractor.id
Restrict delete
FK_4m0n148qldxi5eqmoe45cr3i4
company_subcontractor.company_id
sys_companies.company_id
Restrict delete
FKC7FFE91E28C762A3
project_log.user_id
sys_users.user_id
Restrict delete
FKC7FFE91EFE2B983
project_log.project_id
project.id
Restrict delete
FKC7FFE91EA1B485D2
project_log.proxy_user_id
sys_users.user_id
Restrict delete
FKC7FFE91E92D2B99F
project_log.site_id
site.id
Restrict delete
proximity_ibfk_1
proximity.site_id
site.id
Restrict delete
FK_survey_request_survey_template_id
ivueit_survey_request.template_id
ivueit_survey_template.id
Restrict delete
FK_survey_request_site_id
ivueit_survey_request.site_id
site.id
Restrict delete
FK_survey_request_project_id
ivueit_survey_request.project_id
project.id
Restrict delete
FK_survey_request_requested_by_id
ivueit_survey_request.requested_by_id
sys_users.user_id
Restrict delete
FK_iq12tn5cnhqw5e9itguklpbn0
lookup_table_log.lookup_id
project_field_lookup_table.id
Restrict delete
FK_fc917yhypt9og0bf0r5cd11vh
lookup_table_log.user_id
sys_users.user_id
Restrict delete
FK_701fak7fvokprb2ih0l17pe7
lookup_table_log.proxy_user_id
sys_users.user_id
Restrict delete
FK_report_history_report
report_run_history.report_id
reports.report_id
Cascade on delete
FK_report_history_user
report_run_history.user_id
sys_users.user_id
Restrict delete
fk_project_expense_type_id
dealer_request.expense_type_id
project_expense_type.id
Restrict delete
fk_project_sd_group_id
dealer_request.project_group_id
project_sd_group.group_id
Restrict delete
FK_6vk6apfsdke1b4peshpm3vg92
dealer_request.site_id
site.id
Restrict delete
FK_e1oikmeet0wxn9pg0s2cjv8ui
dealer_request.status_id
dealer_request_status.id
Restrict delete
FK_804sqc0e59w6d31d30xc1cc1a
dealer_request.type_id
dealer_request_type.id
Restrict delete
fk_project_id
dealer_request.project_id
project.id
Restrict delete
fk_assigned_user_id
dealer_request.assigned_user_id
sys_users.user_id
Restrict delete
FK_n287624sgt1287ltwkry7k189
dealer_request.created_by_id
sys_users.user_id
Restrict delete
fk_site_transaction_type_id
dealer_request.transaction_type_id
site_transaction_type.id
Restrict delete
FK_sjp7m071bthllv1ev5ore64f1
dealer_request.last_update_by_id
sys_users.user_id
Restrict delete
FK_plg_category_round
plg_template_category.round_id
plg_round.id
Restrict delete
FK_plg_template_category_plg_template
plg_template_category.template_id
plg_template.id
Restrict delete
FK205BA21665383478
sys_users.token_created_by_user_id
sys_users.user_id
Restrict delete
FK205BA21651C65451
sys_users.contact_id
contact.contact_id
Restrict delete
FK205BA216AEBF15EE
sys_users.last_ip_id
sys_ip_addrs.ip_id
Restrict delete
FK205BA2165C9984F4
sys_users.sponsor_id
sys_users.user_id
Restrict delete
FK37FA6AE28DB3D838
project_file.folder_id
project_folder.id
Restrict delete
FKC7FFE91EFE2B9836
open_date_weekly_report_cr.site_id
project.site_id
Restrict delete
FK_4ygvyo4h37a4mv2jxwh20g7p3
target_area_document.candidate_id
target_area_candidate.id
Restrict delete
fk_exception_type
target_area_document.exception_type_id
target_area_exception_document_type.id
Restrict delete
fk_ta_doc_ta
target_area_document.target_area_id
target_area.id
Restrict delete
FK_1jdlxqxh7m9hinlj2pqdtmoe3
target_area_document.type_id
target_area_document_type.id
Restrict delete
FK_qehxlv74jodsx7lf7yw723v38
target_area_document.last_update_user_id
sys_users.user_id
Restrict delete
FK_r5lpqse06eo5tm60d9sn5ufrr
site_geocoding_data.site_id
site.id
Restrict delete
FK808F4F7801340C3
notification_attachment.notification_id
notification.id
Restrict delete
FKE031C90B92D2B99F
site_item.site_id
site.id
Restrict delete
FKE031C90B633BB4FE
site_item.site_item_subtype_id
site_item_subtype.id
Restrict delete
FKE031C90B6D9E1076
site_item.site_item_type_id
site_item_type.id
Restrict delete
FK7B91F7507D387CEC
reports_chart_value.report_id
reports.report_id
Restrict delete
FK_milestone_template_template
milestone_template_channel.template_id
milestone_templates.template_id
Restrict delete
FK_milestone_template_channel
milestone_template_channel.channel_code
site_channel.channel_code
Restrict delete
FK_c50o6sx7yq7waddcgojgahrcw
program_end_design.program_id
program.id
Restrict delete
FK_program_end_design_site_design
program_end_design.site_design_id
site_design.id
Restrict delete
fk_srs_rent_analysis_srs_report_id
srs_rent_analysis.srs_report_id
srs_report.id
Restrict delete
fk_srs_rent_analysis_project_file_id
srs_rent_analysis.project_file_id
project_file.id
Restrict delete
FKDB8A3043BAE22181
punch_list_item.sla_exception
punch_list_sla_exception_type.id
Restrict delete
FK_3xihx7o0b8djj2qoc12or1uy2
punch_list_item.marked_complete_by_id
sys_users.user_id
Restrict delete
FKDB8A30438A57A86
punch_list_item.vendor_id
sys_companies.company_id
Restrict delete
FKDB8A30433EC39B33
punch_list_item.sub_category_id
punch_list_sub_category.id
Restrict delete
FKDB8A3043198EEAFB
punch_list_item.asset_type_id
asset_type.id
Restrict delete
FK_punchlist_item_giude_item
punch_list_item.plg_item_id
project_plg_item.id
Restrict delete
FKDB8A304399B55D9E
punch_list_item.reason_code_id
punch_list_reason.id
Restrict delete
FK_nq8hwkavi57ea0gnyhlsg7fvk
punch_list_item.asset_category_id
asset_category.id
Restrict delete
FKDB8A3043FE2B983
punch_list_item.project_id
project.id
Restrict delete
FKDB8A30433E9054A2
punch_list_item.category_id
punch_list_category.id
Restrict delete
FK_mu931g7k25ys1f7aygieejqld
locale_contact.role_id
sys_roles.role_id
Restrict delete
FK_rk52n27cv5eo18ioajoabkpjg
locale_contact.org_id
site_org.org_id
Restrict delete
FK_3x0wkpic8xubn15m720htmmq
locale_contact.locale_id
locale.id
Restrict delete
FK_1s8g7146rxe9fmiguuj25hu8h
locale_contact.user_id
sys_users.user_id
Restrict delete
FK_bulk_val_job_line_job
bulk_validation_line.job_id
bulk_validation_job.id
Restrict delete
FK_asset_asset_schedule
asset.schedule_id
asset_schedule.id
Restrict delete
FK_asset_asset_type
asset.type_id
asset_type.id
Restrict delete
FK_thxhdci6kj1keylwun9fw479b
program_workflow_participant.workflow_id
program_workflow.id
Restrict delete
FK_su2pap5il1sqrd3xu3bqr44gk
program_workflow_participant.user_id
sys_users.user_id
Restrict delete
FK_jll0h8k70vvyma7wkjsoo7ubj
program_workflow_participant.company_email_id
company_email.id
Restrict delete
FK_h36kpkb5t3k9aynqeq339k8uo
program_workflow_participant.type_id
program_workflow_participant_type.id
Restrict delete
FK_pxic3r88936136qqla6s1kup4
program_workflow_participant.company_id
sys_companies.company_id
Restrict delete
FK_jt8fimjcbq7lbappcdtisroi8
survey_participation.company_type_id
sys_company_types.type_id
Restrict delete
FK_onj1i2q37uuj85tvnqrc08169
survey_participation.project_type_id
project_type.id
Restrict delete
FK_bpqieo5abb7ar306rmwk5f67j
survey_participation.role_id
sys_roles.role_id
Restrict delete
FK_2r20baccdb84hnx58fr812mdt
program_document_layout.program_id
program.id
Restrict delete
FK_igrpoqoqa4i1fh4emfgmh1vl9
program_document_layout.document_type_id
program_document_type.id
Restrict delete
FKA2AA99F0375E5FC
project_fixtures.type_id
fixture_types.id
Restrict delete
FKA2AA99F0FE2B983
project_fixtures.project_id
project.id
Restrict delete
FK5B459DFF28C762A3
sys_user_notes.user_id
sys_users.user_id
Restrict delete
FK_qdg1csppw8fek4tjfo8udiy1j
action_trigger_queue.user_id
sys_users.user_id
Restrict delete
FK_ij17xj4s598i7m96phmpke2sq
workflow_type_history.workflow_type_id
workflow_type.id
Restrict delete
FK_fxisf46jhcd5dxaotmp5v93ri
workflow_type_history.proxy_user_id
sys_users.user_id
Restrict delete
FK_5itt3jbleifdpbx4yseu28vlm
workflow_type_history.user_id
sys_users.user_id
Restrict delete
FK5D08B2C4CF2AFC39
workflow_log.actor_id
sys_users.user_id
Restrict delete
FK5D08B2C4ABF90BA7
workflow_log.workflow_id
workflow.id
Restrict delete
FK5D08B2C4A1B485D2
workflow_log.proxy_user_id
sys_users.user_id
Restrict delete
FK5D08B2C43B7237AE
workflow_log.owner_id
workflow_participant.id
Restrict delete
FK_7ao1gk2nqshmg6yoql8v8se84
workflow_log.owner_role_id
sys_roles.role_id
Restrict delete
FKC17E956BE6BD1E7A
asset_warranty.asset_id
asset.id
Restrict delete
FK_itgpxw183hn7bhhe2cpkjai7i
asset_warranty.installation_vendor_id
asset_manufacturer.id
Restrict delete
FK_4r7do0t017iubwalrpcuu4fq7
asset_warranty.warranty_status_id
warranty_status.id
Restrict delete
FK_8wc9p3scj2mgcc3302pd745wq
asset_warranty.warranty_vendor_id
asset_manufacturer.id
Restrict delete
FK_6bv90fggo5hnk059i3pxlndqg
asset_warranty.area_impacted_id
area_impacted.id
Restrict delete
FK_d1s957m27hnyn4ci40ac4rklj
asset_warranty.asset_refrigerant_id
asset_refrigerant.id
Restrict delete
FKC17E956B198EEAFB
asset_warranty.asset_type_id
asset_type.id
Restrict delete
FK_3ck5une1un4y3tyihwdtoe7i4
asset_warranty.warranty_manager_id
asset_warranty_manager.id
Restrict delete
FKC17E956B92D2B99F
asset_warranty.site_id
site.id
Restrict delete
FK_33k7o3rvqjgac5h6jwlgxhyp
asset_warranty.warranty_in_service_status_id
warranty_in_service.id
Restrict delete
FK_1q8evv8iwoi8bycnqoggk4qxi
asset_warranty.asset_manufacturer_id
asset_manufacturer.id
Restrict delete
FK_5k13dkf08w998wr90dadyw2h6
asset_warranty.vendor_product_code_id
vendor_product_code.id
Restrict delete
FKD4E3CED792D2B99F
site_support.site_id
site.id
Restrict delete
FKD4E3CED7839C9EC3
site_support.role_id
sys_roles.role_id
Restrict delete
FKD4E3CED728C762A3
site_support.user_id
sys_users.user_id
Restrict delete
FK_site_file_rendition_site_file
site_file_rendition.file_id
site_file.id
Cascade on delete
fk_visit_user_id
user_wiki_page_visit.user_id
sys_users.user_id
Restrict delete
fk_visit_page_id
user_wiki_page_visit.wiki_page_id
wiki_page.id
Restrict delete
FK6012EDF028C762A3
notification_log.user_id
sys_users.user_id
Restrict delete
FK6012EDF0A1B485D2
notification_log.proxy_user_id
sys_users.user_id
Restrict delete
FK1BA73D757D387CEC
feed_export.report_id
reports.report_id
Restrict delete
FK1BA73D7568603D9C
feed_export.list_id
projectlist_custom.id
Restrict delete
FK1BA73D7528C762A3
feed_export.user_id
sys_users.user_id
Restrict delete
FK_g94s8tvb9iii8osgfbe5lefs7
project_type_default_page.default_page_id
project_type.id
Restrict delete
FK_6hhbw2totlb8sd8iwoya672fq
project_type_default_page.project_page_id
project_page.id
Restrict delete
fk_manual_task_sys_user_assigned_idx
manual_task.assigned_user_id
sys_users.user_id
Restrict delete
fk_manual_task_sys_user_accountable_idx
manual_task.accountable_user_id
sys_users.user_id
Restrict delete
fk_manual_task_site_idx
manual_task.store_id
site.id
Restrict delete
fk_manual_task_project_list_idx
manual_task.project_list_id
projectlist_custom.id
Restrict delete
fk_manual_task_updated_by_idx
manual_task.last_update_by_id
sys_users.user_id
Restrict delete
fk_manual_task_project_idx
manual_task.project_id
project.id
Restrict delete
fk_manual_task_created_by_idx
manual_task.created_by_id
sys_users.user_id
Restrict delete
FK_project_sd_group_survey_template_id
project_sd_group.survey_template_id
ivueit_survey_template.id
Restrict delete
FK9B17F1A053B97183
asset_warranty_unit_protection.unit_protection_id
unit_protection.id
Restrict delete
FK9B17F1A04529720A
asset_warranty_unit_protection.warranty_id
asset_warranty.id
Restrict delete
FK_pfgcbp0rthgrvshw0xkbr3mil
site_temp_closure.status_id
temp_closure_status.id
Restrict delete
FK_rah6hfp1ceaq9two3soq6rqgl
site_temp_closure.site_id
site.id
Restrict delete
FK_gsp6th0enpejy9kkjwm7b56us
site_temp_closure.reason_id
temp_closure_reason.id
Restrict delete
FK_plg_program_template
program_plg.template_id
plg_template.id
Restrict delete
FK_plg_program_design
program_plg.design_id
site_design.id
Restrict delete
FK_plg_program_program
program_plg.program_id
program.id
Restrict delete
FKFE5A97CA43C65406
project_field_subgroup.group_id
project_field_group.id
Restrict delete
fk_drfi_folder_id
dealer_request_file.folder_id
dealer_request_folder.id
Restrict delete
FK2C648A928C762A3
project_support.user_id
sys_users.user_id
Restrict delete
FK2C648A9FE2B983
project_support.project_id
project.id
Restrict delete
FK2C648A9839C9EC3
project_support.role_id
sys_roles.role_id
Restrict delete
fk_powerbi_role
powerbi_entry_roles.role_id
sys_roles.role_id
Cascade on delete
fk_powerbi_entry
powerbi_entry_roles.powerbi_entry_id
powerbi_entry.id
Cascade on delete
FK_project_field_change_approver_user
project_field_change_approver.default_user_id
sys_users.user_id
Restrict delete
FK_project_field_change_approver_approval
project_field_change_approver.approval_id
project_field_change_approval.id
Restrict delete
FK_project_field_change_approver_role
project_field_change_approver.role_id
sys_roles.role_id
Restrict delete
FK_9jm491wa0asv8i9ol6wywq3b2
notification_template.updated_by_id
sys_users.user_id
Restrict delete
FK_1h5yj7tft18qlxff1s3wxs2vx
notification_template.created_by_id
sys_users.user_id
Restrict delete
FKB611629D9D4315A0
dashboard_widget_param.widget_id
dashboard_widget.id
Restrict delete
FK132FA766F4FBE4FC
punch_list_action.trigger_id
punch_list_action_trigger.id
Restrict delete
fk_srs_program_settings_project_group_id
srs_program_settings.project_group_id
project_sd_group.group_id
Restrict delete
FK27FF66B265D3A52E
project_form_layout_cell_property.cell_id
project_form_layout_cell.id
Restrict delete
FK_lgxc68rnwpv824qkg57pbimbr
program_message.program_id
program.id
Restrict delete
FK_4ywam7tu26bkd98tcxs7y6hlf
program_message.message_id
message.id
Restrict delete
FK_6wniwfjpewmvourdrllhvldby
program_message.notification_id
notification.id
Restrict delete
FK27978646A1B485D2
sys_activity_log.proxy_user_id
sys_users.user_id
Restrict delete
FK_jb07xi2c80h4vjkmi2igexp9b
program_milestone_note.user_id
sys_users.user_id
Restrict delete
FK_h1s4pi3nrj9khds2rlu3bhjt1
program_milestone_note.proxy_user_id
sys_users.user_id
Restrict delete
FK_m9xd67rojug8txtoh7ke4furi
program_milestone_note.milestone_id
program_milestone.id
Restrict delete
FKB971272C9D32BD2D
intake.request_type_id
intake_request_type.request_type_id
Restrict delete
FKB971272C99605DC0
intake.assigned_id
sys_users.user_id
Restrict delete
FKB971272C5D9C9F0B
intake.root_cause_id
intake_cause.cause_id
Restrict delete
FKB971272C1ADBBF86
intake.priority_id
intake_priority.priority_id
Restrict delete
fk_intake_workstream
intake.workstream_id
intake_workstream.id
Restrict delete
FKB971272CD86B17C6
intake.status_id
intake_status.status_id
Restrict delete
FKB971272C62D97231
intake.system_affected_id
intake_system.system_id
Restrict delete
FK_2i5nyx5396ma3p3gq3rp9i8h3
intake.assigned_role_id
sys_roles.role_id
Restrict delete
FKDAC14C1867DEC566
process_library_user_permits.record_id
process_library_record.id
Restrict delete
FKDAC14C1828C762A3
process_library_user_permits.user_id
sys_users.user_id
Restrict delete
FK6F7CCC0BE98DF3E0
site_channel.template_id
milestone_templates.template_id
Restrict delete
FK_2xmtlbxrkb7apfsj2r66a2f5w
program_action.trigger_id
program_action_trigger.id
Restrict delete
FKF468F61AE77AE998
sitepack_site_response.response_id
sitepack_response.id
Restrict delete
FKF468F61A5814C167
sitepack_site_response.site_pack_id
sitepack.id
Restrict delete
FK_1vqanfqlxucybv9714neuv3is
sys_companies.secondary_id
sys_users.user_id
Restrict delete
FKFD9A3EE967CE5F60
sys_companies.principal_id
sys_users.user_id
Restrict delete
FKFD9A3EE973874CAE
sys_companies.type_id
sys_company_types.type_id
Restrict delete
FK_kik7opfv991d3bl99cl2c8usd
sys_companies.contract_holder_id
site_contract_holder.contract_holder_id
Restrict delete
FK314AF9FE7D387CEC
reports_variable_default.report_id
reports.report_id
Restrict delete
FKAC1DE5DC839C9EC3
process_library_record_responsible.role_id
sys_roles.role_id
Restrict delete
FKAC1DE5DC67DEC566
process_library_record_responsible.record_id
process_library_record.id
Restrict delete
FK_eauuikvg13axl13upd9aq8em9
program.year_id
project_program_year.id
Restrict delete
FK_3e48e26m2gno1rdgnndnbvoy0
program.type_id
project_sd_group.group_id
Restrict delete
FK_n9jmarp1n8tq1g959gd55knxo
program.manager_id
sys_users.user_id
Restrict delete
FK_e0hbc9fvamd89q4ll6aoke43s
program.status_id
program_status.id
Restrict delete
FK_3g55e7kmn4wpntgyvxaevtoyq
program.list_id
projectlist_custom.id
Restrict delete
FK_project_field_pending_change_approver_field_approval
project_field_pending_change_approver.project_field_approver_id
project_field_change_approver.id
Restrict delete
FK_project_field_pending_change_approver_approval
project_field_pending_change_approver.change_id
project_field_pending_change_request.id
Restrict delete
FK_project_field_pending_change_approver_user
project_field_pending_change_approver.approver_id
sys_users.user_id
Restrict delete
FK_project_field_pending_change_approver_role
project_field_pending_change_approver.role_id
sys_roles.role_id
Restrict delete
FK_project_plg_signature_role
project_plg_signature.role_id
sys_roles.role_id
Restrict delete
FK_project_plg_signature_user
project_plg_signature.user_id
sys_users.user_id
Restrict delete
FK_project_plg_signature_image
project_plg_signature.image_id
project_file.id
Restrict delete
FK_project_plg_signature_signature
project_plg_signature.signature_id
project_plg_required_signature.id
Restrict delete
FX_project_plg_signature_contact
project_plg_signature.contact_id
contact.contact_id
Restrict delete
FK7B5B7E464529720A
asset_warranty_note.warranty_id
asset_warranty.id
Restrict delete
FK7B5B7E4628C762A3
asset_warranty_note.user_id
sys_users.user_id
Restrict delete
FK_project_plg_req_sig_sig
project_plg_required_signature.signature_id
plg_signature.id
Restrict delete
FK_project_plg_req_sig_plg
project_plg_required_signature.plg_id
project_plg.id
Restrict delete
FK_project_plg_req_sig_round
project_plg_required_signature.round_id
project_plg_round.id
Restrict delete
FK18015018DC70672A
feed_schedule.export_id
feed_export.id
Restrict delete
FK18015018BD0D958A
feed_schedule.import_id
feed_import.id
Restrict delete
FK235FD054FE2B983
project_folder.project_id
project.id
Restrict delete
FK235FD054E9A9B27C
project_folder.parent_id
project_folder.id
Restrict delete
FK1A4C35A428C762A3
sys_user_values.user_id
sys_users.user_id
Cascade on delete
wiki_page_parent_id
wiki_page.parent_id
wiki_page.id
Restrict delete
FK_tl5hgo8xu862p2hoxrdafquim
sys_roles.role_type_id
sys_role_type.id
Restrict delete
FK_pnhc1jj16a48cn72yr2pnunbr
program_log.program_id
program.id
Restrict delete
FK_1yrrxwie3f2ll8sekhjiq9r8i
program_log.user_id
sys_users.user_id
Restrict delete
FK_s7i7bf30hqs2tj7varkf1xfc6
program_log.proxy_user_id
sys_users.user_id
Restrict delete
FK_8wb6bp7s880a7ooyqk99ccvw3
notification_data_classification.notification_id
notification.id
Restrict delete
FK_8l124ygkl1r4xoqjp0ndp8lo6
notification_data_classification.data_classification_id
project_field_data_classification.id
Restrict delete
FK_target_area_document_type_sitepack
target_area_document_type.sitepack_file_type_id
sitepack_file.id
Restrict delete
FK10ED10A2839C9EC3
process_library_record_informed.role_id
sys_roles.role_id
Restrict delete
FK10ED10A267DEC566
process_library_record_informed.record_id
process_library_record.id
Restrict delete
FKF6AE89F7A1B485D2
sys_security_log.proxy_user_id
sys_users.user_id
Restrict delete
FK_mgexfecmpun44enma9pd43pu1
sys_security_log.current_user_id
sys_users.user_id
Restrict delete
FK_b1lqgyltw9323dd99qab3sk1a
target_area_demographic.id
target_area.id
Restrict delete
FK_pu0i08qc6t8bl3i3p2hk7k7jr
program_milestone_type.responsible_role_id
sys_roles.role_id
Restrict delete
FK_aipncr8pihfshvltcrcmt5g8n
program_milestone_type.dependency_id
program_milestone_type.id
Restrict delete
FK_rxnamks19ah04kkj79hxqn1hr
program_milestone_type.section_id
program_milestone_section.id
Restrict delete
FK_photos_action_trigger
photo_action.trigger_id
photo_action_trigger.id
Restrict delete
FK_prj_plg_sig_role_signature
project_plg_signature_role.signature_id
project_plg_required_signature.id
Restrict delete
FK_prj_plg_sig_role_role
project_plg_signature_role.role_id
sys_roles.role_id
Restrict delete
FKC651A731839C9EC3
scheduled_notification_owner.role_id
sys_roles.role_id
Restrict delete
FKC651A73147BEFA5E
scheduled_notification_owner.notification_id
notification_scheduled.id
Restrict delete
FKABC4A8E9ACD3C926
process_library_record_site_brand.site_brand_id
site_brand.id
Restrict delete
FKABC4A8E967DEC566
process_library_record_site_brand.record_id
process_library_record.id
Restrict delete
FK7EF1B329EDE37D51
asset_type.warranty_manager_id
asset_warranty_manager.id
Restrict delete
FK7EF1B3298A57A86
asset_type.vendor_id
sys_companies.company_id
Restrict delete
FK7EF1B329A980DACA
asset_type.category_id
asset_category.id
Restrict delete
FK_asset_type_company_type
asset_type.company_type_id
sys_company_types.type_id
Restrict delete
FK_idn65a84bh2xkulh8glvqlvni
sys_alert.created_by_user_id
sys_users.user_id
Restrict delete
FK_1coo2tnsi3751ojc76c7ggi1
sys_alert.message_id
message.id
Restrict delete
FK5B8C0C45839C9EC3
sys_company_types.role_id
sys_roles.role_id
Restrict delete
fk_intake_consult_ticket
intake_consultation.ticket_id
intake.id
Restrict delete
fk_intake_consult_user
intake_consultation.user_id
sys_users.user_id
Restrict delete
FK_project_support_auto_program
project_support_auto.program_id
project_sd_group.group_id
Restrict delete
FK_project_support_auto_user
project_support_auto.user_id
sys_users.user_id
Restrict delete
FK_project_support_auto
project_support_auto.role_id
sys_roles.role_id
Restrict delete
FK_project_support_auto_project_type
project_support_auto.project_type_id
project_type.id
Restrict delete
fk_srs_lease_renewal_srs_report_id
srs_lease_renewal.srs_report_id
srs_report.id
Restrict delete
FK9581CC6692D2B99F
site_folder.site_id
site.id
Restrict delete
FK9581CC6630A7A0F2
site_folder.parent_id
site_folder.id
Restrict delete
FK_kcymmeo48e81utf648p0xyfre
warranty_log.proxy_user_id
sys_users.user_id
Restrict delete
FK_31snucjrlpnp5ajdtk97vrj88
warranty_log.type_id
asset_type.id
Restrict delete
FK_dx6xb8auqdcnx3x4h3e4td8bs
warranty_log.site_id
site.id
Restrict delete
FK_6n92j8m4nreo47fj2m10u69cs
warranty_log.warranty_id
asset_warranty.id
Restrict delete
FK_e2r7igtp6lkwl92pf38sd19k8
warranty_log.user_id
sys_users.user_id
Restrict delete
FK3CDFA00B9C0630F6
milestone_task_project_type.project_type_id
project_type.id
Restrict delete
FK3CDFA00B270BB200
milestone_task_project_type.detail_id
milestone_task_detail.id
Restrict delete
FK_98y2nj9ap0b7ydf9aaigt56k9
program_workflow_participant_history.workflow_id
program_workflow.id
Restrict delete
FK_1x00qjf60alcfyegwhf6adkj2
program_workflow_participant_history.proxy_user_id
sys_users.user_id
Restrict delete
FK_75ds9xcr7w00pt5d3filw04cj
program_workflow_participant_history.user_id
sys_users.user_id
Restrict delete
FK_er5yt4j2qn6h35q2bh846vv45
sitepack.reason_id
sitepack_reason.id
Restrict delete
FK_s5a38e9v13xqhw0t19pw9d0ys
sitepack.lease_renewal_term_id
lease_renewal_term.id
Restrict delete
FK284B45E015D60CD3
sitepack.builder_id
sys_users.user_id
Restrict delete
FK_gqe01ubtu5ix467ackmb37nwb
sitepack.srs_report_id
srs_report.id
Restrict delete
FK284B45E0A407C255
sitepack.builder_company_id
sys_companies.company_id
Restrict delete
FK284B45E0BC365699
sitepack.sitepack_type_id
sitepack_type.id
Restrict delete
FK284B45E0514006DF
sitepack.approval_type_id
sitepack_approval_type.id
Restrict delete
FK284B45E0D72362B0
sitepack.attorney_id
sys_users.user_id
Restrict delete
FK284B45E0FE2B983
sitepack.project_id
project.id
Restrict delete
FK284B45E0EF708433
sitepack.law_firm_id
sys_companies.company_id
Restrict delete
FK284B45E0D18E4778
sitepack.status_id
sitepack_status.id
Restrict delete
FK_4bgp7por47y9v8ea4ancyfchq
vendor_task_history.user_id
sys_users.user_id
Restrict delete
FK_orou2mp2xrrltwxqcce69klo3
vendor_task_history.proxy_user_id
sys_users.user_id
Restrict delete
FK_chf0w1cvdxmk4r7l9xhfinkhu
vendor_task_history.vendor_task_id
vendor_task.id
Restrict delete
FK79905FFCFD6A367A
milestone_task_detail.responsible_role_id
sys_roles.role_id
Restrict delete
FK79905FFCF0C07700
milestone_task_detail.task_id
milestone_tasks.task_id
Restrict delete
FK_6eiey6tcjifyim5isukm4kutg
milestone_task_detail.dependency_id
milestone_tasks.task_id
Restrict delete
FK79905FFCABE08F8B
milestone_task_detail.accountable_role_id
sys_roles.role_id
Restrict delete
FK_plg_round_email
plg_round.email_template_id
email_template.id
Restrict delete
FK_project_plg_item_category
project_plg_item.category_id
project_plg_category.id
Restrict delete
FK_project_plg_item_project_plg
project_plg_item.plg_id
project_plg.id
Restrict delete
FK_project_plg_item_completed_by
project_plg_item.completed_by
sys_users.user_id
Restrict delete
FK_project_plg_item_plg_asset
project_plg_item.plg_asset_id
plg_asset_type.id
Restrict delete
FK_project_plg_item_asset
project_plg_item.asset_id
asset_type.id
Restrict delete
FK_project_plg_item_plg_status
project_plg_item.status_id
plg_item_status.id
Restrict delete
FK2843C1ECCFE5C0AF
site_org.parent_id
site_org.org_id
Restrict delete
fk_dealer_request_clarification_last_updated_by
dealer_request_clarification.last_updated_by_id
sys_users.user_id
Restrict delete
fk_dealer_request_clarification_dealer_request
dealer_request_clarification.dealer_request_id
dealer_request.id
Restrict delete
fk_dealer_request_clarification_created_by
dealer_request_clarification.created_by_id
sys_users.user_id
Restrict delete
FK_2oki99le54sh0b5nmkd9ekm6l
program_milestone_action.milestone_type_id
program_milestone_type.id
Restrict delete
FK_project_plg_recipient_user
project_plg_recipient.user_id
sys_users.user_id
Restrict delete
FK_project_plg_recipient_contact
project_plg_recipient.contact_id
contact.contact_id
Restrict delete
FK_project_plg_recipient_role
project_plg_recipient.role_id
sys_roles.role_id
Restrict delete
FK_project_plg_recipient_project_plg
project_plg_recipient.plg_id
project_plg.id
Restrict delete
FK_project_plg_recipient_round
project_plg_recipient.round_id
project_plg_round.id
Restrict delete
FK_cs1ohekyphrvivg16uyg7hon7
program_support.user_id
sys_users.user_id
Restrict delete
FK_gu4kci1k79e7opwmovrb1uhpr
program_support.role_id
sys_roles.role_id
Restrict delete
FK_42qfyd1rka0harvr565kcfwk5
program_support.program_id
program.id
Restrict delete
fk_drf_parent_id
dealer_request_folder.parent_id
dealer_request_folder.id
Restrict delete
fk_drf_dealer_request_id
dealer_request_folder.dealer_request_id
dealer_request.id
Restrict delete
FK417F4E5A9C0630F6
process_library_record_project_type.project_type_id
project_type.id
Restrict delete
FKB998427A67DEC566
process_library_record_project_type.record_id
process_library_record.id
Restrict delete
FK417F4E5A67DEC566
process_library_record_project_type.record_id
process_library_record.id
Restrict delete
FKB998427A9C0630F6
process_library_record_project_type.project_type_id
project_type.id
Restrict delete
FK35F87BEB28C762A3
punch_list_item_recipients_role_user.user_id
sys_users.user_id
Restrict delete
FK35F87BEB49913482
punch_list_item_recipients_role_user.item_id
punch_list_item.id
Restrict delete
FK_punchlist_recipient_contact
punch_list_item_recipients_role_user.contact_id
contact.contact_id
Restrict delete
FK_qwfkkw1k7b0vwd4kyunwd13nx
srs_snapshot.srs_report_id
srs_report.id
Restrict delete
FK_bu8x0jcb9h5wm6fplt8o4jnk7
srs_snapshot.created_by_id
sys_users.user_id
Restrict delete
FK_n11xfyou23jsxbf80d16jxlyt
site_file.doc_type_id
site_document_type.id
Restrict delete
FK_i26ess8cryx0ii6dyvju3dj8q
site_file.project_id
project.id
Restrict delete
FK_dn5oc32uovgkoaq0bghjdfyj0
site_file.uploader_id
sys_users.user_id
Restrict delete
FK_llyrsutfqcac85qnwmc99phh4
site_file.frequency_id
site_file_frequency.id
Restrict delete
FKE0304374D4B1C6AE
site_file.folder_id
site_folder.id
Restrict delete
FK_j1ne6x668vgh8py3yy7t3753h
site_file.project_manager_id
sys_users.user_id
Restrict delete
FK_tb1an0gc6vjyfs497g7w6cdi3
site_file.jurisdiction_id
site_file_jurisdiction.id
Restrict delete
FK_gl3q64eqs0ikwep7s0y53atyb
site_file.retained_by_id
site_file_retained_by.id
Restrict delete
FK7E3A6FF067DEC566
process_library_log.record_id
process_library_record.id
Restrict delete
FK7E3A6FF028C762A3
process_library_log.user_id
sys_users.user_id
Restrict delete
FK7E3A6FF0A1B485D2
process_library_log.proxy_user_id
sys_users.user_id
Restrict delete
fk_dealer_request_lease_created_by
dealer_request_lease.created_by_id
sys_users.user_id
Restrict delete
fk_dealer_request_lease_dealer_request
dealer_request_lease.dealer_request_id
dealer_request.id
Restrict delete
fk_recent_view_user_id
recent_view.user_id
sys_users.user_id
Restrict delete
closest_competitor_ibfk_1
closest_competitor.site_id
site.id
Restrict delete
FK7A002706658AD94A
asset_schedule.template_id
asset_template.id
Restrict delete
FK7A00270692D2B99F
asset_schedule.site_id
site.id
Restrict delete
FK_nhmr5qxap224rq93lyfyf7rxj
program_asset_categories.program_id
program.id
Restrict delete
FK_d6eh30pt2fd7ddmqpkjjmkhgw
program_asset_categories.asset_category_id
asset_category.id
Restrict delete
FK5C1850257952D7EE
process_library_record.title_id
process_library_title.id
Restrict delete
FK_hsyw53vo3dkg5r0my1l1h8n1y
target_area.broker_id
broker.id
Restrict delete
FK_nrpe412lpax38nefyvjmx44k3
project_field.edit_permit_id
sys_permits.permit_id
Restrict delete
FKC752D854839C9EC3
project_field.role_id
sys_roles.role_id
Restrict delete
FK_oi3sxjagndac5rembcl5sx084
project_field.read_permit_id
sys_permits.permit_id
Restrict delete
FKC752D854198EEAFB
project_field.asset_type_id
asset_type.id
Restrict delete
FK_4qypmqu5v1ocmk3mfr51pqlvb
project_field.data_classification_id
project_field_data_classification.id
Restrict delete
FKC752D85490CCAF0E
project_field.subgroup_id
project_field_subgroup.id
Restrict delete
FK_oypgab26ouas92mg39ivfa7lm
project_field.iterative_note_category_id
iterative_note_category.id
Restrict delete
FKC752D8546D9E1076
project_field.site_item_type_id
site_item_type.id
Restrict delete
FKC752D854F0C07700
project_field.task_id
milestone_tasks.task_id
Restrict delete
FK_lsu7rp6b8jnxhcqu0jobbae3q
program_milestone_section.phase_id
program_milestone_phase.id
Restrict delete
FK503B5F0928C762A3
contract_holder_support.user_id
sys_users.user_id
Restrict delete
FK503B5F096284F41D
contract_holder_support.contract_holder_id
site_contract_holder.contract_holder_id
Restrict delete
FK503B5F09839C9EC3
contract_holder_support.role_id
sys_roles.role_id
Restrict delete
FKC4A38579FED870A0
projectlist_custom.sort1_field_id
project_field.id
Restrict delete
FKC4A38579E76B52DE
projectlist_custom.sort3_field_id
project_field.id
Restrict delete
FKC4A38579DBB4C3FD
projectlist_custom.sort4_field_id
project_field.id
Restrict delete
fk_project_list_parent
projectlist_custom.parent_id
projectlist_custom.id
Restrict delete
fk_project_list_link_field
projectlist_custom.link_field_id
project_field.id
Restrict delete
FKC4A38579CFFE351C
projectlist_custom.sort5_field_id
project_field.id
Restrict delete
FKC4A3857928C762A3
projectlist_custom.user_id
sys_users.user_id
Restrict delete
FKC4A38579F321E1BF
projectlist_custom.sort2_field_id
project_field.id
Restrict delete
FKC4A38579C6C48FCB
projectlist_custom.group_by
project_field.id
Restrict delete
FK_nrd12sfsld2rb46houau3qfvi
projectlist_custom.list_group_id
projectlist_group.id
Restrict delete
FK553305B1839C9EC3
sys_role_users.role_id
sys_roles.role_id
Restrict delete
FK553305B128C762A3
sys_role_users.user_id
sys_users.user_id
Cascade on delete
FK_qi1i2gaygqilbnbv5a6grd81b
vendor_survey_project_type.project_type_id
project_type.id
Restrict delete
FK_4811q4mr3e9800svoej5161d5
vendor_survey_project_type.vendor_survey_project_types_id
vendor_survey.id
Restrict delete
FK_gasdkt7mql4ca7c13i3gtyq7l
program_workflow.published_file_id
program_file.id
Restrict delete
FK_qyngqr9lfx0avxpcets7l1add
program_workflow.current_id
program_workflow_log.id
Restrict delete
FK_1ufc40kbcsjgayxmf6ywfmpgn
program_workflow.program_id
program.id
Restrict delete
FK_rn2em56rgem4gubwcihfnqyva
program_workflow.type_id
program_workflow_type.id
Restrict delete
FK_nup_user_id
notification_user_preference.user_id
sys_users.user_id
Cascade on delete
FK_nup_last_received_message_id
notification_user_preference.last_received_message_id
message.id
Null on delete
fk_manual_task_log_task_idx
manual_task_log.task_id
manual_task.id
Restrict delete
fk_manual_task_log_user_idx
manual_task_log.user_id
sys_users.user_id
Restrict delete
fk_manual_task_log_proxy_user_idx
manual_task_log.proxy_user_id
sys_users.user_id
Restrict delete
FK67B16265198EEAFB
asset_action.asset_type_id
asset_type.id
Restrict delete
FK_cgrc9je8uifh5ge9u15pkv45q
program_company_contact.program_id
program.id
Restrict delete
FK_fi96eoba65e36aq7qrmdf882w
program_company_contact.company_email_id
company_email.id
Restrict delete
FK_55e0cju3q0li25we2oigckine
program_company_contact.company_id
sys_companies.company_id
Restrict delete
FK_fkdl5pmtlwknr5ndyd7vhtvy0
program_company_contact.user_id
sys_users.user_id
Restrict delete
fk_permit_usage_log_user_id
permit_usage_log.user_id
sys_users.user_id
Cascade on delete
FX_projectlist_export_projectlist
projectlist_export.draft_list_id
projectlist_custom.id
Restrict delete
FK_96rjsluq2dm8bjiy9awnlnt5c
projectlist_export.project_list_id
projectlist_custom.id
Null on delete
FK_1mqriro6em5okync3a0uivo90
projectlist_export.user_id
sys_users.user_id
Restrict delete
fk_form_group_subgroup
project_form_group.subgroup_id
project_field_subgroup.id
Restrict delete
fk_form_group_section
project_form_group.section_id
project_form_section.id
Restrict delete
FK_iy0fupbnl0mt5brhiee8fltxl
subcontractor_user.subcontractor_id
subcontractor.id
Restrict delete
FK_id3pxl21lxnbwmtuq3odt5uii
subcontractor_user.user_id
sys_users.user_id
Restrict delete
FK_project_plg_category_round
project_plg_category.round_id
project_plg_round.id
Restrict delete
FK_project_plg_category_project_plg
project_plg_category.plg_id
project_plg.id
Restrict delete
FK_2wv5s8edptkly0yp0qjqc22wj
milestone_template_log.user_id
sys_users.user_id
Restrict delete
FK_pfq0irt0qqqmk15owbx907htb
milestone_template_log.template_id
milestone_templates.template_id
Restrict delete
FK_nbmi0qpdm0iia559ex0xonvfh
milestone_template_log.proxy_user_id
sys_users.user_id
Restrict delete
FK_bwdbyp9hrckfa2wdfmxi7bi33
program_project_type.project_type_id
project_type.id
Restrict delete
FK_go3f9alibru05hjggy7cxf7ng
program_project_type.program_project_types_id
program.id
Restrict delete
FK96B423FF2AA21A74
milestone_tasks.section_id
milestone_sections.section_id
Restrict delete
FK47260146839C9EC3
workflow_participant_type.role_id
sys_roles.role_id
Restrict delete
FK_pttcs4ccgxc8l0014t1cp2jay
workflow_participant_type.default_user_id
sys_users.user_id
Restrict delete
FK47260146A09B2901
workflow_participant_type.workflow_id
workflow_type.id
Restrict delete
FKA2D7E350880BCBC9
sys_monitor_events.session_id
sys_monitor_sessions.id
Cascade on delete
FKAA0AECFA51C65451
project_contact.contact_id
contact.contact_id
Restrict delete
FKAA0AECFA839C9EC3
project_contact.role_id
sys_roles.role_id
Restrict delete
FKAA0AECFAFE2B983
project_contact.project_id
project.id
Restrict delete
fk_page_audience_page_id
wiki_page_audience.wiki_page_id
wiki_page.id
Restrict delete
fk_page_audience_audience_id
wiki_page_audience.wiki_audience_id
wiki_audience.id
Restrict delete
fk_dr_note_last_updated_by
dealer_request_note.last_updated_by_id
sys_users.user_id
Restrict delete
fk_dr_note_dealer_request
dealer_request_note.dealer_request_id
dealer_request.id
Restrict delete
fk_dr_note_created_by
dealer_request_note.created_by_id
sys_users.user_id
Restrict delete
FK6B2015EB82389340
project_form_action.form_id
project_form.id
Restrict delete
FK_6km105la331glgcuheq2otbyl
sys_user_password_history.user_id
sys_users.user_id
Restrict delete
FKA73D425F94ACA766
notification_owner.owner_id
sys_roles.role_id
Restrict delete
FKA73D425F801340C3
notification_owner.notification_id
notification.id
Restrict delete
FK_plg_asset_file_plg_asset
plg_asset_file.plg_asset_id
plg_asset_type.id
Restrict delete
demographic_ibfk_1
demographic.site_id
site.id
Restrict delete
FKB87D7EB316D99B31
workflow_participant.company_id
sys_companies.company_id
Restrict delete
FKB87D7EB3692FF708
workflow_participant.company_email_id
company_email.id
Restrict delete
FKB87D7EB3711961A1
workflow_participant.type_id
workflow_participant_type.id
Restrict delete
FKB87D7EB3ABF90BA7
workflow_participant.workflow_id
workflow.id
Restrict delete
FKB87D7EB328C762A3
workflow_participant.user_id
sys_users.user_id
Restrict delete
FKB4DA3121FF458797
sys_role_permits.permit_id
sys_permits.permit_id
Restrict delete
FKB4DA3121839C9EC3
sys_role_permits.role_id
sys_roles.role_id
Restrict delete
FK_project_plg_round_plg
project_plg_round.plg_id
project_plg.id
Restrict delete
FK_project_plg_round_round
project_plg_round.plg_round_id
plg_round.id
Restrict delete
FK_project_plg_round_pdf
project_plg_round.pdf_file_id
project_file.id
Restrict delete
FK9573F93E229B9538
sitepack_security_answer.security_id
sitepack_security.id
Restrict delete
FK9573F93E9CD5C8D8
sitepack_security_answer.question_id
sitepack_security_question.id
Restrict delete
FK584D4846526084A8
sys_permits.parent_id
sys_permits.permit_id
Restrict delete
FK_92nc41r3ygkv94p1byy2ugxe5
temp_closure_action.trigger_id
temp_closure_action_trigger.id
Restrict delete
FKEA9683D152324586
punch_list_item_recipients_company_email.email_id
company_email.id
Restrict delete
FKEA9683D149913482
punch_list_item_recipients_company_email.item_id
punch_list_item.id
Restrict delete
FK12F48E67D9993B00
notification_user_message.notification_group_id
notification_group_email.id
Restrict delete
FK12F48E679E84C785
notification_user_message.message_id
message.id
Restrict delete
FK12F48E6728C762A3
notification_user_message.user_id
sys_users.user_id
Restrict delete
FK_2nxvx0pkde0ut7gowyqw0c31r
notification_user_message.system_alert_id
sys_alert.id
Restrict delete
FK946F7D82B104746
process_library_record_category.category_id
process_library_category.id
Restrict delete
FK946F7D867DEC566
process_library_record_category.record_id
process_library_record.id
Restrict delete
FK_n24daevdemv8xenlwxfhijiu3
survey_response.respondent_role_id
sys_roles.role_id
Restrict delete
FK_7gqks7ck92wbbkr9vn0im46c4
survey_response.question_id
survey_question.id
Restrict delete
FK_21y6p4me43e8qeguo8o7fljv9
survey_response.project_id
project.id
Restrict delete
FK_fp5mvl50ttg02gxfkvmyxi17g
survey_response.company_type_id
sys_company_types.type_id
Restrict delete
FK_krba9o9mplas321hyf6da29u4
survey_response.respondent_id
sys_users.user_id
Restrict delete
FK_8luu5bocb6h1xvxm6uxh1axar
program_workflow_type.document_type_id
program_document_type.id
Restrict delete
FK_kcgosi7hupastpro89k58ovjg
file_extract_job.user_id
sys_users.user_id
Restrict delete
FK228AD1B828C762A3
legal_note.user_id
sys_users.user_id
Restrict delete
FK228AD1B83494DAE3
legal_note.legal_id
legal.id
Restrict delete
FK_g4l61gdmbq4tf9oq9r9c9igo0
srs_report.hero_image_id
project_file.id
Restrict delete
FK_m1xwes4got6cocoo4v4v1iti9
srs_report.created_by_id
sys_users.user_id
Restrict delete
fk_executive_summary
srs_report.executive_summary_id
srs_executive_summary.id
Restrict delete
FK_qg9vau940gidw6u0fpa7qywgj
srs_report.project_id
project.id
Restrict delete
FK_q3hm3gvudyaxr6tslxnpomsfx
srs_report.last_update_by_id
sys_users.user_id
Restrict delete
FK_ij5s9og3ifhk5n8tuh7o1bqic
srs_report.status_id
srs_status.id
Restrict delete
FK_6d8hsnvuchj474hq71cu5gj2w
program_milestone.responsible_company_contact_id
program_company_contact.id
Restrict delete
FK_o11rmeid5cspw1jfg0q9dby6r
program_milestone.responsible_user_id
program_support.id
Restrict delete
FK_4jm7vjb4gdu4ucse9m3ey608v
program_milestone.type_id
program_milestone_type.id
Restrict delete
FK_abprjpuypqei0is6se1r1aax7
program_milestone.responsible_contact_id
program_contact.id
Restrict delete
FK_94f1es7fuwfx6eodfhede9sf9
program_milestone.program_id
program.id
Restrict delete
FK_n5yb1w4xq2r9j7p585rnhu099
program_milestone.dependency_id
program_milestone.id
Restrict delete
FK5193D95A16D99B31
company_email.company_id
sys_companies.company_id
Restrict delete
FK_g5fb2rovtj4rpocelxdrnclqb
milestone_task_program.detail_id
milestone_task_detail.id
Restrict delete
FK_7uvohkok8buiex03gb1y56jwu
milestone_task_program.projectsdgroup_id
project_sd_group.group_id
Restrict delete
FK_tc58ve4w6xdwprch1n09s239q
project_closeout_document_type.site_type_id
site_document_type.id
Restrict delete
FK7AF596C1801340C3
activity_log_action.notification_id
notification.id
Restrict delete
FK2A5A4CE167DEC566
process_library_record_phase.record_id
process_library_record.id
Restrict delete
FK2A5A4CE184A5610E
process_library_record_phase.phase_id
process_library_phase.id
Restrict delete
FKA4FAA1F32FF475B7
menu_item.menu_id
menu.id
Restrict delete
FKA4FAA1F3BC856BBF
menu_item.parent_id
menu_item.id
Restrict delete
FK_689e9cea957gddc2p85yefkts
program_site_channel.program_channels_id
program.id
Restrict delete
FK_95wtbjxawo3uulf6a1bok11wi
program_site_channel.site_channel_id
site_channel.channel_code
Restrict delete
FK_rov7cjd3aoreli3gt9bn4yvgb
program_folder.program_id
program.id
Restrict delete
FK_1i1naghrorf4497ss7u6ya8lg
program_folder.company_type_id
sys_company_types.type_id
Restrict delete
FK_80y2jk0jo2cuao7wb9d0akox5
program_folder.parent_id
program_folder.id
Restrict delete
FK_rvy8wwltsknl2xtee45j1ekwh
program_folder.document_type_id
program_document_type.id
Restrict delete
FK_m9i49q4bj2tj5h9lsimop0b0c
program_folder.company_id
sys_companies.company_id
Restrict delete
fk_intake_req_system
intake_request_type.system_id
intake_system.system_id
Restrict delete
fk_intake_req_parent
intake_request_type.parent_id
intake_request_type.request_type_id
Restrict delete
FK_sqkki9h9pfch04qucx9st80th
intake_request_type.default_user_id
sys_users.user_id
Restrict delete
FK71A2DFED839C9EC3
process_library_record_accountable.role_id
sys_roles.role_id
Restrict delete
FK71A2DFED67DEC566
process_library_record_accountable.record_id
process_library_record.id
Restrict delete
FK_n2221lhag064vj075ian4k1cy
iterative_note.last_update_by_proxy_id
sys_users.user_id
Restrict delete
FK_jea73hx16ls4x7jl0xpoyfbuy
iterative_note.category_id
iterative_note_category.id
Restrict delete
FK_qdblridchgeunqrt31hihha4e
iterative_note.project_id
project.id
Restrict delete
FK_ay4xx489qy1jgv3nbi8lpqpx4
iterative_note.last_update_by_id
sys_users.user_id
Restrict delete
FK_2gfks4o7s6jctg8487cqrkx2t
iterative_note.subcategory_id
project_note_subcategory.id
Restrict delete
FK_mlh1tirn7il2x4pmlve9u8pl8
iterative_note.created_by_id
sys_users.user_id
Restrict delete
FK_1rbchtfwnf0ikagy7g1r88vpg
iterative_note.site_id
site.id
Restrict delete
FK_kwytvlbkpirfdve7r0bx2jash
iterative_note.created_by_proxy_id
sys_users.user_id
Restrict delete
FK8DE3D9D67D387CEC
reports_column.report_id
reports.report_id
Restrict delete
FK_plg_sig_round
plg_signature.round_id
plg_round.id
Restrict delete
FK_plg_sig_template
plg_signature.template_id
plg_template.id
Restrict delete
FK_l885vvkgn66jjce8unuejcb4t
milestone_template_brand.brand_id
site_brand.id
Restrict delete
FK_ka4fj6ujipmrym5949vu0ypk8
milestone_template_brand.template_id
milestone_templates.template_id
Restrict delete
FK7C28732892D2B99F
site_contact.site_id
site.id
Restrict delete
FK7C28732851C65451
site_contact.contact_id
contact.contact_id
Restrict delete
FK7C287328839C9EC3
site_contact.role_id
sys_roles.role_id
Restrict delete
FK5322EBDB28C762A3
sys_admin_job.user_id
sys_users.user_id
Restrict delete
FK5322EBDB255B47AD
sys_admin_job.notify_user_id
sys_users.user_id
Restrict delete
FK_plg_sig_role_signature
plg_signature_role.signature_id
plg_signature.id
Restrict delete
FK_plg_sig_role_role
plg_signature_role.role_id
sys_roles.role_id
Restrict delete
fk_permit_usage_log_entry_log_id
permit_usage_log_entry.permit_usage_log_id
permit_usage_log.id
Cascade on delete
FK_hr7dbrrvix0i7jd8ifyaqr01t
notification.header_id
notification_template.id
Restrict delete
FK_j8g0fcd5tw3dckw7tsovwgfeb
notification.footer_id
notification_template.id
Restrict delete
FK237A88EB1EE1B683
notification.complete_on_send_id
milestone_tasks.task_id
Restrict delete
FK_pnk8bat94tuq6sakd17e722e9
sys_temporary_role_users.role_id
sys_roles.role_id
Restrict delete
FK_otufayypbliy9781hucvy0fuc
sys_temporary_role_users.user_id
sys_users.user_id
Restrict delete
FK70B9F28290CCAF0E
project_form_subgroup_eligibility.subgroup_id
project_field_subgroup.id
Restrict delete
FK_site_org_future_parent
site_org_future.parent_id
site_org_future.org_id
Restrict delete
FK_intakelogproxy
intake_log.proxy_user_id
sys_users.user_id
Restrict delete
FK_intakeloguser
intake_log.user_id
sys_users.user_id
Restrict delete
FK_intakelogticket
intake_log.intake_id
intake.id
Restrict delete
FK4E6AC5752BBA482A
asset_log.schedule_id
asset_schedule.id
Restrict delete
FK4E6AC57528C762A3
asset_log.user_id
sys_users.user_id
Restrict delete
FK4E6AC575A1B485D2
asset_log.proxy_user_id
sys_users.user_id
Restrict delete
FK4E6AC57545D4494A
asset_log.type_id
asset_type.id
Restrict delete
FK7C8A002828C762A3
sitepack_approval_user.user_id
sys_users.user_id
Restrict delete
FK7C8A00285814C167
sitepack_approval_user.site_pack_id
sitepack.id
Restrict delete
FK_site_data_site
site_data.id
site.id
Cascade on delete
FKA9FB0557839C9EC3
project_company.role_id
sys_roles.role_id
Restrict delete
FKA9FB055716D99B31
project_company.company_id
sys_companies.company_id
Restrict delete
FKA9FB0557FE2B983
project_company.project_id
project.id
Restrict delete
FKF3F210D045D4494A
asset_template_type.type_id
asset_type.id
Restrict delete
FKF3F210D0658AD94A
asset_template_type.template_id
asset_template.id
Restrict delete
FK9445467CCD4225D8
legal_action.trigger_id
legal_trigger.id
Restrict delete
FKFDAE893828C762A3
project_company_contact.user_id
sys_users.user_id
Restrict delete
FKFDAE8938692FF708
project_company_contact.company_email_id
company_email.id
Restrict delete
FKFDAE893816D99B31
project_company_contact.company_id
sys_companies.company_id
Restrict delete
FKFDAE8938FE2B983
project_company_contact.project_id
project.id
Restrict delete
FK_quu18sx1ayprj9h4jwcn4kk4j
survey_item.question_id
survey_question.id
Restrict delete
FK_6ttivsda7jc19ea7n0xseu4l1
survey_item.vendor_survey_id
vendor_survey.id
Restrict delete
FK_3p9nwbb5mn5d7v3q6xc738ujp
milestone_templates.brand_id
site_brand.id
Restrict delete
FK_xhg8cvicwaj2e2od1ngcwq4j
program_file.last_update_user_id
sys_users.user_id
Restrict delete
FK_tdy9ta026virwhrdkpabir6e6
program_file.folder_id
program_folder.id
Restrict delete
FKA690076C7D387CEC
reports_link_value.report_id
reports.report_id
Restrict delete
fk_created_by
powerbi_entry.created_by_id
sys_users.user_id
Restrict delete
FKC18AEA9428C762A3
dashboard.user_id
sys_users.user_id
Restrict delete
FK_liik6h8882h4tcsqnkjcwhc2d
target_area_candidate.target_area_id
target_area.id
Restrict delete
FK_kfxsu92rc2xlrmkq89qwef3m8
milestone_task_log.task_id
milestone_tasks.task_id
Restrict delete
FK_lfradrxholoftrlnm5tm3teqm
milestone_task_log.user_id
sys_users.user_id
Restrict delete
FK_9ydsy0hxacmkcu4idsg85tkna
milestone_task_log.proxy_user_id
sys_users.user_id
Restrict delete
FK8F98211428C762A3
sys_monitor_sessions.user_id
sys_users.user_id
Cascade on delete
FK8F982114BF627C2B
sys_monitor_sessions.browser_id
sys_monitor_browsers.id
Restrict delete
FK_ko46nkcjuprpckpupa1b552q
intake_note.proxy_user_id
sys_users.user_id
Restrict delete
FK_9fsjxba23fpkoe7ksr6p73p37
intake_note.user_id
sys_users.user_id
Restrict delete
FK_34alba0toa7g119ruo69628sx
intake_note.intake_id
intake.id
Restrict delete
FK_ih3x3hlhe79hami66i7jkrtka
project_form_log.proxy_user_id
sys_users.user_id
Restrict delete
FK_scf4nfhk38nr9hkfmvv9m9aup
project_form_log.form_id
project_form.id
Restrict delete
FK_ihbyj7oa5wpucgatsswj1w6jw
project_form_log.user_id
sys_users.user_id
Restrict delete
FKE91A2C2BDF419AF
project_form_layout_cell.container_id
project_form_layout_cell.id
Restrict delete
FKE91A2C282389340
project_form_layout_cell.form_id
project_form.id
Restrict delete
FKE91A2C243C65406
project_form_layout_cell.group_id
project_field_group.id
Restrict delete
FKE91A2C290CCAF0E
project_form_layout_cell.subgroup_id
project_field_subgroup.id
Restrict delete
FK_plg_template_item_plg_template
plg_template_item.template_id
plg_template.id
Restrict delete
FK_plg_template_item_asset
plg_template_item.asset_id
asset_type.id
Restrict delete
FK_plg_template_item_category
plg_template_item.category_id
plg_template_category.id
Restrict delete
FK_plg_template_item_plg_asset
plg_template_item.plg_asset_id
plg_asset_type.id
Restrict delete
FK_intake_field_value_field
intake_field_value.field_id
intake_field.id
Restrict delete
FK_intake_field_value_ticket
intake_field_value.ticket_id
intake.id
Restrict delete
FK_mnul0ik4se7fgj22bgycj66wv
sitepack_approval_type.form_id
project_form.id
Restrict delete
FK_serty8byymhmjot4mf25ei01h
project_note_subcategory.category_id
project_note_category.id
Restrict delete
FK55C1C56AACACCFC
fixture_template_types.template_id
fixture_templates.id
Restrict delete
FK55C1C56A375E5FC
fixture_template_types.type_id
fixture_types.id
Restrict delete
FK_kop0j7hihho12j38m42gylmul
project_file_meta.file_id
project_file.id
Restrict delete
FK_mfj4d4yvk43tbwmrkhce36pip
file_extract_file.file_extract_job_id
file_extract_job.id
Restrict delete
fk_intake_display_field
intake_display_field.field_id
intake_field.id
Restrict delete
fk_intake_display_request_type
intake_display_field.type_id
intake_request_type.request_type_id
Restrict delete
FKF494B923A1B485D2
feed_log.proxy_user_id
sys_users.user_id
Restrict delete
FKF494B923BD0D958A
feed_log.import_id
feed_import.id
Restrict delete
FKF494B923DC70672A
feed_log.export_id
feed_export.id
Restrict delete
FK_sjrdqbl86kl4yw46d6xftptu2
program_asset_templates.asset_template_id
asset_template.id
Restrict delete
FK_941lut3oc8iti4c37vffoibq8
program_asset_templates.program_id
program.id
Restrict delete
FK63D97F2D839C9EC3
site_contact_role.role_id
sys_roles.role_id
Restrict delete
FK416A358B28C762A3
legal_approver.user_id
sys_users.user_id
Restrict delete
FK416A358B3494DAE3
legal_approver.legal_id
legal.id
Restrict delete
FK_i6exiavy1dtc06650pbgpj24l
sys_user_setting_history.user_id
sys_users.user_id
Restrict delete
FK_lk24wpdh9m31rbg8yfap0wgjm
sys_alert_attachment.system_alert_id
sys_alert.id
Restrict delete
FK_sqlolbtd5xp1y0g8h6vo8deq2
punch_list_item_note.item_id
punch_list_item.id
Restrict delete
FK_78tb6yp4re873ttcwk5lff6my
punch_list_item_note.update_user_id
sys_users.user_id
Restrict delete
FK_16l1n5gh0terwokut71n74y35
punch_list_item_note.proxy_user_id
sys_users.user_id
Restrict delete
FK_ahjko0qr5o2d4nti2fe3hsec4
punch_list_item_note.user_id
sys_users.user_id
Restrict delete
FK_3r56e6xqus4o8vu5u8l1p47x9
punch_list_item_note.update_proxy_user_id
sys_users.user_id
Restrict delete
FK_project_field_change_field
project_field_change_approval.field_id
project_field.id
Restrict delete
FK_7hr775by2ha5k2ykco652ub2f
notification_sent_action.notification_id
notification.id
Restrict delete
FKA2DF1E4F7D387CEC
dashboard_widget.report_id
reports.report_id
Restrict delete
FKA2DF1E4FE3AF496C
dashboard_widget.dashboard_id
dashboard.id
Restrict delete
fk_dealer_request_log_user_id
dealer_request_log.user_id
sys_users.user_id
Restrict delete
fk_dealer_request_log_proxy_user_id
dealer_request_log.proxy_user_id
sys_users.user_id
Restrict delete
fk_dealer_request_log_dealer_request
dealer_request_log.dealer_request_id
dealer_request.id
Restrict delete
FKE69058F628C762A3
punch_list_item_recipients_company_user.user_id
sys_users.user_id
Restrict delete
FKE69058F649913482
punch_list_item_recipients_company_user.item_id
punch_list_item.id
Restrict delete
FK484595D828C762A3
projectlist_run_history.user_id
sys_users.user_id
Restrict delete
FK484595D8D9B40676
projectlist_run_history.project_list_id
projectlist_custom.id
Restrict delete
FK_t09r10c9w87pwleplfacys56x
project.fixture_template_id
fixture_templates.id
Restrict delete
FK_cmq2womflwqgdijyxklbasgdi
project.status_id
project_status.id
Restrict delete
FK_k0iaw5c7hylidf45rts7ce7yb
project.project_type_id
project_type.id
Restrict delete
FK_dtydefwc4byv5kfrx2hbh4bgc
project.site_id
site.id
Restrict delete
FK_bftxes6m7wdalxc9u1mn6lb2l
project.visibility_group_id
project_visibility_group.id
Restrict delete
FK_s5c7bvqqr2d4voh4sva3pjhla
project.program_year
project_program_year.id
Restrict delete
FKED904B19D8855999
project.prj_program_id
project_sd_group.group_id
Restrict delete
FK_dmlw998kad1w51wd5g74p7rtn
project.contract_holder_id
site_contract_holder.contract_holder_id
Restrict delete
FK_ltw1rmihusannpbphu728rtdb
project.asset_schedule_id
asset_schedule.id
Restrict delete
FK_q2d1ayt3yj5idlmn5oddy4lvo
project.dead_reason_id
project_dead_reason.id
Restrict delete
FK_s56iiqwoq2cewd5yxo3lhvxi7
project.signage_program_id
project_signage_program.id
Restrict delete
fk_form_section_form
project_form_section.form_id
project_form.id
Restrict delete
FK_2y4dip11fk3flautkoh31qx2c
project_note.update_user_id
sys_users.user_id
Restrict delete
FK_tm1vyu1bq9y6v3vuifo4ai8iy
project_note.update_proxy_user_id
sys_users.user_id
Restrict delete
FK37FE255828C762A3
project_note.user_id
sys_users.user_id
Restrict delete
FK37FE2558FE2B983
project_note.project_id
project.id
Restrict delete
FK_d2hklp4l4sj6ma7stx7llk7fx
project_note.subcategory_id
project_note_subcategory.id
Restrict delete
FKB298AA89FABF4A33
site_sampson.cam_user_id
sys_users.user_id
Restrict delete
FK_tbn5muh3wco6dldap0vcd3dh2
site_sampson.org_id
site_org.org_id
Restrict delete
FK_rfffmr4qoubi0h86c306vq8ve
support_action.trigger_id
support_action_trigger.id
Restrict delete
FK_plg_asset_type_category
plg_asset_type.category_id
asset_category.id
Restrict delete
FK_plg_asset_type_company_type
plg_asset_type.company_type_id
sys_company_types.type_id
Restrict delete
FK_1ipwjaq4gjgcjkuj9p49g73pr
program_workflow_participant_type.role_id
sys_roles.role_id
Restrict delete
FK_bqurf790aytjy49u073vptees
program_workflow_participant_type.default_user_id
sys_users.user_id
Restrict delete
FK_nl6qhup25v7e862d8te7oodo
program_workflow_participant_type.workflow_id
program_workflow_type.id
Restrict delete
FKC9EDD565270BB200
milestone_task_template.detail_id
milestone_task_detail.id
Restrict delete
FKC9EDD565E98DF3E0
milestone_task_template.template_id
milestone_templates.template_id
Restrict delete
FKCBA0B9BA839C9EC3
sitepack_file_role.role_id
sys_roles.role_id
Restrict delete
FKCBA0B9BA320B408A
sitepack_file_role.site_pack_file_id
sitepack_file.id
Restrict delete
FK_sn_sent_action_notification
scheduled_notification_sent_action.notification_id
notification_scheduled.id
Restrict delete
FK62162B957AFE0D5
legal.paralegal_id
sys_users.user_id
Restrict delete
FK62162B971C12EE4
legal.signer_id
sys_users.user_id
Restrict delete
FK62162B9EF708433
legal.law_firm_id
sys_companies.company_id
Restrict delete
FK62162B9E74672D3
legal.managing_attorney_id
sys_users.user_id
Restrict delete
FK62162B9FE2B983
legal.project_id
project.id
Restrict delete
FK62162B944EE899C
legal.status_id
legal_status.id
Restrict delete
FK62162B9D72362B0
legal.attorney_id
sys_users.user_id
Restrict delete
FK62162B92A1C51C
legal.type_id
legal_type.id
Restrict delete
FK_program_start_design_site_design
program_start_design.site_design_id
site_design.id
Restrict delete
FK_a57wtu76m8tojec51cja9wdln
program_start_design.program_id
program.id
Restrict delete
FK_a0x2yfm3m1b9qeqtt93spgpou
program_workflow_log.workflow_id
program_workflow.id
Restrict delete
FK_bf5r00hkf89qhvsa0mjhyk1vm
program_workflow_log.file_id
program_file.id
Restrict delete
FK_edpf3gt9atu0auf7j6oge36un
program_workflow_log.owner_id
program_workflow_participant.id
Restrict delete
FK_k0ryptxgmp5wpo2qqato40s62
program_workflow_log.proxy_user_id
sys_users.user_id
Restrict delete
FK_ovsj67dje3wmrxr73p9wjsoes
program_workflow_log.owner_role_id
sys_roles.role_id
Restrict delete
FK_croe3r4g0q4yt2g5ie53dr39
program_workflow_log.actor_id
sys_users.user_id
Restrict delete
FK9F2AFDAE82389340
project_form_validation.form_id
project_form.id
Restrict delete
FK_project_data_project
project_data.id
project.id
Cascade on delete
FK_project_form_field_group
project_form_field.group_id
project_form_group.id
Restrict delete
FK1441BEA571369034
project_form_field.field_id
project_field.id
Restrict delete
FK1441BEA582389340
project_form_field.form_id
project_form.id
Restrict delete
FK_ne7lm0y71ua6buwgwgq6w63ri
project_subcontractor.project_company_id
project_company.id
Restrict delete
FK_sghyvbgyv130yk9mlmvqcnmaw
project_subcontractor.subcontractor_id
subcontractor.id
Restrict delete
FK_nxht9wpqfr17f48wfr62g2agd
notification_group_role.role_id
sys_roles.role_id
Restrict delete
FK_ca2p7y155rcmlv6frngnw29aj
notification_group_role.group_email_id
notification_group_email.id
Restrict delete
FK143DD982375E5FC
site_fixtures.type_id
fixture_types.id
Restrict delete
FK143DD98292D2B99F
site_fixtures.site_id
site.id
Restrict delete
FK_qgwcel9i7037h9tbpldl0rbx1
workflow_participant_history.workflow_id
workflow.id
Restrict delete
FK_ldkprfuhkcyipyqnwj1iarxxm
workflow_participant_history.user_id
sys_users.user_id
Restrict delete
FK_nesa3b0lexo9uqotv96r9hiq3
workflow_participant_history.proxy_user_id
sys_users.user_id
Restrict delete
FK_t2ttjeemgor0wrhdrvh75yw06
project_type.default_page_id
project_page.id
Restrict delete
FK_r4by8o0be82ud3qfqagsia1o
program_asset_responsible_roles.role_id
sys_roles.role_id
Restrict delete
FK_kfbt8fiqji624uomyk9yh5xnd
program_asset_responsible_roles.program_id
program.id
Restrict delete
FK_nvusa1grl64uxm1pc889lrvmn
program_company.company_id
sys_companies.company_id
Restrict delete
FK_6iyb6d3wp0iqtnempvlh96e5o
program_company.program_id
program.id
Restrict delete
FK_50gpypr1xg36aq3b73wr64yrq
program_company.role_id
sys_roles.role_id
Restrict delete
FK_2uvebsf0or6fru25omahwyseu
vendor_task_action.trigger_id
vendor_task_action_trigger.id
Restrict delete
FKF11409E567DEC566
process_library_record_site_channel.record_id
process_library_record.id
Restrict delete
FKF11409E525DF84A6
process_library_record_site_channel.site_channel_id
site_channel.channel_code
Restrict delete
FKC915C580BD960DE9
projectlist_filter.custom_id
projectlist_custom.id
Restrict delete
FK35DF47353BF280
site.channel_code
site_channel.channel_code
Restrict delete
FK_86gbf7pver21drcga9ycsba7i
site.fixture_template_id
fixture_templates.id
Restrict delete
FK_nkh33tq23qmkqt4ub742jxyom
site.transaction_type_id
site_transaction_type.id
Restrict delete
FK_agoj59n9fmf143n32we9kluuc
site.close_reason_id
site_closure_reason.id
Restrict delete
FK_3bauynt93kvbdf94e4yud4opi
site.type_code
site_type.type_code
Restrict delete
FK_51hh7krapcdkfxc03h4upb2tk
site.Sublease_type
sublease_type.id
Restrict delete
FK_dhsqtbvphnwwjlp3ch7y57iwh
site.status_code
site_status.status_code
Restrict delete
FK_2wtpkmhjialxvhfvg3hbcb5da
site.last_modified_project_id
project.id
Restrict delete
FK_ek7j9lif1jxhl6cpow03wslu5
site.asset_schedule_id
asset_schedule.id
Restrict delete
FK_emy8k04nyd6wf0dtmudap9ufi
site.legal_entity_id
legal_lease_entities.id
Restrict delete
FK_6u67gre7a58mhug4vrc57jolh
site.contract_holder_id
site_contract_holder.contract_holder_id
Restrict delete
FK_nq0y3s90v1212ber41obay71f
site.visibility_group_id
site_visibility_group.id
Restrict delete
FK_site_site_brand
site.brand_id
site_brand.id
Restrict delete
FK6A50E994D9B40676
projectlist_run_statistic.project_list_id
projectlist_custom.id
Restrict delete
FK_d2g16sj4i2bqkr3kl8y1q639w
project_subcontractor_contact.project_subcontractor_id
project_subcontractor.id
Restrict delete
FK_l3qjc7srva8lxl541na0mn3kx
project_subcontractor_contact.user_id
sys_users.user_id
Restrict delete
FK_8ayryxth5wx1m0gg487ewu13r
target_area_log.user_id
sys_users.user_id
Restrict delete
FK_q051etq6wgik5319gnrfhhrjj
target_area_log.target_area_id
target_area.id
Restrict delete
FK_798fr6qghgtewex2b78c6ek1i
target_area_log.proxy_user_id
sys_users.user_id
Restrict delete
FK39A64AC3124156D6
fixture_types.category_id
fixture_type_categories.id
Restrict delete
FK21BD7BF2C557739
workflow.current_id
workflow_log.id
Restrict delete
FK21BD7BF4C7747A7
workflow.published_file_id
project_file.id
Restrict delete
FK21BD7BF7A8FBA6
workflow.type_id
workflow_type.id
Restrict delete
FK21BD7BFFE2B983
workflow.project_id
project.id
Restrict delete
fk_proxy_user_id
wiki_page_history.proxy_user_id
sys_users.user_id
Restrict delete
fk_wiki_page_id
wiki_page_history.wiki_page_id
wiki_page.id
Restrict delete
fk_user_id
wiki_page_history.user_id
sys_users.user_id
Restrict delete
FK_nqcd5x6eaxc48f62g1cn6wsnm
site_reverse_geocoding_data.site_id
site.id
Restrict delete
FK_ffm9ku4hyh3atqqar4aelhika
vendor_task.company_id
sys_companies.company_id
Restrict delete
FK_p0g96mntnormr9hhy733wcheo
vendor_task.photo_album_id
project_folder.id
Restrict delete
FK_dnfa31cnqwelri4drtfvfe8
vendor_task.last_checkin_user_id
sys_users.user_id
Restrict delete
FK_oxh2fxj4n3cyx3a0wwaes86o7
vendor_task.project_id
project.id
Restrict delete
FK_8o61niwb35h58yg32ddhrilxl
vendor_task.role_id
sys_roles.role_id
Restrict delete
FKDE0F141DDB9BF934
milestone_sections.phase_id
milestone_phases.phase_id
Restrict delete
FK2770240A801340C3
notification_action.notification_id
notification.id
Restrict delete
FKC5CCFEBFE4DC07C0
sitepack_security.recommended_package_id
sitepack_security_package.id
Restrict delete
FKC5CCFEBF234F8245
sitepack_security.received_user_id
sys_users.user_id
Restrict delete
FKC5CCFEBFFE2B983
sitepack_security.project_id
project.id
Restrict delete
FKC5CCFEBFD59452D2
sitepack_security.requested_user_id
sys_users.user_id
Restrict delete
FKC5CCFEBF23A15CBF
sitepack_security.recommended_user_id
sys_users.user_id
Restrict delete
FKC5CCFEBFE0F44D1
sitepack_security.ordered_user_id
sys_users.user_id
Restrict delete
FK2C0913CAFE2B983
project_milestone.project_id
project.id
Restrict delete
FK_a7svrnqcdi6axm20um3ofp26i
project_milestone.dependency_id
project_milestone.id
Restrict delete
FK2C0913CAF0C07700
project_milestone.task_id
milestone_tasks.task_id
Restrict delete
FK_alv8066m70p3qw7t6fw5l4w4n
project_milestone.detail_id
milestone_task_detail.id
Restrict delete
fk_audience_permit_id
wiki_audience.permit_id
sys_permits.permit_id
Restrict delete
FK_plg_project_project
project_plg.project_id
project.id
Restrict delete
FK_plg_project_status
project_plg.status_id
plg_status.id
Restrict delete
FK_plg_project_template
project_plg.template_id
plg_template.id
Restrict delete
FKC4875F659C0630F6
project_type_pages.project_type_id
project_type.id
Restrict delete
FKC4875F659EF7F4D6
project_type_pages.project_page_id
project_page.id
Restrict delete
wiki_page_attachment_page_id
wiki_page_attachment.page_id
wiki_page.id
Restrict delete
FK_hddn1f92odeu2yyka6rdjdscg
program_contact.role_id
sys_roles.role_id
Restrict delete
FK_2vwx63nnxwnp3ssltp4oe1yux
program_contact.contact_id
contact.contact_id
Restrict delete
FK_26ighsholsf7srl5snt2iai69
program_contact.program_id
program.id
Restrict delete

Check Constraints

Table Constraint Name Constraint