13 lines
1.4 KiB
SQL
13 lines
1.4 KiB
SQL
CREATE TABLE `sycn_store_specs` (
|
||
`sycn_specs_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '多规格编号',
|
||
`json_specs` json DEFAULT NULL COMMENT '多规格json数据，如[{"spec": [{"name": "颜色","value": "红色"},{"name": "尺寸","value": "10"}],"priceAndstock": {"price": 100,"stock": 10}},{"spec": [{ "name": "颜色","value": "黑色"},{"name": "尺寸","value": "30"}],
|
||
"priceAndstock": {"price": 300,"stock": 30}}]',
|
||
`product_number` varchar(50) DEFAULT '' COMMENT '条形码',
|
||
`store_id` int unsigned NOT NULL DEFAULT '0' COMMENT '店铺编号',
|
||
`is_deal` varchar(1) NOT NULL DEFAULT '0' COMMENT '是否处理完成,1:是，0：否',
|
||
`created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '新建时间',
|
||
`updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`sycn_specs_id`) USING BTREE,
|
||
KEY `index_store_id` (`store_id`) USING BTREE,
|
||
KEY `index_is_deal` (`is_deal`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='多规格数据表'; |