ThunderMeat - Laravel Schema Designer

users

id increments
uuid string (255)
name string (255)
email string (255)
phone string (255)
role ^FK integer
status tinyInteger
dateofbirth string (255)
gender enum
profilePic string (255)
password string (255)
merchant_id string (255)
corporation_name string (255)
corporation_number string (255)
ceo string (255)
operation_certificate string (255)
bussiness_number string (255)
bussiness_registration string (255)
softDeletes softDeletes
timestamps timestamps

roles

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
displayname string (255)
description string (255)
permissions ^FK integer
status tinyInteger

permissions

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
displayname string (255)
description string (255)
status tinyInteger

categories

id increments
timestamps timestamps
softDeletes softDeletes
parent_category integer
name string (255)
slug string (255)
tags string (255)
status tinyInteger
icon string (255)
shop_id ^FK integer

coupenLists

id increments
timestamps timestamps
softDeletes softDeletes
code string (255)
type enum
status tinyInteger
shop_id ^FK integer
details string (255)
discount double
discount_type string (255)
start_date date
end_date date

banners

id increments
timestamps timestamps
softDeletes softDeletes
image string (255)
published tinyInteger
shop_id ^FK integer

requests

id increments
timestamps timestamps
softDeletes softDeletes
type string (255)
description string (255)
status tinyInteger
shop_id ^FK integer

notifications

id increments
timestamps timestamps
softDeletes softDeletes
type string (255)
description string (255)
status tinyInteger
shop_id ^FK integer

bankDetails

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
bank_name string (255)
account_number string (255)

shops

id increments
timestamps timestamps
softDeletes softDeletes
store_name string (255)
store_manager string (255)
store_phone string (255)
sector string (255)
bussiness_address string (255)
bussiness_condition string (255)
store_image string (255)
password string (255)
delivery_radius integer
logo string (255)
facebook string (255)
google string (255)
twitter string (255)
youtube string (255)
user_id ^FK integer
about_shop mediumText

meats

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)
image string (255)
stock integer
price double
thickness integer
thickness_image string (255)
shop_id ^FK integer
cat_id ^FK integer
sub_cat_id string
user_id ^FK integer
car_reference longText

shopnews

id increments
timestamps timestamps
softDeletes softDeletes
shop_id ^FK integer
title string (255)
description text
status tinyInteger

shopAvailableTime

id increments
timestamps timestamps
softDeletes softDeletes
shop_id ^FK integer
dayname string (255)
start_time string (100)
end_time string (100)
off_day enum

orders

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
shipping_address string (255)
payment_type string (255)
payment_status string (255)
payment_details mediumText
grand_total double
coupon_discount double
code string
date date
viewed tinyInteger
delivery_viewed tinyInteger
payment_status_viewed tinyInteger
commission_calculated tinyInteger

order_details

id increments
timestamps timestamps
softDeletes softDeletes
order_id ^FK integer
shop_id ^FK integer
product_id ^FK integer
variation text
price double
tax double
shipping_cost double
quantity integer
payment_status string (50)
delivery_status string (50)
shipping_type string (50)
pickup_point_id string (100)
coupon_code string (100)
weight string (50)
size string (50)
comments string (255)
requests string (255)

reviews

id increments
timestamps timestamps
softDeletes softDeletes
shop_id ^FK integer
user_id integer
comment string (255)
status integer
viewed integer

faqs

id increments
timestamps timestamps
softDeletes softDeletes
shop_id ^FK integer
title string (255)
description mediumText
status tinyInteger

general_settings

id increments
timestamps timestamps
softDeletes softDeletes
frontend_color string (255)
logo string (100)
admin_logo string (100)
admin_login_background string (100)
admin_login_sidebar string (100)
favicon string (100)
site_name string (100)
address string (100)
description string (100)
phone string (100)
email string (100)
facebook string (100)
instagram string (100)
twitter string (100)
youtube string (100)
google_plus string (100)

currencies

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
symbol string (100)
exchange_rate string (100)
status integer
code string (20)

languages

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
code string (100)
rtl tinyInteger

favourites

id increments
timestamps timestamps
softDeletes softDeletes
shop_id integer
user_id integer

ratings

id increments
timestamps timestamps
softDeletes softDeletes
shop_id ^FK integer
user_id ^FK integer
rating integer

sliders

id increments
timestamps timestamps
softDeletes softDeletes
photo string (255)
published tinyInteger
link string (255)

user_access_tokens

id increments
timestamps timestamps
uuid string (255)
access_token text
disabled tinyInteger
last_used_at datetime

business_settings

id increments
timestamps timestamps
type string (255)
value string (255)