SW#7

Tables (6)

Untitled (Student(교육생))

  • Key (student_id) — INT — Primary key — NOT NULL
  • Field2 (name) — VARCHAR(50)
  • Field3 (is_major) — BOOLEAN
  • Field (is_dropout) — BOOLEAN
  • Field (generation) — INT

Untitled (Course(교육과정))

  • Key (course_id) — INT — Primary key — NOT NULL
  • Field (course_type) — ENUM('공통', '특화', '자율') 또는 VARCHAR

Untitled (Classroom(반))

  • Key (classroom_id) — INT — Primary key — NOT NULL
  • Field (classroom_nm) — VARCHAR(20)

Untitled (Consultant(컨설턴트))

  • Key (consultant_id) — INT — Primary key — NOT NULL
  • Field2 (name) — VARCHAR(50)
  • Field (task) — VARCHAR(100)

Untitled (Coach(코치))

  • Key (coach_id) — INT — Primary key — NOT NULL
  • Field2 (name) — VARCHAR(50)
  • Field (task) — VARCHAR(100)

Untitled (Assignment(반배정))

  • Key (Assignment_id) — INT — Primary key — NOT NULL
  • Key (student_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (consultant_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (coach_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (classroom_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (course_id) — INT — Foreign key → Untitled.Key — NOT NULL