Home
ecommerce
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
users
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
email
string
password
string
status
boolean
type
string
avatar
string
phone
string
disabled_at
timestamp
roles
id
increments
timestamps
timestamps
softDeletes
softDeletes
attributes
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
status
boolean
attribute_details
id
increments
timestamps
timestamps
softDeletes
softDeletes
attribute_id
FK
integer
name
string
products
id
increments
timestamps
timestamps
softDeletes
softDeletes
sku
string
name
string
description
text
tags
string
category_id
FK
bigInteger
brand_id
FK
bigInteger
unit
string
refundable
boolean
free_shipping
boolean
low_stock_quantity
integer
show_stock_quantity
boolean
cash_on_delivery
boolean
todays_deal
boolean
estimate_shipping
integer
tax
double
discount
double
quantity
integer
meta_title
string
meta_description
text
available
boolean
categories
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
slug
string
status
boolean
parent_id
FK
bigInteger
order
integer
icon
string
banner
string
show_in_navbar
boolean
brands
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
logo
string
status
boolean
product_offers
id
increments
timestamps
timestamps
softDeletes
softDeletes
product_id
FK
bigInteger
day_start
datetime
day_end
datetime
percentage
double
(2,2)
price
double
quantity
integer
orders
id
increments
timestamps
timestamps
softDeletes
softDeletes
coupon_id
FK
bigInteger
user_id
FK
bigInteger
address_id
FK
bigInteger
tax_percentage
decimal
type
tinyInteger
payment
tinyInteger
total_cost
decimal
order_status_id
FK
bigInteger
total_products
decimal
reference
string
order_details
id
increments
timestamps
timestamps
softDeletes
softDeletes
order_id
FK
bigInteger
product_id
FK
bigInteger
quantity
integer
delivery_date
datetime
comments
id
increments
softDeletes
softDeletes
timestamps
timestamps
rate
string
order_id
FK
bigInteger
rate_comment
string
status
boolean
cart_payments
id
increments
timestamps
timestamps
softDeletes
softDeletes
method
string
method_title
string
order_id
FK
bigInteger
product_reviews
id
increments
timestamps
timestamps
softDeletes
softDeletes
title
string
rating
integer
comment
text
status
boolean
product_id
FK
bigInteger
user_id
FK
bigInteger
product_images
id
increments
timestamps
timestamps
softDeletes
softDeletes
type
string
path
string
product_id
FK
bigInteger
shipments
id
increments
timestamps
timestamps
softDeletes
softDeletes
status
string
total_qty
integer
total_weight
integer
carrier_code
string
carrier_title
string
track_number
text
email_sent
boolean
customer_id
FK
bigInteger
order_id
FK
bigInteger
order_address_id
FK
bigInteger
shipment_items
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
description
string
qty
string
weight
string
price
decimal
product_id
FK
bigInteger
order_item_id
FK
bigInteger
shipment_id
FK
bigInteger
additional
json
product_type
string
total_cost
decimal
settings
timestamps
timestamps
id
increments
softDeletes
softDeletes
key
string
value
text
status
boolean
name
string
setting_group_id
FK
integer
type
enum
slides
id
increments
timestamps
timestamps
softDeletes
softDeletes
image
string
heading
string
description
text
link
string
status
boolean
contacts
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
email
string
subject
string
message
text
coupons
id
increments
timestamps
timestamps
softDeletes
softDeletes
code
string
type
string
amount_type
enum
amount
double
from
timestamp
to
timestamp
status
boolean
social_links
id
increments
timestamps
timestamps
name
string
icon_code
string
icon_color
string
url
string
wishlists
id
increments
timestamps
timestamps
softDeletes
softDeletes
product_id
FK
bigInteger
user_id
FK
bigInteger
countries
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
code
string
status
boolean
cities
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
state_code
string
status
boolean
addresses
id
increments
timestamps
timestamps
softDeletes
softDeletes
address_1
string
address_2
string
state_code
string
city_id
FK
bigInteger
country_id
FK
bigInteger
user_id
FK
bigInteger
status
boolean
currencies
id
increments
timestamps
timestamps
softDeletes
softDeletes
Transactions
id
increments
timestamps
timestamps
softDeletes
softDeletes
pages
id
increments
timestamps
timestamps
softDeletes
softDeletes
title
string
content
text
image
text
status
boolean
order_status
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
status
boolean
attribute_products
id
increments
timestamps
timestamps
softDeletes
softDeletes
product_id
FK
bigInteger
attribute_id
FK
bigInteger
value
string
setting_groups
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
image
string
description
text
ads
id
increments
timestamps
timestamps
softDeletes
softDeletes
title
string
url
string
start_date
date
end_date
date
menus
id
increments
timestamps
timestamps
softDeletes
softDeletes
title
string
parent_id
FK
bigInteger
status
boolean
show_in_navbar
boolean
url
string
sort
integer
×
Comments for ecommerce
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01