DeliveryHub
Tables (6)
Menu
- id (menu_id) — bigint — Primary key — NOT NULL
- restaurant_id — bigint — Foreign key → Restaurant.id — NOT NULL
- name — varchar(50)
- description — varchar(255)
- price — int
- created_at — datetime
- updated_at — datetime
Order
- id (order_id) — bigint — Primary key — NOT NULL
- customer_id (user_id) — bigint — Foreign key → User.id — NOT NULL
- restaurant_id — bigint — Foreign key → Restaurant.id — NOT NULL
- status — varchar(50)
- total_price — int
- created_at — datetime
- updated_at — datetime
- location — varchar(50
OrderItem
- id (item_id) — bigint — Primary key — NOT NULL
- order_id — bigint — Foreign key → Order.id — NOT NULL
- menu_id — bigint — Foreign key → Menu.id — NOT NULL
- quantity — int
- price — int
Restaurant
- id (restaurant_id) — bigint — Primary key — NOT NULL
- owner id (user_id) — bigint — Foreign key → User.id — NOT NULL
- name — varchar(50)
- location — varchar(50)
- created_at — datetime
- updated_at — datetime
Review
- id (review_id) — bigint — Primary key — NOT NULL
- user id (user_id) — bigint — Foreign key → User.id — NOT NULL
- restaurant id (restaurant_id) — bigint — Foreign key → Restaurant.id — NOT NULL
- title — varchar(50)
- content — text
- rate — int
User
- id (user_id) — bigint — Primary key — NOT NULL
- name — varchar(50)
- role — varchar(50)
- email — varchar(50)
- password — varchar(16)
- created_at — datetime
- updated_at — datetime