DB설계, ERD작성 실습
테이블 (4)
Coach (coach)
- Coach Id (coach_id) — INT(11) — 기본 키 — NOT NULL
- Last Name (last_name) — VARCHAR(255)
- First Name (first_name) — VARCHAR(255)
- Room Id (room_id) — INT(30) — 외래 키 → Room.Room Id — NOT NULL
Consultant (consultant)
- Consultant Id (consultant_id) — INT(11) — 기본 키 — NOT NULL
- Last Name (last_name) — VARCHAR(255)
- First Name (first_name) — VARCHAR(255)
- Room Id (room_id) — INT(30) — 외래 키 → Room.Room Id — NOT NULL
Room (room)
- Room Id (room_id) — INT(30) — 기본 키 — NOT NULL
- Region (region) — VARCHAR(255)
- Number (number) — INT(11)
- Course (course) — VARCHAR(255)
Student (student)
- Student Id (student_id) — INT(11) — 기본 키 — NOT NULL
- Last Name (last_name) — VARCHAR(255)
- First Name (first_name) — VARCHAR(255)
- Major (major) — BOOLEAN
- Discharge (discharge) — BOOLEAN
- Room Id (room_id) — INT(30) — 외래 키 → Room.Room Id — NOT NULL