정규화
테이블 (9)
Untitled (profile)
- Key (id) — int — 기본 키 — NOT NULL
- Field (name) — varchar
- Field (phone1) — varchar
- Field (phone2) — varchar
Untitled (member)
- Key (id) — int — 기본 키 — NOT NULL
- Field (name) — varchar
Untitled (phonebook)
- Field (phone) — varchar
- Key (id) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (student_lecture)
- Key (number) — int — 기본 키 — NOT NULL
- Key (lecture) — varchar — 기본 키 — NOT NULL
- Field (campus) — varchar
- Field (grade) — varchar
Untitled (student_identify)
- Key (number) — int — 기본 키 — NOT NULL
- Field (campus) — varchar
Untitled (student_grade)
- Field (grade) — varchar
- Key (lecture) — varchar — NOT NULL
- Key (number) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (worldcup)
- Key (year) — int — 기본 키 — NOT NULL
- Field (winner) — varchar
- Field (coach) — varchar
Untitled (winnerList)
- Key (year) — int — 기본 키 — NOT NULL
- Field (nation) — varchar
Untitled (teams)
- Field (coach) — varchar
- Field (nation) — varchar
- Key (year) — int — 외래 키 → Untitled.Key — NOT NULL