Home
ecommerceapp
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
products
id
increments
id_store
FK
integer
id_brand
FK
integer
id_category
FK
integer
id_user
FK
integer
timestamps
timestamps
softDeletes
softDeletes
short_description
string
(600)
full_description
text
base_price
float
(10,2)
code
string
(12)
views_count
bigInteger
is_actived
integer
views_counter
integer
brands
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
(120)
url_web
string
(800)
url_image
string
(800)
contry
string
(200)
telephone
string
(25)
address
string
(300)
zip_code
integer
city
string
(60)
state
string
(60)
url_logo
string
(300)
product_galerys
id
increments
timestamps
timestamps
id_product
FK
integer
url_image
string
(800)
reviews
id
increments
timestamps
timestamps
id_user
integer
id_product
FK
integer
description
text
counter_stars
integer
is_active
integer
attributes
id
increments
timestamps
timestamps
id_product
FK
integer
name
string
(100)
type
integer
content
text
product_configs
id
increments
timestamps
timestamps
id_product
FK
integer
review_is_active
integer
due_date
datetime
discount
float
(10,2)
stores
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
(200)
code
string
(20)
store_configs
id
increments
timestamps
timestamps
softDeletes
softDeletes
country
string
(20)
orders
id
increments
timestamps
timestamps
id_user
FK
integer
id_purchase_address
string
(600)
status
integer
payment_method
string
(200)
users
id
increments
timestamps
timestamps
role
integer
orders_products
id
increments
id_product
FK
integer
id_order
FK
integer
timestamps
timestamps
quantity
integer
inventorys
id
increments
timestamps
timestamps
id_product
FK
integer
quantity
integer
categorys
id
increments
timestamps
timestamps
slug
string
(50)
name
string
(200)
description
text
tied_products
id
increments
timestamps
timestamps
parent
integer
child
integer
store_logs
id
increments
id_user
FK
integer
id_store
FK
integer
timestamps
timestamps
type
string
(100)
description
text
purchase_address
id
increments
id_order
FK
integer
id_user
FK
integer
timestamps
timestamps
shipping_address
text
first_name
string
(120)
last_name
string
(200)
city
string
(100)
state
string
(60)
country
string
(60)
additional_comment
text
zip_code
integer
assigned_stores
id
increments
timestamps
timestamps
id_user
FK
integer
id_store
FK
integer
invoicings_config
id
increments
timestamps
timestamps
copyright
string
(120)
url_logo
string
(600)
footer_text
string
(600)
store_currencies
id
increments
timestamps
timestamps
id_store
FK
integer
currency
string
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01