7ason - Laravel Schema Designer

users

id increments
timestamps timestamps
first_name string (191)
second_name string (191)
email string (191)
password string (191)
birth_date date
role enum
image string (191)
gender enum
region_id ^FK integer

news

id increments
timestamps timestamps
title string (191)
image string (191)
body text

galleries

id increments
timestamps timestamps
title string (191)
image string (191)
video string (191)
body string (191)

settings

id increments
timestamps timestamps
name string (191)
type string (191)
ar_value longText
en_value longText
page string (191)
slug string (191)
title string (191)

other_branches

id increments
timestamps timestamps
name string (191)
telephone string (191)
address string (191)
image string (191)
status tinyInteger

brands

id increments
timestamps timestamps
image string (191)

addresses

id increments
timestamps timestamps
name string (191)
telephone string (191)
city_id ^FK integer
region_id ^FK integer
lng string (191)
lat string (191)
address string (191)

cities

id increments
timestamps timestamps
ar_name string (191)
en_name string (191)

regions

id increments
timestamps timestamps
city_id ^FK integer
ar_name string (191)
en_name string (191)

stores

id increments
ar_name string (191)
en_name string (191)
image string (191)
user_id ^FK integer
product_id integer
timestamps timestamps

products

id increments
timestamps timestamps
ar_name string (191)
en_name string (191)
description text
price string (191)
category_id ^FK integer
amount string (191)
sub_category_id ^FK integer
image string (191)

colors

id increments
name string (191)
timestamps timestamps

sizes

id increments
timestamps timestamps
shoulder string (191)
middle string (191)
length string (191)
width string (191)
sleeves string (191)

product_rates

id increments
timestamps timestamps
user_id ^FK integer
product_id ^FK integer
value integer
title string (191)
comment text
image string (191)

categories

id increments
timestamps timestamps
ar_name string (191)
en_name string (191)

sub_categories

id increments
timestamps timestamps
ar_name string (191)
en_name string (191)
category_id ^FK integer

orders

id increments
timestamps timestamps
status enum

companies

id increments
timestamps timestamps
ar_name string (191)
en_name string (191)
telephone string
order_id ^FK integer
price string (191)

points

id increments
timestamps timestamps
user_id ^FK integer

favorites

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

payments

id increments
card_number string (191)
name string (191)
date date
secret_code string (191)
user_id ^FK integer
timestamps timestamps

order_product

id increments
timestamps timestamps
total string (191)
amount string (191)
product_id ^FK integer
order_id ^FK integer

product_size

id increments
timestamps timestamps
product_id ^FK integer
size_id ^FK integer

color_product

id increments
timestamps timestamps
product_id ^FK integer
color_id ^FK integer

notifications

id increments
timestamps timestamps
title string (191)
user_id ^FK integer

contact_us

id increments
timestamps timestamps
address string (191)
telephone string (191)
email string (191)
facebook string (191)
twitter string (191)
instagram string (191)

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