Home
kosme
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
customers
id
increments
timestamps
timestamps
softDeletes
softDeletes
uuid
uuid
name
string
gender
tinyInteger
dob
date
pob
string
user_id
integer
number
string
(127)
is_enabled
boolean
created_by
integer
updated_by
integer
products
id
increments
timestamps
timestamps
softDeletes
softDeletes
uuid
uuid
brand_id
integer
title
string
description
text
weight
float
dimension
json
unit_id
integer
created_by
integer
updated_by
integer
is_digital
boolean
variants
id
increments
timestamps
timestamps
softDeletes
softDeletes
uuid
uuid
title
string
sku
string
(127)
product_id
integer
stock_total
float
stock_buffered
float
is_enabled
boolean
is_available
boolean
dimension
json
weight
float
unit_id
integer
description
text
created_by
integer
updated_by
integer
prices
id
increments
timestamps
timestamps
softDeletes
softDeletes
uuid
uuid
variant_id
integer
currency_code
char
(3)
amount
decimal
(16,2)
min_quantity
float
max_quantity
float
is_default
boolean
is_enabled
boolean
updated_by
integer
created_by
integer
product_categories
id
increments
timestamps
timestamps
softDeletes
softDeletes
uuid
uuid
title
string
(127)
parent_id
integer
description
text
index
integer
is_enabled
boolean
is_featured
boolean
created_by
integer
updated_by
integer
product_parameters
id
increments
timestamps
timestamps
uuid
uuid
slug
string
(63)
description
text
values
json
index
integer
updated_by
integer
created_by
integer
variant_parameters
id
increments
timestamps
timestamps
uuid
uuid
variant_id
integer
slug
string
(63)
value
string
(127)
remarks
text
updated_by
integer
created_by
integer
brands
id
increments
timestamps
timestamps
softDeletes
softDeletes
uuid
uuid
title
string
(127)
is_digital
boolean
description
text
index
integer
is_enabled
boolean
is_featured
boolean
created_by
integer
updated_by
integer
product_category_pivots
id
increments
timestamps
timestamps
uuid
uuid
product_id
integer
category_id
integer
created_by
integer
updated_by
integer
description_pivots
id
increments
timestamps
timestamps
uuid
uuid
product_id
integer
slug
string
(63)
description
text
index
integer
is_enabled
boolean
created_by
integer
updated_by
integer
enablers
id
increments
timestamps
timestamps
uuid
uuid
ref_id
integer
ref_model
string
(127)
ref_table
string
(127)
enabled_at
timestamp
disabled_at
timestamp
created_by
integer
updated_by
integer
carts
id
increments
timestamps
timestamps
uuid
uuid
customer_id
integer
is_current
boolean
voucher_code
string
(63)
payment_method
integer
data
json
item_count
integer
created_by
integer
updated_by
integer
cart_items
id
increments
timestamps
timestamps
cart_id
integer
uuid
uuid
variant_id
integer
product_id
integer
seller_id
integer
quantity
float
remarks
text
address_id
integer
is_selected
boolean
data
json
created_by
integer
updated_by
integer
orders
id
increments
timestamps
timestamps
softDeletes
softDeletes
uuid
uuid
group_id
integer
cart_id
integer
customer_id
integer
number
string
(127)
date_issued
timestamp
date_paid
timestamp
date_processed
timestamp
date_manifested
timestamp
date_shipped
timestamp
date_completed
timestamp
data
json
status
smallInteger
updated_by
integer
created_by
integer
order_groups
id
increments
timestamps
timestamps
uuid
uuid
created_by
integer
updated_by
integer
order_items
id
increments
timestamps
timestamps
order_id
integer
uuid
uuid
variant_id
integer
product_id
integer
remarks
mediumText
payment_methods
id
increments
timestamps
timestamps
uuid
uuid
slug
string
(63)
title
string
(127)
description
text
is_enabled
boolean
created_by
integer
updated_by
integer
vouchers
id
increments
timestamps
timestamps
uuid
uuid
brand_id
integer
code
string
(63)
is_enabled
boolean
is_expired
boolean
quota
integer
quota_fulfilled
integer
quota_buffered
integer
title
string
(127)
description
text
updated_by
integer
created_by
integer
voucher_pivots
id
increments
timestamps
timestamps
uuid
uuid
voucher_id
integer
ref_type
string
(127)
ref_table
string
(63)
ref_id
integer
notifications
id
uuid
timestamps
timestamps
notifiable_id
integer
notifiable_type
string
data
text
read_at
timestamp
data_stores
id
increments
timestamps
timestamps
uuid
uuid
type_id
integer
title
string
description
text
data
json
created_by
integer
updated_by
integer
softDeletes
softDeletes
data_store_pivots
id
increments
timestamps
timestamps
uuid
uuid
ref_id
integer
ref_model
string
(127)
ref_table
string
(63)
data_id
integer
slug
string
(63)
index
integer
created_by
integer
updated_by
integer
data_store_types
id
increments
timestamps
timestamps
uuid
uuid
title
string
(127)
description
text
updated_by
integer
created_by
integer
comments
id
bigIncrements
uuid
uuid
body
text
commentable_id
bigInteger
commentable_type
string
read_at
datetime
created_by
bigInteger
updated_by
bigInteger
timestamps
timestamps
faqs
id
increments
uuid
uuid
index
integer
question
string
answer
text
helpful_no
integer
helpful_yes
integer
timestamps
timestamps
softDeletes
softDeletes
created_by
integer
updated_by
integer
is_enabled
boolean
reviews
id
increments
uuid
uuid
content
text
ref
morphs
user_id
integer
hidden_at
timestamp
is_trusted
boolean
timestamps
timestamps
like_total
integer
dislike_total
integer
average_rating
decimal
articles
id
increments
uuid
uuid
title
string
content
longText
video_url
string
status
string
author_name
string
published_at
datetime
created_by
integer
updated_by
integer
softDeletes
softDeletes
timestamps
timestamps
slug
string
tags
id
increments
name
string
slug
string
type
string
order_column
integer
timestamps
timestamps
taggables
tag_id
bigInteger
taggable_type
string
taggable_id
string
wishlist
id
increments
timestamps
timestamps
uuid
uuid
user_id
bigInteger
ref_type
string
ref_id
bigInteger
ref_table
string
banners
id
increments
uuid
uuid
title
string
description
text
bannerable_type
string
bannerable_id
integer
bannerable_table
string
is_enabled
boolean
index
integer
url
string
created_by
integer
updated_by
integer
softDeletes
softDeletes
timestamps
timestamps
flashsales
id
increments
uuid
uuid
title
string
description
text
is_enabled
boolean
created_by
integer
updated_by
integer
timestamps
timestamps
flashsale_items
id
increments
timestamps
timestamps
uuid
uuid
ref_id
string
ref_type
string
ref_table
string
price_id
integer
stock_total
integer
stock_buffered
integer
transactions
id
increments
timestamps
timestamps
uuid
uuid
date
timestamp
invoice_number
string
type
smallInteger
remarks
text
ref_table
string
(127)
ref_model
string
(127)
ref_id
integer
amount_previous
decimal
(16,2)
amount
decimal
(16,2)
amount_final
decimal
(16,2)
currency_id
char
(3)
status
integer
article_categories
id
increments
timestamps
timestamps
index
integer
title
string
description
text
is_enabled
boolean
is_featured
boolean
article_pivots
id
increments
timestamps
timestamps
uuid
uuid
article_id
integer
category_id
integer
review_category
id
increments
timestamps
timestamps
title
string
description
text
is_enabled
boolean
index
string
uuid
uuid
review_category_pivots
id
increments
timestamps
timestamps
review_id
bigInteger
category_id
integer
rating
smallInteger
likeable_pivots
id
increments
timestamps
timestamps
user_id
integer
ref
morphs
skin_diaries
id
increments
uuid
uuid
user_id
string
date
date
description
text
timestamps
timestamps
custom_properties
json
skin_diary_products
id
increments
skin_diary_id
bigInteger
uuid
uuid
title
string
brand
string
url
string
description
text
ref
nullableMorphs
ref_table
string
rating
tinyInteger
step_name
string
index
tinyInteger
timestamps
timestamps
skin_diary_template
id
increments
uuid
uuid
title
string
description
text
collection
string
index
smallInteger
created_by
integer
updated_by
integer
timestamps
timestamps
skin_template_slot
id
increments
template_id
integer
uuid
uuid
title
string
type
string
(20)
source
string
text
string
manipulations
json
timestamps
timestamps
quests
id
increments
uuid
uuid
title
string
event_name
string
description
text
point
integer
repeateable
boolean
multipliable
boolean
requirement_type
string
requirement_subject_relation
string
requirement_value
integer
requirement_field
string
requirement_operator
string
(5)
quota
integer
limit_interval
smallInteger
limit_per_user
boolean
start_at
datetime
end_at
datetime
created_by
integer
updated_by
integer
timestamps
timestamps
softDeletes
softDeletes
badges
id
increments
name
string
description
text
icon
string
level
tinyInteger
timestamps
timestamps
point_min
integer
point_maintain
integer
purchase_min
integer
reputations
id
increments
quest_id
integer
name
string
point
integer
subject
morphs
user_id
integer
meta
json
timestamps
timestamps
user_badges
timestamps
timestamps
user_id
integer
badge_id
integer
rewards
id
increments
uuid
uuid
title
string
description
text
is_enabled
boolean
quantity
integer
given_type
string
slug
string
ref_table
string
ref
nullableMorphs
custom_properties
json
created_by
integer
updated_by
integer
timestamps
timestamps
given_value
string
user_rewards
id
increments
uuid
uuid
reward_id
integer
user_id
integer
timestamps
timestamps
valid_from
datetime
expired_at
datetime
redeemed_at
datetime
badge_reward_pivots
badge_id
integer
reward_id
integer
timestamps
timestamps
commerce_events
id
increments
uuid
uuid
event_type
string
ref
nullableMorphs
ref_table
string
custom_properties
json
user_agent
string
source_ip
ipAddress
url
string
referrer
string
timestamps
timestamps
commerce_periodic_reports
id
increments
uuid
uuid
ref
nullableMorphs
ref_table
string
event_type
string
period_type
string
period_value
string
value
float
custom_properties
json
timestamps
timestamps
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01