create table t9
(
goodsid int unsigned not null comment '商品ID',
classid int unsigned not null comment '分类ID',
goodsname varchar(20) not null comment '商品名称',
is_stop tinyint unsigned not null comment '是否停用 1停用 0 正常',
primary key pk_goodsid(goodsid),
unique key uk_name(goodsname),
key idx_classid_goodsid(classid,goodsid)
) engine = innodb default charset = utf8 comment = '商品表'
其中一些规范，可参见阿里的规范 https://www.jianshu.com/p/991b1bdf7f20
