ERD 그리기

테이블 (6)

Class (class)

  • Region (region) — VARCHAR(100) — 기본 키 — NOT NULL
  • Number (number) — INT — 기본 키 — NOT NULL
  • CoachName (coach_name) — VARCHAR(50) — 외래 키 → Coach.CoachName — NOT NULL
  • ConsultantName (consultant_name) — VARCHAR(50) — 외래 키 → Consultant.ConsultantName — NOT NULL

Coach

  • CoachName (coach_name) — VARCHAR(50) — 기본 키 — NOT NULL
  • JobName (job_name) — VARCHAR(100) — 외래 키 → Job.JobName — NOT NULL

Consultant (consultant)

  • ConsultantName (consultant_name) — VARCHAR(50) — 기본 키 — NOT NULL
  • JobName (job_name) — VARCHAR(100) — 외래 키 → Job.JobName — NOT NULL

Curriculum (curriculum)

  • Course (course) — VARCHAR(10) — 기본 키 — NOT NULL

Job (job)

  • JobName (job_name) — VARCHAR(100) — 기본 키 — NOT NULL

Student (student)

  • Cardinal (cardinal) — INT — 기본 키 — NOT NULL
  • Major (major) — VARCHAR(100)
  • Class (class) — VARCHAR(50)
  • Retirement (retirement) — VARCHAR(10)
  • Region (region) — VARCHAR(100) — 외래 키 → Class.Region — NOT NULL
  • Number (number) — INT — 외래 키 → Class.Number — NOT NULL