TABLES
70
VIEWS
0
COLUMNS
1006
Constraints
1
Anomalies
119
Routines
0
Database Properties
Database Type: PostgreSQL - 14.7
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| Events | 0 | 0 | 24 | 0 | Table | |
| EventResponseComment | 0 | 0 | 11 | 0 | Table | |
| ProgramMaster | 0 | 3 | 30 | 2 | Table | |
| EmailTemplate | 0 | 1 | 13 | 6 | Table | |
| UserBankDetail | 0 | 1 | 14 | 0 | Table | |
| CourseClass | 3 | 2 | 10 | 2 | Table | |
| CourseTag | 3 | 2 | 10 | 2 | Table | |
| AssignmentDetails | 0 | 4 | 24 | 2 | Table | |
| Clubs | 0 | 1 | 22 | 3 | Table | |
| ReachOut | 0 | 1 | 13 | 0 | Table | |
| UserRole | 0 | 2 | 10 | 4 | Table | |
| UserVerification | 0 | 1 | 6 | 0 | Table | |
| TermStats | 0 | 2 | 15 | 0 | Table | |
| UserProgram | 0 | 2 | 12 | 1 | Table | |
| UserSection | 0 | 2 | 10 | 1 | Table | |
| CourseDoubtDiscussionChat | 0 | 2 | 14 | 1 | Table | |
| UserEducation | 0 | 1 | 20 | 0 | Table | |
| BiddingResponse | 0 | 2 | 13 | 0 | Table | |
| RolePolicy | 0 | 3 | 11 | 0 | Table | |
| Log | 0 | 1 | 9 | 0 | Table | |
| EventMember | 0 | 0 | 11 | 0 | Table | |
| CategoryCourseMaster | 0 | 2 | 9 | 0 | Table | |
| ItemCategory | 0 | 1 | 11 | 0 | Table | |
| ClubMember | 0 | 0 | 11 | 0 | Table | |
| GradingTemplateMaster | 2 | 2 | 10 | 4 | Table | |
| Announcement | 1 | 1 | 22 | 27 | Table | |
| UserGroup | 0 | 1 | 9 | 0 | Table | |
| CourseMaster | 4 | 6 | 32 | 3 | Table | |
| Policy | 1 | 2 | 11 | 25 | Table | |
| SessionDetail | 0 | 3 | 40 | 3 | Table | |
| CourseFormat | 0 | 5 | 21 | 9 | Table | |
| TempRecord | 0 | 2 | 13 | 1 | Table | |
| Grades | 0 | 3 | 15 | 1 | Table | |
| PlacementLevel | 2 | 2 | 9 | 3 | Table | |
| CourseType | 3 | 2 | 10 | 3 | Table | |
| CourseStats | 0 | 2 | 15 | 0 | Table | |
| Program | 8 | 1 | 32 | 1 | Table | |
| CourseGradingTemplate | 0 | 2 | 10 | 2 | Table | |
| TermCourse | 12 | 6 | 32 | 2 | Table | |
| ProgramTerm | 0 | 1 | 21 | 2 | Table | |
| AssignmentGroup | 0 | 0 | 11 | 0 | Table | |
| Organization | 24 | 1 | 13 | 4 | Table | |
| Role | 2 | 1 | 10 | 8 | Table | |
| CourseMode | 3 | 1 | 10 | 2 | Table | |
| ClubResponseComment | 0 | 0 | 11 | 0 | Table | |
| SessionFaculty | 0 | 2 | 11 | 2 | Table | |
| Category | 2 | 2 | 15 | 5 | Table | |
| OrganizationIntegration | 0 | 2 | 13 | 6 | Table | |
| CourseBidding | 0 | 1 | 12 | 0 | Table | |
| Resource | 2 | 1 | 11 | 5 | Table | |
| CourseDoubtDiscussion | 1 | 2 | 17 | 1 | Table | |
| UserExperience | 0 | 1 | 19 | 0 | Table | |
| AnnoucementType | 0 | 1 | 8 | 10 | Table | |
| PlacementLevelCriteria | 0 | 2 | 10 | 3 | Table | |
| StudentAssignment | 1 | 2 | 11 | 2 | Table | |
| User | 21 | 1 | 28 | 13 | Table | |
| ClubType | 1 | 1 | 9 | 2 | Table | |
| SectionGroup | 0 | 3 | 11 | 0 | Table | |
| SequelizeMeta | 15 | 0 | 1 | 101 | Table | |
| AnnouncementDetails | 0 | 3 | 11 | 49 | Table | |
| Notification | 0 | 2 | 14 | 0 | Table | |
| EventPhotos | 0 | 0 | 9 | 0 | Table | |
| Quiz | 1 | 1 | 10 | 0 | Table | |
| CourseSession | 0 | 3 | 25 | 6 | Table | |
| UserProfile | 0 | 1 | 12 | 2 | Table | |
| AssignmentResource | 1 | 2 | 10 | 3 | Table | |
| EventStudentReview | 0 | 0 | 11 | 0 | Table | |
| UserLevel | 0 | 2 | 11 | 0 | Table | |
| Section | 6 | 2 | 16 | 4 | Table | |
| UserCourse | 0 | 2 | 11 | 0 | Table |