정규화
테이블 (15)
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 (no) — int — 기본 키 — NOT NULL
- Key (lecture) — varchar — 기본 키 — NOT NULL
- Field (campus) — varchar
- Field (grade) — varchar
Untitled (student_no)
- Key (no) — int — 기본 키 — NOT NULL
- Field (campus) — varchar
Untitled (student_grade)
- Field (grade) — varchar
- Field (lecture) — varchar
- Key (no) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (worldcup)
- Key (year) — int — 기본 키 — NOT NULL
- Field (winner) — varchar
- Field (coach) — varchar
Untitled (teams)
- Field (nation) — varchar
- Field (coach) — varchar
- Key (year) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (winnerlist)
- Key (year) — int — 기본 키 — NOT NULL
- Field (nation) — varchar
Untitled (회원)
- Key (ID) — varchar — 기본 키 — NOT NULL
- Field (pass) — varchar
- Field (email) — varchar
- Field (name) — varchar
Untitled (프로필)
- Key (ID) — varchar — 외래 키 → Untitled.Key — NOT NULL
- Field (학교) — varchar
- Field (회사) — varchar
Untitled (게시글)
- Key (글번호) — int — 기본 키 — NOT NULL
- Key (ID) — varchar — 외래 키 → Untitled.Key — NOT NULL
- Field (등록날짜) — varchar
- Field (조회수) — int
- Field (좋아요) — int
Untitled (댓글)
- Field (댓글 번호) — int — 기본 키
- Field (내용) — varchar
- Key (글번호) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (ID) — varchar — 외래 키 → Untitled.Key — NOT NULL
Untitled (좋아요)
- Key (ID) — varchar — 외래 키 → Untitled.Key — NOT NULL
- Key (글번호) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (친구목록)
- Key (ID) — varchar — 외래 키 → Untitled.Key — NOT NULL
- Field (친구ID) — varchar
- Field (친구 수) — int