restaurant
Tables (7)
menu
- menu_id — int — Primary key — NOT NULL
- menu_name — text — NOT NULL
- price — int — NOT NULL
order_menu
- or_me_id — int — Primary key — NOT NULL
- order_id — int — Foreign key → orders.order_id — NOT NULL
- menu_id — int — Foreign key → menu.menu_id — NOT NULL
orders
- order_id — int — Primary key — NOT NULL
- ordered_at — datetime — NOT NULL
- delivery_status — text — NOT NULL
- total_price — int — NOT NULL
- user_id — int — Foreign key → users.user_id — NOT NULL
- rest_id — int — Foreign key → restaurant.rest_id — NOT NULL
rest_menu
- re_me_id — int — Primary key — NOT NULL
- rest_id — int — Foreign key → restaurant.rest_id — NOT NULL
- menu_id — int — Foreign key → menu.menu_id — NOT NULL
restaurant
- rest_id — int — Primary key — NOT NULL
- rest_name — text — NOT NULL
- address — text — NOT NULL
- phone — text — NOT NULL
- category — text — NOT NULL
review
- review_id — int — Primary key — NOT NULL
- content — text — NOT NULL
- rating — int — NOT NULL
- order_id — int — Foreign key → orders.order_id — NOT NULL
users
- user_id — int — Primary key — NOT NULL
- email — text — NOT NULL
- name — text — NOT NULL
- phone — text — NOT NULL