필수PJT_02

테이블 (4)

Coach (coach)

  • Coach_id — int(11) — 기본 키 — NOT NULL
  • Last_Name (last_name) — varchar(255) — NOT NULL
  • First_Name (first_name) — varchar(255) — NOT NULL
  • Task (task) — varchar(255)
  • Student_id (student_id) — int(11) — 외래 키 → Student.Student_id — NOT NULL
  • Class_id (Class_id2) — int(2) — 외래 키 → Student.Class_id — NOT NULL

Consultant (consultant)

  • Consultant_id (consultant_id) — int(11) — 기본 키 — NOT NULL
  • Last_name (last_name) — varchar(255) — NOT NULL
  • First_name (first_name) — varchar(255) — NOT NULL
  • Task (task) — varchar(255)
  • Student_id (student_id) — int(11) — 외래 키 → Student.Student_id — NOT NULL
  • Class_id — int(2) — 외래 키 → Student.Class_id — NOT NULL

Curriculum (curriculum)

  • Class_id — int(2) — 기본 키 — NOT NULL
  • Class (class) — int(2) — NOT NULL

Student (student)

  • Student_id (student_id) — int(11) — 기본 키 — NOT NULL
  • Class_id — int(2) — 외래 키 → Curriculum.Class_id — NOT NULL
  • Year (year) — int(2) — NOT NULL
  • Last_Name (last_name) — varchar(255) — NOT NULL
  • First_Name (first_name) — varchar(255) — NOT NULL
  • Major (major) — bool — NOT NULL
  • Enrollment (enrollment) — bool — NOT NULL
  • Project (project) — varchar(255) — NOT NULL
  • Area (area) — varchar(255) — NOT NULL