9기_대전2반_이시영_ERD

테이블 (5)

Class (class)

  • Class (class) — INT — 기본 키 — NOT NULL
  • Region (region) — VARCHAR(50)
  • Coach ID (coach_id) — INT — 외래 키 → Coach.Coach ID
  • Consultant ID (consultant_id) — INT — 외래 키 → Consultant.Consultant ID — NOT NULL

Coach (coach)

  • Coach ID (coach_id) — INT — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(50)
  • Work (work) — VARCHAR(100)

Consultant (consultant)

  • Consultant ID (consultant_id) — INT — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(50)
  • Work (work) — VARCHAR(100)

Student (student)

  • Student ID (student_id) — INT — 기본 키 — NOT NULL
  • Class (class) — INT — 외래 키 → Class.Class — NOT NULL
  • Curriculum (curriculum) — VARCHAR(50)
  • Name (name) — VARCHAR(50)
  • Degree (degree) — INT
  • Discharge (discharge) — BOOLEAN
  • Track (track) — VARCHAR(50( — 외래 키 → Track.Track — NOT NULL

Track (track)

  • Track (track) — VARCHAR(50( — 기본 키 — NOT NULL