필수4

테이블 (5)

AREA (Untitled5)

  • area_id — INT — 기본 키 — NOT NULL
  • tr_id — INT — 외래 키 → TRAINEE.tr_id — NOT NULL
  • coach_id — INT — 외래 키 → TRAINEE.coach_id — NOT NULL
  • curr_id — INT — 외래 키 → TRAINEE.curr_id — NOT NULL
  • Field

COACH (Untitled3)

  • coach_id — INT — 기본 키 — NOT NULL
  • work_id (Field) — INT

CONSULTANT (Untitled2)

  • con_id — INT — 기본 키 — NOT NULL
  • tr_id — INT — 외래 키 → TRAINEE.tr_id — NOT NULL
  • coach_id — INT — 외래 키 → TRAINEE.coach_id — NOT NULL
  • curr_id — INT — 외래 키 → TRAINEE.curr_id — NOT NULL
  • work_id — INT

Curriculum (Untitled)

  • curr_id — INT — 기본 키 — NOT NULL

TRAINEE (Untitled4)

  • tr_id — INT — 기본 키 — NOT NULL
  • coach_id — INT — 외래 키 → COACH.coach_id — NOT NULL
  • curr_id — INT — 외래 키 → Curriculum.curr_id — NOT NULL
  • major_id — INT
  • discharge_id — INT
  • major_id (Field)