Sofra - Laravel Schema Designer

sellers

id increments
shop_name string
district_id ^FK integer
email string (150)
password string
min_charge decimal
delivery_cost decimal
mobile string (25)
whatsapp string (25)
image string
is_on boolean
timestamps timestamps

cities

id increments
city string
timestamps timestamps

products

id increments
name string
seller_id ^FK integer
description string
price decimal
deadline string
image string
timestamps timestamps

offers

id increments
seller_id ^FK integer
name string
description text
price decimal
from datetime
to datetime
image string
timestamps timestamps

categories

id increments
name string
timestamps timestamps

notifcations

id increments
title string
order_id ^FK integer
body string
notfiable_id integer
notfiable_type string
timestamps timestamps

settings

id increments
fb_url string
whatsapp_url string
instagram_url string
terms_conditions string
timestamps timestamps

contact_us

id increments
request enum
name string
email string
mobile string
body string
timestamps timestamps

buyers

id increments
name string
email string (150)
mobile string (25)
district_id ^FK integer
address string
password string
timestamps timestamps

orders

id increments
buyer_id ^FK integer
seller_id ^FK integer
status enum
cost decimal
delivery_cost decimal
total decimal
commission decimal
notes decimal
timestamps timestamps

reviews

id increments
seller_id ^FK integer
buyer_id ^FK integer
review text
star integer
timestamps timestamps

districts

id increments
city_id ^FK integer
district string
timestamps timestamps

order_product

id increments
timestamps timestamps
product_id ^FK integer
order_id ^FK integer
price decimal
quantitiy string
special_req mediumText

category_seller

id increments
timestamps timestamps
category_id ^FK integer
seller_id ^FK integer

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