CS_DATA_CODE/pg_input_voa_back_data.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 12.10
-- Dumped by pg_dump version 12.10

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: pg_input_voa_back_data; Type: TABLE; Schema: dim_pm; Owner: pmparse
--

CREATE TABLE dim_pm.pg_input_voa_back_data (
    id character varying,
    ne_id character varying,
    vo character varying,
    shelf_id character varying,
    slot_id character varying,
    "timestamp" timestamp without time zone,
    is_history integer
);


ALTER TABLE dim_pm.pg_input_voa_back_data OWNER TO pmparse;

--
-- Data for Name: pg_input_voa_back_data; Type: TABLE DATA; Schema: dim_pm; Owner: pmparse
--

INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000006080', '1', '0', '2', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000002191', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000008897', '1', '0', '7', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000013370', '1', '3', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000008897', '1', '2', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000013370', '1', '5', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000090249', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000004406', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000067916', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000004405', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000002191', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000006080', '1', '0', '2', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000004406', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000065523', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000069040', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000067916', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000004405', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000067916', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000004125', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000090248', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000004125', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000068903', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000067835', '1', '0', '2', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000004125', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000013397', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000013370', '1', '3', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000008897', '1', '0', '7', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000013370', '1', '5', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000008897', '1', '2', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000067835', '1', '0', '2', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000056976', '1', '5', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000056976', '1', '5', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000019392', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000067916', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000069040', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000069919', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000019392', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000019392', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000013397', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000065523', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000068903', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000068903', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000011760', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000011760', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000065523', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000004406', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000004125', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000090248', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000068903', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000065523', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000004406', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000090249', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000019392', '1', '0', '1', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000069919', '1', '0', '17', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000001405', '1', '0', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000001477', '1', '1', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000001477', '1', '1', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000001405', '1', '0', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000001359', '1', '0', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000001405', '1', '1', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000001405', '1', '1', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000001359', '1', '0', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000000811', '1', '0', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000001359', '1', '1', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000000819', '1', '1', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000000974', '1', '0', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000000920', '1', '0', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000000974', '1', '1', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000000974', '1', '1', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000000920', '1', '0', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000000819', '1', '0', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000000920', '1', '1', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000000811', '1', '1', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000001477', '1', '0', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000000920', '1', '1', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000000819', '1', '0', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000000974', '1', '0', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000000819', '1', '1', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000001359', '1', '1', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000000811', '1', '0', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000001477', '1', '0', '3', '2022-07-14 20:00:01.891644', NULL);
INSERT INTO dim_pm.pg_input_voa_back_data VALUES (NULL, '15200000000811', '1', '1', '3', '2022-07-14 20:00:01.891644', NULL);


--
-- Name: TABLE pg_input_voa_back_data; Type: ACL; Schema: dim_pm; Owner: pmparse
--

GRANT SELECT ON TABLE dim_pm.pg_input_voa_back_data TO richuser;
GRANT ALL ON TABLE dim_pm.pg_input_voa_back_data TO nokia;


--
-- PostgreSQL database dump complete
--