sofra - Laravel Schema Designer

restaurants

id increments
timestamps timestamps
name string
email string
phone string
city_id ^FK integer
password string
whatsapp_number string
image_url string
is_open boolean
delivery_fee integer
min_order integer

customers

id increments
timestamps timestamps
city_id ^FK integer
name string
email string
phone string
password string

products

id increments
timestamps timestamps
name string
image_url string
price decimal (8,2)
offer_price decimal (8,2)
prep_time integer
description string

offers

id increments
timestamps timestamps
name string
description string
from datetime
to datetime
restaurant_id ^FK integer

customer_restaurant

customer_id ^FK integer
restaurant_id ^FK integer
body string
rating tinyInteger

carts

id increments
timestamps timestamps
customer_id ^FK integer
total decimal (8,2)

order_product

order_id ^FK integer
product_id ^FK integer
qty integer
price decimal (8,2)

orders

id increments
timestamps timestamps
customer_id ^FK integer
payment_id ^FK integer
state string
notes string
subtotal decimal (8,2)
delivery_fee decimal (8,2)
comission decimal (8,2)

cart_product

cart_id ^FK integer
product_id ^FK integer
qty integer
special_request string

payment_method

id increments
method string

categories

id increments
timestamps timestamps
name string

cuisine_restaurant

cuisine_id ^FK integer
restaurant_id ^FK integer

districts

id increments
timestamps timestamps
name string
city_id ^FK integer

cities

id increments
timestamps timestamps
name string

notifications

id increments
timestamps timestamps
body string

customer_notification

customer_id ^FK integer
notification_id ^FK integer
is_read boolean

promotion_restaurant

promotion_id ^FK integer
restaurant_id ^FK integer

customer_promotion

customer_id ^FK integer
promotion_id ^FK integer
order_id ^FK integer

about_us

id increments
timestamps timestamps
description string

contact_us

id increments
timestamps timestamps
full_name string
email string
phone string
message string
message_type ^FK integer

message_type

id increments
timestamps timestamps
type string

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