ecommerce - Laravel Schema Designer

currencies

id increments
name string
symbol string
code string
decimal_digites string (50)
status tinyInteger
softDeletes softDeletes
timestamps timestamps

Ads

id increments
title string
content text
image string
category_id ^FK integer
status tinyInteger
timestamps timestamps

categories

id increments
name string
parent_id ^FK integer
status tinyInteger
tags text
sort integer
resturant_id ^FK bigInteger
show_in_navbar tinyInteger
timestamps timestamps
softDeletes softDeletes

foods

id increments
name string
discription text
price double
discount_price string
publish tinyInteger
category_id ^FK integer
calories integer
prepration_time time
size_id ^FK integer
sold_out tinyInteger
timestamps timestamps

sizes

id increments
name string
food_id ^FK integer
timestamps timestamps

resturant_setting

id increments
key string
value string
timestamps timestamps
resturant_id ^FK bigInteger

reviews

id increments
review text
rate double
user_id ^FK bigInteger
food_id bigInteger
resturant_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

extra

id increments
food_id ^FK integer
name string
description text
price double
status tinyInteger
timestamps timestamps

extra_food

id increments
food_id ^FK integer
extra_food_id ^FK integer
timestamps timestamps

tables

id bigInteger
number string
resturant_id ^FK bigInteger
timestamps timestamps

images

id increments
name string
file_name string
size string
types string
imageable_id integer
imageable_type string
timestamps timestamps

favourites

id increments
food_id ^FK integer
user_id ^FK integer
timestamps timestamps

notification

id increments
timestamps timestamps

notification_types

id increments
name string
timestamps timestamps

faqs

id increments
question string
answer text
feq_cateogry_id ^FK integer
timestamps timestamps

faq_cateogries

id increments
name string
timestamps timestamps

banners

id increments
image string
timestamps timestamps

payment_types

id increments
title string
stauts tinyInteger
timestamps timestamps

orders

id bigIncrements
usrer_id bigInteger
price double
tax double
services_amount double
total_price double
resturant_id ^FK bigInteger
table_id ^FK bigInteger
payment_type_id ^FK integer
status tinyInteger
timestamps timestamps

order_items

id bigIncrements
food_id ^FK integer
qty string
is_gift string
price string
timestamps timestamps
order_id ^FK bigInteger

users

id bigIncrements
name string
email string
phone string
type string
avatar string
timestamps timestamps
softDeletes softDeletes

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