normalize
Tables (15)
Untitled (member)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — varchar
Untitled (phonebook)
- Field (phone) — varchar
- Key (id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (student_lecture)
- Key (no) — int — Primary key — NOT NULL
- Key (lecture) — varchar — Primary key — NOT NULL
- Field (campus) — varchar
- Field (grade) — varchar
Untitled (student_no)
- Key (no) — int — Primary key — NOT NULL
- Field (campus) — varchar
Untitled (score)
- Key (no) — int — Foreign key → Untitled.Key — NOT NULL
- Field (grade) — varchar
- Field (lecture) — varchar
Untitled (worldcup)
- Key (year) — int — Primary key — NOT NULL
- Field (winner) — varchar
- Field (coach) — vachar
Untitled (winnerlist)
- Key (year) — int — Primary key — NOT NULL
- Field (nation) — varchar
Untitled (teams)
- Field (nation) — varchar
- Field2 (coach) — varchar
- Key (year) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (회원)
- Key (id) — varchar — Primary key — NOT NULL
- Field (password) — varchar
- Field (email) — varchar
- Field (name) — varchar
Untitled (프로필)
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Field (school) — varchar
- Field (job) — varchar
Untitled (친구목록)
- Field (f_id) — varchar
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
Untitled (글 쓰기)
- Field (글no) — int — Primary key
- Field (date) — date
- Field (view) — int
- Field (like) — int
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
Untitled (reply)
- Key (댓글no) — int — Primary key — NOT NULL
- Field (글no) — int — Foreign key → Untitled.Field
- Field (content) — varchar
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
Untitled (like)
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Field (글no) — int — Foreign key → Untitled.Field
Untitled2 (profile)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — varchar
- Field (phone1) — varchar
- Field (phnoe2) — varchar