关于mysql:代金券表

CREATE TABLE t_vouchers (
id int(10) NOT NULL AUTO_INCREMENT ,
title varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代金券题目' ,
thumbnail varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '缩略图' ,
amount int(11) NULL DEFAULT NULL COMMENT '抵扣金额' ,
price decimal(10,2) NULL DEFAULT NULL COMMENT '售价' ,
status int(10) NULL DEFAULT NULL COMMENT '-1=过期 0=下架 1=上架' ,
start_use_time datetime NULL DEFAULT NULL COMMENT '开始应用工夫' ,
expire_time datetime NULL DEFAULT NULL COMMENT '过期工夫' ,
redeem_restaurant_id int(10) NULL DEFAULT NULL COMMENT '验证餐厅' ,
stock int(11) NULL DEFAULT 0 COMMENT '库存' ,
stock_left int(11) NULL DEFAULT 0 COMMENT '残余数量' ,
description varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '形容信息' ,
clause varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用条款' ,
create_date datetime NULL DEFAULT NULL ,
update_date datetime NULL DEFAULT NULL ,
is_valid tinyint(1) NULL DEFAULT NULL ,
PRIMARY KEY (id)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1
ROW_FORMAT=COMPACT
;