Constraints

129 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
quizAttemptResponses_companyId_fkey
quizAttemptResponses.companyId
companies.id
Cascade on delete
quizAttemptResponses_quizAttemptId_fkey
quizAttemptResponses.quizAttemptId
quizAttempts.id
Cascade on delete
quizAttemptResponses_topicId_fkey
quizAttemptResponses.topicId
topics.id
Cascade on delete
quizAttemptResponses_userId_fkey
quizAttemptResponses.userId
users.id
Cascade on delete
quizAttemptResponses_courseId_fkey
quizAttemptResponses.courseId
courses.id
Cascade on delete
quizAttemptResponses_questionId_fkey
quizAttemptResponses.questionId
questions.id
Cascade on delete
userLicenses_companyId_fkey
userLicenses.companyId
companies.id
Cascade on delete
userLicenses_licenseId_fkey
userLicenses.licenseId
licenses.id
Cascade on delete
userLicenses_userId_fkey
userLicenses.userId
users.id
Cascade on delete
ltiAttempts_companyId_fkey
ltiAttempts.companyId
companies.id
Cascade on delete
ltiAttempts_userId_fkey
ltiAttempts.userId
users.id
Cascade on delete
ltiAttempts_courseId_fkey
ltiAttempts.courseId
courses.id
Cascade on delete
ltiAttempts_topicId_fkey
ltiAttempts.topicId
topics.id
Cascade on delete
sections_courseId_fkey
sections.courseId
courses.id
Cascade on delete
sections_companyId_fkey
sections.companyId
companies.id
Cascade on delete
redemptionCodeGroups_companyId_fkey
redemptionCodeGroups.companyId
companies.id
Cascade on delete
discountGroupTags_discountGroupId_fkey
discountGroupTags.discountGroupId
discountGroups.id
Cascade on delete
discountGroupTags_tagId_fkey
discountGroupTags.tagId
tags.id
Cascade on delete
discountGroupTags_companyId_fkey
discountGroupTags.companyId
companies.id
Cascade on delete
assignmentSubmissions_userId_fkey
assignmentSubmissions.userId
users.id
Cascade on delete
quizAttemptResponses_assignmentId_fkey
assignmentSubmissions.assignmentId
topics.id
Cascade on delete
assignmentSubmissions_companyId_fkey
assignmentSubmissions.companyId
companies.id
Cascade on delete
assignmentSubmissions_courseId_fkey
assignmentSubmissions.courseId
courses.id
Cascade on delete
courseGroups_companyId_fkey
courseGroups.companyId
companies.id
Cascade on delete
productTags_companyId_fkey
productTags.companyId
companies.id
Cascade on delete
productTags_productId_fkey
productTags.productId
products.id
Cascade on delete
productTags_tagId_fkey
productTags.tagId
tags.id
Cascade on delete
bundleTags_bundleId_fkey
bundleTags.bundleId
bundles.id
Cascade on delete
bundleTags_companyId_fkey
bundleTags.companyId
companies.id
Cascade on delete
bundleTags_tagId_fkey
bundleTags.tagId
tags.id
Cascade on delete
onboardingSurveyResponses_onboardingSurveyId_fkey
onboardingSurveyResponses.onboardingSurveyId
onboardingSurveys.id
Cascade on delete
onboardingSurveyResponses_userId_fkey
onboardingSurveyResponses.userId
users.id
Cascade on delete
onboardingSurveyResponses_companyId_fkey
onboardingSurveyResponses.companyId
companies.id
Cascade on delete
licenses_parentLicense_fkey
licenses.parentLicense
licenses.id
Cascade on delete
licenses_companyId_fkey
licenses.companyId
companies.id
Cascade on delete
licenses_clientId_fkey
licenses.clientId
clients.id
Cascade on delete
awardTypes_companyId_fkey
awardTypes.companyId
companies.id
Cascade on delete
courseGroupCustomFields_courseGroupId_fkey
courseGroupCustomFields.courseGroupId
courseGroups.id
Cascade on delete
courseGroupCustomFields_companyId_fkey
courseGroupCustomFields.companyId
companies.id
Cascade on delete
redemptionCodes_redemptionCodeGroupId_fkey
redemptionCodes.redemptionCodeGroupId
redemptionCodeGroups.id
Cascade on delete
redemptionCodes_companyId_fkey
redemptionCodes.companyId
companies.id
Cascade on delete
certificates_userId_fkey
certificates.userId
users.id
Cascade on delete
certificates_companyId_fkey
certificates.companyId
companies.id
Cascade on delete
courseActions_userId_fkey
courseActions.userId
users.id
Cascade on delete
courseActions_companyId_fkey
courseActions.companyId
companies.id
Cascade on delete
courseActions_courseId_fkey
courseActions.courseId
courses.id
Cascade on delete
waitlists_courseId_fkey
waitlists.courseId
courses.id
Cascade on delete
waitlists_companyId_fkey
waitlists.companyId
companies.id
Cascade on delete
waitlists_userId_fkey
waitlists.userId
users.id
Cascade on delete
milestoneCourses_courseGroupId_fkey
milestoneCourses.courseGroupId
courseGroups.id
Cascade on delete
milestoneCourses_courseId_fkey
milestoneCourses.courseId
courses.id
Cascade on delete
milestoneCourses_milestoneId_fkey
milestoneCourses.milestoneId
milestones.id
Cascade on delete
milestoneCourses_companyId_fkey
milestoneCourses.companyId
companies.id
Cascade on delete
pickableGroups_companyId_fkey
pickableGroups.companyId
companies.id
Cascade on delete
scormAttemptResponses_topicId_fkey
scormAttemptResponses.topicId
topics.id
Cascade on delete
scormAttemptResponses_userId_fkey
scormAttemptResponses.userId
users.id
Cascade on delete
scormAttemptResponses_courseId_fkey
scormAttemptResponses.courseId
courses.id
Cascade on delete
scormAttemptResponses_scormAttemptId_fkey
scormAttemptResponses.scormAttemptId
scormAttempts.id
Cascade on delete
scormAttemptResponses_companyId_fkey
scormAttemptResponses.companyId
companies.id
Cascade on delete
userLearningPaths_companyId_fkey
userLearningPaths.companyId
companies.id
Cascade on delete
userLearningPaths_learningPathId_fkey
userLearningPaths.learningPathId
learningPaths.id
Cascade on delete
userLearningPaths_userId_fkey
userLearningPaths.userId
users.id
Cascade on delete
learningPaths_companyId_fkey
learningPaths.companyId
companies.id
Cascade on delete
products_companyId_fkey
products.companyId
companies.id
Cascade on delete
users_companyId_fkey
users.companyId
companies.id
Cascade on delete
users_clientId_fkey
users.clientId
clients.id
Cascade on delete
tags_companyId_fkey
tags.companyId
companies.id
Cascade on delete
quizAttempts_courseId_fkey
quizAttempts.courseId
courses.id
Cascade on delete
quizAttempts_topicId_fkey
quizAttempts.topicId
topics.id
Cascade on delete
quizAttempts_companyId_fkey
quizAttempts.companyId
companies.id
Cascade on delete
quizAttempts_userId_fkey
quizAttempts.userId
users.id
Cascade on delete
discountGroups_companyId_fkey
discountGroups.companyId
companies.id
Cascade on delete
bundles_companyId_fkey
bundles.companyId
companies.id
Cascade on delete
courseGroupTags_courseGroupId_fkey
courseGroupTags.courseGroupId
courseGroups.id
Cascade on delete
courseGroupTags_companyId_fkey
courseGroupTags.companyId
companies.id
Cascade on delete
courseGroupTags_tagId_fkey
courseGroupTags.tagId
tags.id
Cascade on delete
pickableGroupTags_pickableGroupId_fkey
pickableGroupTags.pickableGroupId
pickableGroups.id
Cascade on delete
pickableGroupTags_tagId_fkey
pickableGroupTags.tagId
tags.id
Cascade on delete
pickableGroupTags_companyId_fkey
pickableGroupTags.companyId
companies.id
Cascade on delete
userBundles_companyId_fkey
userBundles.companyId
companies.id
Cascade on delete
userBundles_bundleId_fkey
userBundles.bundleId
bundles.id
Cascade on delete
userBundles_userId_fkey
userBundles.userId
users.id
Cascade on delete
userCourseProgresses_courseId_fkey
userCourseProgresses.courseId
courses.id
Cascade on delete
userCourseProgresses_userId_fkey
userCourseProgresses.userId
users.id
Cascade on delete
userCourseProgresses_companyId_fkey
userCourseProgresses.companyId
companies.id
Cascade on delete
learningPathActions_companyId_fkey
learningPathActions.companyId
companies.id
Cascade on delete
learningPathActions_milestoneId_fkey
learningPathActions.milestoneId
milestones.id
Cascade on delete
learningPathActions_learningPathId_fkey
learningPathActions.learningPathId
learningPaths.id
Cascade on delete
learningPathActions_userId_fkey
learningPathActions.userId
users.id
Cascade on delete
registrationCodes_companyId_fkey
registrationCodes.companyId
companies.id
Cascade on delete
clientTags_companyId_fkey
clientTags.companyId
companies.id
Cascade on delete
clientTags_tagId_fkey
clientTags.tagId
tags.id
Cascade on delete
clientTags_clientId_fkey
clientTags.clientId
clients.id
Cascade on delete
lessons_courseId_fkey
lessons.courseId
courses.id
Cascade on delete
lessons_companyId_fkey
lessons.companyId
companies.id
Cascade on delete
lessons_sectionId_fkey
lessons.sectionId
sections.id
Cascade on delete
testimonials_courseGroupId_fkey
testimonials.courseGroupId
courseGroups.id
Cascade on delete
testimonials_userId_fkey
testimonials.userId
users.id
Cascade on delete
testimonials_companyId_fkey
testimonials.companyId
companies.id
Cascade on delete
onboardingSurveys_clientId_fkey
onboardingSurveys.clientId
clients.id
Cascade on delete
onboardingSurveys_companyId_fkey
onboardingSurveys.companyId
companies.id
Cascade on delete
userCourses_userId_fkey
userCourses.userId
users.id
Cascade on delete
userCourses_companyId_fkey
userCourses.companyId
companies.id
Cascade on delete
userCourses_courseId_fkey
userCourses.courseId
courses.id
Cascade on delete
awards_companyId_fkey
awards.companyId
companies.id
Cascade on delete
awards_awardTypeId_fkey
awards.awardTypeId
awardTypes.id
Cascade on delete
awards_clientId_fkey
awards.clientId
clients.id
Cascade on delete
awards_userId_fkey
awards.userId
users.id
Cascade on delete
questionChoices_companyId_fkey
questionChoices.companyId
companies.id
Cascade on delete
questionChoices_questionId_fkey
questionChoices.questionId
questions.id
Cascade on delete
scormAttempts_topicId_fkey
scormAttempts.topicId
topics.id
Cascade on delete
scormAttempts_courseId_fkey
scormAttempts.courseId
courses.id
Cascade on delete
scormAttempts_companyId_fkey
scormAttempts.companyId
companies.id
Cascade on delete
scormAttempts_userId_fkey
scormAttempts.userId
users.id
Cascade on delete
learningPathTags_learningPathId_fkey
learningPathTags.learningPathId
learningPaths.id
Cascade on delete
learningPathTags_tagId_fkey
learningPathTags.tagId
tags.id
Cascade on delete
learningPathTags_companyId_fkey
learningPathTags.companyId
companies.id
Cascade on delete
registrationCodeRedemptions_registrationCodeId_fkey
registrationCodeRedemptions.registrationCodeId
registrationCodes.id
Cascade on delete
registrationCodeRedemptions_companyId_fkey
registrationCodeRedemptions.companyId
companies.id
Cascade on delete
milestones_companyId_fkey
milestones.companyId
companies.id
Cascade on delete
milestones_learningPathId_fkey
milestones.learningPathId
learningPaths.id
Cascade on delete
questions_companyId_fkey
questions.companyId
companies.id
Cascade on delete
topics_companyId_fkey
topics.companyId
companies.id
Cascade on delete
topics_courseId_fkey
topics.courseId
courses.id
Cascade on delete
topics_lessonId_fkey
topics.lessonId
lessons.id
Cascade on delete
topics_sectionId_fkey
topics.sectionId
sections.id
Cascade on delete
courses_companyId_fkey
courses.companyId
companies.id
Cascade on delete
courses_courseGroupId_fkey
courses.courseGroupId
courseGroups.id
Cascade on delete
clients_companyId_fkey
clients.companyId
companies.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint