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