daily1_엔티티추출

테이블 (5)

Class (class)

  • Class Num (class_num) — INT(11) — 기본 키 — NOT NULL
  • Region (region) — VARCHAR(22) — 기본 키 — NOT NULL
  • Student ID (student_id) — INT(7) — 외래 키 → Student.Student ID — NOT NULL
  • Consultant ID (consultant_id) — INT(7) — 외래 키 → Consultant.Consultant ID — NOT NULL
  • Coach ID (coach_id) — INT(7) — 외래 키 → Coach.Coach ID — NOT NULL

Coach (coach)

  • Coach ID (coach_id) — INT(7) — 기본 키 — NOT NULL
  • Field
  • Field2

Consultant (consultant)

  • Consultant ID (consultant_id) — INT(7) — 기본 키 — NOT NULL
  • Field
  • Field2

Course (course)

  • Course Name (course_name) — VARCHAR(12) — 기본 키 — NOT NULL
  • Student ID (student_id) — INT(7) — 외래 키 → Student.Student ID — NOT NULL

Student (students)

  • Student ID (student_id) — INT(7) — 기본 키 — NOT NULL
  • Major (major) — boolean
  • Retirement (retirement) — boolean