기말과제
테이블 (11)
Untitled (brand)
- Key (name) — char(10) — 기본 키 — NOT NULL
- Field (explanation) — longtext
- Field (location) — char(30)
Untitled (perfume_brand)
- Key (perfumeCode) — char(20) — 외래 키 → perfume.Key — NOT NULL
- Key (name) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (fragrance)
- Key (fragrance code) — char(15) — 기본 키 — NOT NULL
- Field (name) — char(10)
- Field (explanation) — longtext
- Field (keyword) — char(10)
Untitled (spice)
- Key (spiceCode) — char(15) — 기본 키 — NOT NULL
- Field (name) — char(10)
- Field (explanation) — longtext
- Key (fragrance code) — char(15) — 외래 키 → Untitled.Key — NOT NULL
Untitled (review)
- Key (review number) — char(20) — 기본 키 — NOT NULL
- Field (date) — date
- Field (review) — longtext
Untitled (user)
- Key (user ID) — char(15) — 기본 키 — NOT NULL
- Field (name) — char(10)
- Field (email) — char(40)
Untitled (perfume_review)
- Key (perfumeCode) — char(20) — 외래 키 → perfume.Key — NOT NULL
- Key (review number) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (perfume_frag)
- Key (perfumeCode) — char(20) — 외래 키 → perfume.Key — NOT NULL
- Key (fragrance code) — char(15) — 외래 키 → Untitled.Key — NOT NULL
Untitled (perfume_spice)
- Key (perfumeCode) — char(20) — 외래 키 → perfume.Key — NOT NULL
- Key (code) — char(15) — 외래 키 → Untitled.Key — NOT NULL
Untitled (review_user)
- Key (user ID) — char(15) — 외래 키 → Untitled.Key — NOT NULL
- Key (review number) — char(20) — 외래 키 → Untitled.Key — NOT NULL
perfume
- Key (perfumeCode) — char(20) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (price) — integer(10)
- Field (explanation) — longtext
- Field (keyword) — char(10)