Merchant2 - Laravel Schema Designer

mer_product_category

id bigIncrements
timestamps timestamps
softDeletes softDeletes
product_id bigInteger
category_id bigInteger
product_category_order integer
scope string (100)

mer_related_product

id bigIncrements
timestamps timestamps
related_product_id bigInteger
parent_product_id bigInteger
product_id bigInteger
related_product_order integer
scope string (100)

mer_sku

id bigIncrements
timestamps timestamps
softDeletes softDeletes
attribute_id1 bigInteger
option_id1 bigInteger
attribute_id2 bigInteger
option_id2 bigInteger
attribute_id3 bigInteger
option_id3 bigInteger
attribute_id4 bigInteger
option_id4 bigInteger
attribute_id5 bigInteger
option_id5 bigInteger
number string (128)
name string (255)
message string (255)
extra1 string (255)
extra2 string (255)
extra3 string (255)
track_inventory string (255)
inventory_level integer
note string (255)
scope string (255)

mer_products

id bigIncrements
timestamps timestamps
name string (255)
keywords string (255)
short_description string (255)
description text
is_active tinyInteger
code string (100)
unit_price double (10,4)
unit_cost double (10,4)
weight double (10,4)
header text
footer text
is_taxed tinyInteger
small_image string (255)
medium_image string (255)
larage_image string (255)
extra1 string (255)
extra2 string (255)
extra3 string (255)
extra4 string (255)
extra5 string
category_id bigInteger
product_order integer
scope string (255)

mer_discounts

timestamps timestamps
id bigIncrements
softDeletes softDeletes
code string (100)
name string (255)
description text
is_active tinyInteger
user_applies_type string (32)
user_applies_value string (255)
item_applies_type string (32)
item_applies_value string (255)
reward_type string (32)
reward string (255)
coupon_code string (100)
start_date datetime
expiration_date datetime
times_used integer
max_times_used integer
is_times_per_customer tinyInteger
discount_order integer
extra1 string (255)
extra2 string (255)
extra3 string (255)
scope string (255)

mer_sku_discount

id bigIncrements
timestamps timestamps
softDeletes softDeletes
discount_id bigInteger
sku_id bigInteger
scope string (255)

mer_category

id bigIncrements
timestamps timestamps
softDeletes softDeletes
code string (100)
name string (255)
keywords string (255)
description text
is_active tinyInteger
category_itree_d bigInteger
header string (255)
footer string (255)
small_image string (255)
medium_image string (255)
larage_image string (255)
extra1 string (255)
extra2 string (255)
extra3 string (255)
parent_category_id bigInteger
category_order integer
scope string (255)

mer_product_attribute

id bigIncrements
timestamps timestamps
softDeletes softDeletes
product_id bigInteger
attribute_id bigInteger
scope string (255)

mer_attribute

id bigIncrements
timestamps timestamps
softDeletes softDeletes
code string (100)
name string (255)
is_active tinyInteger
description string (255)
type string (100)
unit_cost double (10,4)
unit_price double
all_price double (12,2)
weight double (10,4)
small_image string (255)
larage_image string (255)
option_id bigInteger
is_required tinyInteger
attribute_order tinyInteger
scope string (255)

mer_category_setting

id bigIncrements
timestamps timestamps
softDeletes softDeletes
category_id bigInteger
code string (100)
name string (255)
description string (255)
type string (100)
value_type string (255)
integer_value integer
small_value string (64)
larage_value string (255)
text_value text
scope string (255)

mer_product_setting

id bigIncrements
timestamps timestamps
softDeletes softDeletes
code string (100)
name string (255)
description string (255)
is_active tinyInteger
integer_value integer
small_value string (64)
larage_value string (255)
type string (100)
scope string (255)

mer_option

id bigIncrements
timestamps timestamps
softDeletes softDeletes
attribute_id bigInteger
code string (100)
name string (255)
description string (255)
unit_cost double (10,4)
unit_price double (10,4)
all_price double (12,2)
weight double
small_image string (255)
larage_image string (255)
option_order integer
scope string (255)

mer_country

id bigIncrements
timestamps timestamps
softDeletes softDeletes
code string (100)
name string (255)
is_active tinyInteger
allow_order_state tinyInteger
country_order tinyInteger
scope string (255)

mer_state

id bigIncrements
timestamps timestamps
softDeletes softDeletes
country_id bigInteger
code string (100)
name string (255)
is_active tinyInteger
state_order tinyInteger
scope string (255)

mer_basic_tax_rate

id bigIncrements
timestamps timestamps
softDeletes softDeletes
country_id bigInteger
state_id bigInteger
is_active tinyInteger
city string (255)
rate double (10,4)
scope string (255)
postal_code string (255)

mer_setting

id bigIncrements
softDeletes softDeletes
code string (100)
name string (255)
description string (255)
type string (100)
value_type string (16)
integer_value integer
small_value string (64)
medium_value string (255)
text_value text
scope string (255)
timestamps timestamps

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