daily_1_엔티티추출

테이블 (6)

Class (class)

  • Class ID (class_id) — INT — 기본 키 — NOT NULL
  • Type (type) — VARCHAR
  • Consultant ID (consultant_id) — INT — 외래 키 → Consultant.Consultant ID — NOT NULL
  • Coach ID (coach_id) — INT — 외래 키 → Coach.Coach ID — NOT NULL

Coach (coach)

  • Coach ID (coach_id) — INT — 기본 키 — NOT NULL
  • Last Name (last_name) — VARCHAR
  • First Name (first_name) — VARCHAR
  • Job ID (job_id) — INT — 외래 키 → Job.Job ID — NOT NULL

Consultant (consultant)

  • Consultant ID (consultant_id) — INT — 기본 키 — NOT NULL
  • Last Name (last_name) — VARCHAR
  • First Name (first_name) — VARCHAR
  • Job ID (job_id) — INT — 외래 키 → Job.Job ID — NOT NULL

Course (course)

  • Course ID (course_id) — INT — 기본 키 — NOT NULL
  • Name (name) — VARCHAR

Job (job)

  • Job ID (job_id) — INT — 기본 키 — NOT NULL
  • Name (name) — VARCHAR

Student (student)

  • Student ID (student_id) — INT — 기본 키 — NOT NULL
  • Last Name (last_name) — VARCHAR
  • First Name (first_name) — VARCHAR
  • Generation (generation) — INT
  • Major (major) — BOOLEAN
  • Left (left) — BOOLEAN
  • Class ID (class_id) — INT — 외래 키 → Class.Class ID — NOT NULL
  • Course ID (course_id) — INT — 외래 키 → Course.Course ID — NOT NULL