mysql
Tables (6)
Course
- course_id — LONG — Primary key — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT — NOT NULL
- start_date — DATE
- end_date — DATE
- created_at — TIMESTAMP — NOT NULL
- instructor_id — LONG — Foreign key → Instructor.instructor_id — NOT NULL
- operator_id — LONG — Foreign key → Operator.operator_id — NOT NULL
Enrollment
- enrollment_id — LONG — Primary key — NOT NULL
- student_id (student_id2) — LONG — Foreign key → Student.student_id — NOT NULL
- course_id — LONG — Foreign key → Course.course_id — NOT NULL
- status — VARCHAR(50)
- enrolled_at — TIMESTAMP
Instructor
- instructor_id — LONG — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- department — VARCHAR(120)
- email — VARCHAR(120)
Operator
- operator_id — LONG — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- role — VARCHAR(80) — NOT NULL
- email — VARCHAR(120)
Review
- review_id — LONG — Primary key — NOT NULL
- course_id (course_id2) — LONG — Foreign key → Course.course_id — NOT NULL
- student_id — LONG — Foreign key → Student.student_id — NOT NULL
- rating — TINYINT — NOT NULL
- comment — TEXT — EX
- created_at — TIMESTAMP — NOT NULL
Student
- student_id — LONG — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(120)
- major — VARCHAR(100)
- created_at — TIMESTAMP