pg_input_oa_board_standard.sql 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204
  1. --
  2. -- PostgreSQL database dump
  3. --
  4. -- Dumped from database version 12.10
  5. -- Dumped by pg_dump version 12.10
  6. SET statement_timeout = 0;
  7. SET lock_timeout = 0;
  8. SET idle_in_transaction_session_timeout = 0;
  9. SET client_encoding = 'UTF8';
  10. SET standard_conforming_strings = on;
  11. SELECT pg_catalog.set_config('search_path', '', false);
  12. SET check_function_bodies = false;
  13. SET xmloption = content;
  14. SET client_min_messages = warning;
  15. SET row_security = off;
  16. SET default_tablespace = '';
  17. SET default_table_access_method = heap;
  18. --
  19. -- Name: pg_input_oa_board_standard; Type: TABLE; Schema: dim_pm; Owner: pmparse
  20. --
  21. CREATE TABLE dim_pm.pg_input_oa_board_standard (
  22. board_model character varying,
  23. standard_gain_min numeric(28,2),
  24. standard_gain_max numeric(28,2),
  25. standard_single_40_wave_output numeric(28,2),
  26. standard_single_80_wave_output numeric(28,2),
  27. standard_single_96_wave_output numeric(28,2),
  28. "timestamp" timestamp without time zone,
  29. is_history integer
  30. );
  31. ALTER TABLE dim_pm.pg_input_oa_board_standard OWNER TO pmparse;
  32. --
  33. -- Data for Name: pg_input_oa_board_standard; Type: TABLE DATA; Schema: dim_pm; Owner: pmparse
  34. --
  35. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC6OAU01A', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  36. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC6OAU01B', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  37. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC6OAU02A', 20.00, 31.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  38. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC6OAU02B', 20.00, 31.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  39. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC6OAU03A', 26.00, 32.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  40. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC6OAU03B', 26.00, 32.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  41. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC6OAU05A', 23.00, 34.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  42. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC6OBU01', 22.00, 24.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  43. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC6OBU03', 22.00, 24.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  44. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC6OBU05', 23.00, 23.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  45. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC6OPU01', 18.00, 22.00, -2.00, -5.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  46. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC6OPU02', 19.00, 21.00, -2.00, -5.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  47. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC6OPU03', 21.00, 25.00, 0.00, -3.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  48. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC8OBU01', 22.00, 24.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  49. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC8OBU03', 22.00, 24.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  50. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC8OBU05', 23.00, 23.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  51. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC8OPU02', 19.00, 21.00, 0.00, -3.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  52. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC8OPU04', 16.00, 18.00, 0.00, -3.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  53. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC9OAU01', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  54. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC9OAU02', 20.00, 31.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  55. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC9OAU03', 26.00, 32.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  56. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC9OAU05A', 23.00, 34.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  57. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC9OBU01', 22.00, 24.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  58. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC9OBU03', 22.00, 24.00, 1.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  59. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC9OBU05', 23.00, 23.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  60. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSC9OPU03', 21.00, 25.00, 0.00, -3.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  61. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSE2OAU03', 24.00, 36.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  62. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSE3OAUC01C', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  63. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSE3OAUC03C', 24.00, 36.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  64. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSE3OAUC03E', 24.00, 36.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  65. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSE3OAUC05A', 23.00, 34.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  66. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSE3OBUC03C', 23.00, 23.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  67. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSE3OBUC03E', 23.00, 23.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  68. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSE3OBUC05A', 23.00, 23.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  69. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSE3OPUC03C', 21.00, 25.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  70. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSE4OAUC03A', 24.00, 36.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  71. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSE4OPUC03A', 21.00, 25.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  72. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSE5OAUC01C', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  73. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSE5OAUC03E', 24.00, 36.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  74. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSE5OAUC05A', 23.00, 34.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  75. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSE5OBUC03E', 23.00, 23.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  76. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSE5OBUC05A', 23.00, 23.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  77. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SSE5OPUC03C', 21.00, 25.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  78. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN11OAU101', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  79. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN11OAU102', 20.00, 31.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  80. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN11OAU103', 24.00, 36.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  81. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN11OAU105', 23.00, 34.00, 7.00, -4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  82. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN11OBU101', 20.00, 20.00, 0.00, -3.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  83. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN11OBU103', 23.00, 23.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  84. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN11OBU104', 17.00, 17.00, 0.00, -3.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  85. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN11OBU105', 23.00, 23.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  86. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN11OBU205', 23.00, 23.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  87. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN12HBA', 29.00, 29.00, 10.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  88. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN12OAU100', 16.00, 25.50, 2.00, -1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  89. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN12OAU101', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  90. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN12OAU102', 20.00, 31.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  91. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN12OAU103', 24.00, 36.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  92. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN12OAU105', 23.00, 34.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  93. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN12OBU101', 20.00, 20.00, 0.00, -3.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  94. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN12OBU103', 23.00, 23.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  95. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN12OBU104', 17.00, 17.00, 0.00, -3.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  96. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN12OBU105', 23.00, 23.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  97. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN12OBU205', 23.00, 23.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  98. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN13OAU101', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  99. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN13OAU103', 24.00, 36.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  100. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN13OAU105', 23.00, 34.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  101. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN13OAU106', 16.00, 23.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  102. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN13OAU107', 19.00, 27.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  103. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN13OBU101', 20.00, 20.00, 0.00, -3.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  104. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN13OBU103', 23.00, 23.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  105. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN13OBU104', 17.00, 17.00, 0.00, -3.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  106. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN13OBU105', 23.00, 23.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  107. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN13OBU205', 23.00, 23.00, 7.00, 4.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  108. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN12TD20', 23.00, 23.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  109. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN15OAU101P', 20.00, 20.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  110. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TNF2OBU01', 19.00, 40.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  111. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN15OAU106P', 16.00, 23.00, 2.00, -1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  112. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN11D4001', 19.00, 40.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  113. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN15OAU101', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  114. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TNF1EX4001', 19.00, 40.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  115. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TNF3SCC03-001', 19.00, 40.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  116. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN11MCA401', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  117. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN12DCP01', 18.50, 21.50, 0.00, -3.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  118. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN15OAU101', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  119. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN15OAU101', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  120. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN15OAU101', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  121. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN15OAU101', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  122. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN15OAU101', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  123. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TNF6TTA01-033', 19.00, 40.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  124. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TNF1OLP', 19.00, 40.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  125. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN15OAU101', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  126. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TNF1DSFIU01', 19.00, 40.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  127. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TNF6TTA01-114', 19.00, 40.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  128. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN15OAU101', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  129. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN15OAU101', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  130. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TNF1AST401-003', 19.00, 40.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  131. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN13M40V01', 19.00, 40.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  132. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN13STG', 19.00, 40.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  133. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN11AST2-001', 19.00, 40.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  134. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('TN15OAU101', 20.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  135. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EOBA1717', 17.00, 17.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  136. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EOBA2220', 22.00, 22.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  137. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EOBAH2424', 24.00, 24.00, 8.00, 5.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  138. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EOBAH2726', 27.00, 27.00, 10.00, 7.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  139. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EOBAS1717', 17.00, 17.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  140. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EOBAS2220', 22.00, 22.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  141. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EONA1820', 18.00, 18.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  142. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EONA2520', 25.00, 25.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  143. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EONA3120', 31.00, 31.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  144. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EONAD2520', 25.00, 25.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  145. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EONAD3320', 33.00, 33.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  146. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EONAH2723', 27.00, 27.00, 7.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  147. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EONAH2724', 27.00, 27.00, 8.00, 5.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  148. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EONAS1820', 18.00, 18.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  149. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EONAS2520', 25.00, 25.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  150. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EOPA1717', 17.00, 17.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  151. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EOPA2217', 22.00, 22.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  152. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EOPAS1717', 17.00, 17.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  153. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('EOPAS2217', 22.00, 22.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  154. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SEOBA1717', 17.00, 17.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  155. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SEOBA2217', 22.00, 22.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  156. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SEOBA2220', 22.00, 22.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  157. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SEOPA1717', 17.00, 17.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  158. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SEOPA1720', 17.00, 17.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  159. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SEOPA2217', 22.00, 22.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  160. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SEOPA2220', 22.00, 22.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  161. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SEOPA2717', 27.00, 27.00, 1.00, -2.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  162. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SEOPA2720', 27.00, 27.00, 1.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  163. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('SEOPA3420', 34.00, 34.00, 4.00, 1.00, NULL, '2022-07-11 20:00:01.765105', NULL);
  164. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('481821.0', 18.00, 18.00, 5.00, 2.00, 1.20, '2022-07-11 20:00:01.765105', NULL);
  165. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('482321.0', 23.00, 23.00, 5.00, 2.00, 1.20, '2022-07-11 20:00:01.765105', NULL);
  166. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('481824.0', 18.00, 18.00, 8.00, 5.00, 4.20, '2022-07-11 20:00:01.765105', NULL);
  167. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('482021.0', 20.00, 20.00, 5.00, 2.00, 1.20, '2022-07-11 20:00:01.765105', NULL);
  168. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('482324.0', 23.00, 23.00, 8.00, 5.00, 4.20, '2022-07-11 20:00:01.765105', NULL);
  169. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('482521.0', 25.00, 25.00, 5.00, 2.00, 1.20, '2022-07-11 20:00:01.765105', NULL);
  170. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('1820', 18.00, 18.00, 4.00, 1.00, 0.20, '2022-07-11 20:00:01.765105', NULL);
  171. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('2223.0', 22.00, 22.00, 7.00, 4.00, 3.20, '2022-07-11 20:00:01.765105', NULL);
  172. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('2320', 23.00, 23.00, 4.00, 1.00, 0.20, '2022-07-11 20:00:01.765105', NULL);
  173. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('1820', 18.00, 18.00, 4.00, 1.00, 0.20, '2022-07-11 20:00:01.765105', NULL);
  174. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('1820.0', 18.00, 18.00, 4.00, 1.00, 0.20, '2022-07-11 20:00:01.765105', NULL);
  175. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('1413.0', 14.00, 14.00, -3.00, -6.00, -6.80, '2022-07-11 20:00:01.765105', NULL);
  176. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('481414.0', 14.00, 14.00, -2.00, -5.00, -5.80, '2022-07-11 20:00:01.765105', NULL);
  177. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('482014.0', 20.00, 20.00, -2.00, -5.00, -5.80, '2022-07-11 20:00:01.765105', NULL);
  178. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('481014.0', 10.00, 10.00, -2.00, -5.00, -5.80, '2022-07-11 20:00:01.765105', NULL);
  179. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('481714.0', 17.00, 17.00, -2.00, -5.00, -5.80, '2022-07-11 20:00:01.765105', NULL);
  180. INSERT INTO dim_pm.pg_input_oa_board_standard VALUES ('2320.0', 23.00, 23.00, 4.00, 1.00, 0.20, '2022-07-11 20:00:01.765105', NULL);
  181. --
  182. -- Name: TABLE pg_input_oa_board_standard; Type: ACL; Schema: dim_pm; Owner: pmparse
  183. --
  184. GRANT SELECT ON TABLE dim_pm.pg_input_oa_board_standard TO richuser;
  185. GRANT ALL ON TABLE dim_pm.pg_input_oa_board_standard TO nokia;
  186. --
  187. -- PostgreSQL database dump complete
  188. --