daily_1_엔티티추출

테이블 (5)

Class (class)

  • Class Id (id) — INT(10) — 기본 키 — NOT NULL
  • No (no) — INT(2)
  • Region (region) — VARCHAR(2)
  • Consultant Id (consultant_id) — INT(10) — 외래 키 → Consultant.Consultant Id — NOT NULL
  • Coach Id (coach_id) — INT(10) — 외래 키 → Coach.Coach Id — NOT NULL

Coach (coach)

  • Coach Id (id) — INT(10) — 기본 키 — NOT NULL
  • Class Id (class_id) — INT(2)
  • Task (task) — VARCHAR(225)

Consultant (consultant)

  • Consultant Id (id) — INT(10) — 기본 키 — NOT NULL
  • Class Id (class_id) — INT(2)
  • Task (task) — VARCHAR(225)

Curriculum (curriculum)

  • Curriculum Id (id) — INT(10) — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(2)

Student (student)

  • Student Id (id) — INT(10) — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(10)
  • No th (no_th) — INT(2)
  • Is Major (is_major) — BOOLEAN — 전공 / 비전공
  • Is Leave (is_leave) — BOOLEAN
  • Class Id (class_id) — INT(10) — 외래 키 → Class.Class Id — NOT NULL