교육기관 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