ㄴㅇㄹㅎ
Tables (11)
addresses
- id — BIGINT
- user_id — BIGINT — NOT NULL
- address_type — ENUM('집', '회사', '기타')
- address_detail — VARCHAR(255)
- latitude — DECIMAL(10,7)
- longitude — DECIMAL(10,7)
- is_default — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
categories
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
likes
- id — BIGINT
- user_id — BIGINT — NOT NULL
- restaurant_id — BIGINT — NOT NULL
- created_at — DATETIME
menu_options
- id — BIGINT
- menu_id — BIGINT — NOT NULL
- name — VARCHAR(100)
- is_required — BOOLEAN
- is_single — BOOLEAN
menus
- id — BIGINT
- restaurant_id — BIGINT — NOT NULL
- name — VARCHAR(100)
- description — TEXT
- price — DECIMAL(10,2)
- status — VARCHAR(20)
- created_at — DATETIME
- updated_at — DATETIME
option_items
- id — BIGINT
- menu_option_id — BIGINT — NOT NULL
- name — VARCHAR(100)
- price — DECIMAL(10,2)
order_item_options
- id — BIGINT
- order_item_id — BIGINT — NOT NULL
- option_item_id — BIGINT — NOT NULL
order_items
- id — BIGINT
- order_id — BIGINT — NOT NULL
- menu_id — BIGINT — NOT NULL
- quantity — INT — NOT NULL
- menu_price_at_order — DECIMAL(10,2)
orders
- id — BIGINT
- user_id — BIGINT — NOT NULL
- restaurant_id — BIGINT — NOT NULL
- address_id — BIGINT
- total_price — DECIMAL(10,2)
- status — VARCHAR(20)
- created_at — DATETIME
- updated_at — DATETIME
restaurants
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- category_id — BIGINT
- min_order_price — DECIMAL(10,2)
- latitude — DECIMAL(10,7)
- longitude — DECIMAL(10,7)
- status — VARCHAR(20)
- created_at — DATETIME
- updated_at — DATETIME
users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(200) — NOT NULL
- name — VARCHAR(100)
- phone_number — VARCHAR(20)
- status — VARCHAR(20)
- created_at — DATETIME
- updated_at — DATETIME