CREATE TABLE `card` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `root_kdtid` varchar(20) NOT NULL COMMENT '总部ID', `store_id` varchar(20) NOT NULL COMMENT '店铺ID', `batch_id` bigint(20) NOT NULL COMMENT '批次ID', `card_code` varchar(128) NOT NULL COMMENT '卡号', `card_type` int(6) NOT NULL COMMENT '卡券状态', `distributor` varchar(64) NOT NULL COMMENT '经销商', `mobile` varchar(64) NOT NULL COMMENT '领取电话', `publish_time` timestamp NULL DEFAULT NULL COMMENT '发行时间', `activate_time` timestamp NULL DEFAULT NULL COMMENT '激活时间', `sell_time` timestamp NULL DEFAULT NULL COMMENT '售出时间', `get_time` timestamp NULL DEFAULT NULL COMMENT '领取时间', `finish_time` timestamp NULL DEFAULT NULL COMMENT '完成时间', `card_info` varchar(512) DEFAULT NULL COMMENT '卡券备注', `create_by` varchar(15) NOT NULL COMMENT '创建人', `update_by` varchar(15) DEFAULT NULL COMMENT '修改人', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUT O_INCREMENT=31 DEFAULT CHARSET=utf8 COMMENT='卡券表'生成一个此表的全参insert语句

INSERT INTO card (id, root_kdtid, store_id, batch_id, card_code, card_type, distributor, mobile, publish_time, activate_time, sell_time, get_time, finish_time, card_info, create_by, update_by, create_time, update_time) VALUES (NULL, '总部ID', '店铺ID', '批次ID', '卡号', '卡券状态', '经销商', '领取电话', NULL, NULL, NULL, NULL, NULL, '卡券备注', '创建人', NULL, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);