0923644

과제

테이블 (5)

Class (class)

  • Class ID (class id) — INT(11) — 기본 키 — NOT NULL
  • Student_ID (student_id2) — INT(11) — 외래 키 → Student.Student_ID — NOT NULL
  • Consultant_ID (consultant_id) — INT(11) — 외래 키 → Consultant.Consultant_ID — NOT NULL
  • Coach_ID (coach_id) — INT(11) — 외래 키 → Coach.Coach_ID — NOT NULL
  • Kind (kind) — VARCHAR(10) — 외래 키 → Curriculum.Kind — NOT NULL
  • Kind (kind2) — VARCHAR(10) — 외래 키 → Student.Kind — NOT NULL
  • Region (region) — VARCHAR(20)
  • Number (number) — INT(11)

Coach (coach)

  • Coach_ID (coach_id) — INT(11) — 기본 키 — NOT NULL
  • NAME (name) — VARCHAR(255)

Consultant (consultant)

  • Consultant_ID (consultant_id) — INT(11) — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(255)

Curriculum (curriculum)

  • Kind (kind) — VARCHAR(10) — 기본 키 — NOT NULL

Student (student)

  • Student_ID (student_id) — INT(11) — 기본 키 — NOT NULL
  • Kind (kind) — VARCHAR(10) — 외래 키 → Curriculum.Kind — NOT NULL
  • Major (major) — BOOL
  • Discharge (discharge) — BOOL
  • Last Name (last_name) — VARCHAR(255)
  • First NAME (first name) — VARCHAR(255)