You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

541 lines
63 KiB

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

/*
Navicat Premium Data Transfer
Source Server : 抢占式-preemptively.trytowish.cn
Source Server Type : MySQL
Source Server Version : 80031
Source Host : preemptively.trytowish.cn:3306
Source Schema : omind-user-plat
Target Server Type : MySQL
Target Server Version : 80031
File Encoding : 65001
Date: 23/02/2024 11:21:01
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for omind_app
-- ----------------------------
DROP TABLE IF EXISTS `omind_app`;
CREATE TABLE `omind_app` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`app_type` int unsigned NOT NULL DEFAULT '0' COMMENT '0 openAPI 1 ',
`app_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '',
`app_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'key',
`secret` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '',
`valid_time` bigint unsigned NOT NULL DEFAULT '253402271999' COMMENT '',
`state` tinyint NOT NULL DEFAULT '0' COMMENT '0 1',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`del_flag` tinyint unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Records of omind_app
-- ----------------------------
BEGIN;
INSERT INTO `omind_app` VALUES (1, 1, '', 'dbkUZnQjnIsUW0n7', 'k1E4e6ssJhk5ZIUkD1yn65NEX8ZwFCTF', 253402271999, 1, '2023-12-18 10:04:48', '2024-01-18 10:05:59', 0);
COMMIT;
-- ----------------------------
-- Table structure for omind_bill
-- ----------------------------
DROP TABLE IF EXISTS `omind_bill`;
CREATE TABLE `omind_bill` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
`station_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'id()',
`base_operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'id()',
`start_charge_seq` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '"运营商ID+唯一编号",27',
`connector_id` varchar(26) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '()',
`start_charge_seq_stat` tinyint unsigned NOT NULL DEFAULT '0' COMMENT ':1;2;3;4;5;8;20',
`user_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'id',
`start_time` datetime DEFAULT NULL COMMENT '("yyyy-MM-dd HH:mm:ss")',
`end_time` datetime DEFAULT NULL COMMENT '("yyyy-MM-dd HH:mm:ss")',
`total_power` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '(:,2)',
`total_elec_money` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '(:,2)',
`total_service_money` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '(:,2)',
`total_money` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '(:,2)',
`real_pay_money` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '(:,2)',
`stop_reason` int unsigned NOT NULL DEFAULT '0' COMMENT ':0;1;2BMS;3;4;5-99',
`stop_fail_reason` tinyint unsigned NOT NULL DEFAULT '0' COMMENT ':0;1;2线;3;4~99',
`sum_period` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'N032',
`charge_detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT ' json',
`car_vin` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '',
`plate_no` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '',
`succ_stat` tinyint unsigned NOT NULL DEFAULT '0' COMMENT ':0;1;',
`bill_type` tinyint unsigned DEFAULT NULL COMMENT ' 0 1',
`soc` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '(:0)',
`pay_state` tinyint unsigned NOT NULL DEFAULT '0' COMMENT ':0;1;',
`remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '',
`price_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT ' json',
`pay_plat` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '',
`transaction_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '()',
`del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT ':0;1',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '',
`tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '',
`currentA` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT 'A(:A,:0 ())',
`voltageA` decimal(6,2) DEFAULT '0.00' COMMENT 'A(:V,:0 ())',
`charge_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT ' 1;2',
`charge_money` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT '',
PRIMARY KEY (`id`) USING BTREE,
KEY `start_charge_seq` (`start_charge_seq`),
KEY `connector_id` (`connector_id`),
KEY `create_time` (`create_time`),
KEY `station_id` (`station_id`),
KEY `start_time` (`start_time`),
KEY `end_time` (`end_time`)
) ENGINE=InnoDB AUTO_INCREMENT=11438 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Records of omind_bill
-- ----------------------------
BEGIN;
INSERT INTO `omind_bill` VALUES (11408, '11010810001', 'MA80GFQM8', 'MA01D1QR8946841013052518400', '2411010810000101', 4, 2, '2024-01-22 16:09:15', '2024-01-22 16:09:42', 0.54, 0.11, 0.33, 0.44, 0.44, 65, 0, 1, NULL, 'TRLTOZLGSYQFN0FSD', '', 0, NULL, 32.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"SevicePrice\":\"1.0000\",\"PriceType\":2}]', '', '', 0, '2024-01-22 16:09:44', '2024-01-22 16:09:16', '000000', 0.00, 0.00, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11409, '11010810001', 'MA80GFQM8', 'MA01D1QR8946841334579474432', '2411010810000101', 4, 1, '2024-01-22 16:10:32', '2024-01-22 16:10:49', 0.44, 0.09, 0.27, 0.36, 0.36, 65, 0, 1, NULL, 'P0VHYL9SK7OV7CWP6', '', 0, NULL, 22.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"SevicePrice\":\"1.0000\",\"PriceType\":2}]', '', '', 0, '2024-01-22 16:10:49', '2024-01-22 16:10:32', '000000', 0.00, 0.00, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11410, '11010810001', 'MA80GFQM8', 'MA01D1QR8946842207078592512', '2411010810000101', 4, 1, '2024-01-22 16:14:00', '2024-01-22 16:14:03', 0.39, 0.08, 0.24, 0.32, 0.32, 65, 0, 1, NULL, 'MYMJBMNSRDTQH6XEL', '', 0, NULL, 15.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"SevicePrice\":\"1.0000\",\"PriceType\":2}]', '', '', 0, '2024-01-22 16:14:04', '2024-01-22 16:14:00', '000000', 0.00, 0.00, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11411, '11010810001', 'MA80GFQM8', 'MA01D1QR8946843452543610880', '2411010810000101', 4, 1, '2024-01-22 16:18:57', '2024-01-22 16:19:00', 0.33, 0.07, 0.20, 0.27, 0.27, 65, 0, 1, NULL, 'ET4CJDNCERSQQ0CDR', '', 0, NULL, 34.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"SevicePrice\":\"1.0000\",\"PriceType\":2}]', '', '', 0, '2024-01-22 16:19:01', '2024-01-22 16:18:57', '000000', 0.00, 0.00, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11412, '11010810001', 'MA80GFQM8', 'MA01D1QR8946843832212008960', '2411010810000101', 4, 1, '2024-01-22 16:20:27', '2024-01-22 16:20:56', 0.88, 0.18, 0.53, 0.71, 0.71, 65, 0, 1, NULL, 'PV6SPTVF3QCB33SVM', '', 0, NULL, 37.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"SevicePrice\":\"1.0000\",\"PriceType\":2}]', '', '', 0, '2024-01-22 16:20:57', '2024-01-22 16:20:28', '000000', 0.00, 0.00, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11413, '11010810001', 'MA80GFQM8', 'MA01D1QR8946844054275239936', '2411010810000101', 4, 1, '2024-01-22 16:21:20', '2024-01-22 16:31:10', 14.36, 2.88, 8.62, 11.50, 11.50, 65, 0, 1, NULL, 'JHETYPH7RTC6VMR8R', '', 0, NULL, 28.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"SevicePrice\":\"1.0000\",\"PriceType\":2}]', '', '', 0, '2024-01-22 16:31:11', '2024-01-22 16:21:21', '000000', 0.00, 0.00, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11414, '11010810001', 'MA80GFQM8', 'MA01D1QR8947188467878866944', '2411010810000301', 4, 3, '2024-01-23 15:09:56', '2024-01-23 16:22:57', 103.72, 20.76, 62.24, 83.00, 83.00, 65, 0, 2, NULL, 'VGM75EF9GAPXCQNLW', '', 0, NULL, 36.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"ServicePrice\":\"1.0000\",\"PriceType\":0}]', '', '', 0, '2024-01-23 16:22:57', '2024-01-23 15:09:56', '000000', 249.10, 56.50, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11415, '11010810001', 'MA80GFQM8', 'MA01D1QR8947189336695386112', '2411010810000101', 4, 1, '2024-01-23 15:13:22', '2024-01-23 15:17:47', 6.09, 1.22, 3.66, 4.88, 4.88, 65, 0, 1, NULL, 'B6QI6A93QV47WCKC5', '', 0, NULL, 25.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"ServicePrice\":\"1.0000\",\"PriceType\":0}]', '', '', 0, '2024-01-23 15:17:48', '2024-01-23 15:13:23', '000000', 0.00, 0.00, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11416, '11010810001', 'MA80GFQM8', 'MA01D1QR8947192333093580800', '2411010810000101', 4, 1, '2024-01-23 15:25:16', '2024-01-23 16:11:14', 65.00, 13.00, 39.00, 52.00, 52.00, 65, 0, 2, NULL, 'RRVGT36FBMZEPJYZG', '', 0, NULL, 41.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"ServicePrice\":\"1.0000\",\"PriceType\":0}]', '', '', 0, '2024-01-23 16:11:15', '2024-01-23 15:25:17', '000000', 222.10, 40.40, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11417, '11010810001', 'MA80GFQM8', 'MA01D1QR8947203928091799552', '2411010810000101', 4, 1, '2024-01-23 16:11:21', '2024-01-23 16:12:29', 1.82, 0.37, 1.10, 1.47, 1.47, 65, 0, 1, NULL, 'OG8IRJUMQVVV4UJU9', '', 0, NULL, 34.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"ServicePrice\":\"1.0000\",\"PriceType\":0}]', '', '', 0, '2024-01-23 16:12:30', '2024-01-23 16:11:21', '000000', 137.50, 181.80, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11418, '11010810001', 'MA80GFQM8', 'MA01D1QR8947204568423608320', '2411010810000101', 4, 1, '2024-01-23 16:13:54', '2024-01-23 16:15:51', 2.98, 0.60, 1.79, 2.39, 2.39, 65, 0, 1, NULL, '62PRASO3EQRSZUDW5', '', 0, NULL, 4.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"ServicePrice\":\"1.0000\",\"PriceType\":0}]', '', '', 0, '2024-01-23 16:15:51', '2024-01-23 16:13:54', '000000', 210.60, 108.50, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11419, '11010810001', 'MA80GFQM8', 'MA01D1QR8947205667801018368', '2411010810000101', 4, 1, '2024-01-23 16:18:16', '2024-01-23 18:02:19', 147.71, 29.55, 88.63, 118.18, 118.18, 65, 0, 3, NULL, 'DAWM1BZPAFLTFO0M1', '', 0, NULL, 45.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"ServicePrice\":\"1.0000\",\"PriceType\":0}]', '', '', 0, '2024-01-23 18:02:20', '2024-01-23 16:18:16', '000000', 182.30, 194.80, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11420, '11010810001', 'MA80GFQM8', 'MA01D1QR8947208916234940416', '2411010810000301', 4, 4, '2024-01-23 16:31:10', '2024-01-23 16:42:27', 16.41, 3.29, 9.85, 13.14, 13.14, 65, 0, 1, NULL, 'Y5B0X9H44FFFCAMBH', '', 0, NULL, 51.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"ServicePrice\":\"1.0000\",\"PriceType\":0}]', '', '', 0, '2024-01-23 16:42:28', '2024-01-23 16:31:11', '000000', 338.70, 188.80, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11421, '11010810001', 'MA80GFQM8', 'MA01D1QR8947212789846650880', '2411010810000301', 4, 4, '2024-01-23 16:46:34', '2024-01-23 16:47:45', 1.75, 0.35, 1.05, 1.40, 1.40, 65, 0, 1, NULL, '0BUKVDUUDDBDFBTRJ', '', 0, NULL, 46.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"ServicePrice\":\"1.0000\",\"PriceType\":0}]', '', '', 0, '2024-01-23 16:47:45', '2024-01-23 16:46:34', '000000', 322.80, 48.70, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11422, '11010810001', 'MA80GFQM8', 'MA01D1QR8947216729963245568', '2411010810000301', 4, 4, '2024-01-23 17:02:13', '2024-01-23 17:17:02', 20.92, 4.19, 12.56, 16.75, 16.75, 65, 0, 1, NULL, 'RO1LU3EJOLR2O70MK', '', 0, NULL, 42.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"ServicePrice\":\"1.0000\",\"PriceType\":0}]', '', '', 0, '2024-01-23 17:17:04', '2024-01-23 17:02:14', '000000', 177.30, 61.40, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11423, '11010810001', 'MA80GFQM8', 'MA01D1QR8947223384251707392', '2411010810000301', 4, 4, '2024-01-23 17:28:40', '2024-01-23 17:28:50', 0.50, 0.10, 0.30, 0.40, 0.40, 65, 0, 1, NULL, '35DTQJWYHOVJDBNYF', '', 0, NULL, 19.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"ServicePrice\":\"1.0000\",\"PriceType\":0}]', '', '', 0, '2024-01-23 17:28:51', '2024-01-23 17:28:40', '000000', 4.50, 24.20, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11424, '11010810001', 'MA80GFQM8', 'MA01D1QR8947227111180218368', '2411010810000301', 4, 4, '2024-01-23 17:43:28', '2024-01-23 17:43:36', 0.50, 0.10, 0.30, 0.40, 0.40, 65, 0, 1, NULL, 'IOVHAVC2MH14WYBVX', '', 0, NULL, 41.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"ServicePrice\":\"1.0000\",\"PriceType\":0}]', '', '', 0, '2024-01-23 17:43:37', '2024-01-23 17:43:29', '000000', 238.30, 27.20, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11425, '11010810001', 'MA80GFQM8', 'MA01D1QR8947230968924876800', '2411010810000301', 4, 4, '2024-01-23 17:58:48', '2024-01-23 17:59:23', 1.11, 0.23, 0.67, 0.90, 0.90, 65, 0, 1, NULL, 'KEYJMGLPANIGHSDZN', '', 0, NULL, 45.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"ServicePrice\":\"1.0000\",\"PriceType\":0}]', '', '', 0, '2024-01-23 17:59:24', '2024-01-23 17:58:48', '000000', 228.10, 75.30, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11426, '11010810001', 'MA80GFQM8', 'MA01D1QR8947234996954083328', '2411010810000301', 4, 4, '2024-01-23 18:14:48', '2024-01-23 18:14:58', 0.29, 0.06, 0.18, 0.24, 0.24, 65, 0, 1, NULL, 'BIVOBJNZOFMTVQHU9', '', 0, NULL, 27.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"1.0000\",\"ServicePrice\":\"1.0000\",\"PriceType\":0}]', '', '', 0, '2024-01-23 18:14:59', '2024-01-23 18:14:49', '000000', 72.80, 20.20, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11427, '11010810001', 'MA80GFQM8', 'MA01D1QR8948313966218850304', '2411010810000101', 4, 2, '2024-01-26 17:42:14', '2024-01-26 17:42:57', 0.76, 1.53, 0.00, 1.53, 1.53, 0, 0, 0, NULL, '', '', 0, NULL, 15.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"0.2000\",\"ServicePrice\":\"0.6000\",\"PriceType\":0},{\"StartTime\":\"060000\",\"ElecPrice\":\"0.5000\",\"ServicePrice\":\"0.5000\",\"PriceType\":0},{\"StartTime\":\"100000\",\"ElecPrice\":\"0.6000\",\"ServicePrice\":\"0.5000\",\"PriceType\":0},{\"StartTime\":\"180000\",\"ElecPrice\":\"0.8000\",\"ServicePrice\":\"0.4000\",\"PriceType\":0},{\"StartTime\":\"220000\",\"ElecPrice\":\"0.5000\",\"ServicePrice\":\"0.5000\",\"PriceType\":0}]', '', '', 0, '2024-01-26 17:42:57', '2024-01-26 17:42:15', '000000', 159.00, 242.60, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11428, '11010810001', 'MA80GFQM8', 'MA01D1QR8949288193096953856', '2411010810000101', 4, 4, '2024-01-29 10:13:28', '2024-01-29 10:17:09', 5.32, 10.65, 0.00, 10.65, 10.65, 0, 0, 0, NULL, '', '', 0, NULL, 3.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"0.2000\",\"ServicePrice\":\"0.6000\",\"PriceType\":0},{\"StartTime\":\"060000\",\"ElecPrice\":\"0.5000\",\"ServicePrice\":\"0.5000\",\"PriceType\":0},{\"StartTime\":\"100000\",\"ElecPrice\":\"0.6000\",\"ServicePrice\":\"0.5000\",\"PriceType\":0},{\"StartTime\":\"180000\",\"ElecPrice\":\"0.8000\",\"ServicePrice\":\"0.4000\",\"PriceType\":0},{\"StartTime\":\"220000\",\"ElecPrice\":\"0.5000\",\"ServicePrice\":\"0.5000\",\"PriceType\":0}]', '', '', 0, '2024-01-29 10:17:09', '2024-01-29 10:13:29', '000000', 195.70, 67.90, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11429, '11010810001', 'MA80GFQM8', 'MA01D1QR8949307066349268992', '2411010810000101', 4, 4, '2024-01-29 11:28:27', '2024-01-29 11:33:04', 6.62, 9.26, 0.00, 9.26, 9.26, 0, 0, 0, NULL, '', '', 0, NULL, 13.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"0.4000\",\"ServicePrice\":\"0.3000\",\"PriceType\":0},{\"StartTime\":\"090000\",\"ElecPrice\":\"0.6000\",\"ServicePrice\":\"0.8000\",\"PriceType\":0},{\"StartTime\":\"130000\",\"ElecPrice\":\"0.7000\",\"ServicePrice\":\"0.4000\",\"PriceType\":0}]', '', '', 0, '2024-01-29 11:33:04', '2024-01-29 11:28:28', '000000', 96.30, 157.30, 2, 5.00);
INSERT INTO `omind_bill` VALUES (11430, '11010810001', 'MA80GFQM8', 'MA01D1QR8957653938163953664', '2411010810000101', 4, 1, '2024-02-21 12:15:56', '2024-02-21 12:16:13', 0.20, 0.09, 0.07, 0.16, 0.16, 0, 0, 0, NULL, '', '', 0, NULL, 56.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"0.4000\",\"ServicePrice\":\"0.3000\",\"PriceType\":0},{\"StartTime\":\"090000\",\"ElecPrice\":\"0.6000\",\"ServicePrice\":\"0.8000\",\"PriceType\":0},{\"StartTime\":\"130000\",\"ElecPrice\":\"0.7000\",\"ServicePrice\":\"0.4000\",\"PriceType\":0}]', '', '', 0, '2024-02-21 12:16:13', '2024-02-21 12:15:57', '000000', 184.80, 157.70, 1, 0.00);
INSERT INTO `omind_bill` VALUES (11431, '11010810001', 'MA80GFQM8', 'MA01D1QR8957681099843317760', '2411010810000101', 4, 4, '2024-02-21 14:03:52', '2024-02-21 14:04:07', 0.39, 0.16, 0.12, 0.28, 0.28, 0, 0, 0, NULL, '', '', 0, NULL, 8.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"0.4000\",\"ServicePrice\":\"0.3000\",\"PriceType\":0},{\"StartTime\":\"090000\",\"ElecPrice\":\"0.6000\",\"ServicePrice\":\"0.8000\",\"PriceType\":0},{\"StartTime\":\"130000\",\"ElecPrice\":\"0.7000\",\"ServicePrice\":\"0.4000\",\"PriceType\":0}]', '', '', 0, '2024-02-21 14:04:08', '2024-02-21 14:03:53', '000000', 123.90, 358.60, 1, -1.00);
INSERT INTO `omind_bill` VALUES (11432, '11010810001', 'MA80GFQM8', 'MA01D1QR8957681292630306816', '2411010810000101', 4, 1, '2024-02-21 14:04:38', '2024-02-21 14:05:04', 0.52, 0.22, 0.16, 0.38, 0.38, 0, 0, 0, NULL, '', '', 0, NULL, 22.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"0.4000\",\"ServicePrice\":\"0.3000\",\"PriceType\":0},{\"StartTime\":\"090000\",\"ElecPrice\":\"0.6000\",\"ServicePrice\":\"0.8000\",\"PriceType\":0},{\"StartTime\":\"130000\",\"ElecPrice\":\"0.7000\",\"ServicePrice\":\"0.4000\",\"PriceType\":0}]', '', '', 0, '2024-02-21 14:05:04', '2024-02-21 14:04:39', '000000', 54.30, 213.10, 1, -1.00);
INSERT INTO `omind_bill` VALUES (11433, '11010810001', 'MA80GFQM8', 'MA01D1QR8958077727880261632', '2411010810000101', 4, 3, '2024-02-22 16:19:56', '2024-02-22 16:48:24', 39.27, 15.86, 11.90, 27.76, 27.76, 0, 0, 0, NULL, '', '', 0, NULL, 69.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"0.4000\",\"ServicePrice\":\"0.3000\",\"PriceType\":0},{\"StartTime\":\"090000\",\"ElecPrice\":\"0.6000\",\"ServicePrice\":\"0.8000\",\"PriceType\":0},{\"StartTime\":\"130000\",\"ElecPrice\":\"0.7000\",\"ServicePrice\":\"0.4000\",\"PriceType\":0}]', '', '', 0, '2024-02-22 16:48:24', '2024-02-22 16:19:57', '000000', 146.90, 229.90, 1, -1.00);
INSERT INTO `omind_bill` VALUES (11434, '11010810001', 'MA80GFQM8', 'MA01D1QR8958086206674186240', '2411010810000101', 4, 3, '2024-02-22 16:53:37', '2024-02-22 16:59:17', 8.10, 3.25, 2.44, 5.69, 5.69, 0, 0, 0, NULL, '', '', 0, NULL, 16.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"0.4000\",\"ServicePrice\":\"0.3000\",\"PriceType\":0},{\"StartTime\":\"090000\",\"ElecPrice\":\"0.6000\",\"ServicePrice\":\"0.8000\",\"PriceType\":0},{\"StartTime\":\"130000\",\"ElecPrice\":\"0.7000\",\"ServicePrice\":\"0.4000\",\"PriceType\":0}]', '', '', 0, '2024-02-22 16:59:17', '2024-02-22 16:53:38', '000000', 52.10, 38.50, 1, -1.00);
INSERT INTO `omind_bill` VALUES (11435, '11010810001', 'MA80GFQM8', 'MA01D1QR8958087712089583616', '2411010810000101', 4, 3, '2024-02-22 16:59:36', '2024-02-22 17:11:44', 17.17, 7.05, 5.29, 12.34, 12.34, 0, 0, 0, NULL, '', '', 0, NULL, 62.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"0.4000\",\"ServicePrice\":\"0.3000\",\"PriceType\":0},{\"StartTime\":\"090000\",\"ElecPrice\":\"0.6000\",\"ServicePrice\":\"0.8000\",\"PriceType\":0},{\"StartTime\":\"130000\",\"ElecPrice\":\"0.7000\",\"ServicePrice\":\"0.4000\",\"PriceType\":0}]', '', '', 0, '2024-02-22 17:11:44', '2024-02-22 16:59:37', '000000', 137.20, 381.60, 1, -1.00);
INSERT INTO `omind_bill` VALUES (11436, '11010810001', 'MA80GFQM8', 'MA01D1QR8958091711073234944', '2411010810000101', 4, 3, '2024-02-22 17:15:30', '2024-02-22 17:15:39', 0.38, 0.16, 0.12, 0.28, 0.28, 0, 0, 0, NULL, '', '', 0, NULL, 60.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"0.4000\",\"ServicePrice\":\"0.3000\",\"PriceType\":0},{\"StartTime\":\"090000\",\"ElecPrice\":\"0.6000\",\"ServicePrice\":\"0.8000\",\"PriceType\":0},{\"StartTime\":\"130000\",\"ElecPrice\":\"0.7000\",\"ServicePrice\":\"0.4000\",\"PriceType\":0}]', '', '', 0, '2024-02-22 17:15:39', '2024-02-22 17:15:30', '000000', 71.00, 395.40, 1, -1.00);
INSERT INTO `omind_bill` VALUES (11437, '11010810001', 'MA80GFQM8', 'MA01D1QR8958345544768696320', '2411010810000301', 4, 2, '2024-02-23 10:04:08', '2024-02-23 10:04:24', 0.47, 0.20, 0.15, 0.35, 0.35, 0, 0, 0, NULL, '', '', 0, NULL, 48.00, 1, '', '[{\"StartTime\":\"000000\",\"ElecPrice\":\"0.4000\",\"ServicePrice\":\"0.3000\",\"PriceType\":0},{\"StartTime\":\"090000\",\"ElecPrice\":\"0.6000\",\"ServicePrice\":\"0.8000\",\"PriceType\":0},{\"StartTime\":\"130000\",\"ElecPrice\":\"0.7000\",\"ServicePrice\":\"0.4000\",\"PriceType\":0}]', '', '', 0, '2024-02-23 10:04:24', '2024-02-23 10:04:09', '000000', 182.40, 293.50, 1, -1.00);
COMMIT;
-- ----------------------------
-- Table structure for omind_connector
-- ----------------------------
DROP TABLE IF EXISTS `omind_connector`;
CREATE TABLE `omind_connector` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`station_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电站id(运营商自定义的唯一编码)',
`operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '基础运营商id(组织机构代码)',
`user_operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户平台运营商id(组织机构代码)',
`base_operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '基础运营商id(组织机构代码)',
`equipment_id` varchar(23) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '设备编码(设备唯一编码,对同一运营商,保证唯一)',
`connector_id` varchar(26) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电设备接口编码(充电设备接口编码,同一运营商内唯一)',
`connector_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电设备接口名称',
`connector_type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '充电设备接口类型:1、家用插座(模式2);2、交流接口插座(模式3连接方式B);3、交流接口插头(带枪线模式3连接方式C);4、直流接口枪头(带枪线模式4);5、无线充电座;6、其他',
`voltage_upper_limits` smallint unsigned NOT NULL DEFAULT '0' COMMENT '额定电压上限(单位:V)',
`voltage_lower_limits` smallint unsigned NOT NULL DEFAULT '0' COMMENT '额定电压下限(单位:V)',
`current_value` smallint unsigned NOT NULL COMMENT '额定电流(单位:A)',
`power` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '额定功率(单位:kW)',
`park_no` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '车位号(停车场车位编号)',
`national_standard` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '国家标准:1、2011;2、2015',
`status` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '充电设备接口状态:0、离网;1、空闲;2、占用(未充电);3、占用(充电中);4、占用(预约锁定);255、故障',
`park_status` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '车位状态:0:未知;10:空闲;50:已上锁',
`lock_status` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '地锁状态:0:未知;10:已解锁;50:已上锁',
`del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE,
KEY `equipment_id` (`equipment_id`),
KEY `connector_id` (`connector_id`),
KEY `station_id` (`station_id`),
KEY `operator_id` (`operator_id`),
KEY `base_operator_id` (`base_operator_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4532 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='充电设备接口信息表';
-- ----------------------------
-- Records of omind_connector
-- ----------------------------
BEGIN;
INSERT INTO `omind_connector` VALUES (4526, '11010810001', 'MA80GFQM8', 'MA01D1QR8', 'MA80GFQM8', '24110108100001', '2411010810000101', '快充01', 4, 960, 180, 120, 120.00, '', 2, 2, 0, 0, 0, '2024-02-23 11:20:00', '2024-02-23 11:20:00', '000000');
INSERT INTO `omind_connector` VALUES (4527, '11010810001', 'MA80GFQM8', 'MA01D1QR8', 'MA80GFQM8', '24110108100002', '2411010810000201', '快充02', 4, 180, 960, 120, 120.00, '', 2, 2, 0, 0, 0, '2024-02-23 11:20:00', '2024-02-23 11:20:00', '000000');
INSERT INTO `omind_connector` VALUES (4528, '11010810001', 'MA80GFQM8', 'MA01D1QR8', 'MA80GFQM8', '24110108100003', '2411010810000301', '快充03', 4, 180, 960, 120, 120.00, '', 2, 0, 0, 0, 0, '2024-02-23 11:20:00', '2024-02-23 11:20:00', '000000');
INSERT INTO `omind_connector` VALUES (4529, '11010810001', 'MA80GFQM8', 'MA01D1QR8', 'MA80GFQM8', '24110108100004', '2411010810000401', '快充04', 4, 180, 960, 120, 120.00, '', 2, 0, 0, 0, 0, '2024-02-23 11:20:00', '2024-02-23 11:20:00', '000000');
INSERT INTO `omind_connector` VALUES (4530, '11010810001', 'MA80GFQM8', 'MA01D1QR8', 'MA80GFQM8', '24110108100005', '2411010810000501', '快充05', 4, 180, 960, 120, 120.00, '', 2, 0, 0, 0, 0, '2024-02-23 11:20:00', '2024-02-23 11:20:00', '000000');
INSERT INTO `omind_connector` VALUES (4531, '11010810001', 'MA80GFQM8', 'MA01D1QR8', 'MA80GFQM8', '24110108100006', '2411010810000601', '快充06', 4, 180, 960, 120, 120.00, '', 2, 0, 0, 0, 0, '2024-02-23 11:20:00', '2024-02-23 11:20:00', '000000');
COMMIT;
-- ----------------------------
-- Table structure for omind_equipment
-- ----------------------------
DROP TABLE IF EXISTS `omind_equipment`;
CREATE TABLE `omind_equipment` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`station_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电站id(运营商自定义的唯一编码)',
`operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '运营商id(组织机构代码)',
`user_operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户平台运营商id(组织机构代码)',
`base_operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '基础运营商id(组织机构代码)',
`equipment_id` varchar(23) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '设备编码(设备唯一编码,对同一运营商,保证唯一)',
`equipment_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电设备名称',
`manufacturer_id` varchar(9) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '设备生产商组织机构代码',
`manufacturer_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '设备生产商名称',
`equipment_model` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '设备型号(由设备生产商定义的设备型号)',
`production_date` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '设备生产日期(YYYY-MM-DD)',
`equipment_type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '设备类型:1、直流设备;2、交流设备;3、交直流一体设备;4、无线设备;5、其他',
`equipment_lng` decimal(6,6) unsigned NOT NULL DEFAULT '0.000000' COMMENT '站点经度(GCJ-02坐标系,保留小数点后6位)',
`equipment_lat` decimal(6,6) unsigned NOT NULL DEFAULT '0.000000' COMMENT '站点纬度(GCJ-02坐标系,保留小数点后6位)',
`power` decimal(6,1) unsigned NOT NULL DEFAULT '0.0' COMMENT '充电设备总功率(单位:kW,保留小数点后1位)',
`del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE,
KEY `operator_id` (`operator_id`),
KEY `station_id` (`station_id`),
KEY `equipment_id` (`equipment_id`),
KEY `manufacturer_id` (`manufacturer_id`),
KEY `base_operator_id` (`base_operator_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3572 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='充电设备信息表';
-- ----------------------------
-- Records of omind_equipment
-- ----------------------------
BEGIN;
INSERT INTO `omind_equipment` VALUES (3566, '11010810001', 'MA80GFQM8', 'MA01D1QR8', 'MA80GFQM8', '24110108100001', 'A1直流桩', 'MA01D1QR8', '', 'A1', '2024-01-05', 1, 0.000000, 0.000000, 120.0, 0, '2024-02-23 11:20:00', '2024-02-23 11:20:00', '000000');
INSERT INTO `omind_equipment` VALUES (3567, '11010810001', 'MA80GFQM8', 'MA01D1QR8', 'MA80GFQM8', '24110108100002', 'A2直流桩', 'MA01D1QR8', '', 'A1', '', 1, 0.000000, 0.000000, 120.0, 0, '2024-02-23 11:20:00', '2024-02-23 11:20:00', '000000');
INSERT INTO `omind_equipment` VALUES (3568, '11010810001', 'MA80GFQM8', 'MA01D1QR8', 'MA80GFQM8', '24110108100003', 'A3直流桩', 'MA01D1QR8', '', 'A1', '', 1, 0.000000, 0.000000, 120.0, 0, '2024-02-23 11:20:00', '2024-02-23 11:20:00', '000000');
INSERT INTO `omind_equipment` VALUES (3569, '11010810001', 'MA80GFQM8', 'MA01D1QR8', 'MA80GFQM8', '24110108100004', 'A4直流桩', 'MA01D1QR8', '', 'A1', '', 1, 0.000000, 0.000000, 120.0, 0, '2024-02-23 11:20:00', '2024-02-23 11:20:00', '000000');
INSERT INTO `omind_equipment` VALUES (3570, '11010810001', 'MA80GFQM8', 'MA01D1QR8', 'MA80GFQM8', '24110108100005', 'A5直流桩', 'MA01D1QR8', '', 'A1', '', 1, 0.000000, 0.000000, 120.0, 0, '2024-02-23 11:20:00', '2024-02-23 11:20:00', '000000');
INSERT INTO `omind_equipment` VALUES (3571, '11010810001', 'MA80GFQM8', 'MA01D1QR8', 'MA80GFQM8', '24110108100006', 'A6直流桩', 'MA01D1QR8', '', 'A1', '', 1, 0.000000, 0.000000, 120.0, 0, '2024-02-23 11:20:00', '2024-02-23 11:20:00', '000000');
COMMIT;
-- ----------------------------
-- Table structure for omind_feedback
-- ----------------------------
DROP TABLE IF EXISTS `omind_feedback`;
CREATE TABLE `omind_feedback` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`user_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
`connector_id` varchar(26) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '桩ID',
`feedback_type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '反馈类型:1、充电站;2、充电桩;3、充电枪;50、其他',
`feedback_content` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '反馈内容',
`imgs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '图片',
`reply_content` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '回复内容',
`reply_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否回复:0、未回复;1、已回复',
`remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
`del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户反馈表';
-- ----------------------------
-- Records of omind_feedback
-- ----------------------------
BEGIN;
INSERT INTO `omind_feedback` VALUES (1, 4, '', 3, 'qwert', '[]', 'aaa', 1, '', 0, '2024-01-23 11:28:41', '2024-01-22 16:16:58', '000000');
INSERT INTO `omind_feedback` VALUES (2, 1, '11', 3, '11', '[]', '123', 1, '', 0, '2024-01-23 18:57:28', '2024-01-23 12:09:03', '000000');
INSERT INTO `omind_feedback` VALUES (3, 1, '123', 3, 'qq', '[]', '123', 1, '', 0, '2024-01-23 18:57:20', '2024-01-23 18:54:46', '000000');
COMMIT;
-- ----------------------------
-- Table structure for omind_operator
-- ----------------------------
DROP TABLE IF EXISTS `omind_operator`;
CREATE TABLE `omind_operator` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '运营商id(组织机构代码)',
`operator_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '运营商名称',
`operator_tel1` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '运营商客服电话1',
`operator_tel2` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '运营商客服电话2',
`operator_reg_address` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '运营商注册地址',
`operator_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注信息',
`user_operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '客户归属运营商id(组织机构代码)',
`operator_secret` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '运营商密钥',
`data_secret` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '消息密钥',
`data_secret_iv` char(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '消息密钥初始化向量',
`sig_secret` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '签名密钥',
`base_operator_secret` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '基础运营商密钥',
`base_data_secret` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '基础消息密钥',
`base_data_secret_iv` char(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '基础消息密钥初始化向量',
`base_sig_secret` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '基础签名密钥',
`api_url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '接口地址',
`plat_type` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '平台类型:1、OMIND',
`del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '000000' COMMENT '租户编号',
PRIMARY KEY (`id`),
KEY `operator_id` (`operator_id`),
KEY `user_operator_id` (`user_operator_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='基础设施运营商信息表';
-- ----------------------------
-- Records of omind_operator
-- ----------------------------
BEGIN;
INSERT INTO `omind_operator` VALUES (28, 'MA80GFQM8', '北京飞天科技邮箱公司', '13800000000', '13800000000', '北京市海淀区中关村大街', '', 'MA01D1QR8', 'o6gpvB9uo87UBHGy', '7sEQg8caT0kpAUNO', 'l9JC1bDWFLidvdv8', 'RnKZnW2RxxuXPOIz', 'e3bb15a6f95f8bb7', '37ruITzn5kL0hFZG', 'idPU4cFo4MAn2JEL', '57fd20184e19ca9a', 'http://172.25.0.101:9801/evcs/v1/', 1, 0, '2024-01-11 15:52:32', '2024-01-11 15:52:32', '000000');
COMMIT;
-- ----------------------------
-- Table structure for omind_price
-- ----------------------------
DROP TABLE IF EXISTS `omind_price`;
CREATE TABLE `omind_price` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`station_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电站ID',
`price_code` bigint NOT NULL DEFAULT '0' COMMENT '价格模版ID0为默认价格',
`start_time` datetime NOT NULL COMMENT '时段起始时间点 6位 HHmmss',
`price_type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '价格类型:0、尖;1、峰;2、平;3、谷;',
`elec_price` decimal(10,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '电价:XXXX.XXXX',
`service_price` decimal(10,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '服务费单价:XXXX.XXXX',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
`del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
`tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='充电价格表';
-- ----------------------------
-- Records of omind_price
-- ----------------------------
BEGIN;
INSERT INTO `omind_price` VALUES (1, '11010810001', 0, '2024-01-22 00:00:00', 2, 1.0000, 1.0000, '2024-01-22 13:03:09', '', 2, '000000');
INSERT INTO `omind_price` VALUES (2, '11010810002', 0, '2024-01-22 00:00:00', 2, 1.0000, 1.0000, '2024-01-22 13:03:34', '', 2, '000000');
INSERT INTO `omind_price` VALUES (3, '11010810003', 0, '2024-01-22 00:00:00', 2, 1.0000, 1.0000, '2024-01-22 13:03:52', '', 2, '000000');
INSERT INTO `omind_price` VALUES (4, '11010810001', 0, '2024-01-22 00:00:00', 0, 1.0000, 1.0000, '2024-01-22 18:22:19', '', 2, '000000');
INSERT INTO `omind_price` VALUES (5, '11010810002', 0, '2024-01-22 00:00:00', 0, 1.0000, 1.0000, '2024-01-22 18:25:10', '', 0, '000000');
INSERT INTO `omind_price` VALUES (6, '11010810003', 0, '2024-01-22 00:00:00', 0, 0.2000, 0.6000, '2024-01-22 18:39:28', '', 2, '000000');
INSERT INTO `omind_price` VALUES (7, '11010810003', 0, '2024-01-22 06:00:00', 0, 0.5000, 0.5000, '2024-01-22 18:39:28', '', 2, '000000');
INSERT INTO `omind_price` VALUES (8, '11010810003', 0, '2024-01-22 10:00:00', 0, 0.6000, 0.5000, '2024-01-22 18:39:28', '', 2, '000000');
INSERT INTO `omind_price` VALUES (9, '11010810003', 0, '2024-01-22 18:00:00', 0, 0.8000, 0.4000, '2024-01-22 18:39:28', '', 2, '000000');
INSERT INTO `omind_price` VALUES (10, '11010810003', 0, '2024-01-22 22:00:00', 0, 0.5000, 0.5000, '2024-01-22 18:39:28', '', 2, '000000');
INSERT INTO `omind_price` VALUES (11, '11010810003', 0, '2024-01-22 00:00:00', 0, 1.0000, 1.0000, '2024-01-22 18:40:14', '', 2, '000000');
INSERT INTO `omind_price` VALUES (12, '11010810003', 0, '2024-01-22 00:00:00', 0, 0.2000, 0.6000, '2024-01-22 18:40:46', '', 2, '000000');
INSERT INTO `omind_price` VALUES (13, '11010810003', 0, '2024-01-22 06:00:00', 0, 0.5000, 0.5000, '2024-01-22 18:40:46', '', 2, '000000');
INSERT INTO `omind_price` VALUES (14, '11010810003', 0, '2024-01-22 10:00:00', 0, 0.6000, 0.5000, '2024-01-22 18:40:46', '', 2, '000000');
INSERT INTO `omind_price` VALUES (15, '11010810003', 0, '2024-01-22 18:00:00', 0, 0.8000, 0.4000, '2024-01-22 18:40:46', '', 2, '000000');
INSERT INTO `omind_price` VALUES (16, '11010810003', 0, '2024-01-22 22:00:00', 0, 0.5000, 0.5000, '2024-01-22 18:40:46', '', 2, '000000');
INSERT INTO `omind_price` VALUES (17, '11010810003', 0, '2024-01-22 00:00:00', 0, 1.0000, 1.0000, '2024-01-22 18:40:59', '', 2, '000000');
INSERT INTO `omind_price` VALUES (18, '11010810003', 0, '2024-01-22 00:00:00', 0, 0.2000, 0.6000, '2024-01-22 18:55:39', '', 2, '000000');
INSERT INTO `omind_price` VALUES (19, '11010810003', 0, '2024-01-22 06:00:00', 0, 0.5000, 0.5000, '2024-01-22 18:55:39', '', 2, '000000');
INSERT INTO `omind_price` VALUES (20, '11010810003', 0, '2024-01-22 10:00:00', 0, 0.6000, 0.5000, '2024-01-22 18:55:39', '', 2, '000000');
INSERT INTO `omind_price` VALUES (21, '11010810003', 0, '2024-01-22 18:00:00', 0, 0.8000, 0.4000, '2024-01-22 18:55:39', '', 2, '000000');
INSERT INTO `omind_price` VALUES (22, '11010810003', 0, '2024-01-22 22:00:00', 0, 0.5000, 0.5000, '2024-01-22 18:55:39', '', 2, '000000');
INSERT INTO `omind_price` VALUES (23, '11010810003', 0, '2024-01-22 00:00:00', 0, 1.0000, 1.0000, '2024-01-22 18:57:36', '', 2, '000000');
INSERT INTO `omind_price` VALUES (24, '11010810003', 0, '2024-01-22 00:00:00', 0, 1.0000, 1.0000, '2024-01-22 19:03:46', '', 2, '000000');
INSERT INTO `omind_price` VALUES (25, '11010810003', 0, '2024-01-22 00:00:00', 0, 1.0000, 1.0000, '2024-01-22 19:03:57', '', 2, '000000');
INSERT INTO `omind_price` VALUES (26, '11010810003', 0, '2024-01-22 00:00:00', 0, 1.0000, 1.0000, '2024-01-22 19:04:18', '', 2, '000000');
INSERT INTO `omind_price` VALUES (27, '11010810003', 0, '2024-01-22 00:00:00', 0, 0.2000, 0.6000, '2024-01-22 19:04:36', '', 2, '000000');
INSERT INTO `omind_price` VALUES (28, '11010810003', 0, '2024-01-22 06:00:00', 0, 0.5000, 0.5000, '2024-01-22 19:04:36', '', 2, '000000');
INSERT INTO `omind_price` VALUES (29, '11010810003', 0, '2024-01-22 10:00:00', 0, 0.6000, 0.5000, '2024-01-22 19:04:36', '', 2, '000000');
INSERT INTO `omind_price` VALUES (30, '11010810003', 0, '2024-01-22 18:00:00', 0, 0.8000, 0.4000, '2024-01-22 19:04:36', '', 2, '000000');
INSERT INTO `omind_price` VALUES (31, '11010810003', 0, '2024-01-22 22:00:00', 0, 0.5000, 0.5000, '2024-01-22 19:04:36', '', 2, '000000');
INSERT INTO `omind_price` VALUES (32, '11010810003', 0, '2024-01-22 00:00:00', 0, 0.2000, 0.6000, '2024-01-22 19:04:49', '', 2, '000000');
INSERT INTO `omind_price` VALUES (33, '11010810003', 0, '2024-01-22 06:00:00', 0, 0.5000, 0.5000, '2024-01-22 19:04:49', '', 2, '000000');
INSERT INTO `omind_price` VALUES (34, '11010810003', 0, '2024-01-22 10:00:00', 0, 0.6000, 0.5000, '2024-01-22 19:04:49', '', 2, '000000');
INSERT INTO `omind_price` VALUES (35, '11010810003', 0, '2024-01-22 18:00:00', 0, 0.8000, 0.4000, '2024-01-22 19:04:49', '', 2, '000000');
INSERT INTO `omind_price` VALUES (36, '11010810003', 0, '2024-01-22 22:00:00', 0, 0.5000, 0.5000, '2024-01-22 19:04:49', '', 2, '000000');
INSERT INTO `omind_price` VALUES (37, '11010810003', 0, '2024-01-22 00:00:00', 0, 1.0000, 1.0000, '2024-01-22 19:05:57', '', 2, '000000');
INSERT INTO `omind_price` VALUES (38, '11010810003', 0, '2024-01-22 00:00:00', 0, 1.0000, 1.0000, '2024-01-22 20:44:17', '', 2, '000000');
INSERT INTO `omind_price` VALUES (39, '11010810003', 0, '2024-01-22 00:00:00', 0, 1.0000, 1.0000, '2024-01-22 20:44:23', '', 2, '000000');
INSERT INTO `omind_price` VALUES (40, '11010810003', 0, '2024-01-22 00:00:00', 0, 0.2000, 0.6000, '2024-01-22 20:44:30', '', 2, '000000');
INSERT INTO `omind_price` VALUES (41, '11010810003', 0, '2024-01-22 06:00:00', 0, 0.5000, 0.5000, '2024-01-22 20:44:30', '', 2, '000000');
INSERT INTO `omind_price` VALUES (42, '11010810003', 0, '2024-01-22 10:00:00', 0, 0.6000, 0.5000, '2024-01-22 20:44:30', '', 2, '000000');
INSERT INTO `omind_price` VALUES (43, '11010810003', 0, '2024-01-22 18:00:00', 0, 0.8000, 0.4000, '2024-01-22 20:44:30', '', 2, '000000');
INSERT INTO `omind_price` VALUES (44, '11010810003', 0, '2024-01-22 22:00:00', 0, 0.5000, 0.5000, '2024-01-22 20:44:30', '', 2, '000000');
INSERT INTO `omind_price` VALUES (45, '11010810003', 0, '2024-01-22 00:00:00', 0, 1.0000, 1.0000, '2024-01-22 20:44:34', '', 0, '000000');
INSERT INTO `omind_price` VALUES (46, '11010810001', 0, '2024-01-22 00:00:00', 0, 1.0000, 1.0000, '2024-01-22 21:04:10', '', 2, '000000');
INSERT INTO `omind_price` VALUES (47, '11010810001', 0, '2024-01-22 00:00:00', 0, 0.2000, 0.6000, '2024-01-22 21:04:17', '', 2, '000000');
INSERT INTO `omind_price` VALUES (48, '11010810001', 0, '2024-01-22 06:00:00', 0, 0.5000, 0.5000, '2024-01-22 21:04:17', '', 2, '000000');
INSERT INTO `omind_price` VALUES (49, '11010810001', 0, '2024-01-22 10:00:00', 0, 0.6000, 0.5000, '2024-01-22 21:04:17', '', 2, '000000');
INSERT INTO `omind_price` VALUES (50, '11010810001', 0, '2024-01-22 18:00:00', 0, 0.8000, 0.4000, '2024-01-22 21:04:17', '', 2, '000000');
INSERT INTO `omind_price` VALUES (51, '11010810001', 0, '2024-01-22 22:00:00', 0, 0.5000, 0.5000, '2024-01-22 21:04:17', '', 2, '000000');
INSERT INTO `omind_price` VALUES (52, '11010810001', 0, '2024-01-23 00:00:00', 0, 1.0000, 1.0000, '2024-01-23 11:12:57', '', 2, '000000');
INSERT INTO `omind_price` VALUES (53, '11010810001', 0, '2024-01-23 00:00:00', 0, 1.0000, 1.0000, '2024-01-23 11:12:59', '', 2, '000000');
INSERT INTO `omind_price` VALUES (54, '11010810001', 0, '2024-01-24 00:00:00', 0, 1.0000, 1.0000, '2024-01-24 18:14:44', '', 2, '000000');
INSERT INTO `omind_price` VALUES (55, '11010810001', 0, '2024-01-24 00:00:00', 0, 1.0000, 1.0000, '2024-01-24 18:15:04', '', 2, '000000');
INSERT INTO `omind_price` VALUES (56, '11010810001', 0, '2024-01-24 00:00:00', 0, 0.2000, 0.6000, '2024-01-24 18:16:49', '', 2, '000000');
INSERT INTO `omind_price` VALUES (57, '11010810001', 0, '2024-01-24 06:00:00', 0, 0.5000, 0.5000, '2024-01-24 18:16:49', '', 2, '000000');
INSERT INTO `omind_price` VALUES (58, '11010810001', 0, '2024-01-24 10:00:00', 0, 0.6000, 0.5000, '2024-01-24 18:16:49', '', 2, '000000');
INSERT INTO `omind_price` VALUES (59, '11010810001', 0, '2024-01-24 18:00:00', 0, 0.8000, 0.4000, '2024-01-24 18:16:49', '', 2, '000000');
INSERT INTO `omind_price` VALUES (60, '11010810001', 0, '2024-01-24 22:00:00', 0, 0.5000, 0.5000, '2024-01-24 18:16:49', '', 2, '000000');
INSERT INTO `omind_price` VALUES (61, '11010810001', 0, '2024-01-29 00:00:00', 0, 0.4000, 0.3000, '2024-01-29 10:24:23', '', 0, '000000');
INSERT INTO `omind_price` VALUES (62, '11010810001', 0, '2024-01-29 09:00:00', 0, 0.6000, 0.8000, '2024-01-29 10:24:23', '', 0, '000000');
INSERT INTO `omind_price` VALUES (63, '11010810001', 0, '2024-01-29 13:00:00', 0, 0.7000, 0.4000, '2024-01-29 10:24:23', '', 0, '000000');
COMMIT;
-- ----------------------------
-- Table structure for omind_station
-- ----------------------------
DROP TABLE IF EXISTS `omind_station`;
CREATE TABLE `omind_station` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`station_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电站id(运营商自定义的唯一编码)',
`operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '运营商id(组织机构代码)',
`user_operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户平台运营商id(组织机构代码)',
`base_operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '基础运营商id(组织机构代码)',
`equipment_owner_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '设备所属商id(组织机构代码)',
`station_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电站名称',
`country_code` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电站国家代码,比如CN',
`area_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电站省市辖区编码',
`address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '详细地址',
`station_tel` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '站点电话(能够联系场站工作人员进行协助的联系电话)',
`service_tel` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '服务电话(平台服务电话例如400的电话)',
`station_type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '站点类型:1、公共;50、个人;100、公交(专用);101、环卫(专用);102、物流(专用);103、出租车(专用);255、其他',
`station_status` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '站点状态:0、未知;1、建设中;5、关闭下线;6、维护中;50、正常使用',
`park_nums` int unsigned NOT NULL DEFAULT '0' COMMENT '车位数量(可停放进行充电的车位总数默认0 未知)',
`station_lng` decimal(10,6) unsigned NOT NULL DEFAULT '0.000000' COMMENT '站点经度(GCJ-02坐标系,保留小数点后6位)',
`station_lat` decimal(10,6) unsigned NOT NULL DEFAULT '0.000000' COMMENT '站点纬度(GCJ-02坐标系,保留小数点后6位)',
`site_guide` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '站点引导:描述性文字,用于引导车主找到充电车位',
`construction` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '建设场所类型:1、居民区;2、公共机构;3、企事业单位;4、写字楼;5、工业园区;6、交通枢纽;7、大型文体设施;8、城市绿地;9、大型建筑配建停车场;10、路边停车位;11、城际高速服务区;255、其他',
`pictures` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '站点照片(充电设备照片、充电车位照片、停车场入口照片)JSON串',
`match_cars` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '使用车型描述(描述该站点接受的车大小以及类型,如大巴、物流车、私家乘用车、出租车等)',
`park_info` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '车位楼层及数量描述(车位楼层以及数量信息)',
`busine_hours` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '营业时间描述',
`electricity_fee` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电电费描述',
`service_fee` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '服务费描述',
`park_fee` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '停车费描述',
`payment` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '支付方式::刷卡、线上、现金。其中电子钱包类卡为刷卡,身份鉴权卡、微信/支付宝、APP为线上',
`support_order` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否支持预约(充电设备是否需要提前预约后才能使用。0为不支持预约;1为支持预约。不填默认为0)',
`plat_type` tinyint unsigned NOT NULL COMMENT '平台类型',
`remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注信息',
`del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
PRIMARY KEY (`id`),
KEY `station_id` (`station_id`),
KEY `operator_id` (`operator_id`),
KEY `equipment_owner_id` (`equipment_owner_id`),
KEY `area_code` (`area_code`)
) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='充电站信息表';
-- ----------------------------
-- Records of omind_station
-- ----------------------------
BEGIN;
INSERT INTO `omind_station` VALUES (128, '11010810001', 'MA80GFQM8', 'MA01D1QR8', 'MA80GFQM8', 'MA01D1QR8', '海淀区001充电站', '86', '110108', '中关村大街', '13900000000', '13900000000', 0, 50, 0, 116.315792, 39.984553, '地下一层', 1, '[\"http://172.25.0.15:9000/ruoyi/2024/01/26/c855d51293b8453baa8c00019b891fe7.jpeg\"]', '小轿车', '收费15元/小时', '1', '1', '1', '', '微信', 0, 1, '', 0, '2024-02-23 11:20:00', '2024-02-23 11:20:00', '000000');
INSERT INTO `omind_station` VALUES (129, '11010810002', 'MA80GFQM8', 'MA01D1QR8', 'MA80GFQM8', 'MA01D1QR8', '海淀区002充电站', '86', '110108', '中关村大街', '13900000000', '13900000000', 0, 50, 0, 116.416792, 39.987553, '地下一层', 0, '[]', '小轿车', '收费15元/小时', '', '', '', '', '微信', 0, 1, '', 0, '2024-02-23 11:20:00', '2024-02-23 11:20:00', '000000');
INSERT INTO `omind_station` VALUES (130, '11010810003', 'MA80GFQM8', 'MA01D1QR8', 'MA80GFQM8', 'MA01D1QR8', '海淀区003充电站', '86', '110108', '中关村大街', '13900000000', '13900000000', 0, 50, 0, 116.516792, 39.987553, '地下一层', 0, '[]', '小轿车', '收费15元/小时', '', '', '', '', '微信', 0, 1, '', 0, '2024-02-23 11:20:00', '2024-02-23 11:20:00', '000000');
COMMIT;
-- ----------------------------
-- Table structure for omind_station_images
-- ----------------------------
DROP TABLE IF EXISTS `omind_station_images`;
CREATE TABLE `omind_station_images` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`station_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电站id(运营商自定义的唯一编码)',
`image_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '图片类型:1、充电站照片;2、充电桩照片;3、充电车位照片;4、停车场入口照片',
`image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '站点图片',
`image_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图片名称',
`show_seq` int unsigned DEFAULT '0' COMMENT '显示顺序',
`del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='充电站图片表';
-- ----------------------------
-- Table structure for omind_user
-- ----------------------------
DROP TABLE IF EXISTS `omind_user`;
CREATE TABLE `omind_user` (
`uid` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`phone_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '国家区号码',
`mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户手机号',
`nick_name` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户昵称',
`wechat_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '微信昵称',
`unionid_wx` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '当且仅当该移动应用已获得该用户的 userinfo 授权时,才会出现该字段',
`openid_wx` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '小程序openID',
`unionid_ali` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'ali统一id',
`openid_ali` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '支付宝用户唯一标识',
`credit_pay_wx` int NOT NULL DEFAULT '0' COMMENT '微信信用分授权-后支付',
`credit_pay_ali` int NOT NULL DEFAULT '0' COMMENT '阿里信用分授权-后支付',
`sex` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0、未知;1、男;2、女',
`country` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '国家',
`province` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '省',
`city` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '城市',
`birthday` bigint NOT NULL DEFAULT '0' COMMENT '生日',
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '头像地址',
`platform` int unsigned NOT NULL DEFAULT '0' COMMENT '注册来源的平台:关联平台id(0未知)',
`disable_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否禁用用户:0、启用;1、禁用',
`register_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间',
`last_visit_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '最近一次访问时间',
`last_visit_ip` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '最近一次访问ip',
`last_visit_area` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '最近一次访问ip对应区域',
`org_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '用户是否从属组织机构:0、不从属;1、从属',
`remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
`del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
PRIMARY KEY (`uid`),
KEY `mobile` (`mobile`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户表';
-- ----------------------------
-- Records of omind_user
-- ----------------------------
BEGIN;
INSERT INTO `omind_user` VALUES (1, '86', '13124790000', '13124790000', '', 'ooEjV5vbOwzEVob09TQxxy2N64rc', 'onCyY5d9TRmkhnFaOM0c9PlAQVso', '', '', 0, 0, 0, '', '', '', 0, '', 0, 0, '2024-01-22 15:29:51', '2024-02-23 10:07:58', '219.142.137.156,172.25.0.3', '', 0, '', 0, '2024-02-23 10:07:58', '2024-01-22 15:29:51', '000000');
INSERT INTO `omind_user` VALUES (2, '86', '13400000000', '13400000000', '', 'ooEjV5ukdDN9ertqD-j-j8mHReAk', 'onCyY5ed6WUVCJrNDRtIEN4bTCV8', '', '', 0, 0, 0, '', '', '', 0, '', 0, 0, '2024-01-22 15:33:29', '2024-02-23 10:51:35', '219.142.137.156,172.25.0.3', '', 0, '', 0, '2024-02-23 10:51:35', '2024-01-22 15:33:30', '000000');
INSERT INTO `omind_user` VALUES (3, '86', '18600000000', '18600000000', '', 'ooEjV5hqzMrsHGPc8nI-ila6Wf_U', 'onCyY5TXaphwcjXBJiqsMSAnycaI', '', '', 0, 0, 0, '', '', '', 0, '', 0, 0, '2024-01-22 15:33:58', '2024-02-22 17:33:25', '219.142.137.156,172.25.0.3', '', 0, '', 0, '2024-02-22 17:33:25', '2024-01-22 15:33:59', '000000');
INSERT INTO `omind_user` VALUES (4, '86', '13800000000', '13800000000', '', 'ooEjV5sQcoZDsP9a-EI1Mmo-ZMrQ', 'onCyY5Uve8iwpq_3JTR5SgBTL_PM', '', '', 0, 0, 0, '', '', '', 0, '', 0, 0, '2024-01-22 15:49:46', '2024-02-22 09:59:34', '219.142.137.156,172.25.0.3', '', 0, '', 0, '2024-02-22 09:59:34', '2024-01-22 15:49:47', '000000');
COMMIT;
-- ----------------------------
-- Table structure for omind_user_car
-- ----------------------------
DROP TABLE IF EXISTS `omind_user_car`;
CREATE TABLE `omind_user_car` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '车辆ID',
`user_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
`plate_no` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '车牌号',
`car_vin` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '车辆vin码',
`engine_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '发动机号码',
`vehicle_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '车辆类型',
`car_model` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '品牌型号',
`owner` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '车辆所有人',
`address` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '住址',
`use_character` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '使用性质:运营、非运营',
`register_date` date DEFAULT NULL COMMENT '注册日期(格式"yyyy-MM-dd")',
`issue_date` date DEFAULT NULL COMMENT '发证日期(格式"yyyy-MM-dd")',
`license_imgs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'json',
`check_state` tinyint unsigned NOT NULL DEFAULT '0' COMMENT ':0;1;2;3',
`auth_state` tinyint unsigned NOT NULL DEFAULT '0' COMMENT ':0;1;2;3',
`remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '',
`del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT ':0;1',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '',
`tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `plate_no` (`plate_no`),
KEY `car_vin` (`car_vin`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Records of omind_user_car
-- ----------------------------
BEGIN;
INSERT INTO `omind_user_car` VALUES (126, 4, 'A12345', '', '', '', '', '', '', '', NULL, NULL, NULL, 0, 0, '', 0, '2024-01-23 11:30:20', '2024-01-23 11:30:20', '000000');
INSERT INTO `omind_user_car` VALUES (127, 1, 'AD99999', '', '', '', '', '', '', '', NULL, NULL, NULL, 0, 0, '', 0, '2024-01-23 12:09:16', '2024-01-23 12:09:16', '000000');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;