Constraints

264 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
FK_StudentYears_ID
StudentYears.ID
Students.ID
Restrict delete
FK_OnlinePaymentMerchants_SynFinanceDatabaseCode
OnlinePaymentMerchants.SynFinanceDatabaseCode
SynDatabases.Code
Restrict delete
FK_EventSubGroup_EventGroup
EventSubGroup.EventGroupSeq
EventGroup.EventGroupSeq
Restrict delete
FK_EventGroup_Community
EventSubGroup.ResponsibleStaffID
Community.ID
Restrict delete
FK_EventGroup_Events
EventGroup.EventsSeq
Events.EventsSeq
Restrict delete
FK_EventAbility_Events
EventAbility.EventsSeq
Events.EventsSeq
Restrict delete
FK_EventGeneralConsent_Events
EventGeneralConsent.EventsSeq
Events.EventsSeq
Restrict delete
FK_FutureStudentApplicationSchools_FutureStudents
FutureStudentApplicationSchools.ID
FutureStudents.ID
Restrict delete
FK_ObjectBookingsMasterMembers_ObjectBookingsMaster
ObjectBookingsMasterMembers.ObjectBookingsMasterSeq
ObjectBookingsMaster.ObjectBookingsMasterSeq
Restrict delete
FK_ObjectBookingsMasterMembers_Community
ObjectBookingsMasterMembers.ID
Community.ID
Restrict delete
FK_ObjectBookingsMasterMembers_ObjectBookingsSeq_ObjectBookings_ObjectBookingsSeq
ObjectBookingsMasterMembers.ObjectBookingsSeq
ObjectBookings.ObjectBookingsSeq
Restrict delete
FK_CommunityCommunicationsCurrent_Community
CommunityCommunicationsCurrent.ID
Community.ID
Restrict delete
FK_CommunityCommunicationsCurrent_Communications
CommunityCommunicationsCurrent.CommunicationCode
Communications.CommunicationCode
Restrict delete
FK_CommunityEventsCurrentAttributes_EventAttributes
CommunityEventsCurrentAttributes.EventAttributesSeq
EventAttributes.EventAttributesSeq
Restrict delete
FK_SubjectAssessmentVELSDomainDimensions_SubjectAssessmentVELSDomains
SubjectAssessmentVELSDomainDimensions.SubjectAssessmentVELSDomainsSeq
SubjectAssessmentVELSDomains.SubjectAssessmentVELSDomainsSeq
Restrict delete
FK_OnlineImportStudentsSchoolPreferences_OnlineImportStudents
OnlineImportStudentsSchoolPreferences.OnlineImportStudentsSeq
OnlineImportStudents.OnlineImportStudentsSeq
Restrict delete
FK_Tags_Community
Tags.ID
Community.ID
Restrict delete
FK_wkSubjectClassesbulk_Community_ConfigUserID
wkSubjectClassesbulk.ConfigUserID
Community.ID
Restrict delete
FK_SubjectClassesResultLock_SubjectClasses
SubjectClassesResultLock.SubjectClassesSeq
SubjectClasses.SubjectClassesSeq
Restrict delete
FK_EventObjectBookings_ObjectBookings_ObjectBookingsSeq
EventObjectBookings.ObjectBookingsSeq
ObjectBookings.ObjectBookingsSeq
Restrict delete
FK_EventObjectBookings_ObjectLoans_ObjectLoansSeq
EventObjectBookings.ObjectLoansSeq
ObjectLoans.ObjectLoansSeq
Restrict delete
FK_EventObjectBookings_Community_ResponsibleStaffId
EventObjectBookings.ResponsibleStaffId
Community.ID
Restrict delete
FK_EventObjectBookings_Events_EventsSeq
EventObjectBookings.EventsSeq
Events.EventsSeq
Restrict delete
FK_StudentCourseCharges_StudentCourses
StudentCourseCharges.StudentCoursesSeq
StudentCourses.StudentCoursesSeq
Restrict delete
FK_CommunityInvolvement_Community
CommunityInvolvement.ID
Community.ID
Restrict delete
FK_ObjectAccommodation_LinkedID
ObjectAccommodation.LinkedID
Community.ID
Restrict delete
FK_ObjectAccommodation_AgentID
ObjectAccommodation.AgentID
Community.ID
Restrict delete
FK_ObjectAccommodation_ObjectNumber
ObjectAccommodation.ObjectNumber
Objects.ObjectNumber
Restrict delete
FK_SubjectAssessmentAreas_SubjectAssessments
SubjectAssessmentAreas.FileType
SubjectAssessmentAreas.FileYear
SubjectAssessmentAreas.FileSemester
SubjectAssessmentAreas.ClassCampus
SubjectAssessmentAreas.AssessmentCode
SubjectAssessments.FileType
SubjectAssessments.FileYear
SubjectAssessments.FileSemester
SubjectAssessments.ClassCampus
SubjectAssessments.AssessmentCode
Restrict delete
FK_ObjectTypeCategoryElements_ObjectTypeElements
ObjectTypeCategoryElements.ObjectTypeElementNumber
ObjectTypeElements.ObjectTypeElementNumber
Restrict delete
FK_ObjectTypeCategoryElements_ObjectTypes
ObjectTypeCategoryElements.ObjectTypesSeq
ObjectTypes.ObjectTypesSeq
Restrict delete
FK_CommunityOccupHistory_Community
CommunityOccupHistory.ID
Community.ID
Restrict delete
FK_PTInterviewSessions_PTInterviewCycles
PTInterviewSessions.PTICycleCode
PTInterviewCycles.PTICycleCode
Restrict delete
FK_ObjectTypeElements_ObjectTypes
ObjectTypeElements.ObjectTypesSeq
ObjectTypes.ObjectTypesSeq
Restrict delete
FK_ObjectAttributes_ObjectTypeAttributes
ObjectAttributes.ObjectTypeAttributesSeq
ObjectTypeAttributes.ObjectTypeAttributesSeq
Restrict delete
FK_ObjectAttributes_Objects
ObjectAttributes.ObjectNumber
Objects.ObjectNumber
Restrict delete
FK_EventAttendeeConsents_ConsentGivenByID_Community
EventAttendeeConsents.ConsentGivenByID
Community.ID
Restrict delete
FK_EventAttendeeConsents_EventConsents
EventAttendeeConsents.EventConsentSeq
EventConsents.EventConsentSeq
Restrict delete
FK_EventAttendeeConsents_AttendeeID_Community
EventAttendeeConsents.AttendeeID
Community.ID
Restrict delete
FK_Courses_CourseAgentCommissionControl
Courses.CourseAgentCommissionControlSeqDefault
CourseAgentCommissionControl.CourseAgentCommissionControlSeq
Restrict delete
FK_CommissionLinkCoursesSeq_Courses
Courses.CommissionLinkCoursesSeq
Courses.CoursesSeq
Restrict delete
FK_Courses_LinkedCoursesSeq
Courses.CoursesSeq
Courses.CoursesSeq
Restrict delete
FK_ObjectTypeCategories_ObjectTypes
ObjectTypeCategories.ObjectTypesSeq
ObjectTypes.ObjectTypesSeq
Restrict delete
FK_PastoralCareContacts_PastoralCare
PastoralCareContacts.PastoralCareSeq
tPastoralCare.PastoralCareSeq
Restrict delete
FK_CommunityEventsCurrentGuestsAttributes_CommunityEventsCurrentGuests
CommunityEventsCurrentGuestsAttributes.CommunityEventsCurrentGuestsSeq
CommunityEventsCurrentGuests.CommunityEventsCurrentGuestsSeq
Restrict delete
FK_CommunityEventsCurrentGuestsAttributes_EventAttributes
CommunityEventsCurrentGuestsAttributes.EventAttributesSeq
EventAttributes.EventAttributesSeq
Restrict delete
FK_DonorProspects_Community
DonorProspects.ID
Community.ID
Restrict delete
FK_OnlinePaymentOptionLevelThree_NotifyStaffID
OnlinePaymentOptionLevelThree.NotifyStaffID
Staff.ID
Restrict delete
FK_OnlinePaymentOptionLevelThree_OnlinePaymentOptionLevelTwoSeq
OnlinePaymentOptionLevelThree.OnlinePaymentOptionLevelTwoSeq
OnlinePaymentOptionLevelTwo.OnlinePaymentOptionLevelTwoSeq
Restrict delete
FK_wkStudentNZMOEENROL_SystemProcessControl
wkStudentNZMOEENROL.SystemProcessNumber
SystemProcessControl.SystemProcessNumber
Restrict delete
FK_ObjectBookingsUnallocated_ObjectBookingsMaster
ObjectBookingsUnallocated.ObjectBookingsMasterSeq
ObjectBookingsMaster.ObjectBookingsMasterSeq
Restrict delete
FK_DisabilityAdjustment_Community
DisabilityAdjustment.ID
Community.ID
Restrict delete
FK_CourseClasses_Courses
CourseClasses.CoursesSeq
Courses.CoursesSeq
Restrict delete
FK_CommunityLegal_Community
CommunityLegal.ID
Community.ID
Restrict delete
FK_OnlineImportStudentsCustom_OnlineImportStudents
OnlineImportStudentsCustom.OnlineImportStudentsSeq
OnlineImportStudents.OnlineImportStudentsSeq
Restrict delete
FK_NotificationRules_SMSProviderDetails
NotificationRules.SMSProviderDetailsSeq
SMSProviderDetails.SMSProviderDetailsSeq
Restrict delete
FK_OnlineImportContactsCommunity_OnlineImportContacts
OnlineImportContactsCommunity.OnlineImportContactsSeq
OnlineImportContacts.OnlineImportContactsSeq
Restrict delete
FK_OnlineImportContactsCommunity_Community
OnlineImportContactsCommunity.CommunityID
Community.ID
Restrict delete
FK_PastoralCareComments_PastoralCare
PastoralCareComments.PastoralCareSeq
tPastoralCare.PastoralCareSeq
Restrict delete
FK_CommunityEventsCurrentGuests_Events_EventCode
CommunityEventsCurrentGuests.EventCode
Events.EventCode
Restrict delete
FK_CommunityEventsCurrentGuests_Community_GuestID
CommunityEventsCurrentGuests.GuestID
Community.ID
Restrict delete
FK_CommunityEventsCurrentGuests_Community_HostID
CommunityEventsCurrentGuests.ID
Community.ID
Restrict delete
FK_CommunityEventsCurrentGuests_CommunityEventsCurrent
CommunityEventsCurrentGuests.EventCurrentSeq
CommunityEventsCurrent.EventCurrentSeq
Restrict delete
FK_tStaffTraining_CommunityQualifications
tStaffTraining.QualificationSeq
CommunityQualifications.QualificationSeq
Restrict delete
FK_tStaffTraining_Staff
tStaffTraining.ID
Staff.ID
Restrict delete
FK_tStaffTraining_LearningAreas
tStaffTraining.FileType
tStaffTraining.LearningAreaCode
LearningAreas.FileType
LearningAreas.LearningAreaCode
Restrict delete
FK_StudentSchools_Community
StudentSchools.ID
Community.ID
Restrict delete
FK_StaffJobPositions_OverrideReportsToJobPositionsSeq
StaffJobPositions.OverrideReportsToJobPositionsSeq
JobPositions.JobPositionsSeq
Restrict delete
FK_StaffJobPositions_JobPositions
StaffJobPositions.JobPositionsSeq
JobPositions.JobPositionsSeq
Restrict delete
FK_StaffJobPositions_Staff
StaffJobPositions.ID
Staff.ID
Restrict delete
FK_CommunityInvolvementActivity_Community_ActivityByID
CommunityInvolvementActivity.ActivityByID
Community.ID
Restrict delete
FK_CommunityInvolvementActivity_Community_ID
CommunityInvolvementActivity.ID
Community.ID
Restrict delete
FK_CommunityCitizenshipVisaSubclassConditions_CommunityCitizenshipVisaSubclasses
CommunityCitizenshipVisaSubclassConditions.CommunityCitizenshipVisaSubclassesSeq
CommunityCitizenshipVisaSubclasses.CommunityCitizenshipVisaSubclassesSeq
Restrict delete
FK_SubscribersObjects_Subscribers
SubscribersObjects.SubscribersSeq
Subscribers.SubscribersSeq
Restrict delete
FK_PastStudentContacts_ID_Community
PastStudentContacts.ID
Community.ID
Restrict delete
FK_PastStudentContacts_LinkedID_Community
PastStudentContacts.LinkedID
Community.ID
Restrict delete
FK_PTInterviews_PTInterviewSessionSlots
PTInterviews.PTISessionSlotSeq
PTInterviewSessionSlots.PTISessionSlotSeq
Restrict delete
FK_wkStudentNZMOEGetNSN_SystemProcessControl
wkStudentNZMOEGetNSN.SystemProcessNumber
SystemProcessControl.SystemProcessNumber
Restrict delete
FK_CommunityVehicles_Community
CommunityVehicles.ID
Community.ID
Restrict delete
FK_PastStudentYears_ID
PastStudentYears.ID
PastStudentsOriginal.ID
Restrict delete
FK_MembershipAppointment_CalendarAppointment
MembershipAppointment.CalendarAppointmentSeq
CalendarAppointment.CalendarAppointmentSeq
Restrict delete
FK_MembershipAppointment_MembershipType
MembershipAppointment.MembershipTypeSeq
MembershipType.MembershipTypeSeq
Restrict delete
FK_WebServiceMethodVersionParameters_WebServiceMethodVersions_WebServiceMethodVersionsSeq
WebServiceMethodVersionParameters.WebServiceMethodVersionsSeq
WebServiceMethodVersions.WebServiceMethodVersionsSeq
Restrict delete
FK_ObjectTypes_ObjectTypes_DefaultChildObjectTypesSeq
ObjectTypes.DefaultChildObjectTypesSeq
ObjectTypes.ObjectTypesSeq
Restrict delete
FK_StudentAwards_SystemProcessControl
StudentAwards.SystemProcessNumber
SystemProcessControl.SystemProcessNumber
Restrict delete
FK_tAttendances_AttendanceMaster
tAttendances.AttendanceMasterSeq
AttendanceMaster.AttendanceMasterSeq
Restrict delete
FK_ObjectElements_Objects
ObjectElements.ObjectNumber
Objects.ObjectNumber
Restrict delete
FK_ObjectElements_ObjectTypeElements
ObjectElements.ObjectTypeElementNumber
ObjectTypeElements.ObjectTypeElementNumber
Restrict delete
FK_Constituencies_Community
Constituencies.ID
Community.ID
Restrict delete
FK_SystemProcessControlPrints_SystemProcessControl
SystemProcessControlPrints.SystemProcessNumber
SystemProcessControl.SystemProcessNumber
Restrict delete
FK_SubjectClassElectiveGroup_SubjectClasses
SubjectClassElectiveGroup.SubjectClassesSeq
SubjectClasses.SubjectClassesSeq
Restrict delete
FK_ObjectTypeTaskStaff_Community
ObjectTypeTaskStaff.ID
Community.ID
Restrict delete
FK_ObjectTypeTaskStaff_ObjectTypes
ObjectTypeTaskStaff.ObjectTypesSeq
ObjectTypes.ObjectTypesSeq
Restrict delete
FK_OnlineImportContactsCustom_OnlineImportContacts
OnlineImportContactsCustom.OnlineImportContactsSeq
OnlineImportContacts.OnlineImportContactsSeq
Restrict delete
FK_StudentClasses_CommunityID
StudentClasses.CommPortalPrintID
Community.ID
Restrict delete
FK_StudentExternalTests_Community
StudentExternalTests.StudentID
Community.ID
Restrict delete
FK_StudentExternalTests_ExternalTests
StudentExternalTests.ExternalTestsSeq
ExternalTests.ExternalTestsSeq
Restrict delete
FK_ObjectLoans_Community_ID
ObjectLoans.ID
Community.ID
Restrict delete
FK_ObjectLoans_Community_ReturnedToID
ObjectLoans.ReturnedToID
Community.ID
Restrict delete
FK_ObjectLoans_Objects
ObjectLoans.ObjectNumber
Objects.ObjectNumber
Restrict delete
FK_ObjectLoans_ObjectBookings
ObjectLoans.ObjectBookingsSeq
ObjectBookings.ObjectBookingsSeq
Restrict delete
FK_ObjectLoans_Community_IssuedByID
ObjectLoans.IssuedByID
Community.ID
Restrict delete
FK_EventAttributes_EventAttributesMaster
EventAttributes.EventAttributesMasterSeq
EventAttributesMaster.EventAttributesMasterSeq
Restrict delete
FK_CommunityCitizenshipVisaSubclasses_CommunityCitizenships
CommunityCitizenshipVisaSubclasses.CommunityCitizenshipsSeq
CommunityCitizenships.CommunityCitizenshipsSeq
Restrict delete
FK_TimesheetsDeleted_luTableName
TimesheetsDeleted.StaffID
Staff.ID
Restrict delete
FK_ObjectTypeAttributes_ObjectTypes
ObjectTypeAttributes.ObjectTypesSeq
ObjectTypes.ObjectTypesSeq
Restrict delete
FK_StudentContacts_ID_Community
StudentContacts.ID
Community.ID
Restrict delete
FK_StudentContacts_LinkedID_Community
StudentContacts.LinkedID
Community.ID
Restrict delete
FK_PTInterviewSessionSlots_PTInterviewSessions
PTInterviewSessionSlots.PTISessionSeq
PTInterviewSessions.PTISessionSeq
Restrict delete
FK_PTInterviewSessionSlotsStaff_PTISessionSlotSeq
PTInterviewSessionSlotsStaff.PTISessionSlotSeq
PTInterviewSessionSlots.PTISessionSlotSeq
Restrict delete
FK_PTInterviewSessionSlotsStaff_PTInterviewsSeq
PTInterviewSessionSlotsStaff.PTInterviewsSeq
PTInterviews.PTInterviewsSeq
Restrict delete
FK_OnlineImportContacts_OnlineImportApplications
OnlineImportContacts.OnlineImportApplicationsSeq
OnlineImportApplications.OnlineImportApplicationsSeq
Restrict delete
FK_VSNBatchStudents_StudentStatic
VSNBatchStudents.ID
StudentStatic.ID
Restrict delete
FK_VSNBatchStudents_VSNBatches
VSNBatchStudents.VSNBatchesSeq
VSNBatches.VSNBatchesSeq
Restrict delete
FK_StaffExternalDetails_StaffExternalDetailsDefinitions
StaffExternalDetails.StaffExternalDetailsDefinitionsSeq
StaffExternalDetailsDefinitions.StaffExternalDetailsDefinitionsSeq
Restrict delete
FK_MedicalRisk_MedicalConditionSeq_MedicalCondition_MedicalConditionSeq
MedicalRisk.MedicalConditionSeq
MedicalCondition.MedicalConditionSeq
Restrict delete
FK_ConfigGroupSecurity_SynDatabases
ConfigGroupSecurity.SynDatabaseCode
SynDatabases.Code
Restrict delete
FK_MedicalSymptom_MedicalConditionSeq_MedicalCondition_MedicalConditionSeq
MedicalSymptom.MedicalConditionSeq
MedicalCondition.MedicalConditionSeq
Restrict delete
FK_JobPositionNotifications_Community
JobPositionNotifications.ID
Community.ID
Restrict delete
FK_JobPositionNotifications_JobPositions
JobPositionNotifications.JobPositionsSeq
JobPositions.JobPositionsSeq
Restrict delete
FK_PastStudentClasses_CommunityID
PastStudentClasses.CommPortalPrintID
Community.ID
Restrict delete
FK_SubscribersObjectsRelation_SubscribersObjectsSeq_SubscribersObjects
SubscribersObjectsRelation.SubscribersObjectsSeq
SubscribersObjects.SubscribersObjectsSeq
Restrict delete
FK_SubscribersObjectsRelation_SubscribersObjectsDependeeSeq_SubscribersObjects
SubscribersObjectsRelation.SubscribersObjectsDependeeSeq
SubscribersObjects.SubscribersObjectsSeq
Restrict delete
FK_MembershipRule_MembershipType
MembershipRule.MembershipTypeSeq
MembershipType.MembershipTypeSeq
Restrict delete
FK_OnlinePaymentOptionLevelTwo_OnlinePaymentOptionLevelOneSeq
OnlinePaymentOptionLevelTwo.OnlinePaymentOptionLevelOneSeq
OnlinePaymentOptionLevelOne.OnlinePaymentOptionLevelOneSeq
Restrict delete
FK_OnlinePaymentOptionLevelTwo_OnlinePaymentMerchantsSeq
OnlinePaymentOptionLevelTwo.OnlinePaymentMerchantsSeq
OnlinePaymentMerchants.OnlinePaymentMerchantsSeq
Restrict delete
FK_CommunityEventsAttributes_Community
CommunityEventsAttributes.ID
Community.ID
Restrict delete
FK_CommunityEventsAttributes_EventAttributes
CommunityEventsAttributes.EventAttributesSeq
EventAttributes.EventAttributesSeq
Restrict delete
FK_CourseAgentCommissionRules_CourseAgentCommissionControl
CourseAgentCommissionRules.CourseAgentCommissionControlSeq
CourseAgentCommissionControl.CourseAgentCommissionControlSeq
Restrict delete
FK_SubjectAssessmentVELSStrands_SubjectAssessmentCurriculum
SubjectAssessmentVELSStrands.SubjectAssessmentCurriculumSeq
SubjectAssessmentCurriculum.SubjectAssessmentCurriculumSeq
Restrict delete
FK_ParentStaffScheduleSeq_StaffScheduleSeq
StaffSchedule.ParentStaffScheduleSeq
StaffSchedule.StaffScheduleSeq
Restrict delete
FK_StaffSchedule_TimesheetsSeq_Timesheets_TimesheetsSeq
StaffSchedule.TimesheetsSeq
Timesheets.TimesheetsSeq
Restrict delete
FK_SubjectClasses_StaffSchedule
StaffSchedule.SubjectClassesSeq
SubjectClasses.SubjectClassesSeq
Restrict delete
FK_StaffSchedule_SystemProcessControl
StaffSchedule.SystemProcessNumber
SystemProcessControl.SystemProcessNumber
Restrict delete
FK_PastStudents_Community
PastStudents.ID
Community.ID
Restrict delete
FK_CommunityEventsTickets_EventsSeq
CommunityEventsTickets.EventsSeq
Events.EventsSeq
Restrict delete
FK_StaffExternalTests_ExternalTests
StaffExternalTests.ExternalTestsSeq
ExternalTests.ExternalTestsSeq
Restrict delete
FK_StaffExternalTests_Community
StaffExternalTests.StaffID
Community.ID
Restrict delete
FK_CommunitySkills_Community
CommunitySkills.ID
Community.ID
Restrict delete
FK_StudentCourses_PriorStudentCoursesSeq
StudentCourses.PriorStudentCoursesSeq
StudentCourses.StudentCoursesSeq
Restrict delete
FK_StudentCourses_CourseAgentCommissionControl
StudentCourses.CourseAgentCommissionControlSeq
CourseAgentCommissionControl.CourseAgentCommissionControlSeq
Restrict delete
FK_StudentCourses_Community
StudentCourses.CommissionAuthorisedID
Community.ID
Restrict delete
FK_StudentCourses_Community_AgentID
StudentCourses.AgentID
Community.ID
Restrict delete
FK_StudentCourses_Courses
StudentCourses.CoursesSeq
Courses.CoursesSeq
Restrict delete
FK_StudentCourses_ID
StudentCourses.ID
Community.ID
Restrict delete
FK_Timesheets_StaffId_Staff_Id
Timesheets.StaffID
Staff.ID
Restrict delete
FK_EventConsents_Events
EventConsents.EventsSeq
Events.EventsSeq
Restrict delete
FK_OnlineImportApplicationsCustom_OnlineImportApplications
OnlineImportApplicationsCustom.OnlineImportApplicationsSeq
OnlineImportApplications.OnlineImportApplicationsSeq
Restrict delete
FK_OnlineImportStudents_OnlineImportApplications
OnlineImportStudents.OnlineImportApplicationsSeq
OnlineImportApplications.OnlineImportApplicationsSeq
Restrict delete
FK_PastStudentsOriginal_PastStudents
PastStudentsOriginal.ID
PastStudents.ID
Restrict delete
FK_EventMedicalCondition_Events
EventMedicalCondition.EventsSeq
Events.EventsSeq
Restrict delete
FK_SubjectAssessmentVELSDomains_SubjectAssessmentVELSStrands
SubjectAssessmentVELSDomains.SubjectAssessmentVELSStrandsSeq
SubjectAssessmentVELSStrands.SubjectAssessmentVELSStrandsSeq
Restrict delete
FK_SifTeachingGroupSubscriberEvent_SubscriberEvents
SifTeachingGroupSubscriberEvent.SubscriberEventsSeq
SubscriberEvents.SubscriberEventsSeq
Restrict delete
FK_PTInterviewSessionStaff_PTInterviewSessions
PTInterviewSessionStaff.PTISessionSeq
PTInterviewSessions.PTISessionSeq
Restrict delete
FK_MedicalPlanMedication_MedicalPlanSeq_MedicalPlan_MedicalPlanSeq
MedicalPlanMedication.MedicalPlanSeq
MedicalPlan.MedicalPlanSeq
Restrict delete
FK_MedicalPlanMedication_MedicationSeq_Medication_MedicationSeq
MedicalPlanMedication.MedicationSeq
Medication.MedicationSeq
Restrict delete
FK_Communications_CommunicationTypeCode
Communications.CommunicationTypeCode
CommunicationTypes.CommunicationTypeCode
Restrict delete
FK_ObjectBookingSubjectClasses_ObjectBookings
ObjectBookingSubjectClasses.ObjectBookingsSeq
ObjectBookings.ObjectBookingsSeq
Restrict delete
FK_EventOrganisers_Events
EventOrganisers.EventCode
Events.EventCode
Restrict delete
FK_StaffLearningAreas_Staff
StaffLearningAreas.ID
Staff.ID
Restrict delete
FK_StaffAppraisals_Staff
StaffAppraisals.ID
Staff.ID
Restrict delete
FK_CommunityMembership_Community
CommunityMembership.ID
Community.ID
Restrict delete
FK_CommunityMembership_MembershipType
CommunityMembership.MembershipTypeSeq
MembershipType.MembershipTypeSeq
Restrict delete
FK_TagListCommunity_Community
TagListCommunity.ID
Community.ID
Restrict delete
FK_TagListCommunity_TagLists
TagListCommunity.TagListsSeq
TagLists.TagListsSeq
Restrict delete
FK_Staff_Community
Staff.ID
Community.ID
Restrict delete
FK_CommunityEventsCurrent_Community
CommunityEventsCurrent.ID
Community.ID
Restrict delete
FK_CommunityEventsCurrent_Events
CommunityEventsCurrent.EventCode
Events.EventCode
Restrict delete
FK_StudentExternalTestResults_StudentExternalTests
StudentExternalTestResults.StudentExternalTestsSeq
StudentExternalTests.StudentExternalTestsSeq
Restrict delete
FK_VSNBatches_SystemProcessControl
VSNBatches.SystemProcessNumber
SystemProcessControl.SystemProcessNumber
Restrict delete
FK_EventApprovalProcessActivity_Events
EventApprovalProcessActivity.EventsSeq
Events.EventsSeq
Restrict delete
FK_CommunityEventsGuests_Events_EventCode
CommunityEventsGuests.EventCode
Events.EventCode
Restrict delete
FK_CommunityEventsGuests_Community_GuestID
CommunityEventsGuests.GuestID
Community.ID
Restrict delete
FK_FutureStudents_Community
FutureStudents.ID
Community.ID
Restrict delete
FK_ObjectTaskActivities_Community_FollowUpID
ObjectTaskActivities.FollowUpID
Community.ID
Restrict delete
FK_ObjectTaskActivities_ObjectTasks
ObjectTaskActivities.ObjectTasksSeq
ObjectTasks.ObjectTasksSeq
Restrict delete
FK_PTInterviewSessionYearLevels_PTInterviewSessions
PTInterviewSessionYearLevels.PTISessionSeq
PTInterviewSessions.PTISessionSeq
Restrict delete
FK_SubscribersObjectsColumns_SubscribersObjects
SubscribersObjectsColumns.SubscribersObjectsSeq
SubscribersObjects.SubscribersObjectsSeq
Restrict delete
FK_StaffScheduleDefinitionDays_Staff
StaffScheduleDefinitionDays.StaffID
Staff.ID
Restrict delete
FK_CommunityCitizenships_Community
CommunityCitizenships.ID
Community.ID
Restrict delete
FK_StaffScheduleStudentClasses_Community
StaffScheduleStudentClasses.ID
Community.ID
Restrict delete
FK_StaffScheduleStudentClasses_SubjectClasses_SubjectClassesSeq
StaffScheduleStudentClasses.SubjectClassesSeq
SubjectClasses.SubjectClassesSeq
Restrict delete
FK_StaffScheduleStudentClasses_StaffSchedule
StaffScheduleStudentClasses.StaffScheduleSeq
StaffSchedule.StaffScheduleSeq
Restrict delete
FK_ActionUserSubscriptionPreferences_ID_Community_ID
ActionUserSubscriptionPreferences.ID
Community.ID
Restrict delete
FK_SynAnalyticsApplication_SynAnalyticsSeq
SynAnalyticsApplication.SynAnalyticsSeq
SynAnalytics.Seq
Restrict delete
FK_JobPositionsConfigGroup_JobPositions
JobPositionsConfigGroup.JobPositionsSeq
JobPositions.JobPositionsSeq
Restrict delete
FK_ActionMessageSubscriber_ActionMessageSeq_ActionMessage_ActionMessageSeq
ActionMessageSubscriber.ActionMessageSeq
ActionMessage.ActionMessageSeq
Restrict delete
FK_PTInterviewSessionSlotStaffNotAvail_PTInterviewSessionSlots
PTInterviewSessionSlotStaffNotAvail.PTISessionSlotSeq
PTInterviewSessionSlots.PTISessionSlotSeq
Restrict delete
FK_ReceiptsOnline_OnlinePaymentMerchantsSeq
ReceiptsOnline.OnlinePaymentMerchantsSeq
OnlinePaymentMerchants.OnlinePaymentMerchantsSeq
Restrict delete
FK_CommunityCheck_Community
CommunityCheck.ID
Community.ID
Restrict delete
FK_CommunityCheck_Community_VerifiedByID
CommunityCheck.VerifiedByID
Community.ID
Restrict delete
FK_ObjectTasks_Community_AllocatedToID
ObjectTasks.AllocatedToID
Community.ID
Restrict delete
FK_ObjectTasks_Community_InitiatedByID
ObjectTasks.InitiatedByID
Community.ID
Restrict delete
FK_ObjectTasks_Objects
ObjectTasks.ObjectNumber
Objects.ObjectNumber
Restrict delete
FK_ActionMessage_ActionedByUserID_Community_ID
ActionMessage.ActionedByUserID
Community.ID
Restrict delete
FK_ActionMessage_TasksSeq_Tasks_TasksSeq
ActionMessage.TasksSeq
Tasks.TasksSeq
Restrict delete
FK_ActionMessage_TargetUserID_Community_ID
ActionMessage.TargetUserID
Community.ID
Restrict delete
FK_ActionMessage_MessageTypeCode_ActionMessageType_Code
ActionMessage.MessageTypeCode
ActionMessageType.Code
Restrict delete
FK_CommunityAddressLinks_Community
CommunityAddressLinks.ID
Community.ID
Restrict delete
FK_CommunityAddressLinks_CommunityAddresses
CommunityAddressLinks.CommunityAddressesSeq
CommunityAddresses.CommunityAddressesSeq
Restrict delete
FK_StaffComments_Staff
StaffComments.ID
Staff.ID
Restrict delete
FK_PastoralCareActions_PastoralCare
PastoralCareActions.PastoralCareSeq
tPastoralCare.PastoralCareSeq
Restrict delete
FK_SubjectClasses_MasterClassCode
SubjectClasses.FileType
SubjectClasses.FileYear
SubjectClasses.FileSemester
SubjectClasses.ClassCampus
SubjectClasses.MasterClassCode
SubjectClasses.FileType
SubjectClasses.FileYear
SubjectClasses.FileSemester
SubjectClasses.ClassCampus
SubjectClasses.ClassCode
Restrict delete
FK_MedicalEquipment_MedicalConditionSeq_MedicalCondition_MedicalConditionSeq
MedicalEquipment.MedicalConditionSeq
MedicalCondition.MedicalConditionSeq
Restrict delete
FK_wkAttendances_wkAttendanceMaster
wkAttendances.wkAttendanceMasterSeq
wkAttendanceMaster.wkAttendanceMasterSeq
Restrict delete
FK_AbsenceEvents_CommunityID
AbsenceEvents.ID
Community.ID
Restrict delete
FK_SchoolLOTEYear_luLOTE
SchoolLOTEYear.LOTECode
SchoolLOTE.Code
Restrict delete
FK_AttendanceMaster_SeqLinkedTo
AttendanceMaster.SeqLinkedTo
AttendanceMaster.AttendanceMasterSeq
Restrict delete
FK_CommunityAlerts_ID_Community
CommunityAlerts.ID
Community.ID
Restrict delete
FK_EventMembershipType_MembershipType
EventMembershipType.MembershipTypeSeq
MembershipType.MembershipTypeSeq
Restrict delete
FK_EventMembershipType_Events
EventMembershipType.EventsSeq
Events.EventsSeq
Restrict delete
FK_WebServiceMethodVersions_WebServiceMethods_WebServiceMethodsSeq
WebServiceMethodVersions.WebServiceMethodsSeq
WebServiceMethods.WebServiceMethodsSeq
Restrict delete
FK_Objects_InsurancePolicies
Objects.InsurancePoliciesSeq
InsurancePolicies.InsurancePoliciesSeq
Restrict delete
FK_Objects_ObjectTypes
Objects.ObjectTypesSeq
ObjectTypes.ObjectTypesSeq
Restrict delete
FK_Objects_SystemProcessControl
Objects.SystemProcessNumber
SystemProcessControl.SystemProcessNumber
Restrict delete
FK_Objects_Community_ResponsibleID
Objects.ResponsibleID
Community.ID
Restrict delete
FK_Objects_Objects
Objects.ParentObjectNumber
Objects.ObjectNumber
Restrict delete
FK_Objects_Community_LoanedToID
Objects.LoanedToID
Community.ID
Restrict delete
FK_FileSemestersElectiveGroup_FileSemesters
FileSemestersElectiveGroup.FileSemestersSeq
FileSemesters.FileSemestersSeq
Restrict delete
FK_CommunityCommuniationMethods_CommunicationTypes
CommunityCommuniationMethods.CommunicationTypeCode
CommunicationTypes.CommunicationTypeCode
Restrict delete
FK_CommunityCommuniationMethods_Community
CommunityCommuniationMethods.ID
Community.ID
Restrict delete
FK_CommunityLoginsPage_ID_Community_ID
CommunityLoginsPage.ID
Community.ID
Restrict delete
FK_CommunityLoginsPage_ConfigSeq_Config_ConfigSeq
CommunityLoginsPage.ConfigSeq
tConfig.ConfigSeq
Restrict delete
FK_EventImmunisation_EventsSeq
EventImmunisation.EventsSeq
Events.EventsSeq
Restrict delete
FK_AccessLog_Community
AccessLog.ID
Community.ID
Restrict delete
FK_AccessLog_Config
AccessLog.ConfigSeq
tConfig.ConfigSeq
Restrict delete
FK_ActionUserPreferences_ID_Community_ID
ActionUserPreferences.ID
Community.ID
Restrict delete
FK_CommunityKeys_Keys
CommunityKeys.KeyCode
Keys.KeyCode
Restrict delete
FK_CommunityKeys_Community
CommunityKeys.ID
Community.ID
Restrict delete
FK_OnlineEditorPublishedForms_OnlineEditorPage
OnlineEditorPublishedForms.OnlineEditorPageSeq
OnlineEditorPage.OnlineEditorPageSeq
Restrict delete
FK_CommunityQualifications_Community
CommunityQualifications.ID
Community.ID
Restrict delete
FK_ObjectBookings_Community_BookedByID
ObjectBookings.BookedByID
Community.ID
Restrict delete
FK_ObjectBookings_Community_BorrowerID
ObjectBookings.BorrowerID
Community.ID
Restrict delete
FK_ObjectBookings_Objects
ObjectBookings.ObjectNumber
Objects.ObjectNumber
Restrict delete
FK_ObjectBookings_ObjectBookingsUnallocated
ObjectBookings.ObjectBookingsUnallocatedSeq
ObjectBookingsUnallocated.ObjectBookingsUnallocatedSeq
Restrict delete
FK_Events_AbsenceEventsSystemProcessNumber
Events.AbsenceEventsSystemProcessNumber
SystemProcessControl.SystemProcessNumber
Restrict delete
FK_Events_OnlinePaymentOptionLevelThreeSeq
Events.OnlinePaymentOptionLevelThreeSeq
OnlinePaymentOptionLevelThree.OnlinePaymentOptionLevelThreeSeq
Restrict delete
FK_PastoralCare_Community
tPastoralCare.ID
Community.ID
Restrict delete
FK_PastoralCare_SubjectClasses
tPastoralCare.SubjectClassesSeq
SubjectClasses.SubjectClassesSeq
Restrict delete
FK_MedicalConditionAllergy_MedicalConditionSeq_MedicalCondition_MedicalConditionSeq
MedicalConditionAllergy.MedicalConditionSeq
MedicalCondition.MedicalConditionSeq
Restrict delete
FK_MedicalConditionAllergy_MedicalAllergySeq_MedicalAllergy_MedicalAllergySeq
MedicalConditionAllergy.MedicalAllergySeq
MedicalAllergy.MedicalAllergySeq
Restrict delete
FK_EventAppointment_Events
EventAppointment.EventsSeq
Events.EventsSeq
Restrict delete
FK_EventAppointment_StaffSchedule
EventAppointment.StaffScheduleSeq
StaffSchedule.StaffScheduleSeq
Restrict delete
FK_ObjectTypeCategoryAttributes_ObjectTypes
ObjectTypeCategoryAttributes.ObjectTypesSeq
ObjectTypes.ObjectTypesSeq
Restrict delete
FK_ObjectTypeCategoryAttributes_ObjectTypeAttributes
ObjectTypeCategoryAttributes.ObjectTypeAttributesSeq
ObjectTypeAttributes.ObjectTypeAttributesSeq
Restrict delete
FK_SifStaffAssignmentSubscriberEvent_SubscriberEvents
SifStaffAssignmentSubscriberEvent.SubscriberEventsSeq
SubscriberEvents.SubscriberEventsSeq
Restrict delete
FK_FutureStudentContacts_ID_Community
FutureStudentContacts.ID
Community.ID
Restrict delete
FK_FutureStudentContacts_FutureStudents
FutureStudentContacts.ID
FutureStudents.ID
Restrict delete
FK_FutureStudentContacts_LinkedID_Community
FutureStudentContacts.LinkedID
Community.ID
Restrict delete
FK_SifStudentPersonalSubscriberEvent_SubscriberEvents
SifStudentPersonalSubscriberEvent.SubscriberEventsSeq
SubscriberEvents.SubscriberEventsSeq
Restrict delete
FK_SubjectClassStaff_Community
SubjectClassStaff.StaffID
Community.ID
Restrict delete
FK_SubjectClassStaff_SystemProcessControl
SubjectClassStaff.SystemProcessNumber
SystemProcessControl.SystemProcessNumber
Restrict delete
FK_wkTimesheetsImport_Staff_Staff_ID
wkTimesheetsImport.StaffID
Staff.ID
Restrict delete
FK_MedicalConditionMedication_MedicalConditionSeq_MedicalCondition_MedicalConditionSeq
MedicalConditionMedication.MedicalConditionSeq
MedicalCondition.MedicalConditionSeq
Restrict delete
FK_MedicalConditionMedication_MedicationSeq_Medication_MedicationSeq
MedicalConditionMedication.MedicationSeq
Medication.MedicationSeq
Restrict delete
FK_Transport_Community
Transport.ID
Community.ID
Restrict delete
FK_FutureStudentApplications_FutureStudents
FutureStudentApplications.ID
FutureStudents.ID
Restrict delete
FK_TimetableSchedule_TimetableConfig
TimetableSchedule.TimetableConfigSeq
TimetableConfig.TimetableConfigSeq
Restrict delete
FK_Students_Community
Students.ID
Community.ID
Restrict delete
FK_FileSemesterFileType_FileSemesters
FileSemesterFileType.FileSemestersSeq
FileSemesters.FileSemestersSeq
Restrict delete
FK_JobPositions_ReportsToJobPositionsSeq
JobPositions.ReportsToJobPositionsSeq
JobPositions.JobPositionsSeq
Restrict delete
FK_SifStaffPersonalSubscriberEvent_SubscriberEvents
SifStaffPersonalSubscriberEvent.SubscriberEventsSeq
SubscriberEvents.SubscriberEventsSeq
Restrict delete
FK_CourseStaff_Courses
CourseStaff.CoursesSeq
Courses.CoursesSeq
Restrict delete
FK_CourseStaff_Staff
CourseStaff.StaffID
Staff.ID
Restrict delete

Check Constraints

Table Constraint Name Constraint
None detected