ssafy

Tables (6)

classes

  • class_id (Key) — INT — Primary key — NOT NULL
  • region — ENUM('Seoul', 'Daejeon', 'Gumi', 'Gwangju', 'Busan', 'Ulsan') — NOT NULL
  • class_number — INT — NOT NULL
  • consultant_id (Key2) — INT — Foreign key → consultants.consultant_id — NOT NULL
  • coach_id (Key3) — INT — Foreign key → coaches.coach_id — NOT NULL

coaches

  • coach_id (Key) — INT — Primary key — NOT NULL
  • name — VARCHAR(100)

consultants

  • consultant_id (Key) — INT — Primary key — NOT NULL
  • name — VARCHAR(100)

courses

  • course_id — INT — Primary key — NOT NULL
  • course_name — VARCHAR(100)
  • type — ENUM('common', 'special', 'self') — NOT NULL

enrollments

  • enrollment_id — INT — Primary key — NOT NULL
  • course_id — INT — Foreign key → courses.course_id — NOT NULL
  • student_id (Key) — INT — Foreign key → students.student_id — NOT NULL

students

  • student_id (Key) — INT — Primary key — NOT NULL
  • name — VARCHAR(100)
  • status — ENUM('active', 'inactive', 'graduated') — NOT NULL
  • major — ENUM('major', 'non_major') — NOT NULL
  • cardinal number — INT