You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
30 lines
1.4 KiB
30 lines
1.4 KiB
|
|
DROP TABLE IF EXISTS `vege_replenish`;
|
|
CREATE TABLE `vege_replenish` (
|
|
`id` BIGINT(32) NOT NULL AUTO_INCREMENT COMMENT 'ID，唯一编号',
|
|
`sid` VARCHAR(64) NOT NULL COMMENT 'sid',
|
|
`createTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
|
|
`remarks` VARCHAR(255) NULL DEFAULT NULL COMMENT '备注信息',
|
|
|
|
`cardCode` VARCHAR(255) NULL DEFAULT NULL COMMENT '卡编码，个人卡、企业卡是卡编码，转赠记录的是转赠编码',
|
|
`customerSid` VARCHAR(100) NULL DEFAULT NULL COMMENT '绑卡人',
|
|
`cardtype` VARCHAR(255) NULL DEFAULT 0 COMMENT '0 个人卡 1 企业卡 2 转赠的',
|
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE=InnoDB COMMENT='绑卡记录';
|
|
|
|
DROP TABLE IF EXISTS `vege_replenish_detail`;
|
|
CREATE TABLE `vege_replenish_detail` (
|
|
`id` BIGINT(32) NOT NULL AUTO_INCREMENT COMMENT 'ID，唯一编号',
|
|
`sid` VARCHAR(64) NOT NULL COMMENT 'sid',
|
|
`createTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
|
|
`remarks` VARCHAR(255) NULL DEFAULT NULL COMMENT '备注信息',
|
|
|
|
`orderSid` VARCHAR(100) NULL DEFAULT NULL COMMENT '订单SID',
|
|
`goodsSid` VARCHAR(100) NULL DEFAULT NULL COMMENT '商品Sid',
|
|
`goodsName` VARCHAR(100) NULL DEFAULT NULL COMMENT '商品名称',
|
|
`goodsNumber` INT(10) NULL DEFAULT '1' COMMENT '商品数量',
|
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE=InnoDB COMMENT='绑卡记录商品信息';
|
|
|
|
|