epices - Laravel Schema Designer

users

id increments
timestamps timestamps
name string (255)
email string (255)
password string (255)
guid string (255)
role enum
status boolean

orders

id increments
timestamps timestamps
order_date datetime
order_tax float
order_total float
order_promotion float
status enum
id_user ^FK integer
id_coupon ^FK integer

invoices

id increments
timestamps timestamps
invoice_total float
original_filename string (255)
filename string (255)
invoice_type string (255)
id_order ^FK integer

coupons

id increments
timestamps timestamps
coupon_type string (255)
coupon_description string (255)
valid_until datetime
id_order ^FK integer
percent float

reviews

id increments
timestamps timestamps
comment string (255)
rating float
is_approved boolean
id_epice ^FK integer
id_user ^FK integer

epices

id increments
id_category ^FK integer
timestamps timestamps
name string (255)
short_description text
description text
number integer
image_url string (255)
price float
stock smallInteger
guid string (255)
id_tax ^FK integer
status boolean

category

id increments
timestamps timestamps
name string (255)
description text
guid string (255)

promotions

id increments
timestamps timestamps
start datetime
end datetime
promotion_type string (255)
guid string (255)
id_epice ^FK integer
percent float

taxs

id increments
timestamps timestamps
type string (255)
percent float
guid string (255)

product_meta

id increments
timestamps timestamps
avg_rating float
total_sales integer
rating_count integer
date_start datetime
date_end datetime
guid string (255)
id_epice ^FK integer

order_items

id increments
id_order ^FK integer
timestamps timestamps
tax_rate float
price float
promotion_amount float
order_item_amount float
tax_amount float
guid string (255)
id_epice integer

customer_meta

id increments
timestamps timestamps
first_name string (255)
last_name string (255)
phone string (255)
date_last_active datetime
country string (255)
post_code string (255)
city string (255)
street string (255)
street_number string (255)
guid string (255)
id_user ^FK integer

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