erd실습

테이블 (4)

Class (Untitled2)

  • class_id (class_pk) — INT — 기본 키 — NOT NULL
  • area (지역) — CHAR
  • class_number (반) — INT

Coach

  • coach_id (coach_pk) — INT — 기본 키 — NOT NULL
  • name (이름) — VARCHAR
  • work (담당업무) — VARCHAR
  • class_id (class_pk2) — INT — 외래 키 → Class.class_id — NOT NULL

Consultant (Untitled3)

  • consiltant_id (consultannt_pk) — INT — 기본 키 — NOT NULL
  • work (담당업무) — VARCHAR
  • class_number (담당반) — INT
  • Field
  • class_id (class_pk) — INT — 외래 키 → Class.class_id — NOT NULL

Student (Untitled)

  • id (student_id) — INT — 기본 키 — NOT NULL
  • name (이름) — VARCHAR
  • Major (전공여부) — BOOLEAN
  • retire (퇴소여부) — BOOLEAN
  • unit (기수) — INT
  • Field5 (교육과정) — CHAR
  • class_id (class_pk) — INT — 외래 키 → Class.class_id — NOT NULL