Inicio Explorar Axuda
Rexistro Iniciar sesión
tino
/
tino-charge-cloud-master
2
0
Fork 0
Ficheiros Incidencias 0 Pull Requests 0 Wiki
Árbore: c3e3a4c325
Ramas Etiquetas
tino-charge-...
/
docker
/
mysql
/
init
/
tino-user-plat.sql

tino-user-plat.sql 63 KB
Histórico Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 抢占式-preemptively.trytowish.cn
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 80031
    7. 

  7.  Source Host           : preemptively.trytowish.cn:3306
    8. 

  8.  Source Schema         : omind-user-plat
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 80031
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 23/02/2024 11:21:01
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for omind_app
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `omind_app`;
    24. 

  24. CREATE TABLE `omind_app` (
    25. 

  25.   `id` int unsigned NOT NULL AUTO_INCREMENT,
    26. 

  26.   `app_type` int unsigned NOT NULL DEFAULT '0' COMMENT '0 openAPI 1 奥升小程序',
    27. 

  27.   `app_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '应用名',
    28. 

  28.   `app_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '应用key',
    29. 

  29.   `secret` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '应用密钥',
    30. 

  30.   `valid_time` bigint unsigned NOT NULL DEFAULT '253402271999' COMMENT '有效期',
    31. 

  31.   `state` tinyint NOT NULL DEFAULT '0' COMMENT '启用标记0未启用 1启用',
    32. 

  32.   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    33. 

  33.   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    34. 

  34.   `del_flag` tinyint unsigned NOT NULL DEFAULT '0',
    35. 

  35.   PRIMARY KEY (`id`)
    36. 

  36. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    37. 

  37. 

  38. -- ----------------------------
    39. 

  39. -- Records of omind_app
    40. 

  40. -- ----------------------------
    41. 

  41. BEGIN;
    42. 

  42. INSERT INTO `omind_app` VALUES (1, 1, '奥陌小程序', 'dbkUZnQjnIsUW0n7', 'k1E4e6ssJhk5ZIUkD1yn65NEX8ZwFCTF', 253402271999, 1, '2023-12-18 10:04:48', '2024-01-18 10:05:59', 0);
    43. 

  43. COMMIT;
    44. 

  44. 

  45. -- ----------------------------
    46. 

  46. -- Table structure for omind_bill
    47. 

  47. -- ----------------------------
    48. 

  48. DROP TABLE IF EXISTS `omind_bill`;
    49. 

  49. CREATE TABLE `omind_bill` (
    50. 

  50.   `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
    51. 

  51.   `station_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电站id(运营商自定义的唯一编码)',
    52. 

  52.   `base_operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '基础平台运营商id(组织机构代码)',
    53. 

  53.   `start_charge_seq` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '格式"运营商ID+唯一编号",27字符',
    54. 

  54.   `connector_id` varchar(26) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电设备接口编码(充电设备接口编码，同一运营商内唯一)',
    55. 

  55.   `start_charge_seq_stat` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '充电订单状态:1、启动中;2、充电中;3、停止中;4、已结束;5、未知;8、异常订单;20、已处理异常订单',
    56. 

  56.   `user_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '充电者用户id',
    57. 

  57.   `start_time` datetime DEFAULT NULL COMMENT '开始充电时间(格式"yyyy-MM-dd HH:mm:ss")',
    58. 

  58.   `end_time` datetime DEFAULT NULL COMMENT '结束充电时间(格式"yyyy-MM-dd HH:mm:ss")',
    59. 

  59.   `total_power` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '累计充电量(单位:度,小数点后2位)',
    60. 

  60.   `total_elec_money` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '总电费(单位:元,小数点后2位)',
    61. 

  61.   `total_service_money` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '总服务费(单位:元,小数点后2位)',
    62. 

  62.   `total_money` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '累计总金额(单位:元,小数点后2位)',
    63. 

  63.   `real_pay_money` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '实际支付总金额(单位:元,小数点后2位)',
    64. 

  64.   `stop_reason` int unsigned NOT NULL DEFAULT '0' COMMENT '充电结束原因:0、用户手动停止充电;1、客户归属地运营商平台停止充电;2、BMS停止充电;3、充电机设备故障;4、连接器断开;5-99、自定义',
    65. 

  65.   `stop_fail_reason` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '停止失败原因:0、无;1、此设备不存在;2、此设备离线;3、设备已停止充电;4~99、自定义',
    66. 

  66.   `sum_period` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '时段数N，范围：0～32',
    67. 

  67.   `charge_detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '交易信息 json',
    68. 

  68.   `car_vin` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '车辆识别码',
    69. 

  69.   `plate_no` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '车牌号',
    70. 

  70.   `succ_stat` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '成功标识:0、成功;1、失败;',
    71. 

  71.   `bill_type` tinyint unsigned DEFAULT NULL COMMENT '订单类型 0扫码充电 1刷卡充电',
    72. 

  72.   `soc` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '电池剩余电量(默认:0)',
    73. 

  73.   `pay_state` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否支付:0、未支付;1、已支付;',
    74. 

  74.   `remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
    75. 

  75.   `price_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '价格信息 json',
    76. 

  76.   `pay_plat` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电平台',
    77. 

  77.   `transaction_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '支付交易号(如微信)',
    78. 

  78.   `del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
    79. 

  79.   `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    80. 

  80.   `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    81. 

  81.   `tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
    82. 

  82.   `currentA` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT 'A相电流(单位:A,默认:0 含直流(输出))',
    83. 

  83.   `voltageA` decimal(6,2) DEFAULT '0.00' COMMENT 'A相电压(单位:V,默认:0 含直流(输出))',
    84. 

  84.   `charge_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '充电类型 1、充满;2、按金额充电',
    85. 

  85.   `charge_money` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT '用户预计充电金额',
    86. 

  86.   PRIMARY KEY (`id`) USING BTREE,
    87. 

  87.   KEY `start_charge_seq` (`start_charge_seq`),
    88. 

  88.   KEY `connector_id` (`connector_id`),
    89. 

  89.   KEY `create_time` (`create_time`),
    90. 

  90.   KEY `station_id` (`station_id`),
    91. 

  91.   KEY `start_time` (`start_time`),
    92. 

  92.   KEY `end_time` (`end_time`)
    93. 

  93. ) ENGINE=InnoDB AUTO_INCREMENT=11438 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='充电订单信息表';
    94. 

  94. 

  95. -- ----------------------------
    96. 

  96. -- Records of omind_bill
    97. 

  97. -- ----------------------------
    98. 

  98. BEGIN;
    99. 

  99. 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);
    100. 

  100. 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);
    101. 

  101. 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);
    102. 

  102. 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);
    103. 

  103. 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);
    104. 

  104. 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);
    105. 

  105. 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);
    106. 

  106. 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);
    107. 

  107. 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);
    108. 

  108. 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);
    109. 

  109. 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);
    110. 

  110. 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);
    111. 

  111. 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);
    112. 

  112. 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);
    113. 

  113. 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);
    114. 

  114. 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);
    115. 

  115. 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);
    116. 

  116. 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);
    117. 

  117. 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);
    118. 

  118. 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);
    119. 

  119. 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);
    120. 

  120. 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);
    121. 

  121. 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);
    122. 

  122. 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);
    123. 

  123. 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);
    124. 

  124. 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);
    125. 

  125. 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);
    126. 

  126. 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);
    127. 

  127. 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);
    128. 

  128. 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);
    129. 

  129. COMMIT;
    130. 

  130. 

  131. -- ----------------------------
    132. 

  132. -- Table structure for omind_connector
    133. 

  133. -- ----------------------------
    134. 

  134. DROP TABLE IF EXISTS `omind_connector`;
    135. 

  135. CREATE TABLE `omind_connector` (
    136. 

  136.   `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
    137. 

  137.   `station_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电站id(运营商自定义的唯一编码)',
    138. 

  138.   `operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '基础运营商id(组织机构代码)',
    139. 

  139.   `user_operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户平台运营商id(组织机构代码)',
    140. 

  140.   `base_operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '基础运营商id(组织机构代码)',
    141. 

  141.   `equipment_id` varchar(23) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '设备编码(设备唯一编码，对同一运营商，保证唯一)',
    142. 

  142.   `connector_id` varchar(26) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电设备接口编码(充电设备接口编码，同一运营商内唯一)',
    143. 

  143.   `connector_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电设备接口名称',
    144. 

  144.   `connector_type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '充电设备接口类型:1、家用插座(模式2);2、交流接口插座(模式3，连接方式B);3、交流接口插头(带枪线，模式3，连接方式C);4、直流接口枪头(带枪线，模式4);5、无线充电座;6、其他',
    145. 

  145.   `voltage_upper_limits` smallint unsigned NOT NULL DEFAULT '0' COMMENT '额定电压上限(单位:V)',
    146. 

  146.   `voltage_lower_limits` smallint unsigned NOT NULL DEFAULT '0' COMMENT '额定电压下限(单位:V)',
    147. 

  147.   `current_value` smallint unsigned NOT NULL COMMENT '额定电流(单位:A)',
    148. 

  148.   `power` decimal(6,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '额定功率(单位:kW)',
    149. 

  149.   `park_no` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '车位号(停车场车位编号)',
    150. 

  150.   `national_standard` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '国家标准:1、2011;2、2015',
    151. 

  151.   `status` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '充电设备接口状态:0、离网;1、空闲;2、占用(未充电);3、占用(充电中);4、占用(预约锁定);255、故障',
    152. 

  152.   `park_status` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '车位状态:0:未知;10:空闲;50:已上锁',
    153. 

  153.   `lock_status` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '地锁状态:0:未知;10:已解锁;50:已上锁',
    154. 

  154.   `del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
    155. 

  155.   `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    156. 

  156.   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    157. 

  157.   `tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
    158. 

  158.   PRIMARY KEY (`id`) USING BTREE,
    159. 

  159.   KEY `equipment_id` (`equipment_id`),
    160. 

  160.   KEY `connector_id` (`connector_id`),
    161. 

  161.   KEY `station_id` (`station_id`),
    162. 

  162.   KEY `operator_id` (`operator_id`),
    163. 

  163.   KEY `base_operator_id` (`base_operator_id`)
    164. 

  164. ) ENGINE=InnoDB AUTO_INCREMENT=4532 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='充电设备接口信息表';
    165. 

  165. 

  166. -- ----------------------------
    167. 

  167. -- Records of omind_connector
    168. 

  168. -- ----------------------------
    169. 

  169. BEGIN;
    170. 

  170. 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');
    171. 

  171. 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');
    172. 

  172. 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');
    173. 

  173. 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');
    174. 

  174. 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');
    175. 

  175. 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');
    176. 

  176. COMMIT;
    177. 

  177. 

  178. -- ----------------------------
    179. 

  179. -- Table structure for omind_equipment
    180. 

  180. -- ----------------------------
    181. 

  181. DROP TABLE IF EXISTS `omind_equipment`;
    182. 

  182. CREATE TABLE `omind_equipment` (
    183. 

  183.   `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
    184. 

  184.   `station_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电站id(运营商自定义的唯一编码)',
    185. 

  185.   `operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '运营商id(组织机构代码)',
    186. 

  186.   `user_operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户平台运营商id(组织机构代码)',
    187. 

  187.   `base_operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '基础运营商id(组织机构代码)',
    188. 

  188.   `equipment_id` varchar(23) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '设备编码(设备唯一编码，对同一运营商，保证唯一)',
    189. 

  189.   `equipment_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电设备名称',
    190. 

  190.   `manufacturer_id` varchar(9) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '设备生产商组织机构代码',
    191. 

  191.   `manufacturer_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '设备生产商名称',
    192. 

  192.   `equipment_model` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '设备型号(由设备生产商定义的设备型号)',
    193. 

  193.   `production_date` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '设备生产日期(YYYY-MM-DD)',
    194. 

  194.   `equipment_type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '设备类型:1、直流设备;2、交流设备;3、交直流一体设备;4、无线设备;5、其他',
    195. 

  195.   `equipment_lng` decimal(6,6) unsigned NOT NULL DEFAULT '0.000000' COMMENT '站点经度(GCJ-02坐标系,保留小数点后6位)',
    196. 

  196.   `equipment_lat` decimal(6,6) unsigned NOT NULL DEFAULT '0.000000' COMMENT '站点纬度(GCJ-02坐标系,保留小数点后6位)',
    197. 

  197.   `power` decimal(6,1) unsigned NOT NULL DEFAULT '0.0' COMMENT '充电设备总功率(单位:kW,保留小数点后1位)',
    198. 

  198.   `del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
    199. 

  199.   `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    200. 

  200.   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    201. 

  201.   `tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
    202. 

  202.   PRIMARY KEY (`id`) USING BTREE,
    203. 

  203.   KEY `operator_id` (`operator_id`),
    204. 

  204.   KEY `station_id` (`station_id`),
    205. 

  205.   KEY `equipment_id` (`equipment_id`),
    206. 

  206.   KEY `manufacturer_id` (`manufacturer_id`),
    207. 

  207.   KEY `base_operator_id` (`base_operator_id`)
    208. 

  208. ) ENGINE=InnoDB AUTO_INCREMENT=3572 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='充电设备信息表';
    209. 

  209. 

  210. -- ----------------------------
    211. 

  211. -- Records of omind_equipment
    212. 

  212. -- ----------------------------
    213. 

  213. BEGIN;
    214. 

  214. 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');
    215. 

  215. 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');
    216. 

  216. 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');
    217. 

  217. 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');
    218. 

  218. 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');
    219. 

  219. 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');
    220. 

  220. COMMIT;
    221. 

  221. 

  222. -- ----------------------------
    223. 

  223. -- Table structure for omind_feedback
    224. 

  224. -- ----------------------------
    225. 

  225. DROP TABLE IF EXISTS `omind_feedback`;
    226. 

  226. CREATE TABLE `omind_feedback` (
    227. 

  227.   `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    228. 

  228.   `user_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
    229. 

  229.   `connector_id` varchar(26) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '桩ID',
    230. 

  230.   `feedback_type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '反馈类型:1、充电站;2、充电桩;3、充电枪;50、其他',
    231. 

  231.   `feedback_content` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '反馈内容',
    232. 

  232.   `imgs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '图片',
    233. 

  233.   `reply_content` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '回复内容',
    234. 

  234.   `reply_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否回复:0、未回复;1、已回复',
    235. 

  235.   `remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
    236. 

  236.   `del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
    237. 

  237.   `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    238. 

  238.   `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    239. 

  239.   `tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
    240. 

  240.   PRIMARY KEY (`id`),
    241. 

  241.   KEY `user_id` (`user_id`)
    242. 

  242. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户反馈表';
    243. 

  243. 

  244. -- ----------------------------
    245. 

  245. -- Records of omind_feedback
    246. 

  246. -- ----------------------------
    247. 

  247. BEGIN;
    248. 

  248. 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');
    249. 

  249. 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');
    250. 

  250. 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');
    251. 

  251. COMMIT;
    252. 

  252. 

  253. -- ----------------------------
    254. 

  254. -- Table structure for omind_operator
    255. 

  255. -- ----------------------------
    256. 

  256. DROP TABLE IF EXISTS `omind_operator`;
    257. 

  257. CREATE TABLE `omind_operator` (
    258. 

  258.   `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
    259. 

  259.   `operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '运营商id(组织机构代码)',
    260. 

  260.   `operator_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '运营商名称',
    261. 

  261.   `operator_tel1` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '运营商客服电话1',
    262. 

  262.   `operator_tel2` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '运营商客服电话2',
    263. 

  263.   `operator_reg_address` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '运营商注册地址',
    264. 

  264.   `operator_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注信息',
    265. 

  265.   `user_operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '客户归属运营商id(组织机构代码)',
    266. 

  266.   `operator_secret` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '运营商密钥',
    267. 

  267.   `data_secret` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '消息密钥',
    268. 

  268.   `data_secret_iv` char(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '消息密钥初始化向量',
    269. 

  269.   `sig_secret` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '签名密钥',
    270. 

  270.   `base_operator_secret` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '基础运营商密钥',
    271. 

  271.   `base_data_secret` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '基础消息密钥',
    272. 

  272.   `base_data_secret_iv` char(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '基础消息密钥初始化向量',
    273. 

  273.   `base_sig_secret` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '基础签名密钥',
    274. 

  274.   `api_url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '接口地址',
    275. 

  275.   `plat_type` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '平台类型:1、OMIND',
    276. 

  276.   `del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
    277. 

  277.   `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    278. 

  278.   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    279. 

  279.   `tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '000000' COMMENT '租户编号',
    280. 

  280.   PRIMARY KEY (`id`),
    281. 

  281.   KEY `operator_id` (`operator_id`),
    282. 

  282.   KEY `user_operator_id` (`user_operator_id`)
    283. 

  283. ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='基础设施运营商信息表';
    284. 

  284. 

  285. -- ----------------------------
    286. 

  286. -- Records of omind_operator
    287. 

  287. -- ----------------------------
    288. 

  288. BEGIN;
    289. 

  289. 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');
    290. 

  290. COMMIT;
    291. 

  291. 

  292. -- ----------------------------
    293. 

  293. -- Table structure for omind_price
    294. 

  294. -- ----------------------------
    295. 

  295. DROP TABLE IF EXISTS `omind_price`;
    296. 

  296. CREATE TABLE `omind_price` (
    297. 

  297.   `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
    298. 

  298.   `station_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电站ID',
    299. 

  299.   `price_code` bigint NOT NULL DEFAULT '0' COMMENT '价格模版ID，0为默认价格',
    300. 

  300.   `start_time` datetime NOT NULL COMMENT '时段起始时间点 6位 HHmmss',
    301. 

  301.   `price_type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '价格类型:0、尖;1、峰;2、平;3、谷;',
    302. 

  302.   `elec_price` decimal(10,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '电价:XXXX.XXXX',
    303. 

  303.   `service_price` decimal(10,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '服务费单价:XXXX.XXXX',
    304. 

  304.   `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    305. 

  305.   `remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
    306. 

  306.   `del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
    307. 

  307.   `tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
    308. 

  308.   PRIMARY KEY (`id`) USING BTREE
    309. 

  309. ) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='充电价格表';
    310. 

  310. 

  311. -- ----------------------------
    312. 

  312. -- Records of omind_price
    313. 

  313. -- ----------------------------
    314. 

  314. BEGIN;
    315. 

  315. 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');
    316. 

  316. 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');
    317. 

  317. 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');
    318. 

  318. 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');
    319. 

  319. 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');
    320. 

  320. 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');
    321. 

  321. 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');
    322. 

  322. 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');
    323. 

  323. 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');
    324. 

  324. 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');
    325. 

  325. 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');
    326. 

  326. 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');
    327. 

  327. 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');
    328. 

  328. 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');
    329. 

  329. 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');
    330. 

  330. 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');
    331. 

  331. 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');
    332. 

  332. 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');
    333. 

  333. 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');
    334. 

  334. 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');
    335. 

  335. 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');
    336. 

  336. 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');
    337. 

  337. 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');
    338. 

  338. 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');
    339. 

  339. 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');
    340. 

  340. 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');
    341. 

  341. 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');
    342. 

  342. 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');
    343. 

  343. 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');
    344. 

  344. 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');
    345. 

  345. 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');
    346. 

  346. 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');
    347. 

  347. 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');
    348. 

  348. 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');
    349. 

  349. 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');
    350. 

  350. 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');
    351. 

  351. 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');
    352. 

  352. 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');
    353. 

  353. 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');
    354. 

  354. 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');
    355. 

  355. 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');
    356. 

  356. 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');
    357. 

  357. 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');
    358. 

  358. 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');
    359. 

  359. 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');
    360. 

  360. 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');
    361. 

  361. 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');
    362. 

  362. 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');
    363. 

  363. 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');
    364. 

  364. 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');
    365. 

  365. 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');
    366. 

  366. 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');
    367. 

  367. 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');
    368. 

  368. 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');
    369. 

  369. 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');
    370. 

  370. 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');
    371. 

  371. 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');
    372. 

  372. 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');
    373. 

  373. 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');
    374. 

  374. 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');
    375. 

  375. 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');
    376. 

  376. 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');
    377. 

  377. 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');
    378. 

  378. COMMIT;
    379. 

  379. 

  380. -- ----------------------------
    381. 

  381. -- Table structure for omind_station
    382. 

  382. -- ----------------------------
    383. 

  383. DROP TABLE IF EXISTS `omind_station`;
    384. 

  384. CREATE TABLE `omind_station` (
    385. 

  385.   `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
    386. 

  386.   `station_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电站id(运营商自定义的唯一编码)',
    387. 

  387.   `operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '运营商id(组织机构代码)',
    388. 

  388.   `user_operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户平台运营商id(组织机构代码)',
    389. 

  389.   `base_operator_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '基础运营商id(组织机构代码)',
    390. 

  390.   `equipment_owner_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '设备所属商id(组织机构代码)',
    391. 

  391.   `station_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电站名称',
    392. 

  392.   `country_code` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电站国家代码,比如CN',
    393. 

  393.   `area_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电站省市辖区编码',
    394. 

  394.   `address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '详细地址',
    395. 

  395.   `station_tel` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '站点电话(能够联系场站工作人员进行协助的联系电话)',
    396. 

  396.   `service_tel` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '服务电话(平台服务电话，例如400的电话)',
    397. 

  397.   `station_type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '站点类型:1、公共;50、个人;100、公交(专用);101、环卫(专用);102、物流(专用);103、出租车(专用);255、其他',
    398. 

  398.   `station_status` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '站点状态:0、未知;1、建设中;5、关闭下线;6、维护中;50、正常使用',
    399. 

  399.   `park_nums` int unsigned NOT NULL DEFAULT '0' COMMENT '车位数量(可停放进行充电的车位总数，默认：0 未知)',
    400. 

  400.   `station_lng` decimal(10,6) unsigned NOT NULL DEFAULT '0.000000' COMMENT '站点经度(GCJ-02坐标系,保留小数点后6位)',
    401. 

  401.   `station_lat` decimal(10,6) unsigned NOT NULL DEFAULT '0.000000' COMMENT '站点纬度(GCJ-02坐标系,保留小数点后6位)',
    402. 

  402.   `site_guide` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '站点引导:描述性文字，用于引导车主找到充电车位',
    403. 

  403.   `construction` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '建设场所类型:1、居民区;2、公共机构;3、企事业单位;4、写字楼;5、工业园区;6、交通枢纽;7、大型文体设施;8、城市绿地;9、大型建筑配建停车场;10、路边停车位;11、城际高速服务区;255、其他',
    404. 

  404.   `pictures` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '站点照片(充电设备照片、充电车位照片、停车场入口照片)JSON串',
    405. 

  405.   `match_cars` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '使用车型描述(描述该站点接受的车大小以及类型，如大巴、物流车、私家乘用车、出租车等)',
    406. 

  406.   `park_info` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '车位楼层及数量描述(车位楼层以及数量信息)',
    407. 

  407.   `busine_hours` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '营业时间描述',
    408. 

  408.   `electricity_fee` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电电费描述',
    409. 

  409.   `service_fee` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '服务费描述',
    410. 

  410.   `park_fee` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '停车费描述',
    411. 

  411.   `payment` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '支付方式::刷卡、线上、现金。其中电子钱包类卡为刷卡，身份鉴权卡、微信/支付宝、APP为线上',
    412. 

  412.   `support_order` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否支持预约(充电设备是否需要提前预约后才能使用。0为不支持预约;1为支持预约。不填默认为0)',
    413. 

  413.   `plat_type` tinyint unsigned NOT NULL COMMENT '平台类型',
    414. 

  414.   `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注信息',
    415. 

  415.   `del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
    416. 

  416.   `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    417. 

  417.   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    418. 

  418.   `tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
    419. 

  419.   PRIMARY KEY (`id`),
    420. 

  420.   KEY `station_id` (`station_id`),
    421. 

  421.   KEY `operator_id` (`operator_id`),
    422. 

  422.   KEY `equipment_owner_id` (`equipment_owner_id`),
    423. 

  423.   KEY `area_code` (`area_code`)
    424. 

  424. ) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='充电站信息表';
    425. 

  425. 

  426. -- ----------------------------
    427. 

  427. -- Records of omind_station
    428. 

  428. -- ----------------------------
    429. 

  429. BEGIN;
    430. 

  430. 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');
    431. 

  431. 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');
    432. 

  432. 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');
    433. 

  433. COMMIT;
    434. 

  434. 

  435. -- ----------------------------
    436. 

  436. -- Table structure for omind_station_images
    437. 

  437. -- ----------------------------
    438. 

  438. DROP TABLE IF EXISTS `omind_station_images`;
    439. 

  439. CREATE TABLE `omind_station_images` (
    440. 

  440.   `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
    441. 

  441.   `station_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充电站id(运营商自定义的唯一编码)',
    442. 

  442.   `image_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '图片类型:1、充电站照片;2、充电桩照片;3、充电车位照片;4、停车场入口照片',
    443. 

  443.   `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '站点图片',
    444. 

  444.   `image_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图片名称',
    445. 

  445.   `show_seq` int unsigned DEFAULT '0' COMMENT '显示顺序',
    446. 

  446.   `del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
    447. 

  447.   `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    448. 

  448.   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    449. 

  449.   `tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
    450. 

  450.   PRIMARY KEY (`id`) USING BTREE
    451. 

  451. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='充电站图片表';
    452. 

  452. 

  453. -- ----------------------------
    454. 

  454. -- Table structure for omind_user
    455. 

  455. -- ----------------------------
    456. 

  456. DROP TABLE IF EXISTS `omind_user`;
    457. 

  457. CREATE TABLE `omind_user` (
    458. 

  458.   `uid` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
    459. 

  459.   `phone_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '国家区号码',
    460. 

  460.   `mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户手机号',
    461. 

  461.   `nick_name` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户昵称',
    462. 

  462.   `wechat_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '微信昵称',
    463. 

  463.   `unionid_wx` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '当且仅当该移动应用已获得该用户的 userinfo 授权时，才会出现该字段',
    464. 

  464.   `openid_wx` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '小程序openID',
    465. 

  465.   `unionid_ali` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'ali统一id',
    466. 

  466.   `openid_ali` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '支付宝用户唯一标识',
    467. 

  467.   `credit_pay_wx` int NOT NULL DEFAULT '0' COMMENT '微信信用分授权-后支付',
    468. 

  468.   `credit_pay_ali` int NOT NULL DEFAULT '0' COMMENT '阿里信用分授权-后支付',
    469. 

  469.   `sex` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0、未知;1、男;2、女',
    470. 

  470.   `country` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '国家',
    471. 

  471.   `province` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '省',
    472. 

  472.   `city` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '城市',
    473. 

  473.   `birthday` bigint NOT NULL DEFAULT '0' COMMENT '生日',
    474. 

  474.   `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '头像地址',
    475. 

  475.   `platform` int unsigned NOT NULL DEFAULT '0' COMMENT '注册来源的平台:关联平台id(0未知)',
    476. 

  476.   `disable_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否禁用用户:0、启用;1、禁用',
    477. 

  477.   `register_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间',
    478. 

  478.   `last_visit_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '最近一次访问时间',
    479. 

  479.   `last_visit_ip` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '最近一次访问ip',
    480. 

  480.   `last_visit_area` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '最近一次访问ip对应区域',
    481. 

  481.   `org_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '用户是否从属组织机构:0、不从属;1、从属',
    482. 

  482.   `remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
    483. 

  483.   `del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
    484. 

  484.   `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    485. 

  485.   `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    486. 

  486.   `tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
    487. 

  487.   PRIMARY KEY (`uid`),
    488. 

  488.   KEY `mobile` (`mobile`)
    489. 

  489. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户表';
    490. 

  490. 

  491. -- ----------------------------
    492. 

  492. -- Records of omind_user
    493. 

  493. -- ----------------------------
    494. 

  494. BEGIN;
    495. 

  495. 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');
    496. 

  496. 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');
    497. 

  497. 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');
    498. 

  498. 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');
    499. 

  499. COMMIT;
    500. 

  500. 

  501. -- ----------------------------
    502. 

  502. -- Table structure for omind_user_car
    503. 

  503. -- ----------------------------
    504. 

  504. DROP TABLE IF EXISTS `omind_user_car`;
    505. 

  505. CREATE TABLE `omind_user_car` (
    506. 

  506.   `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '车辆ID',
    507. 

  507.   `user_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
    508. 

  508.   `plate_no` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '车牌号',
    509. 

  509.   `car_vin` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '车辆vin码',
    510. 

  510.   `engine_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '发动机号码',
    511. 

  511.   `vehicle_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '车辆类型',
    512. 

  512.   `car_model` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '品牌型号',
    513. 

  513.   `owner` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '车辆所有人',
    514. 

  514.   `address` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '住址',
    515. 

  515.   `use_character` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '使用性质:运营、非运营',
    516. 

  516.   `register_date` date DEFAULT NULL COMMENT '注册日期(格式"yyyy-MM-dd")',
    517. 

  517.   `issue_date` date DEFAULT NULL COMMENT '发证日期(格式"yyyy-MM-dd")',
    518. 

  518.   `license_imgs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '行驶证图片json串',
    519. 

  519.   `check_state` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '审核状态:0、待审核;1、审核通过;2、审核不通过;3、不需审核',
    520. 

  520.   `auth_state` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '认证状态:0、不认证;1、待认证;2、认证通过;3、认证不通过',
    521. 

  521.   `remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
    522. 

  522.   `del_flag` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '数据状态:0、正常;1、删除',
    523. 

  523.   `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    524. 

  524.   `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    525. 

  525.   `tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
    526. 

  526.   PRIMARY KEY (`id`),
    527. 

  527.   KEY `user_id` (`user_id`),
    528. 

  528.   KEY `plate_no` (`plate_no`),
    529. 

  529.   KEY `car_vin` (`car_vin`)
    530. 

  530. ) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户的车辆';
    531. 

  531. 

  532. -- ----------------------------
    533. 

  533. -- Records of omind_user_car
    534. 

  534. -- ----------------------------
    535. 

  535. BEGIN;
    536. 

  536. 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');
    537. 

  537. 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');
    538. 

  538. COMMIT;
    539. 

  539. 

  540. SET FOREIGN_KEY_CHECKS = 1;
    541.