类目表 product_category id bigint(20) NO PRI auto_increment parent_id bigint(20) NO
name varchar(255) NO
pic_url varchar(255) NO
sort int(11) YES 0
status tinyint(4) NO
creator varchar(64) YES
create_time datetime NO CURRENT_TIMESTAMP
updater varchar(64) YES
update_time datetime NO CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP deleted bit(1) NO b'0'
tenant_id bigint(20) NO 0

spu表 shoplazza_product_spu 全部字段 "Field" "Type" "Null" "Key" "Default" "Extra" "id" "bigint(20)" "NO" "PRI" "auto_increment" "shop_id" "bigint(20)" "NO" "MUL" "" "shoplazza_id" "varchar(64)" "NO" "" "" "handle" "varchar(255)" "YES" "MUL" "" "title" "varchar(500)" "NO" "" "" "brief" "varchar(1000)" "YES" "" "" "description" "text" "YES" "" "" "spu" "varchar(100)" "YES" "" "" "vendor" "varchar(255)" "YES" "" "" "vendor_url" "varchar(500)" "YES" "" "" "seo_title" "varchar(500)" "YES" "" "" "seo_description" "text" "YES" "" "" "seo_keywords" "text" "YES" "" "" "image_src" "varchar(500)" "YES" "" "" "image_width" "int(11)" "YES" "" "" "image_height" "int(11)" "YES" "" "" "image_path" "varchar(255)" "YES" "" "" "image_alt" "varchar(500)" "YES" "" "" "inventory_policy" "varchar(50)" "YES" "" "" "inventory_quantity" "int(11)" "YES" "" "0" "" "inventory_tracking" "tinyint(1)" "YES" "" "0" "" "published" "tinyint(1)" "YES" "" "0" "" "published_at" "datetime" "YES" "MUL" "" "requires_shipping" "tinyint(1)" "YES" "" "1" "" "taxable" "tinyint(1)" "YES" "" "0" "" "fake_sales" "int(11)" "YES" "" "0" "" "display_fake_sales" "tinyint(1)" "YES" "" "0" "" "mixed_wholesale" "tinyint(1)" "YES" "" "0" "" "need_variant_image" "tinyint(1)" "YES" "" "0" "" "has_only_default_variant" "tinyint(1)" "YES" "" "0" "" "tags" "text" "YES" "" "" "note" "text" "YES" "" "" "category" "varchar(255)" "YES" "" "" "category_id" "bigint(20)" "YES" "" "" "category_google_id" "bigint(20)" "YES" "" "" "category_level" "int(11)" "YES" "" "" "category_path" "varchar(500)" "YES" "" "" "shoplazza_created_at" "datetime" "YES" "" "" "shoplazza_updated_at" "datetime" "YES" "MUL" "" "tenant_id" "bigint(20)" "NO" "MUL" "" "creator" "varchar(64)" "YES" "" "" "" "create_time" "datetime" "NO" "" "CURRENT_TIMESTAMP" "" "updater" "varchar(64)" "YES" "" "" "" "update_time" "datetime" "NO" "" "CURRENT_TIMESTAMP" "on update CURRENT_TIMESTAMP" "deleted" "bit(1)" "NO" "" "b'0'" ""

shoplazza_product_sku 全部字段 "Field" "Type" "Null" "Key" "Default" "Extra" "id" "bigint(20)" "NO" "PRI" "auto_increment" "spu_id" "bigint(20)" "NO" "MUL" "" "shop_id" "bigint(20)" "NO" "MUL" "" "shoplazza_id" "varchar(64)" "NO" "" "" "shoplazza_product_id" "varchar(64)" "NO" "MUL" "" "shoplazza_image_id" "varchar(64)" "YES" "" "" "title" "varchar(500)" "YES" "" "" "sku" "varchar(100)" "YES" "MUL" "" "barcode" "varchar(100)" "YES" "" "" "position" "int(11)" "YES" "" "0" "" "price" "decimal(10,2)" "YES" "" "" "compare_at_price" "decimal(10,2)" "YES" "" "" "cost_price" "decimal(10,2)" "YES" "" "" "option1" "varchar(255)" "YES" "" "" "option2" "varchar(255)" "YES" "" "" "option3" "varchar(255)" "YES" "" "" "inventory_quantity" "int(11)" "YES" "" "0" "" "weight" "decimal(10,2)" "YES" "" "" "weight_unit" "varchar(10)" "YES" "" "" "image_src" "varchar(500)" "YES" "" "" "wholesale_price" "json" "YES" "" "" "note" "text" "YES" "" "" "extend" "json" "YES" "" "" "shoplazza_created_at" "datetime" "YES" "" "" "shoplazza_updated_at" "datetime" "YES" "" "" "tenant_id" "bigint(20)" "NO" "MUL" "" "creator" "varchar(64)" "YES" "" "" "" "create_time" "datetime" "NO" "" "CURRENT_TIMESTAMP" "" "updater" "varchar(64)" "YES" "" "" "" "update_time" "datetime" "NO" "" "CURRENT_TIMESTAMP" "on update CURRENT_TIMESTAMP" "deleted" "bit(1)" "NO" "" "b'0'" ""