mxys_backend/db/insert_250729.sql

-- 创建骑手评价表
DROP TABLE IF EXISTS `evaluate_rider`;
CREATE TABLE `evaluate_rider`  (
                                   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '评价骑手',
                                   `user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
                                   `order_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单号',
                                   `shop_id` int(11) NULL DEFAULT NULL COMMENT '商户id',
                                   `rider_user_id` int(11) NULL DEFAULT NULL COMMENT '骑手id',
                                   `evaluate_rider_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '评价内容',
                                   `rider_score` int(11) NULL DEFAULT NULL COMMENT '骑手评分',
                                   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '评论时间',
                                   PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;