15 lines
877 B
SQL
15 lines
877 B
SQL
|
CREATE TABLE `wa_thali` (
|
||
|
|
`id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
|
|
`role_id` int DEFAULT NULL COMMENT '关联角色',
|
||
|
|
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
|
||
|
|
`price` decimal(10,2) DEFAULT NULL COMMENT '价格',
|
||
|
|
`month_discount` decimal(6,4) DEFAULT '1.0000' COMMENT '月折扣',
|
||
|
|
`quarter_discount` decimal(6,4) DEFAULT '1.0000' COMMENT '季折扣',
|
||
|
|
`year_discount` decimal(6,4) NOT NULL DEFAULT '1.0000' COMMENT '年折扣',
|
||
|
|
`label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标签',
|
||
|
|
`created_at` int DEFAULT NULL COMMENT '创建时间',
|
||
|
|
`updated_at` int DEFAULT NULL COMMENT '更新时间',
|
||
|
|
`status` tinyint DEFAULT NULL COMMENT '状态',
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|