Anomalies


Things that might not be 'quite right' about your database and schema

Columns whose name and type imply a relationship to another table's primary key

Child Column Implied Parent Column
AnnoucementType.[name] SequelizeMeta.[name]
Announcement.[organizationId] Organization.[id]
AnnouncementDetails.[announcementId] Announcement.[id]
AnnouncementDetails.[organizationId] Organization.[id]
AnnouncementDetails.[programId] Program.[id]
AssignmentDetails.[assignmentResourceId] AssignmentResource.[id]
AssignmentDetails.[name] SequelizeMeta.[name]
AssignmentDetails.[sectionId] Section.[id]
AssignmentDetails.[termCourseId] TermCourse.[id]
AssignmentResource.[name] SequelizeMeta.[name]
AssignmentResource.[organizationId] Organization.[id]
BiddingResponse.[termCourseId] TermCourse.[id]
BiddingResponse.[userId] User.[id]
Category.[name] SequelizeMeta.[name]
Category.[organizationId] Organization.[id]
CategoryCourseMaster.[categoryId] Category.[id]
CategoryCourseMaster.[courseMasterId] CourseMaster.[id]
Clubs.[clubTypeId] ClubType.[id]
ClubType.[organizationId] Organization.[id]
CourseBidding.[programId] Program.[id]
CourseClass.[name] SequelizeMeta.[name]
CourseClass.[organizationId] Organization.[id]
CourseDoubtDiscussion.[termCourseId] TermCourse.[id]
CourseDoubtDiscussion.[userId] User.[id]
CourseDoubtDiscussionChat.[courseDoubtDiscussionId] CourseDoubtDiscussion.[id]
CourseDoubtDiscussionChat.[userId] User.[id]
CourseFormat.[courseClassId] CourseClass.[id]
CourseFormat.[courseModeId] CourseMode.[id]
CourseFormat.[courseTagId] CourseTag.[id]
CourseFormat.[courseTypeId] CourseType.[id]
CourseFormat.[programId] Program.[id]
CourseGradingTemplate.[gradingTemplateMasterId] GradingTemplateMaster.[id]
CourseGradingTemplate.[termCourseId] TermCourse.[id]
CourseMaster.[courseClassId] CourseClass.[id]
CourseMaster.[courseModeId] CourseMode.[id]
CourseMaster.[courseTagId] CourseTag.[id]
CourseMaster.[courseTypeId] CourseType.[id]
CourseMaster.[name] SequelizeMeta.[name]
CourseMaster.[organizationId] Organization.[id]
CourseMode.[organizationId] Organization.[id]
CourseSession.[courseMasterId] CourseMaster.[id]
CourseSession.[sectionId] Section.[id]
CourseSession.[termCourseId] TermCourse.[id]
CourseStats.[termCourseId] TermCourse.[id]
CourseStats.[userId] User.[id]
CourseTag.[name] SequelizeMeta.[name]
CourseTag.[organizationId] Organization.[id]
CourseType.[name] SequelizeMeta.[name]
CourseType.[organizationId] Organization.[id]
EmailTemplate.[organizationId] Organization.[id]
Grades.[studentAssignmentId] StudentAssignment.[id]
Grades.[termCourseId] TermCourse.[id]
Grades.[userId] User.[id]
GradingTemplateMaster.[name] SequelizeMeta.[name]
GradingTemplateMaster.[organizationId] Organization.[id]
ItemCategory.[organizationId] Organization.[id]
Notification.[organizationId] Organization.[id]
Notification.[userId] User.[id]
Organization.[name] SequelizeMeta.[name]
OrganizationIntegration.[name] SequelizeMeta.[name]
OrganizationIntegration.[organizationId] Organization.[id]
PlacementLevel.[name] SequelizeMeta.[name]
PlacementLevel.[organizationId] Organization.[id]
PlacementLevelCriteria.[placementLevelId] PlacementLevel.[id]
PlacementLevelCriteria.[programId] Program.[id]
Policy.[organizationId] Organization.[id]
Policy.[resourceId] Resource.[id]
Program.[gradingTemplateMasterId] GradingTemplateMaster.[id]
ProgramMaster.[categoryId] Category.[id]
ProgramMaster.[name] SequelizeMeta.[name]
ProgramMaster.[organizationId] Organization.[id]
ProgramTerm.[programId] Program.[id]
Quiz.[userId] User.[id]
ReachOut.[organizationId] Organization.[id]
Resource.[organizationId] Organization.[id]
Role.[organizationId] Organization.[id]
RolePolicy.[policyId] Policy.[id]
RolePolicy.[resourceId] Resource.[id]
RolePolicy.[roleId] Role.[id]
Section.[name] SequelizeMeta.[name]
Section.[programId] Program.[id]
SectionGroup.[name] SequelizeMeta.[name]
SectionGroup.[sectionId] Section.[id]
SectionGroup.[termCourseId] TermCourse.[id]
SessionDetail.[courseMasterId] CourseMaster.[id]
SessionDetail.[sectionId] Section.[id]
SessionDetail.[termCourseId] TermCourse.[id]
SessionFaculty.[termCourseId] TermCourse.[id]
SessionFaculty.[userId] User.[id]
StudentAssignment.[quizId] Quiz.[id]
StudentAssignment.[userId] User.[id]
TempRecord.[organizationId] Organization.[id]
TempRecord.[termCourseId] TermCourse.[id]
TermCourse.[courseClassId] CourseClass.[id]
TermCourse.[courseMasterId] CourseMaster.[id]
TermCourse.[courseModeId] CourseMode.[id]
TermCourse.[courseTagId] CourseTag.[id]
TermCourse.[courseTypeId] CourseType.[id]
TermCourse.[sectionId] Section.[id]
TermStats.[programId] Program.[id]
TermStats.[userId] User.[id]
User.[organizationId] Organization.[id]
UserBankDetail.[userId] User.[id]
UserCourse.[termCourseId] TermCourse.[id]
UserCourse.[userId] User.[id]
UserEducation.[userId] User.[id]
UserExperience.[userId] User.[id]
UserGroup.[userId] User.[id]
UserLevel.[placementLevelId] PlacementLevel.[id]
UserLevel.[userId] User.[id]
UserProfile.[userId] User.[id]
UserProgram.[programId] Program.[id]
UserProgram.[userId] User.[id]
UserRole.[roleId] Role.[id]
UserRole.[userId] User.[id]
UserSection.[sectionId] Section.[id]
UserSection.[userId] User.[id]
UserVerification.[userId] User.[id]

Tables without indexes

Table Rows
Anomaly not detected

Tables that contain a single column

Table Column
SequelizeMeta name

Tables with incrementing column names, potentially indicating denormalization

Table
Anomaly not detected

Columns whose default value is the word 'NULL' or 'null'

Table
Anomaly not detected