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