/* Navicat Premium Data Transfer Source Server : 虚拟机80-mysql8.0 Source Server Type : MySQL Source Server Version : 80036 Source Host : 192.168.110.169:3306 Source Schema : charging_pile_service Target Server Type : MySQL Target Server Version : 80036 File Encoding : 65001 Date: 05/08/2024 18:43:25 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_accounting_strategy -- ---------------------------- DROP TABLE IF EXISTS `t_accounting_strategy`; CREATE TABLE `t_accounting_strategy` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '策略名称', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '策略说明', `discount` double(10, 2) NULL DEFAULT NULL COMMENT '会员折扣', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除状态（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '计费策略' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_accounting_strategy -- ---------------------------- -- ---------------------------- -- Table structure for t_accounting_strategy_detail -- ---------------------------- DROP TABLE IF EXISTS `t_accounting_strategy_detail`; CREATE TABLE `t_accounting_strategy_detail` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键', `accounting_strategy_id` int NULL DEFAULT NULL COMMENT '策略id', `type` int NULL DEFAULT NULL COMMENT '阶段（1=尖阶段，2=峰阶段，3=平阶段，4=谷阶段）', `start_time` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开始时间', `end_time` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '结束时间', `electrovalence` double(10, 4) NULL DEFAULT NULL COMMENT '电价', `service_charge` double(10, 4) NULL DEFAULT NULL COMMENT '服务费', `cost_service_charge` double(10, 4) NULL DEFAULT NULL COMMENT '原价服务费', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '计费策略明细' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_accounting_strategy_detail -- ---------------------------- -- ---------------------------- -- Table structure for t_apply_charging_pile -- ---------------------------- DROP TABLE IF EXISTS `t_apply_charging_pile`; CREATE TABLE `t_apply_charging_pile` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用电地址', `capacity` decimal(10, 2) NULL DEFAULT NULL COMMENT '申请容量', `consumption_time` date NULL DEFAULT NULL COMMENT '用电时间', `landlord_handling` int NULL DEFAULT NULL COMMENT '户主经办（0=关，1=开）', `landlord_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '户名', `landlord_id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '户主身份证号码', `landlord_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '户主手机号', `landlord_front_id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '户主身份证正面', `landlord_back_id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '户主身份证反面', `title_certificate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '产权证明', `business_license` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '营业执照', `charging_pile_user` int NULL DEFAULT NULL COMMENT '充电桩用户（0=关，1=开）', `fixed_parking_property_rights` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '固定车位产权', `construction_certificate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '施工证明', `agent_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经办人姓名', `agent_id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经办人身份证号', `agent_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经办人手机号', `agent_front_id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经办人身份证正面', `agent_back_id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经办人身份证背面', `charging_pile` int NULL DEFAULT NULL COMMENT '是否有充电桩（0=否，1=是）', `further_information` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '补充资料', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '备注', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '建桩申请' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_apply_charging_pile -- ---------------------------- -- ---------------------------- -- Table structure for t_carport -- ---------------------------- DROP TABLE IF EXISTS `t_carport`; CREATE TABLE `t_carport` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车库编号', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车库名称', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '车库' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_carport -- ---------------------------- -- ---------------------------- -- Table structure for t_charging_gun -- ---------------------------- DROP TABLE IF EXISTS `t_charging_gun`; CREATE TABLE `t_charging_gun` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键', `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '充电枪编号', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `partner_id` int NULL DEFAULT NULL COMMENT '合作商id', `charging_pile_id` int NULL DEFAULT NULL COMMENT '充电桩id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '充电枪名称', `type` int NULL DEFAULT NULL COMMENT '充电枪类型（0=其他，1=家用插座（模式2），2=交流接口插座（模式3，连接方式B），3=交流接口插头（带枪线，模式3，连接方式C）4=直流接口枪头（带枪线，模式4）5=无线充电座）', `status` int NULL DEFAULT NULL COMMENT '充电枪状态（1=离线，2=空闲，3=占用（未充电），4=占用（充电中），5=占用（已充满），6=占用（预约锁定），7=故障）', `charge_mode` int NULL DEFAULT NULL COMMENT '充电模式（1=超级快充，2=快充，3=慢充）', `accounting_strategy_id` int NULL DEFAULT NULL COMMENT '计费策略id', `upper_rated_voltage` double(10, 2) NULL DEFAULT NULL COMMENT '额定电压上限', `lower_limit_of_rated_voltage` double(10, 2) NULL DEFAULT NULL COMMENT '额定电压下限', `rated_current` double(10, 2) NULL DEFAULT NULL COMMENT '额定电流', `rated_power` double(10, 2) NULL DEFAULT NULL COMMENT '额定功率', `parking_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车位号', `parking_status` int NULL DEFAULT NULL COMMENT '车位状态（0=未知，1=空闲，2=占用）', `parking_lock_state` int NULL DEFAULT NULL COMMENT '地锁状态|（0=未知，1=已解锁，2=已上锁）', `national_standard` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '国家标准', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '说明', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除状态（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '充电枪' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_charging_gun -- ---------------------------- -- ---------------------------- -- Table structure for t_charging_pile -- ---------------------------- DROP TABLE IF EXISTS `t_charging_pile`; CREATE TABLE `t_charging_pile` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键', `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '设备编号', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '充电设备名称', `number` int NULL DEFAULT NULL COMMENT '桩号', `type` int NULL DEFAULT NULL COMMENT '设备类型（0=其他，1=直流设备，2=交流设备，3=交直流一体设备，4=无线设备）', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `partner_id` int NULL DEFAULT NULL COMMENT '合作商id', `manufacturer_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '生产商机构代码', `manufacturer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '生产商名称', `equipment_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '设备型号', `production_date` date NULL DEFAULT NULL COMMENT '生产日期', `rated_power` double(10, 2) NULL DEFAULT NULL COMMENT '额定功率', `charging_station_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '设备充电站编号', `status` int NULL DEFAULT NULL COMMENT '设备状态（1=工作中，2=离线，3=故障）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '充电桩' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_charging_pile -- ---------------------------- -- ---------------------------- -- Table structure for t_charging_pile_notification -- ---------------------------- DROP TABLE IF EXISTS `t_charging_pile_notification`; CREATE TABLE `t_charging_pile_notification` ( `id` bigint NOT NULL COMMENT '主键', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `charging_pile_id` int NULL DEFAULT NULL COMMENT '充电桩id', `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '通知内容', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '发送时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除状态（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE, INDEX `site_id`(`site_id`) USING BTREE, INDEX `charging_pile_id`(`charging_pile_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统通知' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_charging_pile_notification -- ---------------------------- -- ---------------------------- -- Table structure for t_charging_pile_notification_0 -- ---------------------------- DROP TABLE IF EXISTS `t_charging_pile_notification_0`; CREATE TABLE `t_charging_pile_notification_0` ( `id` bigint NOT NULL COMMENT '主键', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `charging_pile_id` int NULL DEFAULT NULL COMMENT '充电桩id', `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '通知内容', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '发送时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除状态（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE, INDEX `site_id`(`site_id`) USING BTREE, INDEX `charging_pile_id`(`charging_pile_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统通知' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_charging_pile_notification_0 -- ---------------------------- -- ---------------------------- -- Table structure for t_charging_pile_notification_1 -- ---------------------------- DROP TABLE IF EXISTS `t_charging_pile_notification_1`; CREATE TABLE `t_charging_pile_notification_1` ( `id` bigint NOT NULL COMMENT '主键', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `charging_pile_id` int NULL DEFAULT NULL COMMENT '充电桩id', `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '通知内容', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '发送时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除状态（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE, INDEX `site_id`(`site_id`) USING BTREE, INDEX `charging_pile_id`(`charging_pile_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统通知' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_charging_pile_notification_1 -- ---------------------------- -- ---------------------------- -- Table structure for t_charging_pile_notification_2 -- ---------------------------- DROP TABLE IF EXISTS `t_charging_pile_notification_2`; CREATE TABLE `t_charging_pile_notification_2` ( `id` bigint NOT NULL COMMENT '主键', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `charging_pile_id` int NULL DEFAULT NULL COMMENT '充电桩id', `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '通知内容', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '发送时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除状态（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE, INDEX `site_id`(`site_id`) USING BTREE, INDEX `charging_pile_id`(`charging_pile_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统通知' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_charging_pile_notification_2 -- ---------------------------- -- ---------------------------- -- Table structure for t_charging_pile_notification_3 -- ---------------------------- DROP TABLE IF EXISTS `t_charging_pile_notification_3`; CREATE TABLE `t_charging_pile_notification_3` ( `id` bigint NOT NULL COMMENT '主键', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `charging_pile_id` int NULL DEFAULT NULL COMMENT '充电桩id', `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '通知内容', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '发送时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除状态（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE, INDEX `site_id`(`site_id`) USING BTREE, INDEX `charging_pile_id`(`charging_pile_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统通知' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_charging_pile_notification_3 -- ---------------------------- -- ---------------------------- -- Table structure for t_charging_pile_notification_4 -- ---------------------------- DROP TABLE IF EXISTS `t_charging_pile_notification_4`; CREATE TABLE `t_charging_pile_notification_4` ( `id` bigint NOT NULL COMMENT '主键', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `charging_pile_id` int NULL DEFAULT NULL COMMENT '充电桩id', `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '通知内容', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '发送时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除状态（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE, INDEX `site_id`(`site_id`) USING BTREE, INDEX `charging_pile_id`(`charging_pile_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统通知' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_charging_pile_notification_4 -- ---------------------------- -- ---------------------------- -- Table structure for t_charging_pile_notification_5 -- ---------------------------- DROP TABLE IF EXISTS `t_charging_pile_notification_5`; CREATE TABLE `t_charging_pile_notification_5` ( `id` bigint NOT NULL COMMENT '主键', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `charging_pile_id` int NULL DEFAULT NULL COMMENT '充电桩id', `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '通知内容', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '发送时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除状态（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE, INDEX `site_id`(`site_id`) USING BTREE, INDEX `charging_pile_id`(`charging_pile_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统通知' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_charging_pile_notification_5 -- ---------------------------- -- ---------------------------- -- Table structure for t_charging_pile_notification_6 -- ---------------------------- DROP TABLE IF EXISTS `t_charging_pile_notification_6`; CREATE TABLE `t_charging_pile_notification_6` ( `id` bigint NOT NULL COMMENT '主键', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `charging_pile_id` int NULL DEFAULT NULL COMMENT '充电桩id', `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '通知内容', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '发送时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除状态（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE, INDEX `site_id`(`site_id`) USING BTREE, INDEX `charging_pile_id`(`charging_pile_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统通知' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_charging_pile_notification_6 -- ---------------------------- -- ---------------------------- -- Table structure for t_charging_pile_notification_7 -- ---------------------------- DROP TABLE IF EXISTS `t_charging_pile_notification_7`; CREATE TABLE `t_charging_pile_notification_7` ( `id` bigint NOT NULL COMMENT '主键', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `charging_pile_id` int NULL DEFAULT NULL COMMENT '充电桩id', `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '通知内容', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '发送时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除状态（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE, INDEX `site_id`(`site_id`) USING BTREE, INDEX `charging_pile_id`(`charging_pile_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统通知' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_charging_pile_notification_7 -- ---------------------------- -- ---------------------------- -- Table structure for t_charging_pile_notification_8 -- ---------------------------- DROP TABLE IF EXISTS `t_charging_pile_notification_8`; CREATE TABLE `t_charging_pile_notification_8` ( `id` bigint NOT NULL COMMENT '主键', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `charging_pile_id` int NULL DEFAULT NULL COMMENT '充电桩id', `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '通知内容', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '发送时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除状态（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE, INDEX `site_id`(`site_id`) USING BTREE, INDEX `charging_pile_id`(`charging_pile_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统通知' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_charging_pile_notification_8 -- ---------------------------- -- ---------------------------- -- Table structure for t_charging_pile_notification_9 -- ---------------------------- DROP TABLE IF EXISTS `t_charging_pile_notification_9`; CREATE TABLE `t_charging_pile_notification_9` ( `id` bigint NOT NULL COMMENT '主键', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `charging_pile_id` int NULL DEFAULT NULL COMMENT '充电桩id', `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '通知内容', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '发送时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除状态（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE, INDEX `site_id`(`site_id`) USING BTREE, INDEX `charging_pile_id`(`charging_pile_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统通知' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_charging_pile_notification_9 -- ---------------------------- -- ---------------------------- -- Table structure for t_fault_message -- ---------------------------- DROP TABLE IF EXISTS `t_fault_message`; CREATE TABLE `t_fault_message` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `charging_pile_id` int NULL DEFAULT NULL COMMENT '充电桩id', `status` int NULL DEFAULT NULL COMMENT '状态（1=离线，2=故障）', `down_time` datetime(0) NULL DEFAULT NULL COMMENT '故障时间', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '故障信息' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_fault_message -- ---------------------------- -- ---------------------------- -- Table structure for t_monitoring_equipment -- ---------------------------- DROP TABLE IF EXISTS `t_monitoring_equipment`; CREATE TABLE `t_monitoring_equipment` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '监控', `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '设备是被吗', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '位置', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '监控' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_monitoring_equipment -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_lot -- ---------------------------- DROP TABLE IF EXISTS `t_parking_lot`; CREATE TABLE `t_parking_lot` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车场名称', `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方停车场编号', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `charge_free_duration` int NULL DEFAULT NULL COMMENT '充电免费时长（分钟）', `charge_capping` double(10, 2) NULL DEFAULT NULL COMMENT '充电收费上限', `charge_rate` double(10, 2) NULL DEFAULT NULL COMMENT '充电收费费率（元/分钟）', `non_charge_free_duration` int NULL DEFAULT NULL COMMENT '非充电免费时长（分钟）', `non_charge_capping` double(10, 2) NULL DEFAULT NULL COMMENT '非充电收费上限', `non_charge_rate` double(10, 2) NULL DEFAULT NULL COMMENT '非充电收费费率（元/分钟）', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '绑定车牌说明', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE, INDEX `site_id`(`site_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车场' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_lot -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record`; CREATE TABLE `t_parking_record` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_0 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_0`; CREATE TABLE `t_parking_record_0` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_0 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_1 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_1`; CREATE TABLE `t_parking_record_1` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_1 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_10 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_10`; CREATE TABLE `t_parking_record_10` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_10 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_11 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_11`; CREATE TABLE `t_parking_record_11` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_11 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_12 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_12`; CREATE TABLE `t_parking_record_12` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_12 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_13 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_13`; CREATE TABLE `t_parking_record_13` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_13 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_14 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_14`; CREATE TABLE `t_parking_record_14` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_14 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_15 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_15`; CREATE TABLE `t_parking_record_15` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_15 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_16 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_16`; CREATE TABLE `t_parking_record_16` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_16 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_17 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_17`; CREATE TABLE `t_parking_record_17` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_17 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_18 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_18`; CREATE TABLE `t_parking_record_18` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_18 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_19 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_19`; CREATE TABLE `t_parking_record_19` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_19 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_2 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_2`; CREATE TABLE `t_parking_record_2` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_2 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_20 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_20`; CREATE TABLE `t_parking_record_20` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_20 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_21 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_21`; CREATE TABLE `t_parking_record_21` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_21 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_22 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_22`; CREATE TABLE `t_parking_record_22` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_22 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_23 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_23`; CREATE TABLE `t_parking_record_23` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_23 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_24 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_24`; CREATE TABLE `t_parking_record_24` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_24 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_25 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_25`; CREATE TABLE `t_parking_record_25` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_25 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_26 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_26`; CREATE TABLE `t_parking_record_26` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_26 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_27 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_27`; CREATE TABLE `t_parking_record_27` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_27 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_28 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_28`; CREATE TABLE `t_parking_record_28` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_28 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_29 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_29`; CREATE TABLE `t_parking_record_29` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_29 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_3 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_3`; CREATE TABLE `t_parking_record_3` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_3 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_30 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_30`; CREATE TABLE `t_parking_record_30` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_30 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_31 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_31`; CREATE TABLE `t_parking_record_31` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_31 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_32 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_32`; CREATE TABLE `t_parking_record_32` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_32 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_33 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_33`; CREATE TABLE `t_parking_record_33` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_33 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_34 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_34`; CREATE TABLE `t_parking_record_34` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_34 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_35 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_35`; CREATE TABLE `t_parking_record_35` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_35 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_36 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_36`; CREATE TABLE `t_parking_record_36` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_36 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_37 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_37`; CREATE TABLE `t_parking_record_37` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_37 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_38 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_38`; CREATE TABLE `t_parking_record_38` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_38 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_39 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_39`; CREATE TABLE `t_parking_record_39` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_39 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_4 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_4`; CREATE TABLE `t_parking_record_4` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_4 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_40 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_40`; CREATE TABLE `t_parking_record_40` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_40 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_41 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_41`; CREATE TABLE `t_parking_record_41` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_41 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_42 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_42`; CREATE TABLE `t_parking_record_42` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_42 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_43 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_43`; CREATE TABLE `t_parking_record_43` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_43 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_44 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_44`; CREATE TABLE `t_parking_record_44` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_44 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_45 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_45`; CREATE TABLE `t_parking_record_45` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_45 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_46 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_46`; CREATE TABLE `t_parking_record_46` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_46 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_47 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_47`; CREATE TABLE `t_parking_record_47` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_47 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_48 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_48`; CREATE TABLE `t_parking_record_48` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_48 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_49 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_49`; CREATE TABLE `t_parking_record_49` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_49 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_5 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_5`; CREATE TABLE `t_parking_record_5` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_5 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_6 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_6`; CREATE TABLE `t_parking_record_6` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_6 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_7 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_7`; CREATE TABLE `t_parking_record_7` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_7 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_8 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_8`; CREATE TABLE `t_parking_record_8` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_8 -- ---------------------------- -- ---------------------------- -- Table structure for t_parking_record_9 -- ---------------------------- DROP TABLE IF EXISTS `t_parking_record_9`; CREATE TABLE `t_parking_record_9` ( `id` bigint NOT NULL COMMENT '订单id', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号', `vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆颜色', `charging_order_id` bigint NULL DEFAULT NULL COMMENT '充电订单id', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `in_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '入场时间', `out_parking_time` datetime(0) NULL DEFAULT NULL COMMENT '出场时间', `parking_duration` int NULL DEFAULT NULL COMMENT '停车时长（分钟）', `order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总费用', `status` int NULL DEFAULT NULL COMMENT '状态（1=已进场，2=已出场，3=已缴费出场）', `out_parking_type` int NULL DEFAULT NULL COMMENT '出场方式（1=缴费出场，2=免费时长内放行）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `app_user_id`(`app_user_id`) USING BTREE, INDEX `parking_lot_id`(`parking_lot_id`) USING BTREE, INDEX `charging_order_id`(`charging_order_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '停车记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_parking_record_9 -- ---------------------------- -- ---------------------------- -- Table structure for t_partner -- ---------------------------- DROP TABLE IF EXISTS `t_partner`; CREATE TABLE `t_partner` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键', `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '合作商ID', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '合作商名称', `role_id` int NULL DEFAULT NULL COMMENT '角色id', `logo_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'logo地址', `rate` double(10, 2) NULL DEFAULT NULL COMMENT '费率', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '注册地址', `phone_one` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '合作商电话1', `phone_two` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '合作商电话2', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '备注', `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '登录账号', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '登录密码', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除状态（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '合作商' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_partner -- ---------------------------- -- ---------------------------- -- Table structure for t_partner_site -- ---------------------------- DROP TABLE IF EXISTS `t_partner_site`; CREATE TABLE `t_partner_site` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `partner_id` int NULL DEFAULT NULL COMMENT '合作商id', `site_menu_id` int NULL DEFAULT NULL COMMENT '菜单id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '合作商站点数据权限' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_partner_site -- ---------------------------- -- ---------------------------- -- Table structure for t_repair -- ---------------------------- DROP TABLE IF EXISTS `t_repair`; CREATE TABLE `t_repair` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键', `repairman` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '报修人', `site_id` int NULL DEFAULT NULL COMMENT '站点id', `charging_pile_id` int NULL DEFAULT NULL COMMENT '充电桩id', `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '报修内容', `repair_time` datetime(0) NULL DEFAULT NULL COMMENT '报修时间', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除状态（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '报修记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_repair -- ---------------------------- -- ---------------------------- -- Table structure for t_site -- ---------------------------- DROP TABLE IF EXISTS `t_site`; CREATE TABLE `t_site` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键', `partner_id` int NULL DEFAULT NULL COMMENT '合作商id', `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '站点编号', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '站点名称', `site_type` int NULL DEFAULT NULL COMMENT '站点类型（0=其他，1=公共，2=个人，3=公交（专业），4=环卫（专用），5=物流（专用），6=出租车（专用））', `business_category` int NULL DEFAULT NULL COMMENT '经营类型（1=直营，2=非直营）', `status` int NULL DEFAULT NULL COMMENT '站点状态（1=正常使用，2=维修中，3=关闭下线）', `construction_site` int NULL DEFAULT NULL COMMENT '建设场所（0=其他，1=居民区，2=公共机构，3=企事业单位，4=写字楼，5=工业园区，6=交通枢纽，7=大型文体设施，8=城市绿地，9=大型建筑配建停车场，10=路边停车位，11=城际高速服务区）', `img_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '站点环境图', `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省名称', `province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省区划代码', `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称', `city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市区划代码', `districts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区县名称', `districts_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区县区划代码', `lon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经度', `lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纬度', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址', `country_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '国家代码', `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '站点电话', `service_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '服务电话', `guide` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '站点引导', `start_service_time` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开始服务时间', `end_service_time` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '结束服务时间', `service_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '站内提供服务', `vehicle_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '车型描述', `parking_space` int NULL DEFAULT NULL COMMENT '车位数', `rate_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '充电费率描述', `space_charge_explain` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '超时占位费说明', `accounting_strategy_id` int NULL DEFAULT NULL COMMENT '计费策略id', `establishment_time` date NULL DEFAULT NULL COMMENT '建站时间', `sort` int NULL DEFAULT NULL COMMENT '排序', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '备注', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除状态（0=否，1=是）', `mark` int NULL DEFAULT NULL COMMENT '评分', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '站点' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_site -- ---------------------------- -- ---------------------------- -- Table structure for t_site_menu -- ---------------------------- DROP TABLE IF EXISTS `t_site_menu`; CREATE TABLE `t_site_menu` ( `menu_id` int NOT NULL AUTO_INCREMENT COMMENT '菜单ID', `menu_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单名称', `parent_id` bigint NULL DEFAULT 0 COMMENT '父菜单ID', `order_num` int NULL DEFAULT 0 COMMENT '显示顺序', `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '路由地址', `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组件路径', `query` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '路由参数', `is_frame` int NULL DEFAULT 1 COMMENT '是否为外链（0是 1否）', `is_cache` int NULL DEFAULT 0 COMMENT '是否缓存（0缓存 1不缓存）', `menu_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）', `visible` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）', `status` tinyint(1) NULL DEFAULT 0 COMMENT '菜单状态（0正常 1停用）', `perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限标识', `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '#' COMMENT '菜单图标', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注', PRIMARY KEY (`menu_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '站点关联菜单表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_site_menu -- ---------------------------- -- ---------------------------- -- Table structure for t_vehicle_ramp -- ---------------------------- DROP TABLE IF EXISTS `t_vehicle_ramp`; CREATE TABLE `t_vehicle_ramp` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键', `parking_lot_id` int NULL DEFAULT NULL COMMENT '停车场id', `carport_id` int NULL DEFAULT NULL COMMENT '车库id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车道名称', `direction` int NULL DEFAULT NULL COMMENT '方向（1=入口，2=出口）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '车道' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_vehicle_ramp -- ---------------------------- SET FOREIGN_KEY_CHECKS = 1;