I GEAR GEEK - Laravel Schema Designer

users

id increments
nickname string (50)
email string (150)
password string (150)
group tinyInteger
active tinyInteger
rememberToken rememberToken
timestamps timestamps
softDeletes softDeletes

categories

id increments
slug string (255)
image_name string (255)
name string (50)
short_description string
long_description text
active tinyInteger
position smallInteger
timestamps timestamps
softDeletes softDeletes

products

id increments
slug string (255)
category_id integer
name string (150)
code string (150)
short_description string (255)
long_description text
featured tinyInteger
rating tinyInteger
count_views integer
count_sales integer
active tinyInteger
option_parent_type_id integer
meta_title string (150)
meta_description string (255)
meta_image string (255)
timestamps timestamps
softDeletes softDeletes

product_specifications

product_id integer
brand_id integer
product_measures string (255)
package_weight decimal (8,3)
package_width decimal
package_length decimal
package_height decimal
package_content text
warranty_id integer

product_option_types

id increments
parent integer
name string (100)
value string (100)
unit string (50)
active tinyInteger
position smallInteger
timestamps timestamps
softDeletes softDeletes

brands

id increments
name string (100)
slug string (255)
active tinyInteger
timestamps timestamps
softDeletes softDeletes

warranties

id increments
name string (100)
active tinyInteger
description text
timestamps timestamps
softDeletes softDeletes

product_options

id increments
product_id integer
option_child_type_id integer
sku string (255)
image_name string (255)
regular_price decimal
sale_price decimal
active tinyInteger
position tinyInteger
timestamps timestamps

product_images

id increments
product_id integer
is_cover tinyInteger
image_name string (255)
caption string (255)
position smallInteger
active tinyInteger
timestamps timestamps

orders

id increments
member_id integer
fullname string (150)
phone string (30)
address string (255)
district_id integer
amphur_id integer
province_id integer
zipcode_id integer
total_price decimal
discount_price decimal
coupon_id integer
coupon_discount decimal
net_price decimal
remark text
shipping_id integer
shipping_price decimal
tracking_no string (50)
shipping_at datetime
timestamps timestamps
softDeletes softDeletes

members

id increments
fullname string (150)
email string (100)
password string (255)
phone string (30)
gender enum
date_of_birth date
activated tinyInteger
activation_code string (255)
activated_at datetime
last_login datetime
rememberToken rememberToken
timestamps timestamps
softDeletes softDeletes

member_addresses

id increments
member_id integer
is_default tinyInteger
fullname string (150)
phone string (30)
address string (255)
district_id integer
amphur_id integer
province_id integer
zipcode_id integer
timestamps timestamps
softDeletes softDeletes

order_payments

id increments
order_id integer
payment_status tinyInteger
payment_channel_id integer
payment_bank_account_id integer
payment_total decimal
payment_at datetime
file_name string (200)
remark text
fullname string (150)
phone string (30)
email string (100)
timestamps timestamps
softDeletes softDeletes

order_products

id increments
order_id integer
name string (150)
option_id integer
sku string (255)
option_type_name string (100)
option_type_value string (100)
option_type_unit string (50)
regular_price decimal
sale_price decimal
warranty_id integer
warranty_expire_date date

coupons

id increments
code string (100)
description text
min_spent decimal
discount_amount decimal
is_percent tinyInteger
discount_limit decimal
is_free_shipping tinyInteger
active tinyInteger
start_date datetime
end_date datetime
usage_limit_per_user integer
usage_limit_per_coupon_count integer
timestamps timestamps
softDeletes softDeletes

promotions

id increments
image_name string (255)
name string (200)
description text
max_discount_percent smallInteger
active tinyInteger
start_date datetime
end_date datetime
timestamps timestamps
softDeletes softDeletes

promotion_products

id increments
promotion_id integer
product_option_id integer
sale_price decimal

product_wishlists

member_id integer
product_id integer
timestamps timestamps

article_categories

id increments
slug string (255)
name string (100)
description text
active tinyInteger
position smallInteger
timestamps timestamps
softDeletes softDeletes

articles

id increments
slug string (255)
category_id integer
title string (255)
content text
image_name string (255)
featured tinyInteger
flag tinyInteger
count_views integer
count_shares integer
meta_title string (150)
meta_description string (255)
meta_image string (255)
created_by integer
updated_by integer
deleted_by integer
published_at datetime
timestamps timestamps
softDeletes softDeletes

tags

id increments
slug string (255)
name string (100)
description text
active tinyInteger
timestamps timestamps

article_tags_roles

article_id integer
tag_id integer

AAA

id increments
timestamps timestamps

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