c973d288
 tangwang
1. 类目字段处理
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
类目表 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
|
|
a10a89a3
tangwang
构造测试数据用于测试分类 和 三种...
|
19
|
spu表 shoplazza_product_spu 全部字段
|
|
39e63ad1
tangwang
docs
|
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
"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'" ""
|
|
a10a89a3
tangwang
构造测试数据用于测试分类 和 三种...
|
67
|
shoplazza_product_sku 全部字段
|
|
39e63ad1
tangwang
docs
|
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
|
"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'" ""
|