w8-delivery
Tables (9)
Untitled (user)
- Key (id) — bigint — Primary key — NOT NULL
- Field (email) — varchar(255) — NOT NULL
- Field (password) — varchar(80) — NOT NULL — 8~24자
- Field2 (name) — varchar(30) — NOT NULL — 한글 기준 22자
- Field (nickname) — varchar(10) — NOT NULL — 한글 기준 8자
- Field (address) — address — NOT NULL
- Field3 (phone_num) — varchar(15) — NOT NULL — ###-####-####
- Field (user_type) — varchar(10) — NOT NULL — USER, OWNER
- Field2 (birthday) — date
- Field (is_deleted) — tinyint(1) — NOT NULL
Untitled (<<address>>)
- Field (city) — varchar(10) — NOT NULL — 시도
- Field (district) — varchar(10) — NOT NULL — 시군구
- Field (street) — varchar(20) — NOT NULL — 도로명
- Field (detail) — varchar(40)
Untitled (store)
- Key (id) — bigint — Primary key — NOT NULL
- Key (owner_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (buisiness_registraion_id) — varchar(40) — NOT NULL — 사업자 등록 정보, UUID
- Field (name) — varchar(35) — NOT NULL — 한글 기준 30자
- Field (address) — address — NOT NULL
- Field (phone_num) — varchar(15) — NOT NULL — (## | ###) - (### | ####) - ####
- Field (open_hour) — time
- Field (close_hour) — time
- Field (estimate_until_arrival) — integer — 예상 수령시간
- Field (delivery_fee) — integer
- Field (is_open) — tinyint(1) — NOT NULL — 가게가 오픈된 상태인지
- Field (is_deleted) — tinyint(1) — NOT NULL
Untitled (store_business_hours)
- Key (id) — bigint — Primary key — NOT NULL
- Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (day_of_week) — varchar(10) — NOT NULL — SUN | MON | TUE | WED | THU | FRI | SAT
- Field (open_time) — datetime — WEEKLY | BIWEEKLY | MONTHLY | BIMONTHLY
- Field (close_time) — datetime
- Field (isOpen) — tinyint(1) — NOT NULL — 휴무일 관련 메시지
Untitled (category)
- Key (id) — bigint — Primary key — NOT NULL
- Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (category) — varchar(20) — NOT NULL — enumerated String
Untitled (orders)
- Key (id) — varchar(20) — Primary key — NOT NULL — UUID
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (menu_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (order_type) — varchar(20) — NOT NULL — DELIVERY | PICKUP | VISITING
- Field (order_status) — varchar(20) — NOT NULL — CANCEL | REJECT | PENDING | COOKING | DEPART | DONE
- Field (delivery_status) — varachar(20) — ONROAD | DONE
- Field (target_address) — address — NOT NULL
- Field (amount) — integer — NOT NULL
- Field (delivery_fee) — integer
- Field (pickup_at) — datetime
- Field (delivery_done_at) — datetime
- Field (is_deleted) — tinyint(1) — NOT NULL
Untitled (menu)
- Key (id) — bigint — Primary key — NOT NULL
- Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar(25) — NOT NULL — 한글 기준 20자
- Field (price) — integer — NOT NULL
- Field (detail) — varchar(150) — 한글 기준 100자
- Field (is_deleted) — tinyint(1) — NOT NULL
Untitled (review)
- Key (id) — bigint — Primary key — NOT NULL
- Key (order_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL — UUID
- Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (stars) — integer — NOT NULL — 1 ~ 5
- Field (content) — text — NOT NULL — 한글 기준 5000
- Field (is_deleted) — tinyint(1) — NOT NULL
Untitled (<<base>>)
- Field (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime — NOT NULL