/*
 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;
