matrizo - Laravel Schema Designer

products

id increments
timestamps timestamps
title string
store_id ^FK integer
short_description string
brand_name string
percentage_discount string
description string
shipping_information text
return_policy text
specification text
warranty text
price string
product_type_id ^FK integer
feature_image string
terms_and_conditions boolean

users

id increments
timestamps timestamps
username string
email string
first_name string
last_name string
sex enum
date_of_birth date
phone_number string
street string
area string
city string
password string
profile_picture string
country_id ^FK integer
state_id ^FK integer
local_government_id ^FK integer
role_id ^FK integer
terms_and_conditions boolean

roles

id increments
timestamps timestamps

vendors

id increments
timestamps timestamps
user_id ^FK integer
full_name string
bank_name string
account_type string
account_number string

stores

id increments
timestamps timestamps
business_id ^FK integer
name string
email string
phone_number string
description string
area string
city string
state_id ^FK integer
country_id ^FK integer
average_delivery_time_rating string
local_government_id ^FK integer
average_quality_rating string
average_customer_satisfaction_rating string

store_ratings

id increments
timestamps timestamps
user_id ^FK integer
store_id ^FK integer
rating_type string
rating integer

store_user

id increments
timestamps timestamps
store_id ^FK integer
user_id ^FK integer
user_type string

product_gallery

id increments
timestamps timestamps
product_id ^FK integer
image_url string

product_meta_info

id increments
timestamps timestamps
product_id ^FK integer
key string
value string

product_types

id increments
timestamps timestamps
title string

trending_cities

id increments
timestamps timestamps
state_id ^FK integer
view_counts integer

orders

id increments
timestamps timestamps
user_id ^FK integer
street string
area string
city string
country_id ^FK integer
state_id ^FK integer
local_government_id ^FK integer
store_pickup boolean
delivery_options string
voucher_code string
voucher_discount string
delivery_charge string
total_amount string
final_amount string
payment_gateway string
card_holder_name string
status string

order_product

id increments
timestamps timestamps
product_id ^FK integer
order_id ^FK integer
quantity integer

wishlists

id increments
timestamps timestamps
product_id ^FK integer
user_id ^FK integer

countries

id increments
timestamps timestamps
name string

states

id increments
timestamps timestamps
name string
capital string
feature_image string
country_id ^FK integer

local_government

id increments
timestamps timestamps
name string
question string
answer string
state_id ^FK integer

faqs

id increments
timestamps timestamps

contacts

id increments
timestamps timestamps
email string
username string
message text

business

id increments
timestamps timestamps
name string
logo string
type string
description string
phone_number string
email string
year_started string
area string
street string
city string
country_id ^FK integer
state_id ^FK integer
local_government_id ^FK integer
vendor_id ^FK integer

slider

id increments
title string
sub_title string
btn_text string
image_url string

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