필수2_DB설계_ERD작성실습
테이블 (5)
Coaches (coches)
- Id (id) — INT(11) — 기본 키 — NOT NULL
- GroupName (group_name) — VARCHAR(15) — 외래 키 → Group.GroupName — NOT NULL
- Job (job) — VARCHAR(45)
- Field
Consultants (consultants)
- Id (id) — INT(11) — 기본 키 — NOT NULL
- GroupName (group_name) — VARCHAR(15) — 외래 키 → Group.GroupName — NOT NULL
- Job (job) — VARCHAR(45)
- Field
Group (group)
- GroupName (group_name) — VARCHAR(15) — 기본 키 — NOT NULL
- Location (location) — VARCHAR(45) — 외래 키 → Locations.Location — NOT NULL
- GroupNumber (group_number) — INT(11)
- Field
Locations (locations)
- Location (location) — VARCHAR(45) — 기본 키 — NOT NULL
- Field
Students (students)
- Student Id (student_id) — INT(11) — 기본 키 — NOT NULL
- GroupName (group_name) — VARCHAR(15) — 외래 키 → Group.GroupName — NOT NULL
- Year (year) — INT(4)
- Related Major (related_major) — BOOLEAN
- Exit (exit) — BOOLEAN
- Name (name) — VARCHAR(45)
- Age (age) — INT(4)
- Gender (gender) — VARCHAR(11)
- Field