We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
描述 提交sql上线的时候,提示表的例里面内容不能为空,其实我们业务上设计是可以的
重现 CREATE TABLE bi_forecasting_rr ( id bigint NOT NULL AUTO_INCREMENT COMMENT 'id', vc_code varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'vc账号编码', asin varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品唯一标识', product_title varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品名称', brand varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '品牌', upc varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品条形码upc', ean varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品条形码ean', data_date bigint DEFAULT NULL COMMENT '报表数据时间', created_at bigint DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (id), KEY product_title (product_title) USING BTREE, KEY brand (brand) USING BTREE, KEY upc (upc) USING BTREE, KEY ean (ean) USING BTREE, KEY asin (asin,vc_code) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='BI预测报表';
bi_forecasting_rr
id
vc_code
asin
product_title
brand
upc
ean
data_date
created_at
环境
错误
The text was updated successfully, but these errors were encountered:
No branches or pull requests
描述
提交sql上线的时候,提示表的例里面内容不能为空,其实我们业务上设计是可以的
重现
CREATE TABLE
bi_forecasting_rr
(id
bigint NOT NULL AUTO_INCREMENT COMMENT 'id',vc_code
varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'vc账号编码',asin
varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品唯一标识',product_title
varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品名称',brand
varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '品牌',upc
varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品条形码upc',ean
varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品条形码ean',data_date
bigint DEFAULT NULL COMMENT '报表数据时间',created_at
bigint DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (
id
),KEY
product_title
(product_title
) USING BTREE,KEY
brand
(brand
) USING BTREE,KEY
upc
(upc
) USING BTREE,KEY
ean
(ean
) USING BTREE,KEY
asin
(asin
,vc_code
) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='BI预测报表';
环境
错误
The text was updated successfully, but these errors were encountered: