supportapp01

테이블 (3)

매장 (mall)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (created_by) — varchar(36) — 외래 키 → 사용자.Key — NOT NULL
  • Field (name) — varchar(255) — NOT NULL
  • Field (phone) — varchar(13) — NOT NULL
  • Field (geo) — geometry — NOT NULL
  • Field (address) — varchar(255) — NOT NULL
  • Field (address_detail) — varchar(255) — NOT NULL
  • Field (remark) — varchar(600)
  • Field (open_at) — varchar(5) — HH:MM
  • Field (close_at) — varchar(5) — HH:MM
  • Field (thumbnail) — varchar(600)

사용자 (user)

  • Key (id) — varchar(36) — 기본 키 — NOT NULL
  • Field (email) — varchar(100) — NOT NULL
  • Field (password) — varchar(255) — NOT NULL
  • Field (name) — varchar(50) — NOT NULL
  • Field (phone) — varchar(13) — NOT NULL
  • Field (role) — enum("USER", "MERCHANT") — NOT NULL

즐겨찾기 (bookmark)

  • Key (created_by) — varchar(36) — 외래 키 → 사용자.Key — NOT NULL
  • Key (mall_id) — bigint — 외래 키 → 매장.Key — NOT NULL