-- Table: test_gw46data.test_gw_org_chart

-- DROP TABLE test_gw46data.test_gw_org_chart;

CREATE TABLE IF NOT EXISTS test_gw46data.test_gw_org_chart
(
    entity_id integer NOT NULL,
    entity_parent_id integer,
    entity_name character varying COLLATE pg_catalog."default" NOT NULL,
    entity_descr character varying COLLATE pg_catalog."default",
    gw_class_name character varying COLLATE pg_catalog."default",
    item_id character varying COLLATE pg_catalog."default",
    hex_color character varying COLLATE pg_catalog."default",
    CONSTRAINT test_gw_org_chart_pkey PRIMARY KEY (entity_id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE test_gw46data.test_gw_org_chart
    OWNER to test_gw46data;