daily_1_엔티티추출

테이블 (5)

Coach (Entity3)

  • coach_id — Long — 기본 키 — NOT NULL
  • coach_name — VARCHAR(50)
  • task — VARCHAR(100)

Consultant (Entity2)

  • consultant_id — Long — 기본 키 — NOT NULL
  • consultant_name — VARCHAR(50)
  • task — VARCHAR(100)

Student (Entity1)

  • student_id — Long — 기본 키 — NOT NULL
  • student_name — VARCHAR(50)
  • gisu — Long
  • major — VARCHAR(50)
  • discharge — VARCHAR(50)

class (Entity4)

  • class_id — Long — 기본 키 — NOT NULL
  • coach_id — Long — 외래 키 → Coach.coach_id — NOT NULL
  • consultant_id — Long — 외래 키 → Consultant.consultant_id — NOT NULL
  • region — VARCHAR(30)
  • ban — Long

course (Entity5)

  • course_id — Long — 기본 키 — NOT NULL
  • type — varchar(50)