교육기관 DB설계

테이블 (13)

Autonomy (autonomy)

  • Autonomy Id (autonomy_id) — INT(200) — 기본 키 — NOT NULL
  • Content (content) — VARCHAR(255)
  • Curriculum Id (curriculum_id) — INT(200) — 외래 키 → Curriculum.Curriculum Id — NOT NULL

Ban (ban)

  • Region Id (region_id) — INT(200) — 외래 키 → Region.Region Id — NOT NULL
  • BanNum Id (banNum_id) — INT(200) — 외래 키 → BanNum.BanNum Id — NOT NULL

BanNum (ban_num)

  • BanNum Id (banNum_id) — INT(200) — 기본 키 — NOT NULL

Coach (coach)

  • Coach Id (coach_id) — INT(200) — 기본 키 — NOT NULL
  • CoachWork id (coachWork_id) — INT(200) — 외래 키 → CoachWork.CoachWork id — NOT NULL
  • Region Id (region_id) — INT(200) — 외래 키 → Ban.Region Id
  • BanNum Id (banNum_id) — INT(200) — 외래 키 → Ban.BanNum Id — NOT NULL
  • Coach Name (coach_name) — VARCHAR(255)

CoachWork (coach_work)

  • CoachWork id (coachWork_id) — INT(200) — 기본 키 — NOT NULL
  • WorkContent (work_content) — VARCHAR(255)

Common (common)

  • Common Id (common_id) — INT(200) — 기본 키 — NOT NULL
  • Content (content) — VARCHAR(255)
  • Curriculum Id (curriculum_id) — INT(200) — 외래 키 → Curriculum.Curriculum Id — NOT NULL

Consultant (consultant)

  • Consultant Id (consultant_id) — INT(200) — 기본 키 — NOT NULL
  • Region Id (region_id) — INT(200) — 외래 키 → Ban.Region Id — NOT NULL
  • BanNum Id (banNum_id) — INT(200) — 외래 키 → Ban.BanNum Id — NOT NULL
  • ConsultantWork id (consultantWork_id) — INT(200) — 외래 키 → ConsultantWork.ConsultantWork id — NOT NULL
  • Consultant Name (consultant_name) — VARCHAR(255)

ConsultantWork (Consultant_work)

  • ConsultantWork id (consultantWork_id) — INT(200) — 기본 키 — NOT NULL
  • WorkContent (work_content) — VARCHAR(255)

Curriculum (curriculum)

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

Kisu (kisu)

  • Kisu id (kisu_id) — INT(200) — 기본 키 — NOT NULL

Region (region)

  • Region Id (region_id) — INT(200) — 기본 키 — NOT NULL
  • Region Name (region_name) — VARCHAR(255)

Specialization (specialization)

  • Specialization Id (specialization_id) — INT(200) — 기본 키 — NOT NULL
  • Content (content) — VARCHAR(255)
  • Curriculum Id (curriculum_id) — INT(200) — 외래 키 → Curriculum.Curriculum Id — NOT NULL

Student (student)

  • Student Id (student_id) — INT(200) — 기본 키 — NOT NULL
  • Student Name (student_name) — VARCHAR(255)
  • Major (major) — TINYINT(1)
  • Retirement (retirement) — TINYINT(1)
  • Kisu id (kisu_id) — INT(200) — 외래 키 → Kisu.Kisu id — NOT NULL
  • Region Id (region_id) — INT(200) — 외래 키 → Ban.Region Id — NOT NULL
  • BanNum Id (banNum_id) — INT(200) — 외래 키 → Ban.BanNum Id — NOT NULL