title
Tables (10)
announcements
- announcement_id — INT
- user_id — INT
- course_id — INT
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- post_date — DATETIME — NOT NULL
attendance
- attendance_id — INT
- enrollment_id — INT
- attendance_date — DATE — NOT NULL
- status — ENUM('present', 'late', 'early_leave', 'absent') — NOT NULL
courses
- course_id — INT
- teacher_id — INT
- course_name — VARCHAR(100) — NOT NULL
- category — VARCHAR(50)
- day_of_week — VARCHAR(50) — NOT NULL
- time — VARCHAR(50) — NOT NULL
- max_capacity — INT — NOT NULL
- current_enroll — INT
- status — ENUM('pending', 'approved', 'rejected') — NOT NULL
- create_date — DATETIME — NOT NULL
enrollments
- enrollment_id — INT
- student_id — INT
- course_id — INT
- enroll_date — DATETIME — NOT NULL
- status — ENUM('active', 'canceled') — NOT NULL
inquiries
- inquiry_id — INT
- student_id — INT
- admin_id — INT
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- status — ENUM('pending', 'answered', 'closed') — NOT NULL
- inquiry_date — DATETIME — NOT NULL
- answer_content — TEXT
- answer_date — DATETIME
students
- student_id — INT
- user_id — INT
- student_number — VARCHAR(20) — NOT NULL
- grade — INT — NOT NULL
- class — INT — NOT NULL
survey_responses
- response_id — INT
- survey_id — INT
- student_id — INT
- answers — JSON — NOT NULL
- submitted_at — DATETIME — NOT NULL
surveys
- survey_id — INT
- user_id — INT
- course_id — INT
- title — VARCHAR(100) — NOT NULL
- questions — JSON — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
teachers
- teacher_id — INT
- user_id — INT
- department — VARCHAR(50)
- memo — TEXT
users
- user_id — INT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- role — ENUM('admin', 'teacher', 'student') — NOT NULL
- reg_date — DATETIME — NOT NULL