sofra - Laravel Schema Designer

restaurant

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

customer

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

product

id increments
timestamps timestamps
name string
image_url string
price decimal
offer_price decimal
prep_time integer
description string

promotion

id increments
timestamps timestamps
name string
description string
from date
to date
value decimal (4,2)

customer_restaurant

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

cart

id increments
timestamps timestamps
customer_id ^FK integer
total decimal

order_product

order_id ^FK integer
product_id ^FK integer
qty integer
price decimal

order

id increments
timestamps timestamps
customer_id ^FK integer
payment_id ^FK integer
state_id ^FK integer
notes string
subtotal decimal
delivery_fee decimal
total decimal

cart_product

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

payment_method

id increments
method string

cuisine

id increments
timestamps timestamps
name string

cuisine_restaurant

cuisine_id ^FK integer
restaurant_id ^FK integer

district

id increments
timestamps timestamps
name string

city

id increments
timestamps timestamps
district_id ^FK integer
name string

notification

id increments
timestamps timestamps
body string

customer_notification

customer_id ^FK integer
notification_id ^FK integer
is_read boolean

order_state

id increments
timestamps timestamps
state string

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