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
AiSummary.[userId] User.[id]
AllyChat.[userId] User.[id]
AnnoucementType.[name] SequelizeMeta.[name]
AnnouncementDetails.[announcementId] Announcement.[id]
AnnouncementDetails.[organizationId] Organization.[id]
AnnouncementDetails.[programId] Program.[id]
AnnouncementView.[announcementId] Announcement.[id]
AnnouncementView.[userId] User.[id]
AppInfo.[organizationId] Organization.[id]
Applications.[name] SequelizeMeta.[name]
Applications.[userId] User.[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]
AttendenceTemplate.[name] SequelizeMeta.[name]
AttendenceTemplate.[termCourseId] TermCourse.[id]
BiddingLogs.[userId] User.[id]
BiddingResponse.[termCourseId] TermCourse.[id]
BiddingResponse.[userId] User.[id]
BiometricAttendance.[userId] User.[id]
BiometricBuilding.[organizationId] Organization.[id]
BiometricDevice.[organizationId] Organization.[id]
BiometricRoom.[organizationId] Organization.[id]
BiometricRoomDevice.[organizationId] Organization.[id]
Birthday.[programId] Program.[id]
Birthday.[userId] User.[id]
BirthdayWish.[birthdayId] Birthday.[id]
Bookmark.[userId] User.[id]
Category.[name] SequelizeMeta.[name]
Category.[organizationId] Organization.[id]
CategoryCourseMaster.[categoryId] Category.[id]
CategoryCourseMaster.[courseMasterId] CourseMaster.[id]
ClubMember.[userId] User.[id]
Clubs.[clubTypeId] ClubType.[id]
ClubType.[organizationId] Organization.[id]
CohortFeedBackQuestion.[programId] Program.[id]
Companies.[name] SequelizeMeta.[name]
CourseBidding.[programId] Program.[id]
CourseClass.[name] SequelizeMeta.[name]
CourseClass.[organizationId] Organization.[id]
CourseDomain.[name] SequelizeMeta.[name]
CourseDomainConfig.[courseDomainId] CourseDomain.[id]
CourseDomainConfig.[domainCategoryId] DomainCategory.[id]
CourseDomainConfig.[name] SequelizeMeta.[name]
CourseDomainConfig.[placementlevelId] PlacementLevel.[id]
CourseDomainConfig.[programId] Program.[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]
CourseMasterDomain.[courseDomainId] CourseDomain.[id]
CourseMasterDomain.[courseMasterId] CourseMaster.[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]
CustomNotification.[userId] User.[id]
DocSign.[programId] Program.[id]
DomainCategory.[courseDomainId] CourseDomain.[id]
DomainCategory.[name] SequelizeMeta.[name]
DoubtGroupUser.[courseDoubtDiscussionId] CourseDoubtDiscussion.[id]
DoubtGroupUser.[userId] User.[id]
DoubtMessageRead.[courseDoubtDiscussionId] CourseDoubtDiscussion.[id]
DoubtMessageRead.[userId] User.[id]
EmailSequence.[emailTemplateId] EmailTemplate.[id]
EmailSequence.[name] SequelizeMeta.[name]
EmailSequence.[organizationId] Organization.[id]
EmailSequence.[programId] Program.[id]
EmailSequence.[sectionId] Section.[id]
EmailSequence.[termCourseId] TermCourse.[id]
EmailTemplate.[organizationId] Organization.[id]
EmployeeStudentLoginLogs.[userId] User.[id]
Grades.[studentAssignmentId] StudentAssignment.[id]
Grades.[termCourseId] TermCourse.[id]
Grades.[userId] User.[id]
GradeTransaction.[termCourseId] TermCourse.[id]
GradingTemplateMaster.[name] SequelizeMeta.[name]
GradingTemplateMaster.[organizationId] Organization.[id]
InterviewRounds.[round_name] SequelizeMeta.[name]
ItemCategory.[organizationId] Organization.[id]
LeaveManagement.[organizationId] Organization.[id]
loginLogs.[userId] User.[id]
MetaFields.[name] SequelizeMeta.[name]
Notification.[organizationId] Organization.[id]
Notification.[userId] User.[id]
NpsTemplate.[name] SequelizeMeta.[name]
NpsTemplateQuestions.[npsTemplateId] NpsTemplate.[id]
Organization.[name] SequelizeMeta.[name]
OrganizationIntegration.[name] SequelizeMeta.[name]
OrganizationIntegration.[organizationId] Organization.[id]
Pedagogy.[name] SequelizeMeta.[name]
Pedagogy.[organizationId] Organization.[id]
PendingRequest.[userId] User.[id]
PlacementLevel.[name] SequelizeMeta.[name]
PlacementLevel.[organizationId] Organization.[id]
PlacementLevel.[programId] Program.[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]
ProgramPlacementResource.[name] SequelizeMeta.[name]
ProgramPlacementResource.[programId] Program.[id]
ProgramTerm.[programId] Program.[id]
Quiz.[userId] User.[id]
QuizLogs.[userId] User.[id]
ReachOut.[accomplishmentId] Accomplishment.[id]
ReachOut.[organizationId] Organization.[id]
ReachOut.[programId] Program.[id]
ReactOutFeedBack.[userId] User.[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]
StudentSidemenuApprovel.[programId] Program.[id]
Teammember.[Name] SequelizeMeta.[name]
TempRecord.[organizationId] Organization.[id]
TempRecord.[termCourseId] TermCourse.[id]
TempTgpaCalculaton.[programId] Program.[id]
TempTgpaCalculaton.[userId] User.[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]
TermCourseDomain.[courseDomainId] CourseDomain.[id]
TermCourseDomain.[termCourseId] TermCourse.[id]
TermDomainStats.[courseDomainId] CourseDomain.[id]
TermDomainStats.[programId] Program.[id]
TermDomainStats.[userId] User.[id]
TermNpsQuestions.[npsTemplateId] NpsTemplate.[id]
TermStats.[programId] Program.[id]
TermStats.[userId] User.[id]
teststTable.[userId] User.[id]
TicketConfig.[programId] Program.[id]
TranscriptUserOtp.[name] SequelizeMeta.[name]
UserBankDetail.[userId] User.[id]
UserBiometricData.[userId] User.[id]
UserCourse.[termCourseId] TermCourse.[id]
UserCourse.[userId] User.[id]
UserCourseDomain.[courseDomainId] CourseDomain.[id]
UserCourseDomain.[placementlevelId] PlacementLevel.[id]
UserCourseDomain.[programId] Program.[id]
UserCourseDomain.[userId] User.[id]
UserCustomPolicy.[userId] User.[id]
UserDocSign.[docSignId] DocSign.[id]
UserDocSign.[userId] User.[id]
UserDomainData.[courseDomainId] CourseDomain.[id]
UserDomainData.[programId] Program.[id]
UserDomainData.[userId] User.[id]
UserDomainLogs.[courseDomainId] CourseDomain.[id]
UserDomainLogs.[programId] Program.[id]
UserDomainLogs.[userId] User.[id]
UserEducation.[userId] User.[id]
UserExperience.[userId] User.[id]
UserGroup.[userId] User.[id]
UserLevel.[placementLevelId] PlacementLevel.[id]
UserLevel.[userId] User.[id]
UserLogs.[userId] User.[id]
UserNewsFeed.[newsFeedId] NewsFeed.[id]
UserNewsFeed.[userId] User.[id]
UserNotification.[userId] User.[id]
UserNpsResponse.[npsTemplateId] NpsTemplate.[id]
UserNpsResponse.[userId] User.[id]
UserPortfolio.[userId] User.[id]
UserPortfolioStatus.[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]
UserSessionFeedBack.[termCourseId] TermCourse.[id]
UserSessionFeedBack.[userId] User.[id]
userSkills.[userId] User.[id]
UserVerification.[userId] User.[id]
wtsNextViewLog.[userId] User.[id]

Tables without indexes

Table Rows
teststTable 0

Tables that contain a single column

Table Column
SequelizeMeta name
teststTable userId

Tables with incrementing column names, potentially indicating denormalization

Table
User

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

Table
Anomaly not detected