pick_up
Tables (10)
authority
- user_id — INT — Primary key — NOT NULL
- name — VARCHAR(20) — Primary key — NOT NULL
cart
- id — INT
- restaurant_id — BIGINT — NOT NULL
- user_id — INT — NOT NULL
- menu_name — VARCHAR(50)
- menu_count — INT — NOT NULL
- menu_price — VARCHAR(50)
- order_id — INT
- inserted — DATETIME — NOT NULL
category
- id — INT
- name — VARCHAR(10) — NOT NULL
- group_code — VARCHAR(10) — NOT NULL
favorites
- id — INT
- user_id — INT — NOT NULL
- restaurant_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
menu
- id — INT
- restaurant_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- price — VARCHAR(20) — NOT NULL
- img — VARCHAR(300)
- inserted — DATETIME — NOT NULL
orders
- id — INT
- merchant_uid — VARCHAR(50) — NOT NULL
- restaurant_id — LONG — NOT NULL
- user_id — INT — NOT NULL
- inserted — DATETIME — NOT NULL
- total_price — INT — NOT NULL
- pick_up_state — BOOLEAN — NOT NULL
- review_status — BOOLEAN — NOT NULL
- estimated_time — VARCHAR(10)
restaurant
- restaurant_id — BIGINT
- user_id — INT — NOT NULL
- restaurant_name — VARCHAR(100) — NOT NULL
- restaurant_tel — VARCHAR(20)
- address — VARCHAR(100) — NOT NULL
- inserted — DATETIME — NOT NULL
- logo — VARCHAR(500)
- latitude — DOUBLE
- longitude — DOUBLE
- category_id — INT — NOT NULL
review
- id — INT
- restaurant_id — BIGINT — NOT NULL
- user_id — INT — NOT NULL
- rating — INT — NOT NULL
- content — VARCHAR(100) — NOT NULL
- inserted — DATETIME — NOT NULL
review_file
- id — INT
- review_id — INT — NOT NULL
- file_name — VARCHAR(200) — NOT NULL
user
- Key — Primary key — NOT NULL
- id — INT — NOT NULL
- email — INT — NOT NULL
- password — INT — NOT NULL
- phone_number — INT — NOT NULL
- nick_name — INT — NOT NULL
- address — INT
- inserted — INT — NOT NULL