ERD실습
테이블 (7)
교육과정
- Course Id (course_id) — int() — 기본 키 — NOT NULL
- Course Name (course_name) — VARCHAR(10)
교육생
- Student Id (student_id) — int() — 기본 키 — NOT NULL
- Course Id (course_id) — int() — 외래 키 → 교육과정.Course Id — NOT NULL
- Last Name (last_name) — VARCHAR(255)
- First Name (first_name) — VARCHAR(255)
- Phone (phone) — VARCHAR(20)
- Gender (gender) — CHAR(1)
- Email (email) — VARCHAR(20)
- Birthday (birthday) — CHAR(8)
- Major (major) — BOOLEAN()
- Exit (exit) — BOOLEAN()
기수
- Semester Id (semester_id) — int() — 기본 키 — NOT NULL
- Student Id (student_id) — int() — 외래 키 → 교육생.Student Id — NOT NULL
- Course Id (course_id) — int() — 외래 키 → 교육생.Course Id — NOT NULL
반
- Class Id (class_id) — int() — 기본 키 — NOT NULL
지역
- Local Id (local_id) — int() — 기본 키 — NOT NULL
- Class Id (class_id) — int() — 외래 키 → 반.Class Id — NOT NULL
- Student Id (student_id) — int() — 외래 키 → 교육생.Student Id — NOT NULL
- Consultant Id (consultant_id) — int() — 외래 키 → 컨설턴트.Consultant Id — NOT NULL
- Course Id (course_id) — int() — 외래 키 → 교육생.Course Id — NOT NULL
- Coach Id (coach_id) — int() — 외래 키 → 코치.Coach Id — NOT NULL
- Local Name (local_name) — VARCHAR(200)
컨설턴트
- Consultant Id (consultant_id) — int() — 기본 키 — NOT NULL
- Last Name (last_name) — VARCHAR(255)
- First Name (first_name) — VARCHAR(255)
- Phone (phone) — VARCHAR(20)
- Gender (gender) — CHAR(1)
- Email (email) — VARCHAR(20)
- Birthday (birthday) — CHAR(8)
- Consultant Work (consultant_work) — VARCHAR(200)
코치
- Coach Id (coach_id) — int() — 기본 키 — NOT NULL
- Last Name (last_name) — VARCHAR(255)
- First Name (first_name) — VARCHAR(255)
- Phone (phone) — VARCHAR(20)
- Gender (gender) — CHAR(1)
- Email (email) — VARCHAR(20)
- Birthday (birthday) — CHAR(8)
- Coach Work (coach_work) — VARCHAR(200)