orderService
Tables (4)
MENU
- 메뉴id (menu_id) — long — Primary key — NOT NULL
- 메뉴이름 (menu_name) — varchar(100) — NOT NULL
- 카테고리 (category) — varchar(100) — NOT NULL
- 가격 (price) — int — NOT NULL
- 설명 (details) — varchar(500)
customer
- 고객id (customer_id) — long — Primary key — NOT NULL
- 지점id (restaurant_id) — long — Foreign key → restaurant.지점id — NOT NULL
- 이름 (name) — varchar(10) — NOT NULL
- 전화번호 (phone) — int — NOT NULL
- 주소 (address) — varchar(100) — NOT NULL
order
- 주문id (order_id) — long — Primary key — NOT NULL
- 메뉴id (menu_id) — long — Foreign key → MENU.메뉴id — NOT NULL
- 고객id (customer_id) — long — Foreign key → customer.고객id — NOT NULL
- 지점id (restaurant_id2) — long — Foreign key → customer.지점id — NOT NULL
- 주문상태 (order_status) — enum — NOT NULL
- 주문시간 (order_time) — datetime — NOT NULL
restaurant
- 지점id (restaurant_id) — long — Primary key — NOT NULL
- 지점이름 (restaurant_name) — varchar(100) — NOT NULL
- 지점주소 (restaurant_address) — varchar(100) — NOT NULL
- 지점번호 (restuarant_number) — int — NOT NULL