ㅈ
Tables (9)
address
- id — BIGINT
- user_id — BIGINT
- label — ENUM('집','회사','기타')
- address — VARCHAR(100)
- latitude — DECIMAL(10,7)
- longitude — DECIMAL(10,7)
- status — TINYINT
- created_at — DATETIME
- updated_at — DATETIME
menu
- id — BIGINT
- restaurant_id — BIGINT
- name — VARCHAR(100)
- price — DECIMAL(10,2)
- description — TEXT
- image_url — TEXT
- status — TINYINT
- created_at — DATETIME
- updated_at — DATETIME
menu_option
- id — BIGINT
- option_group_id — BIGINT
- name — VARCHAR(100)
- price — DECIMAL(10,2)
- created_at — DATETIME
- updated_at — DATETIME
menu_option_group
- id — BIGINT
- menu_id — BIGINT
- name — VARCHAR(100)
- is_required — BOOLEAN
- is_multiple — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
order_menu
- id — BIGINT
- order_id — BIGINT
- menu_id — BIGINT
- quantity — INT
- price — DECIMAL(10,2)
order_menu_option
- id — BIGINT
- order_menu_id — BIGINT
- menu_option_id — BIGINT
orders
- id — BIGINT
- user_id — BIGINT
- restaurant_id — BIGINT
- address_id — BIGINT
- total_price — DECIMAL(10,2)
- status — VARCHAR(20)
- created_at — DATETIME
- updated_at — DATETIME
restaurant
- id — BIGINT
- name — VARCHAR(100)
- category — VARCHAR(50)
- image_url — TEXT
- min_order_price — DECIMAL(10,2)
- delivery_fee — DECIMAL(10,2)
- latitude — DECIMAL(10,7)
- longitude — DECIMAL(10,7)
- status — TINYINT
- created_at — DATETIME
- updated_at — DATETIME
user
- id — BIGINT
- email — VARCHAR(100)
- password — VARCHAR(200)
- name — VARCHAR(50)
- phone_number — VARCHAR(20)
- created_at — DATETIME
- updated_at — DATETIME