Delivery Service
Tables (5)
store
- id — bigint(32) — Primary key — NOT NULL
- name — varchar(100) — Primary key — NOT NULL
- address — varchar(150) — NOT NULL
- status — varchar(45)
- category — varchar(45)
- star — double
- thumnail_url — varchar(200)[ — NOT NULL
- minimum_amount — decimal(11,4) — NOT NULL
- minimum_delivery_amount — decimal(11,4) — NOT NULL
- phone_number — varchar(20)
store_menu
- id — bigint(32) — Primary key — NOT NULL
- name (Field) — varchar(100)
- amount — decimal(11,4)
- store_id — bigint(32) — Foreign key → store.id — NOT NULL
- status — varchar(50)
- thumbnail_url — varchar(200)
- like_count — int
- sequence — int
user
- id — bigint(32) — Primary key — NOT NULL
- name — varchar(50)
- email — varchar(100)
- password — varchar(100)
- status — varchar(50)
- address — varchar(150)
- registered_at — datetime
- unregistered_at — datetime
- last_login_at — datetime
user_order_menu
- id — bingint(32) — Primary key — NOT NULL
- user_order_id — bigint(32) — Foreign key → user_oreder.id — NOT NULL
- store_menu_id — bigint(32) — Foreign key → store_menu.id — NOT NULL
- status — VARCHAR(50)
user_oreder (user_order)
- id — bigint(32) — Primary key — NOT NULL
- user_id — bigint(32) — Foreign key → user.id — NOT NULL
- status — VARCHAR(50)
- amount — DECIMAL(11,4)
- ordered_at — DATETIME
- accepted_at — DATETIME
- cooking_started_at — DATETIME
- delivery_started_at — DATETIME
- received_at — DATETIME