홈 탐색 도움말
가입하기 로그인
yeguanglin
/
forecast
1
0
포크 0
파일 이슈 0 풀 리퀘스트 0 위키
트리: d00fed99d9
브랜치 태그
forecast
/
doc
/
数据库脚本
/
gateway-data.sql

gateway-data.sql 8.9 KB
히스토리 Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111 
  1. ---- 通信的协议
    2. 

  2. INSERT INTO public.config_transmit VALUES (1, 'TCP异步客户端', 'cn.oleauto.transmit.tcp.TcpClient', 'host=设备ip\r\nport=设备端口');
    3. 

  3. INSERT INTO public.config_transmit VALUES (2, 'ModbusTcp客户端', 'cn.oleauto.modbus.tcp.MyTcpMaster', 'host=设备ip\r\nport=设备端口');
    4. 

  4. INSERT INTO public.config_transmit VALUES (3, 'Modbus RTU客户端', 'cn.oleauto.modbus.rtu.MyRtuMaster', 'port=COM11
    5. 

  5. baud=9600
    6. 

  6. dataBis=8
    7. 

  7. stopBit=1');
    8. 

  8. 

  9. ---- 设备的协议
    10. 

  10. INSERT INTO public.config_protocol VALUES (1, 'IEC60870-104', 'cn.oleauto.iec104.IEC104ProtocolImpl', 'cotFieldLength=cot信息字节数\r\ncommonAddressFieldLength=公共地址字节数\r\nioaFieldLength=测点编号字节数\r\ncommonAddress=公共地址\r\norginAddress=源地址');
    11. 

  11. INSERT INTO public.config_protocol VALUES (2, 'ModbusTCP', 'cn.oleauto.modbus.tcp.ModbusTcpProtocolImpl', ' ');
    12. 

  12. INSERT INTO public.config_protocol VALUES (3, 'Modbus RTU', 'cn.oleauto.modbus.rtu.ModbusRtuProtocolImpl', ' ');
    13. 

  13. 

  14. ---- 通信信道
    15. 

  15. INSERT INTO public.config_channel VALUES (0, '000', 'mute 通道', '1', 1, '', 1, '', '', '2026-07-03 14:13:27', '2026-07-03 14:13:27', '', '');
    16. 

  16. INSERT INTO public.config_channel VALUES (1, '001', '电气设备通道', '1', 1, 'host=192.168.1.137\nport=2405', 1, ' ', '', '2026-07-03 15:43:11', '2026-07-03 15:38:53', 'admin', 'admin');
    17. 

  17. INSERT INTO public.config_channel VALUES (3, '003', '气象设备通道', '0', 3, 'port=COM11
    18. 

  18. baud=9600', 3, ' ', '', '2026-07-03 15:43:11', '2026-07-03 15:38:53', 'admin', 'admin');
    19. 

  19. 

  20. ---- 场站数据
    21. 

  21. INSERT INTO public.config_station VALUES (2, '渤海一号风电场', 'BHWP01', 'EAST01', 0, '121.4737', '38.9087', '370000', '370200', '山东省青岛市', 150000, 148000, 75, 12.500000, '2021-06-01', '110kV', '121.4737', '38.9087', '张工', '13800000001', true, 1, 2, true, false, 'admin', '2026-07-01 13:23:25.447023', 'admin', '2026-07-01 13:23:25.447023', 0, NULL, 'EAST01');
    22. 

  22. INSERT INTO public.config_station VALUES (3, '黄海二号风电场', 'HHWP02', 'EAST01', 0, '122.1108', '37.5128', '370000', '371000', '山东省威海市', 120000, 118500, 60, 18.000000, '2022-03-15', '110kV', '122.1108', '37.5128', '李工', '13800000002', true, 1, 1, true, false, 'admin', '2026-07-01 13:23:25.447023', 'admin', '2026-07-01 13:23:25.447023', 0, NULL, 'EAST01');
    23. 

  23. INSERT INTO public.config_station VALUES (4, '沂蒙光伏电站', 'YMPV03', 'EAST01', 0, '118.3262', '35.0654', '370000', '371300', '山东省临沂市', 80000, 79200, 160000, 250.000000, '2020-09-20', '35kV', '118.3262', '35.0654', '王工', '13800000003', true, 1, 1, true, false, 'admin', '2026-07-01 13:23:25.447023', 'admin', '2026-07-01 13:23:25.447023', 1, NULL, 'EAST01');
    24. 

  24. INSERT INTO public.config_station VALUES (5, '戈壁光伏电站', 'GBPV04', 'EAST01', 0, '93.5145', '42.8194', '650000', '650500', '新疆哈密', 200000, 196000, 400000, 1100.000000, '2019-12-01', '220kV', '93.5145', '42.8194', '陈工', '13800000004', true, 1, 1, true, false, 'admin', '2026-07-01 13:23:25.447023', 'admin', '2026-07-01 13:23:25.447023', 1, NULL, 'EAST01');
    25. 

  25. INSERT INTO public.config_station VALUES (1, '江门', 'JMJD01', 'EAST01', 0, '124', '37', '370000', '370000', '广东省', 120000, 120000, 75, 12.500000, '2026-7-6', '110KV', '121.2223', '38.9087', '张工', '13800000000', true, 1, 1, true, false, 'admin', '2026-07-01 13:23:25.447', 'admin', '2026-07-01 13:23:25.447', 0, '', 'EAST01');
    26. 

  26. 

  27. ---- 设备数据
    28. 

  28. INSERT INTO public.config_device (id, name, config_channel_id, config_station_id, tp, brand, model, serial_number, status, install_date, config_device_id, remark, create_time, update_time, create_by, update_by) VALUES (1, '电气设备', 1, '1', 'ELEC', 'brand1', 'model1', 'serial1', 'GOOD', '2026-09-01', NULL, '', '2026-09-01 14:41:10.415056', '2026-09-01 14:41:10.415056', '', '');
    29. 

  29. INSERT INTO public.config_device (id, name, config_channel_id, config_station_id, tp, brand, model, serial_number, status, install_date, config_device_id, remark, create_time, update_time, create_by, update_by) VALUES (2, '气象设备', 3, '1', 'WEAT', 'brand1', 'model1', 'serial1', 'GOOD', '2026-09-01', NULL, '', '2026-09-01 14:41:10.415056', '2026-09-01 14:41:10.415056', '', '');
    30. 

  30. 

  31. ---- 测点数据
    32. 

  32. INSERT INTO public.config_point VALUES (34, '湿度', 'yc30005', 30005, 'YC', 2, '0', 'N', '0', 1, 0, 0, 'N', 0, 0, 0, 0, 0, 0, NULL, '2026-07-03 11:05:09', '2026-07-03 11:05:09', '', '');
    33. 

  33. INSERT INTO public.config_point VALUES (35, '风速', 'yc30006', 30006, 'YC', 2, '0', 'N', '0', 1, 0, 0, 'N', 0, 0, 0, 0, 0, 0, NULL, '2026-07-03 11:05:09', '2026-07-03 11:05:09', '', '');
    34. 

  34. INSERT INTO public.config_point VALUES (36, '风向', 'yc30007', 30007, 'YC', 2, '0', 'N', '0', 1, 0, 0, 'N', 0, 0, 0, 0, 0, 0, NULL, '2026-07-03 11:05:09', '2026-07-03 11:05:09', '', '');
    35. 

  35. INSERT INTO public.config_point VALUES (31, '斜面辐照度', 'yc30002', 30002, 'YC', 2, '0', 'N', '0', 1, 0, 0, 'N', 0, 0, 0, 0, 0, 0, NULL, '2026-07-03 11:05:09', '2026-07-03 11:05:09', '', '');
    36. 

  36. INSERT INTO public.config_point VALUES (32, '温度', 'yc30003', 30003, 'YC', 2, '0', 'N', '0', 1, 0, 0, 'N', 0, 0, 0, 0, 0, 0, NULL, '2026-07-03 11:05:09', '2026-07-03 11:05:09', '', '');
    37. 

  37. INSERT INTO public.config_point VALUES (33, '气压', 'yc30004', 30004, 'YC', 2, '0', 'N', '0', 1, 0, 0, 'N', 0, 0, 0, 0, 0, 0, NULL, '2026-07-03 11:05:09', '2026-07-03 11:05:09', '', '');
    38. 

  38. INSERT INTO public.config_point VALUES (37, '日累计辐照度', 'yc30008', 30008, 'YC', 2, '0', 'N', '0', 1, 0, 0, 'N', 0, 0, 0, 0, 0, 0, NULL, '2026-07-03 11:05:09', '2026-07-03 11:05:09', '', '');
    39. 

  39. INSERT INTO public.config_point VALUES (38, '组件温度', 'yc30009', 30009, 'YC', 2, '0', 'N', '0', 1, 0, 0, 'N', 0, 0, 0, 0, 0, 0, NULL, '2026-07-03 11:05:09', '2026-07-03 11:05:09', '', '');
    40. 

  40. INSERT INTO public.config_point VALUES (11, '并网状态', 'yx4', 4, 'YX', 1, '0', 'N', '0', 1, 0, 0, 'N', 0, 0, 0, 0, 0, 0, NULL, '2026-07-03 11:05:09', '2026-07-03 11:05:09', '', '');
    41. 

  41. INSERT INTO public.config_point VALUES (24, '限电功率', 'yc16389', 16389, 'YC', 1, '0', 'N', '0', 1, 0, 0, 'N', 0, 0, 0, 0, 0, 0, NULL, '2026-07-03 11:05:09', '2026-07-03 11:05:09', '', '');
    42. 

  42. INSERT INTO public.config_point VALUES (25, '可用率', 'yc16390', 16390, 'YC', 1, '0', 'N', '0', 1, 0, 0, 'N', 0, 0, 0, 0, 0, 0, NULL, '2026-07-03 11:05:09', '2026-07-03 11:05:09', '', '');
    43. 

  43. INSERT INTO public.config_point VALUES (22, '实际发电功率', 'yc16385', 16385, 'YC', 1, '0', 'N', '0', 1, 0, 0, 'N', 0, 0, 0, 0, 0, 0, NULL, '2026-07-03 11:05:09', '2026-07-03 11:05:09', '', '');
    44. 

  44. INSERT INTO public.config_point VALUES (23, '理论发电功率', 'yc16405', 16405, 'YC', 1, '0', 'N', '0', 1, 0, 0, 'N', 0, 0, 0, 0, 0, 0, NULL, '2026-07-03 11:05:09', '2026-07-03 11:05:09', '', '');
    45. 

  45. INSERT INTO public.config_point VALUES (4, '设备状态', 'yx2', 2, 'YX', 1, '0', 'N', '0', 1, 0, 0, 'N', 0, 0, 0, 0, 0, 0, NULL, '2026-07-03 11:05:09', '2026-07-03 11:05:09', '', '');
    46. 

  46. INSERT INTO public.config_point VALUES (30, '水平面总辐照度', 'yc30001', 30001, 'YC', 2, '0', 'N', '0', 1, 0, 0, 'N', 0, 0, 0, 0, 0, 0, NULL, '2026-07-03 11:05:09', '2026-07-03 11:05:09', '', '');                                                                                                                                                                                                                                               ('开关分合1','001',1,'YX',1,'0','N','0',1.0,0.0,0.0,'N',0.0,0.0,0.0,0.0,0,0,NULL,'2025-09-11 11:26:55','2025-09-11 15:40:11','','');
    47. 

  47. 

  48. ---- 本地气象测点关联配置
    49. 

  49. INSERT INTO public.config_weather_local (id, config_station_id, irradiance, inclined_irradiance, temperature, pressure, humidity, wind_speed, wind_direction, create_time, update_time, create_by, update_by, daily_irradiance, board_temperature) VALUES (1, 1, '{
    50. 

  50. "deviceId":2,
    51. 

  51. "pointType":"YC",
    52. 

  52. "pointCode":"yc30001"
    53. 

  53. }', '{
    54. 

  54. "deviceId":2,
    55. 

  55. "pointType":"YC",
    56. 

  56. "pointCode":"yc30002"
    57. 

  57. }', '{
    58. 

  58. "deviceId":2,
    59. 

  59. "pointType":"YC",
    60. 

  60. "pointCode":"yc30003"
    61. 

  61. }', '{
    62. 

  62. "deviceId":2,
    63. 

  63. "pointType":"YC",
    64. 

  64. "pointCode":"yc30004"
    65. 

  65. }', '{
    66. 

  66. "deviceId":2,
    67. 

  67. "pointType":"YC",
    68. 

  68. "pointCode":"yc30005"
    69. 

  69. }', '{
    70. 

  70. "deviceId":2,
    71. 

  71. "pointType":"YC",
    72. 

  72. "pointCode":"yc30006"
    73. 

  73. }', '{
    74. 

  74. "deviceId":2,
    75. 

  75. "pointType":"YC",
    76. 

  76. "pointCode":"yc30007"
    77. 

  77. }', '2026-07-24 09:04:12.995791', '2026-07-24 09:04:12.995791', 'admin', 'admin', '{
    78. 

  78. "deviceId":2,
    79. 

  79. "pointType":"YC",
    80. 

  80. "pointCode":"yc30008"
    81. 

  81. }', '{
    82. 

  82. "deviceId":2,
    83. 

  83. "pointType":"YC",
    84. 

  84. "pointCode":"yc30009"
    85. 

  85. }');
    86. 

  86. ---- 本地电气测点关联配置
    87. 

  87. INSERT INTO public.config_electricity_local (id, config_station_id, actual_power, theoretical_power, curtailment_power, device_status, grid_status, availability, create_time, update_time, create_by, update_by) VALUES (1, 1, '{
    88. 

  88. "deviceId":1,
    89. 

  89. "pointType":"YC",
    90. 

  90. "pointCode":"yc16385"
    91. 

  91. }', '{
    92. 

  92. "device_id":1,
    93. 

  93. "pointType":"YC",
    94. 

  94. "point_code":"yc16405"
    95. 

  95. }', '{
    96. 

  96. "device_id":1,
    97. 

  97. "pointType":"YC",
    98. 

  98. "point_code":"yc16389"
    99. 

  99. }', '{
    100. 

  100. "device_id":1,
    101. 

  101. "pointType":"YX",
    102. 

  102. "point_code":"yx2"
    103. 

  103. }', '{
    104. 

  104. "device_id":1,
    105. 

  105. "pointType":"YX",
    106. 

  106. "point_code":"yx4"
    107. 

  107. }', '{
    108. 

  108. "device_id":1,
    109. 

  109. "pointType":"YC",
    110. 

  110. "point_code":"yc16390"
    111. 

  111. }', '2026-07-06 17:45:03.847393', '2026-07-06 17:45:03.847393', '', '');
    112.