Zabiha-Online-App - Laravel Schema Designer

products

id increments
name string
image string
category_id ^FK integer
description text
main_price double
discount_price double
status boolean
store_quantity double
timestamps timestamps

categories

id increments
name string
image string
status boolean
timestamps timestamps

options

id increments
name string
input_type enum
timestamps timestamps

option_values

id increments
option_id ^FK integer
value string
price double
timestamps timestamps

category_option

id increments
option_id integer
category_id integer
timestamps timestamps

orders

id increments
user_id integer
location_id ^FK integer
delivery_time_id ^FK integer
delivery_date date
delivery_type enum
subtotal double
total double
status bigInteger
note text
timestamps timestamps

order_product

id increments
order_id integer
product_id integer
price double
quantity integer
note text
timestamps timestamps

product_reviews

id increments
product_id ^FK integer
user_id integer
comment text
rating tinyInteger
status boolean
timestamps timestamps

contact_us

id increments
neme string
phone string
message text
timestamps timestamps

settings

id increments
app_name string
phone string
email string
whatsapp string
twitter string
privacy_policy string
terms_conditions longText
about_us longText
logo string
value_added double
timestamps timestamps

coupons

id increments
code string
discount string
timestamps timestamps

notifications

id increments
user_id integer
order_id ^FK integer
title string
body string
timestamps timestamps

option_product

id increments
option_value_id ^FK bigInteger
product_id ^FK bigInteger
option_price double
timestamps timestamps

locations

id increments
user_id integer
city_id ^FK integer
address text
lat decimal
long string
timestamps timestamps

cities

id increments
timestamps timestamps
name string
shipping_cost double
status boolean

delivery_times

id increments
from time
to time
timestamps timestamps

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