기말과제

테이블 (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)