DROP TABLE IF EXISTS `we_user_buyGoods`; CREATE TABLE `we_user_buyGoods` ( `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间', `order_id` varchar(50) NOT NULL COMMENT '订单编号(加密课程兑换返回 password_commit,无生成对应订单)', `price` int DEFAULT NULL COMMENT '订单价格(单位是分)', `purchase_name` varchar(50) DEFAULT NULL COMMENT ' 订单名称', `user_id` varchar(50) NOT NULL COMMENT '用户id', PRIMARY KEY (`order_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 103 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小鹅通用户开通权益信息表' ROW_FORMAT = Dynamic;