차곡 DB

테이블 (3)

Untitled (member)

  • Key (id) — long — 기본 키 — NOT NULL
  • Field (roles) — String — NOT NULL
  • Field (name) — String — NOT NULL
  • Field (email) — String — NOT NULL

Untitled (store)

  • Key (id) — long — 기본 키 — NOT NULL
  • Key (member_id) — Long — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — String — NOT NULL
  • Field (address) — String — NOT NULL

Untitled (coupon)

  • Key (id) — long — 기본 키 — NOT NULL
  • Field (max_stamp_number) — int — NOT NULL
  • Field (benefit) — String — NOT NULL
  • Key (store_id) — long — 외래 키 → Untitled.Key — NOT NULL