talabat - Laravel Schema Designer

clients

id increments
timestamps timestamps
first_name string (255)
last_name string (255)
email string (255)
number string (11)
password string (255)
provider_id integer
longitude decimal
latitude decimal

restaurants

id increments
timestamps timestamps
name string (255)
email string (255)
image string (255)
address string (255)
phone string (11)
lang decimal
lat decimal
rate integer
status enum
from datetime
to datetime
category_id ^FK integer

restaurants_categories

id increments
timestamps timestamps
name string (255)

products

id increments
timestamps timestamps
name string (255)
price double (8,2)
time integer
description string (255)
image string (255)
rate float
discount float (0,2)
category_id ^FK integer
restaurant_id ^FK integer
voucher_code string (255)
voucher_discount decimal (0.2)

product_reviews

id increments
timestamps timestamps
comment string (255)
rating double
client_id ^FK integer
product_id ^FK integer

restaurant_reviews

id increments
timestamps timestamps
packaging float
money float
delivery_time float
quality_of_food float
restaurant_id ^FK integer
client_id ^FK integer

orders

id increments
timestamps timestamps
address string (255)
status enum
payment_method enum
preparing_time smallInteger
delivery_time smallInteger
delivery_cost double (8,2)
delivery_man_id integer
client_id ^FK integer
restaurant_id ^FK integer

order_product

id increments
timestamps timestamps
price double
quantity smallInteger
notes string
order_id ^FK integer
product_id ^FK integer

products_categories

id increments
timestamps timestamps
name string

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01