gothshop_db - Laravel Schema Designer

core_products

id increments
uuid string (255)
type_id integer
sku string (255)
brand_id integer
timestamps timestamps
softDeletes softDeletes

product_types

id increments
name string (255)
timestamps timestamps

product_stocks

id increments
product_id integer
qty integer
bakcorders integer
timestamps timestamps

brands

id increments
timestamps timestamps
brand_name string (255)
brand_shortdescription longText
brand_description longText
brand_metatitle string (255)
brand_metakeywords string (255)
brand_metadescription longText
brand_image string (255)

product_attributes

id increments
attribute_name string
attribute_value string
timestamps timestamps

product_details

id increments
product_id integer
product_name string (255)
product_shortdescription longText
product_description longText
product_metatitle string (255)
product_metadescription mediumText
product_metakeywords string (255)
timestamps timestamps

product_images

id increments
product_id integer
image_path string (255)
image_alt string (255)
is_main boolean
is_small boolean
timestamps timestamps

product_barcodes

id increments
product_id integer
barcode_type string (255)
barcode string (255)
timestamps timestamps

product_marketplaces

id increments
marketplace_name string (255)
marketplace_synckey string (255)
timestamps timestamps

product_attribute_match

id increments
timestamps timestamps
product_id integer
attribute_id integer

marketplace_products

id increments
timestamps timestamps
product_id integer
marketplace_id integer

products_prices

id increments
timestamps timestamps
product_id integer
product_price decimal
product_wprice decimal

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