과제

테이블 (4)

Class (class)

  • Class ID (class_id) — INT(11) — 기본 키 — NOT NULL
  • Region (region) — VARCHAR(45)
  • Class Number (class_number) — INT(11)
  • Course (course) — VARCHAR(45)
  • Consultant ID (consultant_id2) — INT(11) — 외래 키 → Consultant.Consultant ID — NOT NULL
  • Class ID (class_id2) — INT(11) — 외래 키 → Consultant.Class ID — NOT NULL
  • Coach ID (coach_id) — INT(11) — 외래 키 → Coach.Coach ID — NOT NULL
  • Class ID (class_id3) — INT(11) — 외래 키 → Coach.Class ID — NOT NULL

Coach (coach)

  • Coach ID (coach_id) — INT(11) — 기본 키 — NOT NULL
  • Class ID (class_id) — INT(11) — 기본 키 — NOT NULL
  • Responsibility (responsibility) — VARCHAR(45)

Consultant (consultant)

  • Consultant ID (consultant_id) — INT(11) — 기본 키 — NOT NULL
  • Class ID (class_id) — INT(11) — 기본 키 — NOT NULL
  • Responsibility (responsibility) — VARCHAR(45)

Student (student)

  • Student ID (student_id) — INT(11) — 기본 키 — NOT NULL
  • Class ID (Key) — INT(11) — 기본 키 — NOT NULL
  • NTH (nth) — INT(11)
  • Is Major (is_major) — TINYINT
  • Is Discharge (is_discharge) — TINYINT
  • Studentcol (studentcol) — VARCHAR(45)
  • Class ID (class_id2) — INT(11) — 외래 키 → Class.Class ID — NOT NULL