테이블링
테이블 (8)
Like (like)
- customer_id — 기본 키 — NOT NULL
- restaurant_id — 기본 키 — NOT NULL
category
- category_id — int — 기본 키 — NOT NULL
- category_name — varchar(50) — NOT NULL
customer
- customer_id — int — 기본 키 — NOT NULL
- customer_name — varchar(50)
- phone — varchar(50) — NOT NULL
- state — enum('Y', 'N')
- location_id — int
food
- food_id — int — 기본 키 — NOT NULL
- food_name — VARCHAR(100) — NOT NULL
- category_id — int
location
- location_id — int — 기본 키 — NOT NULL
- location_name — varchar(50)
menu
- restaurant_id — int
- food_id — int
- price — int — NOT NULL
reservation
- reservation_id — int — 기본 키 — NOT NULL
- reservation_state — enum('Y', 'N')
- reservation_time — timestamp
- customer_id — int
- restaurant_id — int
restaurant
- restaurant_id — int — 기본 키 — NOT NULL
- restaurant_name — varchar(100) — NOT NULL
- phone — varchar(50)
- address — varchar(255) — NOT NULL
- content — text
- open_time — time
- close_time — time
- rating — decimal(2, 1)
- likes — int
- rest_day — varchar(5)
- location_id — int
- category_id — int