daily_1_엔티티추출

테이블 (6)

class (Entity5)

  • class_id — INT — 기본 키 — NOT NULL
  • consultant_id — INT — 외래 키 → consultant.consultant_id — NOT NULL
  • region — VARCAHR(50)
  • class — VARCHAR(10)
  • coach_id — INT — 외래 키 → coach.coach_id — NOT NULL

coach (Entity3)

  • coach_id — INT — 기본 키 — NOT NULL
  • role — VARCHAR(50)

consultant (Entity2)

  • consultant_id — INT — 기본 키 — NOT NULL
  • role — VARCHAR(50)

curriculum (Entity4)

  • cur_id — INT — 기본 키 — NOT NULL
  • course — VARCHAR(50)

student (Entitiy1)

  • student_id — INT — 기본 키 — NOT NULL
  • class_id — INT — 외래 키 → class.class_id — NOT NULL
  • consultant_id — INT — 외래 키 → class.consultant_id — NOT NULL
  • session — INT
  • is_major — INT
  • is_student — INT

student_curriculum (Untitled)

  • student_id — INT — 외래 키 → student.student_id — NOT NULL
  • class_id — INT — 외래 키 → student.class_id — NOT NULL
  • consultant_id — INT — 외래 키 → student.consultant_id — NOT NULL
  • cur_id — INT — 외래 키 → curriculum.cur_id — NOT NULL