Constraints

82 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
FK_daeb36ac964ae20d5a58b1b2353
School.districtsId
Districts.id
Restrict delete
FK_Effectiveness_subjectId
Effectiveness.subjectId
subjects.id
Restrict delete
FK_Effectiveness_userId
Effectiveness.userId
User.id
Restrict delete
FK_Effectiveness_schoolCode
Effectiveness.schoolCode
School.code
Restrict delete
FK_Effectiveness_teacherId
Effectiveness.teacherId
Teacher.id
Restrict delete
FK_06811985933bb90dd6f98a317b6
events.reportId
reports.id
Restrict delete
FK_9929fa8516afa13f87b41abb263
events.userId
User.id
Restrict delete
FK_d1dad46ef5ac6788442c8d32279
events.gradeId
grades.id
Restrict delete
FK_3615e205b9e3e26996906b9c3d1
events.classroomId
classrooms.id
Restrict delete
FK_d34b052f17ba7e1af21ba110bb2
events.calendarId
calendars.id
Restrict delete
FK_76485912ad5e9af8f0a70a46e76
events.schoolCode
School.code
Restrict delete
FK_c5bdb62f805eceeabab7273ef3b
events.subjectId
subjects.id
Restrict delete
FK_QuizDriveConfig_configuredBy
QuizDriveConfig.configuredBy
User.id
Restrict delete
FK_QuizDriveConfig_subjectId
QuizDriveConfig.subjectId
subjects.id
Restrict delete
FK_d693edac097c54cb3bde49d0119
school-teachers_groups_groups.schoolTeachersId
school-teachers.id
Cascade on delete
FK_6a72045ef08abb7ec321875b2ba
school-teachers_groups_groups.groupsId
groups.id
Restrict delete
FK_52219a0a9c667f5b21b10d2169a
UserSchool.schoolCode
School.code
Restrict delete
FK_6a57d79418374df03b809d2a851
UserSchool.userId
User.id
Restrict delete
FK_bed415cd29716cd707e9cb3c09c
reports.userId
User.id
Restrict delete
FK_35b19c8d3af2b077bee7630ea66
Response.sectionId
Section.id
Restrict delete
FK_539193c947fe9372ff936f1d324
Response.code
School.code
Restrict delete
FK_2101124c38bb8f8641c5afb8445
Response.eventId
events.id
Restrict delete
FK_138d95ccc80d80ef980d6da05f4
Response.teacherId
Teacher.id
Restrict delete
FK_58248223824814237f1405a8be5
Response.tutorId
User.id
Restrict delete
FK_960a185f4e70bc375f399e90b20
Response.instrumentId
Instrument.id
Restrict delete
FK_6677f5fdb30ac4e2e65bfe7dbb4
CoachingSession.tutorId
User.id
Restrict delete
FK_cef81ec5bef28760e9d15a74caf
CoachingSession.teacherId
Teacher.id
Restrict delete
FK_790b1c60bbcea0c2b0ce6f3b8b5
CoachingSession.responseId
Response.id
Restrict delete
role_modules_roleId_fkey
role_modules.roleId
Role.id
Cascade on delete
role_modules_moduleId_fkey
role_modules.moduleId
modules.id
Cascade on delete
FK_b0daee34afe516a1b74d80c20b9
file-processing-enquequed-jobs.userId
User.id
Restrict delete
FK_ea22bf3c6b069755e01340f6334
classrooms.teacherId
Teacher.id
Restrict delete
FK_ConnectivityIncident_schoolCode
ConnectivityIncident.schoolCode
School.code
Restrict delete
FK_ConnectivityIncident_createdBy
ConnectivityIncident.createdBy
User.id
Restrict delete
FK_QuizWeeklyAssignment_quizId
QuizWeeklyAssignment.quizId
Quiz.id
Restrict delete
FK_QuizWeeklyAssignment_teacherId
QuizWeeklyAssignment.teacherId
Teacher.id
Restrict delete
FK_ConnectivityIncidentPerson_createdBy
ConnectivityIncidentPerson.createdBy
User.id
Restrict delete
FK_ConnectivityIncidentPerson_schoolCode
ConnectivityIncidentPerson.schoolCode
School.code
Restrict delete
FK_dad4319e832bfe170ac53f7c824
user-schedules.userId
User.id
Restrict delete
FK_RemediationRecord_teacherId
RemediationRecord.teacherId
Teacher.id
Restrict delete
FK_RemediationRecord_createdBy
RemediationRecord.createdBy
User.id
Restrict delete
FK_RemediationRecord_schoolCode
RemediationRecord.schoolCode
School.code
Restrict delete
FK_RemediationRecord_subjectId
RemediationRecord.subjectId
subjects.id
Restrict delete
FK_621ce3ab9903b8ede17762843e2
TeacherAssignmentSections.courseId
courses.id
Restrict delete
FK_6681787c55e00c8d63617075101
user-teaching-hours.userId
User.id
Restrict delete
FK_82bae6b80fe6239e9cf6f1243b9
TeacherSection.userId
User.id
Restrict delete
FK_f1a12ee29a6913654469d254d71
TeacherSection.eventId
events.id
Restrict delete
FK_c42b1527051617efca6499d5444
TeacherSection.sectionId
Section.id
Restrict delete
FK_32176b33361fa600152809ceb4f
TeacherSection.teacherId
Teacher.id
Restrict delete
FK_fcaa387786b6f332e09df01e61a
teacher-assignment.teacherAssignmentSectionsId
TeacherAssignmentSections.id
Restrict delete
FK_215538125bfbdb8fe88a5dca502
teacher-assignment.teacherSchoolId
school-teachers.id
Restrict delete
FK_985dcf300475c9944164020a337
comments.reportId
reports.id
Cascade on delete
FK_7e8d7c49f218ebb14314fdb3749
comments.userId
User.id
Cascade on delete
FK_8d4538a65cf6a1d74fd7166e202
user-teaching-days.userId
User.id
Restrict delete
FK_335d9e9af743fe91668b8f0d6fd
calendars.userId
User.id
Restrict delete
FK_Modeling_subjectId
Modeling.subjectId
subjects.id
Restrict delete
FK_Modeling_teacherId
Modeling.teacherId
Teacher.id
Restrict delete
FK_Modeling_gradeId
Modeling.gradeId
grades.id
Restrict delete
FK_Modeling_schoolCode
Modeling.schoolCode
School.code
Restrict delete
FK_Modeling_createdBy
Modeling.createdBy
User.id
Restrict delete
FK_1516d30a8d534c566e184f3364e
TutorTeacher.userId
User.id
Cascade on delete
FK_da73601ca1d3c6f2787697475b5
TutorTeacher.teacherId
Teacher.id
Cascade on delete
FK_0be2244afbbc2cdc5960b30b555
VirtualSesions.tutorId
User.id
Restrict delete
FK_1e3dbd9c40caf1e5c1f2310f13e
event-teacher.eventId
events.id
Restrict delete
FK_435a1e4bbfefb5654d6802543a3
event-teacher.teacherId
Teacher.id
Restrict delete
FK_e2b16d2d170e1e994c4ed5f9476
user_courses.userId
User.id
Cascade on delete
FK_e49f8af9cda3a22a92d67973af0
user_courses.courseId
courses.id
Restrict delete
FK_0b8c60cc29663fa5b9fb108edd7
User.roleId
Role.id
Restrict delete
FK_809dc6aebab470e58d14e532b53
InfoTutores.districtId
Districts.id
Restrict delete
FK_6b7a48ff759b668d7242e3b4967
InfoTutores.userId
User.id
Restrict delete
Quiz_subjectId_fkey
Quiz.subjectId
subjects.id
Restrict delete
FK_457228c8142066812702ab4103a
resource-changelog.authorId
User.id
Restrict delete
FK_7a4be1bb214006a7f440c250235
resource-changelog.changeTypeId
changeType.id
Restrict delete
FK_ModelingMomentHistory_modelingId
ModelingMomentHistory.modelingId
Modeling.id
Cascade on delete
FK_ModelingMomentHistory_gradeId
ModelingMomentHistory.gradeId
grades.id
Restrict delete
FK_ModelingMomentHistory_schoolCode
ModelingMomentHistory.schoolCode
School.code
Restrict delete
FK_ModelingMomentHistory_subjectId
ModelingMomentHistory.subjectId
subjects.id
Restrict delete
FK_f8d475ff3e396f8767dd6dd3509
school-teachers.schoolCode
School.code
Restrict delete
FK_212f459be55fd54bda058a6cac6
school-teachers.teacherId
Teacher.id
Restrict delete
FK_d03709a9095936a8fc94fa08008
courses.gradeId
grades.id
Restrict delete
FK_4fc71ca03df7fa563050d553c39
courses.subjectId
subjects.id
Restrict delete
FK_4c2deec750f9c9a46fd481b15b7
Section.schoolCode
School.code
Restrict delete

Check Constraints

Table Constraint Name Constraint