SW#7_1334343

Tables (6)

Class

  • class_id — INT — Primary key — NOT NULL
  • region — ENUM('서울', '대전', '구미', '광주', '부울경') — NOT NULL
  • class_number — INT — NOT NULL
  • curriculum_type — ENUM('공통', '특화', '자율') — NOT NULL
  • UNIQUE(region, — class_number)
  • consultant_id — INT — Foreign key → Consultant.consultant_id — NOT NULL
  • coach_id — INT — Foreign key → Coach.coach_id — NOT NULL
  • student_id — INT — Foreign key → Student.student_id — NOT NULL

Coach

  • coach_id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • task — VARCHAR(100)
  • class_id — INT — Foreign key → Class.class_id — NOT NULL

Coach_Assign

  • class_id — INT
  • coach_id — INT

Consultant

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

Consultant_Assign

  • class_id — INT
  • consultant_id — INT

Student

  • student_id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • is_major — BOOLEAN — NOT NULL
  • is_dropout — BOOLEAN — NOT NULL
  • cohort — INT — NOT NULL
  • class_id — INT