과제

테이블 (4)

Class (class)

  • class_id — VARCHAR(255) — 기본 키 — NOT NULL

Coach (coach)

  • Coach_id (Key) — BIGINT(11) — 기본 키 — NOT NULL
  • coach_task — VARCHAR(255)
  • class_id (Field) — VARCHAR(255)
  • class_id — VARCHAR(255) — 외래 키 → Class.class_id — NOT NULL

Consultant (consultant)

  • Consultant_id — BIGINT(11) — 기본 키 — NOT NULL
  • consultant_task — VARCHAR(255)
  • class_id (Field) — VARCHAR(255)
  • class_id — VARCHAR(255) — 외래 키 → Class.class_id — NOT NULL

Student (student)

  • student_id — BIGINT(11) — 기본 키 — NOT NULL
  • unit — VARCHAR(255)
  • major — VARCHAR(255)
  • retireTF (Field) — VARCHAR(255)
  • curriculum — VARCHAR(255)
  • class_id (Field2) — VARCHAR(255)
  • class_id — VARCHAR(255) — 외래 키 → Class.class_id — NOT NULL