daily_1_엔티티추출

테이블 (5)

Class (class)

  • Region (region) — VARCHAR(3) — 기본 키 — NOT NULL
  • Class Num (class_num) — INT(2) — 기본 키 — NOT NULL
  • Coach Id (coach_id) — INT(11) — 외래 키 → Coachs.Coach Id — NOT NULL
  • Consultants Id (consultants_id) — INT(11) — 외래 키 → Consultants.Consultants Id — NOT NULL

Coachs (coachs)

  • Coach Id (coach_id) — INT(11) — 기본 키 — NOT NULL
  • Coach Name (coach_name) — VARCHAR(225)

Consultants (consultants)

  • Consultants Id (consultants_id) — INT(11) — 기본 키 — NOT NULL
  • Consultants Name (consultants_name) — VARCHAR(225)

Curriculums (curriculums)

  • Curriculum Id (curriculum_id) — INT(11) — 기본 키 — NOT NULL
  • Curriculum Name (curriculum_name) — VARCHAR(2)

Students (students)

  • Student Id (student_id) — INT(11) — 기본 키 — NOT NULL
  • Student Name (student_name) — VARCHAR(225)
  • Year (yaer) — INT(2)
  • Is Major (is_major) — CHAR(1)
  • Is Discharge (is_discharge) — CHAR(1)
  • Region (region) — VARCHAR(3) — 외래 키 → Class.Region — NOT NULL
  • Class Num (class_num) — INT(2) — 외래 키 → Class.Class Num — NOT NULL
  • Curriculum Id (curriculum_id) — INT(11) — 외래 키 → Curriculums.Curriculum Id — NOT NULL