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