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