paintsShop - Laravel Schema Designer

users

id increments
name string (200)
national_id string (100)
governorate_id ^FK bigInteger
city_id ^FK bigInteger
address string (200)
code string (20)
confirmation_code string
phone_code enum
phone string (50)
longitude double
latitude double
is_blocked enum
is_login enum
logo string
software_type enum
timestamps timestamps

products

id increments
category_id ^FK bigInteger
product_name string (200)
description string
image string
quantity integer
price double
discount double
discount_in_precent double
bonuses bigInteger
x_of_bonuses integer
timestamps timestamps
softDeletes softDeletes

user_bonuses

id increments
user_id ^FK bigInteger
product_id ^FK bigInteger
timestamps timestamps

colors

id increments
color_code string (100)
timestamps timestamps

products_colors

id increments
product_id ^FK bigInteger
color_id ^FK bigInteger
timestamps timestamps

prizes

id increments
name string (200)
description string (200)
image string
bonuses_number bigInteger
timestamps timestamps
requestes bigInteger

users_prizes

id increments
user_id ^FK bigInteger
prize_id ^FK bigInteger
timestamps timestamps

categories

id increments
name string
description string
timestamps timestamps

governorates

id increments
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string
governorate_id ^FK bigInteger

galleries

id increments
timestamps timestamps
name string
governorate_id ^FK bigInteger
address string
details string
distance string
phone string
longitude double
latitude double

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