deliveryApp
Tables (5)
menu (Untitled3)
- menu_id (Key) — LONG — Primary key — NOT NULL
- menu_name (Field) — VARCHAR
- price (Field2) — INT
- store_id (Key2) — LONG — Foreign key → store.store_id — NOT NULL
order (Untitled4)
- order_id (Key) — LONG — Primary key — NOT NULL
- ordered_at (Field) — DATETIME
- order_status (Field2) — VARCHAR
- menu_id (Key2) — LONG — Foreign key → menu.menu_id — NOT NULL
- user_id (Key3) — LONG — Foreign key → user.user_id — NOT NULL
review (Untitled5)
- review_id (Key) — LONG — Primary key — NOT NULL
- rating (Field) — INT
- created_at (Field2) — DATETIME
- content (Field3) — VARCHAR
- user_id (Key4) — LONG — Foreign key → user.user_id — NOT NULL
- store_id (Key2) — LONG — Foreign key → store.store_id — NOT NULL
- order_id (Key3) — LONG — Foreign key → order.order_id — NOT NULL
store (Untitled2)
- store_id (Key) — LONG — Primary key — NOT NULL
- store_name (Field) — VARCHAR
- open_close_time (Field2) — VARCHAR
- delivery_min_price (Field3) — INT
- store_status (Field4) — VARCHAR
- user_id (Key2) — LONG — Foreign key → user.user_id — NOT NULL
user (Untitled)
- user_id (Key) — LONG — Primary key — NOT NULL
- user_name (Field) — VARCHAR
- email (Field2) — VARCHAR
- password (Field3) — VARCHAR
- user_type (Field7) — VARCHAR
- is_deleted (Field8) — TINYINT(1)