Constraints

41 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_cplessonslearned
cplessonslearned.job_num
job.job_num
Cascade on delete
FK_equipment_write_to_onec_history_onec_file_history_file_Id
equipment_write_to_onec_history.file_Id
onec_file_history.id
Cascade on delete
fk_plan_survey
plan_survey.job_num
job.job_num
Cascade on delete
FK_Equipments_EquipmentClasses_EquipmentClassId
Equipments.EquipmentClassId
EquipmentClasses.Id
Null on delete
FK_Equipments_InventoryGroups_InventoryGroupId
Equipments.InventoryGroupId
InventoryGroups.Id
Null on delete
FK_Equipments_EquipmentModels_EquipmentModelId
Equipments.EquipmentModelId
EquipmentModels.Id
Null on delete
FK_Equipments_EquipmentStatuses_EquipmentStatusId
Equipments.EquipmentStatusId
EquipmentStatuses.Id
Restrict delete
FK_Equipments_ToolTypes_ToolTypeId
Equipments.ToolTypeId
ToolTypes.Id
Null on delete
FK_Equipments_EquipmentLocations_EquipmentLocationId
Equipments.EquipmentLocationId
EquipmentLocations.Id
Null on delete
FK_EquipmentStatusLogs_EquipmentStatuses_NewId
EquipmentStatusLogs.NewId
EquipmentStatuses.Id
Cascade on delete
FK_EquipmentStatusLogs_EquipmentStatuses_OldId
EquipmentStatusLogs.OldId
EquipmentStatuses.Id
Restrict delete
FK_SyncInsiteEntries_SyncDictionaryEntries_DictionaryEntryId
SyncInsiteEntries.DictionaryEntryId
SyncDictionaryEntries.Id
Restrict delete
FK_SyncInsiteEntries_SyncWorkloadEntries_WorkloadEntryId
SyncInsiteEntries.WorkloadEntryId
SyncWorkloadEntries.Id
Restrict delete
FK_EquipmentChanges_SyncDictionaryEntries_DictionaryEntryId
EquipmentChanges.DictionaryEntryId
SyncDictionaryEntries.Id
Restrict delete
FK_EquipmentChanges_SyncWorkloadEntries_WorkloadEntryId
EquipmentChanges.WorkloadEntryId
SyncWorkloadEntries.Id
Restrict delete
FK_SyncInsiteEntryFiles_SyncInsiteEntries_InsiteEntryId
SyncInsiteEntryFiles.InsiteEntryId
SyncInsiteEntries.Id
Restrict delete
fk_questions_run
questions_run.job_num
questions_run.run_no
jr_key.job_num
jr_key.run_no
Cascade on delete
FK_questions_run_Questions_quest_id
questions_run.quest_id
Questions.Id
Restrict delete
FK_ToolTypes_ToolTypeServices_ServiceId
ToolTypes.ServiceId
ToolTypeServices.Id
Restrict delete
FK_ToolTypes_ToolTypeSizes_SizeId
ToolTypes.SizeId
ToolTypeSizes.Id
Restrict delete
FK_ToolTypes_ToolTypeGroups_GroupId
ToolTypes.GroupId
ToolTypeGroups.Id
Restrict delete
FK_ToolTypes_ToolTypeTAs_TAId
ToolTypes.TAId
ToolTypeTAs.Id
Restrict delete
FK_ToolTypes_ToolTypeSubGroups_SubGroupId
ToolTypes.SubGroupId
ToolTypeSubGroups.Id
Restrict delete
FK_tot_ServiceType_service_type_id
tot.service_type_id
ServiceType.Id
Restrict delete
fk_cam_sam
cam_sam.job_num
cam_sam.run_no
jr_key.job_num
jr_key.run_no
Cascade on delete
FK_EquipmentChangeHours_EquipmentChanges_EquipmentChangeId
EquipmentChangeHours.EquipmentChangeId
EquipmentChanges.Id
Cascade on delete
fk_jr_key
jr_key.job_num
job.job_num
Cascade on delete
FK_EquipmentRelationshipLogs_EquipmentRelationshipChanges_Equi~
EquipmentRelationshipLogs.EquipmentRelationshipChangeId
EquipmentRelationshipChanges.Id
Cascade on delete
FK_SyncPipelineWorkloadEntries_SyncWorkloadEntries_WorkloadId
SyncPipelineWorkloadEntries.WorkloadId
SyncWorkloadEntries.Id
Restrict delete
fk_surface_parameters
surface_parameters.job_num
surface_parameters.run_no
jr_key.job_num
jr_key.run_no
Cascade on delete
FK_EquipmentStatusMaps_EquipmentStatuses_EquipmentStatusId
EquipmentStatusMaps.EquipmentStatusId
EquipmentStatuses.Id
Restrict delete
fk_cp2
cp2.job_num
job.job_num
Cascade on delete
fk_cp1
cp1.job_num
job.job_num
Cascade on delete
fk_cp4
cp4.job_num
job.job_num
Cascade on delete
FK_SyncPipelineDictionaryEntries_SyncDictionaryEntries_Diction~
SyncPipelineDictionaryEntries.DictionaryId
SyncDictionaryEntries.Id
Restrict delete
fk_run
run.job_num
run.run_no
jr_key.job_num
jr_key.run_no
Cascade on delete
FK_questions_job_Questions_quest_id
questions_job.quest_id
Questions.Id
Restrict delete
fk_questions_job
questions_job.job_num
job.job_num
Cascade on delete
fk_actual_survey
actual_survey.job_num
actual_survey.run_no
jr_key.job_num
jr_key.run_no
Cascade on delete
fk_activity
activity.job_num
activity.run_no
jr_key.job_num
jr_key.run_no
Cascade on delete
fk_insite_health
insite_health.job_num
insite_health.run_no
jr_key.job_num
jr_key.run_no
Cascade on delete

Check Constraints

Table Constraint Name Constraint