Tables


SchemaSpy Analysis of lms.public

Generated on Tue Nov 11 03:34 UTC 2025

XML Representation
Insertion Order Deletion Order
TABLES 186
VIEWS 0
COLUMNS 3071
Constraints 31
Anomalies 238
Routines 0

Database Properties

Database Type: PostgreSQL - 14.17

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
DoubtMessageRead 0 2 8 24778 Table
MaterialLog 0 1 12 10071 Table
EventResponseComment 0 0 11 0 Table
AccomplishmentPortfolioStatus 0 1 17 0 Table
CourseMasterDomain 0 2 9 1070 Table
EmailTemplate 1 1 14 94 Table
UserBankDetail 0 1 14 3 Table
CourseTag 3 2 10 38 Table
DoubtGroupUser 0 2 9 0 Table
PlacementRecord 0 0 16 268 Table
ReachOut 0 3 40 1844 Table
UserEligibility 0 11 19 14987 Table
UserRole 0 2 10 2989 Table
ItFeedback 0 0 7 24 Table
TvMode 0 0 11 157 Table
EmailSequence 0 6 24 3 Table
UserNewsFeed 0 2 7 21 Table
UserSection 0 2 11 17411 Table
GradeTransaction 0 1 9 52 Table
DocSign 1 1 16 129 Table
CustomReportTemplate 0 0 11 68 Table
UserEducation 0 1 42 1194 Table
Bookmark 0 1 8 26 Table
BiometricRoomDevice 0 1 10 2 Table
FormTemplate 3 0 15 4 Table
Birthday 1 2 12 216 Table
StudentProfileVisibility 0 0 13 1 Table
BiddingResponse 0 2 13 4349 Table
CourseQuestion 0 0 9 69 Table
NewsFeed 1 0 8 29 Table
ItFeedbackLink 0 0 6 1 Table
UserPortfolioStatus 0 1 38 1050 Table
BiometricDevice 0 1 10 2 Table
Log 0 1 9 0 Table
userSkills 0 1 8 3978 Table
Pedagogy 0 2 10 21 Table
QuizProctoring 0 1 10 2 Table
Configuration 0 0 11 1 Table
ClubMember 0 1 11 866 Table
GradingTemplateMaster 2 2 11 45 Table
Announcement 2 2 29 2084 Table
Policy 1 2 12 138 Table
SessionDetail 0 3 65 15597 Table
AfterBeforeLogs 0 0 9 197 Table
TempRecord 0 2 15 3490 Table
UserLogs 0 1 22 1932 Table
UserBiometricData 0 1 13 405 Table
BiddingLogs 0 1 6 400 Table
LeaveManagement 0 1 20 0 Table
CourseStats 0 2 18 25595 Table
Program 24 1 59 141 Table
Accomplishment 1 1 19 169 Table
wtsNext 0 0 19 34 Table
GamificationConfig 2 3 37 168 Table
TermCourse 19 6 42 2861 Table
UserDocs 0 0 5 3 Table
ProgramTerm 0 1 28 545 Table
UserNpsResponse 0 3 17 6203 Table
Organization 32 1 45 6 Table
Role 2 1 11 37 Table
TermNpsQuestions 0 1 41 1730 Table
CourseMode 3 1 10 3 Table
CourseDomainConfig 0 5 29 784 Table
ClubResponseComment 0 0 11 0 Table
SessionFaculty 0 2 11 9364 Table
ProgramPlacementResource 0 2 14 113 Table
Category 2 2 15 41 Table
StudentCounsellor 0 0 10 520 Table
OrganizationIntegration 0 2 16 11 Table
Companies 2 1 16 27 Table
OffCampus 0 1 11 33 Table
Resource 2 1 11 23 Table
CourseDoubtDiscussion 3 5 29 3410 Table
TermCourseDomain 0 2 10 3139 Table
UserExperience 0 1 33 599 Table
userPortfolioWeeklyData 0 0 7 2 Table
CourseDomain 12 1 9 23 Table
UserPortfolioVisitor 0 0 13 93 Table
AllyChat 0 1 6 115 Table
StudentAssignment 1 2 28 89879 Table
UserDomainLogs 0 3 25 776 Table
JobConfig 0 1 8 141 Table
JobViews 0 2 6 797 Table
Notification 0 2 14 0 Table
Quiz 1 1 11 8884 Table
CourseSession 0 3 28 2668 Table
Jobs 7 1 34 173 Table
StudentSidemenuApprovel 0 1 23 23 Table
UserDomainData 0 3 27 2989 Table
AssignmentResource 1 2 10 5 Table
AttendanceLogs 0 0 9 765 Table
Teammember 0 2 11 23 Table
UserLevel 0 2 13 17482 Table
UserCourse 0 2 11 1140 Table
LoginAttempts 0 0 9 99 Table
wtsNextViewLog 0 1 10 502 Table
Events 0 0 48 536 Table
ProgramMaster 0 3 37 102 Table
UserPortfolio 0 1 38 53 Table
UserSessionFeedBack 0 2 13 20926 Table
MetaFields 0 1 6 1 Table
CourseClass 3 2 11 5 Table
AnnouncementView 0 2 6 8786 Table
DailyActiveUser 0 0 7 23 Table
EmailErrorLogs 0 0 6 32955 Table
AssignmentDetails 0 4 49 3664 Table
Clubs 0 1 24 158 Table
CustomNotification 0 1 11 5 Table
DomainCategory 1 2 12 172 Table
UserVerification 0 1 6 87 Table
TermStats 0 2 39 3525 Table
SessionFeedBackQuestion 0 0 13 2 Table
UserProgram 0 2 36 2432 Table
ReactOutFeedBack 0 1 11 235 Table
TicketPreMadeTemplate 0 0 8 7 Table
InterviewRounds 1 2 19 552 Table
CourseDoubtDiscussionChat 0 2 19 13427 Table
FormResponse 0 1 15 49 Table
GroupMetricSubmission 0 4 26 601 Table
AttendenceTemplate 0 2 10 2187 Table
TicketConfig 0 1 12 518 Table
TermDomainStats 0 3 19 7572 Table
TempTgpaCalculaton 0 2 15 0 Table
RolePolicy 0 3 11 1661 Table
CounsellorLogs 0 0 23 313 Table
Skills 0 0 6 3 Table
TicketNotes 0 0 9 32 Table
NpsTemplateQuestions 0 1 19 381 Table
BiometricBuilding 0 1 12 30 Table
EventMember 0 0 13 822 Table
FormAssociations 0 1 14 26 Table
AppInfo 0 1 8 1 Table
CategoryCourseMaster 0 2 9 0 Table
ItemCategory 0 1 11 0 Table
UserCourseDomain 0 4 34 58093 Table
EmailLogs 0 0 7 220936 Table
FrontendErrorLog 0 0 6 5001 Table
UserGroup 0 1 14 7703 Table
CourseMaster 5 6 36 714 Table
CourseFormat 0 5 21 2058 Table
EmployeeStudentLoginLogs 0 1 10 1946 Table
UserDocSign 0 2 8 628 Table
Grades 0 3 15 83020 Table
PlacementLevel 4 3 11 45 Table
StudentNotes 0 1 16 7 Table
teststTable 0 1 1 0 Table
BiometricAttendance 0 1 14 1090 Table
CourseType 3 2 10 4 Table
Eligibility 1 1 21 144 Table
userPortfolioMonthlyData 0 0 8 18 Table
FormQuestion 1 1 35 65 Table
PendingRequest 0 1 12 1 Table
PlacementAnalytics 0 0 10 34 Table
CourseGradingTemplate 0 2 12 2257 Table
CohortFeedBackQuestion 0 1 14 68 Table
AssignmentGroup 0 0 11 3037 Table
BirthdayWish 0 1 21 98 Table
loginLogs 0 1 9 11 Table
WtsAppErrorLogs 0 0 7 0 Table
InAppNotification 0 0 9 1 Table
Applications 0 3 19 1310 Table
UserNotification 0 1 15 289401 Table
TranscriptUserOtp 0 1 11 139 Table
UserRound 0 3 15 1992 Table
CourseBidding 0 1 12 78 Table
QuizLogs 0 1 8 627 Table
ErrorLog 0 0 6 5001 Table
ProgramCohortAnalytics 0 0 10 14 Table
BiometricRoom 0 1 18 48 Table
AnnoucementType 0 1 8 5 Table
PlacementLevelCriteria 0 2 10 2152 Table
User 75 1 113 2987 Table
ClubType 1 1 9 10 Table
SectionGroup 0 5 37 2126 Table
SequelizeMeta 28 0 1 786 Table
UserCustomPolicy 0 1 10 44 Table
AnnouncementDetails 0 3 18 2069 Table
Forms 0 1 25 16 Table
CronJobLog 0 0 12 169 Table
EventPhotos 0 0 9 105 Table
TranscriptTemplate 0 0 10 2 Table
UserProfile 0 1 12 1148 Table
AiSummary 0 1 10 35 Table
NpsTemplate 3 0 10 104 Table
EventStudentReview 0 0 11 125 Table
Section 10 2 20 2243 Table