wanted
Tables (5)
menu (Untitled4)
- menu_id — NOT NULL — Primary key — NOT NULL
- store_id (Key) — NOT NULL — Foreign key → store.store_id — NOT NULL
- menu_name — NOT NULL
- menu_price — NOT NULL
- menu_state (menu_stat) — NOT NULL
order (Untitled3)
- order_id (Key) — NOT NULL — Primary key — NOT NULL
- user_id — NOT NULL — Foreign key → user.user_id — NOT NULL
- order_price — NOT NULL
- order_request — NULL
- order_state — NOT NULL
order_detail (Untitled5)
- order_detail_id — NOT NULL — Primary key — NOT NULL
- order_id (Key) — NOT NULL — Foreign key → order.order_id — NOT NULL
- user_id — NOT NULL — Foreign key → user.user_id — NOT NULL
- menu_id — NOT NULL — Foreign key → menu.menu_id — NOT NULL
- order_detail_quantity — NOT NULL
store (Untitled)
- store_id (Key) — NOT NULL — Primary key — NOT NULL
- store_name — NOT NULL
- store_address — NOT NULL
- store_time — NOT NULL
- store_phone — NOT NULL
- store_content — NULL
user (Untitled2)
- user_id — NOT NULL — Primary key — NOT NULL
- user_name — NOT NULL
- user_email — NOT NULL
- password — NOT NULL
- user_address — NOT NULL