LMS
Tables (8)
courses
- course_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- operator_id — BIGINT — NOT NULL
- start_date — DATE
- end_date — DATE
- created_at — TIMESTAMP — NOT NULL
- user_id — BIGINT — Foreign key → operators.user_id — NOT NULL
enrollments
- course_id — BIGINT — Foreign key → courses.course_id — NOT NULL
- user_id — BIGINT — Foreign key → students.user_id — NOT NULL
- enrolled_at — TIMESTAMP — NOT NULL
- status — VARCHAR(20) — NOT NULL
instructors
- instructor_id — BIGINT — Foreign key → users.user_id — NOT NULL
- career_years — SMALLINT
operators
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- department — VARCHAR(100)
- position — VARCHAR(100)
reviews
- review_id (BIGINT) — BIGINT — Primary key — NOT NULL
- course_id — BIGINT — NOT NULL
- rating — SMALLINT — NOT NULL
- content — TEXT
- created_at — TIMESTAMP — NOT NULL
- user_id — BIGINT — Foreign key → students.user_id — NOT NULL
students
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- student_no — VARCHAR(50)
teaching_assignments
- instructor_id (instructor_id2) — BIGINT — Foreign key → instructors.instructor_id — NOT NULL
- course_id — BIGINT — Foreign key → courses.course_id — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(200)
- created_at — TIMESTAMP — NOT NULL