66 行
4.7 KiB
SQL
66 行
4.7 KiB
SQL
-- ----------------------------
|
||
-- Table structure for ls_rider_route_record
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ls_rider_route_record`;
|
||
CREATE TABLE `ls_rider_route_record` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`rider_id` int(11) NOT NULL DEFAULT 0 COMMENT '骑手id',
|
||
`start_lat` decimal(10,6) NOT NULL DEFAULT 0.000000 COMMENT '起点纬度',
|
||
`start_lng` decimal(10,6) NOT NULL DEFAULT 0.000000 COMMENT '起点经度',
|
||
`end_lat` decimal(10,6) NOT NULL DEFAULT 0.000000 COMMENT '终点纬度',
|
||
`end_lng` decimal(10,6) NOT NULL DEFAULT 0.000000 COMMENT '终点经度',
|
||
`start_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '起点地址',
|
||
`end_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '终点地址',
|
||
`distance` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT '路线距离(公里)',
|
||
`duration` int(11) NOT NULL DEFAULT 0 COMMENT '预计时长(分钟)',
|
||
`strategy` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'fastest' COMMENT '路线策略：fastest最快, shortest最短, avoid_traffic避开拥堵',
|
||
`route_data` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '路线详细数据(JSON格式)',
|
||
`create_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `rider_id`(`rider_id`) USING BTREE,
|
||
INDEX `create_time`(`create_time`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '骑手路线规划记录表' ROW_FORMAT = DYNAMIC;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ls_rider_token
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ls_rider_token`;
|
||
CREATE TABLE `ls_rider_token` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`rider_id` int(11) NOT NULL DEFAULT 0 COMMENT '骑手id',
|
||
`token` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'token值',
|
||
`expires_at` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '过期时间',
|
||
`created_at` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '创建时间',
|
||
`updated_at` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `token`(`token`) USING BTREE,
|
||
INDEX `rider_id`(`rider_id`) USING BTREE,
|
||
INDEX `expires_at`(`expires_at`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '骑手token表' ROW_FORMAT = DYNAMIC;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ls_rider_vehicle
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ls_rider_vehicle`;
|
||
CREATE TABLE `ls_rider_vehicle` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`rider_id` int(11) NOT NULL DEFAULT 0 COMMENT '骑手id',
|
||
`vehicle_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '车辆类型：bicycle自行车, electric_bike电动车, motorcycle摩托车',
|
||
`vehicle_brand` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车辆品牌',
|
||
`vehicle_model` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车辆型号',
|
||
`vehicle_color` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车辆颜色',
|
||
`license_plate` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车牌号',
|
||
`vehicle_photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车辆照片',
|
||
`driving_license` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '行驶证照片',
|
||
`insurance_photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '保险照片',
|
||
`insurance_expire` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '保险过期时间',
|
||
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态：0禁用 1正常',
|
||
`is_current` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否当前使用：0否 1是',
|
||
`add_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '添加时间',
|
||
`update_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `rider_id`(`rider_id`) USING BTREE,
|
||
INDEX `vehicle_type`(`vehicle_type`) USING BTREE,
|
||
INDEX `status`(`status`) USING BTREE,
|
||
INDEX `is_current`(`is_current`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '骑手车辆信息表' ROW_FORMAT = DYNAMIC; |