deploy/db/V_04_CREATE_DB.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.21
-- Dumped by pg_dump version 12.2

-- Started on 2020-06-29 08:40:08 CEST

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 = '';

--
-- TOC entry 181 (class 1259 OID 16611)
-- Name: tbl_attachment; Type: TABLE; Schema: public; Owner: spa_service
--

CREATE TABLE public.tbl_attachment (
    id bigint NOT NULL,
    data bytea NOT NULL,
    file_name character varying(255),
    file_type character varying(255),
    statement_id bigint
);


ALTER TABLE public.tbl_attachment OWNER TO spa_service;

--
-- TOC entry 182 (class 1259 OID 16617)
-- Name: tbl_attachment2tag; Type: TABLE; Schema: public; Owner: spa_service
--

CREATE TABLE public.tbl_attachment2tag (
    tag_id bigint NOT NULL,
    attachment_id bigint NOT NULL
);


ALTER TABLE public.tbl_attachment2tag OWNER TO spa_service;

--
-- TOC entry 183 (class 1259 OID 16620)
-- Name: tbl_attachment_id_seq; Type: SEQUENCE; Schema: public; Owner: spa_service
--

CREATE SEQUENCE public.tbl_attachment_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tbl_attachment_id_seq OWNER TO spa_service;

--
-- TOC entry 2297 (class 0 OID 0)
-- Dependencies: 183
-- Name: tbl_attachment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spa_service
--

ALTER SEQUENCE public.tbl_attachment_id_seq OWNED BY public.tbl_attachment.id;


--
-- TOC entry 184 (class 1259 OID 16622)
-- Name: tbl_comment; Type: TABLE; Schema: public; Owner: spa_service
--

CREATE TABLE public.tbl_comment (
    id bigint NOT NULL,
    disabled boolean,
    text text NOT NULL,
    "timestamp" date,
    user_id bigint,
    workflow_id bigint
);


ALTER TABLE public.tbl_comment OWNER TO spa_service;

--
-- TOC entry 185 (class 1259 OID 16628)
-- Name: tbl_comment_id_seq; Type: SEQUENCE; Schema: public; Owner: spa_service
--

CREATE SEQUENCE public.tbl_comment_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tbl_comment_id_seq OWNER TO spa_service;

--
-- TOC entry 2298 (class 0 OID 0)
-- Dependencies: 185
-- Name: tbl_comment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spa_service
--

ALTER SEQUENCE public.tbl_comment_id_seq OWNED BY public.tbl_comment.id;


--
-- TOC entry 186 (class 1259 OID 16630)
-- Name: tbl_contact; Type: TABLE; Schema: public; Owner: spa_service
--

CREATE TABLE public.tbl_contact (
    id bigint NOT NULL,
    contactdbuser_id character varying(255)
);


ALTER TABLE public.tbl_contact OWNER TO spa_service;

--
-- TOC entry 187 (class 1259 OID 16633)
-- Name: tbl_contact_id_seq; Type: SEQUENCE; Schema: public; Owner: spa_service
--

CREATE SEQUENCE public.tbl_contact_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tbl_contact_id_seq OWNER TO spa_service;

--
-- TOC entry 2299 (class 0 OID 0)
-- Dependencies: 187
-- Name: tbl_contact_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spa_service
--

ALTER SEQUENCE public.tbl_contact_id_seq OWNED BY public.tbl_contact.id;


--
-- TOC entry 188 (class 1259 OID 16635)
-- Name: tbl_department; Type: TABLE; Schema: public; Owner: spa_service
--

CREATE TABLE public.tbl_department (
    id bigint NOT NULL,
    departmentgroup character varying(255),
    name character varying(255)
);


ALTER TABLE public.tbl_department OWNER TO spa_service;

--
-- TOC entry 189 (class 1259 OID 16641)
-- Name: tbl_department_id_seq; Type: SEQUENCE; Schema: public; Owner: spa_service
--

CREATE SEQUENCE public.tbl_department_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tbl_department_id_seq OWNER TO spa_service;

--
-- TOC entry 2300 (class 0 OID 0)
-- Dependencies: 189
-- Name: tbl_department_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spa_service
--

ALTER SEQUENCE public.tbl_department_id_seq OWNED BY public.tbl_department.id;


--
-- TOC entry 190 (class 1259 OID 16643)
-- Name: tbl_departmentstructure; Type: TABLE; Schema: public; Owner: spa_service
--

CREATE TABLE public.tbl_departmentstructure (
    id bigint NOT NULL,
    definition text NOT NULL,
    version bigint NOT NULL
);


ALTER TABLE public.tbl_departmentstructure OWNER TO spa_service;

--
-- TOC entry 191 (class 1259 OID 16649)
-- Name: tbl_departmentstructure_id_seq; Type: SEQUENCE; Schema: public; Owner: spa_service
--

CREATE SEQUENCE public.tbl_departmentstructure_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tbl_departmentstructure_id_seq OWNER TO spa_service;

--
-- TOC entry 2301 (class 0 OID 0)
-- Dependencies: 191
-- Name: tbl_departmentstructure_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spa_service
--

ALTER SEQUENCE public.tbl_departmentstructure_id_seq OWNED BY public.tbl_departmentstructure.id;


--
-- TOC entry 192 (class 1259 OID 16651)
-- Name: tbl_reqdepartment; Type: TABLE; Schema: public; Owner: spa_service
--

CREATE TABLE public.tbl_reqdepartment (
    id bigint NOT NULL,
    contributed boolean,
    optional boolean,
    department_id bigint,
    workflowdata_id bigint
);


ALTER TABLE public.tbl_reqdepartment OWNER TO spa_service;

--
-- TOC entry 193 (class 1259 OID 16654)
-- Name: tbl_reqdepartment_id_seq; Type: SEQUENCE; Schema: public; Owner: spa_service
--

CREATE SEQUENCE public.tbl_reqdepartment_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tbl_reqdepartment_id_seq OWNER TO spa_service;

--
-- TOC entry 2302 (class 0 OID 0)
-- Dependencies: 193
-- Name: tbl_reqdepartment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spa_service
--

ALTER SEQUENCE public.tbl_reqdepartment_id_seq OWNED BY public.tbl_reqdepartment.id;


--
-- TOC entry 194 (class 1259 OID 16656)
-- Name: tbl_statement; Type: TABLE; Schema: public; Owner: spa_service
--

CREATE TABLE public.tbl_statement (
    id bigint NOT NULL,
    business_key uuid,
    city character varying(255),
    district character varying(255),
    due_date date,
    finished boolean,
    receipt_date date,
    title character varying(255),
    contact_id bigint,
    department_structure_id bigint,
    statementtype_id bigint
);


ALTER TABLE public.tbl_statement OWNER TO spa_service;

--
-- TOC entry 195 (class 1259 OID 16662)
-- Name: tbl_statement2parent; Type: TABLE; Schema: public; Owner: spa_service
--

CREATE TABLE public.tbl_statement2parent (
    statement_id bigint NOT NULL,
    parent_id bigint NOT NULL
);


ALTER TABLE public.tbl_statement2parent OWNER TO spa_service;

--
-- TOC entry 196 (class 1259 OID 16665)
-- Name: tbl_statement_edit_log; Type: TABLE; Schema: public; Owner: spa_service
--

CREATE TABLE public.tbl_statement_edit_log (
    id bigint NOT NULL,
    accesstype character varying(255),
    "timestamp" date,
    statement_id bigint,
    user_id bigint
);


ALTER TABLE public.tbl_statement_edit_log OWNER TO spa_service;

--
-- TOC entry 197 (class 1259 OID 16668)
-- Name: tbl_statement_edit_log_id_seq; Type: SEQUENCE; Schema: public; Owner: spa_service
--

CREATE SEQUENCE public.tbl_statement_edit_log_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tbl_statement_edit_log_id_seq OWNER TO spa_service;

--
-- TOC entry 2303 (class 0 OID 0)
-- Dependencies: 197
-- Name: tbl_statement_edit_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spa_service
--

ALTER SEQUENCE public.tbl_statement_edit_log_id_seq OWNED BY public.tbl_statement_edit_log.id;


--
-- TOC entry 198 (class 1259 OID 16670)
-- Name: tbl_statement_id_seq; Type: SEQUENCE; Schema: public; Owner: spa_service
--

CREATE SEQUENCE public.tbl_statement_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tbl_statement_id_seq OWNER TO spa_service;

--
-- TOC entry 2304 (class 0 OID 0)
-- Dependencies: 198
-- Name: tbl_statement_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spa_service
--

ALTER SEQUENCE public.tbl_statement_id_seq OWNED BY public.tbl_statement.id;


--
-- TOC entry 199 (class 1259 OID 16672)
-- Name: tbl_statementtype; Type: TABLE; Schema: public; Owner: spa_service
--

CREATE TABLE public.tbl_statementtype (
    id bigint NOT NULL,
    name character varying(255)
);


ALTER TABLE public.tbl_statementtype OWNER TO spa_service;

--
-- TOC entry 200 (class 1259 OID 16675)
-- Name: tbl_statementtype_id_seq; Type: SEQUENCE; Schema: public; Owner: spa_service
--

CREATE SEQUENCE public.tbl_statementtype_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tbl_statementtype_id_seq OWNER TO spa_service;

--
-- TOC entry 2305 (class 0 OID 0)
-- Dependencies: 200
-- Name: tbl_statementtype_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spa_service
--

ALTER SEQUENCE public.tbl_statementtype_id_seq OWNED BY public.tbl_statementtype.id;


--
-- TOC entry 201 (class 1259 OID 16677)
-- Name: tbl_tag; Type: TABLE; Schema: public; Owner: spa_service
--

CREATE TABLE public.tbl_tag (
    id bigint NOT NULL,
    name character varying(255)
);


ALTER TABLE public.tbl_tag OWNER TO spa_service;

--
-- TOC entry 202 (class 1259 OID 16680)
-- Name: tbl_tag_id_seq; Type: SEQUENCE; Schema: public; Owner: spa_service
--

CREATE SEQUENCE public.tbl_tag_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tbl_tag_id_seq OWNER TO spa_service;

--
-- TOC entry 2306 (class 0 OID 0)
-- Dependencies: 202
-- Name: tbl_tag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spa_service
--

ALTER SEQUENCE public.tbl_tag_id_seq OWNED BY public.tbl_tag.id;


--
-- TOC entry 203 (class 1259 OID 16682)
-- Name: tbl_textblockdefinition; Type: TABLE; Schema: public; Owner: spa_service
--

CREATE TABLE public.tbl_textblockdefinition (
    id bigint NOT NULL,
    definition text NOT NULL,
    version bigint NOT NULL
);


ALTER TABLE public.tbl_textblockdefinition OWNER TO spa_service;

--
-- TOC entry 204 (class 1259 OID 16685)
-- Name: tbl_textblockdefinition_id_seq; Type: SEQUENCE; Schema: public; Owner: spa_service
--

CREATE SEQUENCE public.tbl_textblockdefinition_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tbl_textblockdefinition_id_seq OWNER TO spa_service;

--
-- TOC entry 2307 (class 0 OID 0)
-- Dependencies: 204
-- Name: tbl_textblockdefinition_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spa_service
--

ALTER SEQUENCE public.tbl_textblockdefinition_id_seq OWNED BY public.tbl_textblockdefinition.id;


--
-- TOC entry 205 (class 1259 OID 16687)
-- Name: tbl_user; Type: TABLE; Schema: public; Owner: spa_service
--

CREATE TABLE public.tbl_user (
    id bigint NOT NULL,
    first_name character varying(255),
    last_name character varying(255),
    username character varying(255)
);


ALTER TABLE public.tbl_user OWNER TO spa_service;

--
-- TOC entry 206 (class 1259 OID 16693)
-- Name: tbl_user2department; Type: TABLE; Schema: public; Owner: spa_service
--

CREATE TABLE public.tbl_user2department (
    user_id bigint NOT NULL,
    department_id bigint NOT NULL
);


ALTER TABLE public.tbl_user2department OWNER TO spa_service;

--
-- TOC entry 207 (class 1259 OID 16696)
-- Name: tbl_user_id_seq; Type: SEQUENCE; Schema: public; Owner: spa_service
--

CREATE SEQUENCE public.tbl_user_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tbl_user_id_seq OWNER TO spa_service;

--
-- TOC entry 2308 (class 0 OID 0)
-- Dependencies: 207
-- Name: tbl_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spa_service
--

ALTER SEQUENCE public.tbl_user_id_seq OWNED BY public.tbl_user.id;


--
-- TOC entry 208 (class 1259 OID 16698)
-- Name: tbl_workflowdata; Type: TABLE; Schema: public; Owner: spa_service
--

CREATE TABLE public.tbl_workflowdata (
    id bigint NOT NULL,
    draft text,
    initial_state boolean,
    "position" character varying(255),
    statement_id bigint,
    textblockdefinition_id bigint
);


ALTER TABLE public.tbl_workflowdata OWNER TO spa_service;

--
-- TOC entry 209 (class 1259 OID 16704)
-- Name: tbl_workflowdata_id_seq; Type: SEQUENCE; Schema: public; Owner: spa_service
--

CREATE SEQUENCE public.tbl_workflowdata_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tbl_workflowdata_id_seq OWNER TO spa_service;

--
-- TOC entry 2309 (class 0 OID 0)
-- Dependencies: 209
-- Name: tbl_workflowdata_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spa_service
--

ALTER SEQUENCE public.tbl_workflowdata_id_seq OWNED BY public.tbl_workflowdata.id;


--
-- TOC entry 2074 (class 2604 OID 16706)
-- Name: tbl_attachment id; Type: DEFAULT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_attachment ALTER COLUMN id SET DEFAULT nextval('public.tbl_attachment_id_seq'::regclass);


--
-- TOC entry 2075 (class 2604 OID 16707)
-- Name: tbl_comment id; Type: DEFAULT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_comment ALTER COLUMN id SET DEFAULT nextval('public.tbl_comment_id_seq'::regclass);


--
-- TOC entry 2076 (class 2604 OID 16708)
-- Name: tbl_contact id; Type: DEFAULT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_contact ALTER COLUMN id SET DEFAULT nextval('public.tbl_contact_id_seq'::regclass);


--
-- TOC entry 2077 (class 2604 OID 16709)
-- Name: tbl_department id; Type: DEFAULT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_department ALTER COLUMN id SET DEFAULT nextval('public.tbl_department_id_seq'::regclass);


--
-- TOC entry 2078 (class 2604 OID 16710)
-- Name: tbl_departmentstructure id; Type: DEFAULT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_departmentstructure ALTER COLUMN id SET DEFAULT nextval('public.tbl_departmentstructure_id_seq'::regclass);


--
-- TOC entry 2079 (class 2604 OID 16711)
-- Name: tbl_reqdepartment id; Type: DEFAULT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_reqdepartment ALTER COLUMN id SET DEFAULT nextval('public.tbl_reqdepartment_id_seq'::regclass);


--
-- TOC entry 2080 (class 2604 OID 16712)
-- Name: tbl_statement id; Type: DEFAULT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_statement ALTER COLUMN id SET DEFAULT nextval('public.tbl_statement_id_seq'::regclass);


--
-- TOC entry 2081 (class 2604 OID 16713)
-- Name: tbl_statement_edit_log id; Type: DEFAULT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_statement_edit_log ALTER COLUMN id SET DEFAULT nextval('public.tbl_statement_edit_log_id_seq'::regclass);


--
-- TOC entry 2082 (class 2604 OID 16714)
-- Name: tbl_statementtype id; Type: DEFAULT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_statementtype ALTER COLUMN id SET DEFAULT nextval('public.tbl_statementtype_id_seq'::regclass);


--
-- TOC entry 2083 (class 2604 OID 16715)
-- Name: tbl_tag id; Type: DEFAULT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_tag ALTER COLUMN id SET DEFAULT nextval('public.tbl_tag_id_seq'::regclass);


--
-- TOC entry 2084 (class 2604 OID 16716)
-- Name: tbl_textblockdefinition id; Type: DEFAULT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_textblockdefinition ALTER COLUMN id SET DEFAULT nextval('public.tbl_textblockdefinition_id_seq'::regclass);


--
-- TOC entry 2085 (class 2604 OID 16717)
-- Name: tbl_user id; Type: DEFAULT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_user ALTER COLUMN id SET DEFAULT nextval('public.tbl_user_id_seq'::regclass);


--
-- TOC entry 2086 (class 2604 OID 16718)
-- Name: tbl_workflowdata id; Type: DEFAULT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_workflowdata ALTER COLUMN id SET DEFAULT nextval('public.tbl_workflowdata_id_seq'::regclass);


--
-- TOC entry 2286 (class 2613 OID 33052)
-- Name: 33052; Type: BLOB; Schema: -; Owner: spa_service
--

SELECT pg_catalog.lo_create('33052');


ALTER LARGE OBJECT 33052 OWNER TO spa_service;

--
-- TOC entry 2287 (class 2613 OID 33053)
-- Name: 33053; Type: BLOB; Schema: -; Owner: spa_service
--

SELECT pg_catalog.lo_create('33053');


ALTER LARGE OBJECT 33053 OWNER TO spa_service;

--
-- TOC entry 2288 (class 2613 OID 33054)
-- Name: 33054; Type: BLOB; Schema: -; Owner: spa_service
--

SELECT pg_catalog.lo_create('33054');


ALTER LARGE OBJECT 33054 OWNER TO spa_service;

--
-- TOC entry 2289 (class 2613 OID 33055)
-- Name: 33055; Type: BLOB; Schema: -; Owner: spa_service
--

SELECT pg_catalog.lo_create('33055');


ALTER LARGE OBJECT 33055 OWNER TO spa_service;

--
-- TOC entry 2257 (class 0 OID 16611)
-- Dependencies: 181
-- Data for Name: tbl_attachment; Type: TABLE DATA; Schema: public; Owner: spa_service
--

COPY public.tbl_attachment (id, data, file_name, file_type, statement_id) FROM stdin;
\.


--
-- TOC entry 2258 (class 0 OID 16617)
-- Dependencies: 182
-- Data for Name: tbl_attachment2tag; Type: TABLE DATA; Schema: public; Owner: spa_service
--

COPY public.tbl_attachment2tag (tag_id, attachment_id) FROM stdin;
\.


--
-- TOC entry 2260 (class 0 OID 16622)
-- Dependencies: 184
-- Data for Name: tbl_comment; Type: TABLE DATA; Schema: public; Owner: spa_service
--

COPY public.tbl_comment (id, disabled, text, "timestamp", user_id, workflow_id) FROM stdin;
\.


--
-- TOC entry 2262 (class 0 OID 16630)
-- Dependencies: 186
-- Data for Name: tbl_contact; Type: TABLE DATA; Schema: public; Owner: spa_service
--

COPY public.tbl_contact (id, contactdbuser_id) FROM stdin;
\.


--
-- TOC entry 2264 (class 0 OID 16635)
-- Dependencies: 188
-- Data for Name: tbl_department; Type: TABLE DATA; Schema: public; Owner: spa_service
--

COPY public.tbl_department (id, departmentgroup, name) FROM stdin;
1	Allgemein	Medianet
2	Allgemein	Wasser
3	Allgemein	Gas HD
4	Regionalstelle Darmstadt	Strom Planung/Bau
5	Regionalstelle Darmstadt	Strom Betrieb
6	Regionalstelle Darmstadt	Gas Planung/Bau
7	Regionalstelle Darmstadt	Gas Betrieb
8	Regionalstelle Darmstadt	Straßenbeleuchtung
9	Regionalstelle Groß-Umstadt	Strom Planung/Bau
10	Regionalstelle Groß-Umstadt	Strom Betrieb
11	Regionalstelle Groß-Umstadt	Gas Planung/Bau
12	Regionalstelle Groß-Umstadt	Gas Betrieb
13	Regionalstelle Groß-Umstadt	Straßenbeleuchtung
14	Regionalstelle Heppenheim	Strom Planung/Bau
15	Regionalstelle Heppenheim	Strom Betrieb
16	Regionalstelle Heppenheim	Gas Planung/Bau
17	Regionalstelle Heppenheim	Gas Betrieb
18	Regionalstelle Heppenheim	Straßenbeleuchtung
19	Regionalstelle Erbach	Strom Planung/Bau
20	Regionalstelle Erbach	Strom Betrieb
21	Regionalstelle Erbach	Gas Planung/Bau
22	Regionalstelle Erbach	Gas Betrieb
23	Regionalstelle Erbach	Straßenbeleuchtung
\.


--
-- TOC entry 2266 (class 0 OID 16643)
-- Dependencies: 190
-- Data for Name: tbl_departmentstructure; Type: TABLE DATA; Schema: public; Owner: spa_service
--

COPY public.tbl_departmentstructure (id, definition, version) FROM stdin;
2	{\n\t"Ort#Ortsteil" : {\n\t\t"provides": ["Strom", "Gas", "Wasser", "Straßenbeleuchtung"],\n\t\t"departments" : {\n\t\t\t"Allgemein": ["Medianet", "Wasser", "Gas HD"],\n\t\t\t"Regionalstelle Darmstadt": ["Strom Planung/Bau", "Strom Betrieb", "Gas Planung/Bau","Gas Betrieb","Straßenbeleuchtung"],\n\t\t\t"Regionalstelle Groß-Umstadt": ["Strom Planung/Bau", "Strom Betrieb", "Gas Planung/Bau","Gas Betrieb","Straßenbeleuchtung"],\n\t\t\t"Regionalstelle Heppenheim": ["Strom Planung/Bau", "Strom Betrieb", "Gas Planung/Bau","Gas Betrieb","Straßenbeleuchtung"]\n\t\t}\n\t},\n\t"Heppenheim#Heppenheim" : {\n\t\t"provides": ["Strom", "Gas", "Wasser", "Straßenbeleuchtung"],\n\t\t"departments" : {\n\t\t\t"Regionalstelle Heppenheim": ["Strom Planung/Bau", "Strom Betrieb", "Gas Planung/Bau","Gas Betrieb","Straßenbeleuchtung"]\n\t\t}\n\t},\n\t"Darmstadt#Darmstadt" : {\n\t\t"provides": ["Strom", "Gas", "Wasser", "Straßenbeleuchtung"],\n\t\t"departments" : {\n\t\t\t"Regionalstelle Darmstadt": ["Strom Planung/Bau", "Strom Betrieb", "Gas Planung/Bau","Gas Betrieb","Straßenbeleuchtung"]\n\t\t}\n\t},\n\t"Groß-Umstadt#Groß-Umstadt" : {\n\t\t"provides": ["Strom", "Gas", "Wasser", "Straßenbeleuchtung"],\n\t\t"departments" : {\n\t\t\t"Regionalstelle Groß-Umstadt": ["Strom Planung/Bau", "Strom Betrieb", "Gas Planung/Bau","Gas Betrieb","Straßenbeleuchtung"]\n\t\t}\n\t}\n\n}	1
\.


--
-- TOC entry 2268 (class 0 OID 16651)
-- Dependencies: 192
-- Data for Name: tbl_reqdepartment; Type: TABLE DATA; Schema: public; Owner: spa_service
--

COPY public.tbl_reqdepartment (id, contributed, optional, department_id, workflowdata_id) FROM stdin;
\.


--
-- TOC entry 2270 (class 0 OID 16656)
-- Dependencies: 194
-- Data for Name: tbl_statement; Type: TABLE DATA; Schema: public; Owner: spa_service
--

COPY public.tbl_statement (id, business_key, city, district, due_date, finished, receipt_date, title, contact_id, department_structure_id, statementtype_id) FROM stdin;
\.


--
-- TOC entry 2271 (class 0 OID 16662)
-- Dependencies: 195
-- Data for Name: tbl_statement2parent; Type: TABLE DATA; Schema: public; Owner: spa_service
--

COPY public.tbl_statement2parent (statement_id, parent_id) FROM stdin;
\.


--
-- TOC entry 2272 (class 0 OID 16665)
-- Dependencies: 196
-- Data for Name: tbl_statement_edit_log; Type: TABLE DATA; Schema: public; Owner: spa_service
--

COPY public.tbl_statement_edit_log (id, accesstype, "timestamp", statement_id, user_id) FROM stdin;
\.


--
-- TOC entry 2275 (class 0 OID 16672)
-- Dependencies: 199
-- Data for Name: tbl_statementtype; Type: TABLE DATA; Schema: public; Owner: spa_service
--

COPY public.tbl_statementtype (id, name) FROM stdin;
1	Bauleitplanung
2	Mitverlegungsanfrage
3	Bauvoranfrage
4	Planfeststellungsverfahren
5	Formlose Anfrage
\.


--
-- TOC entry 2277 (class 0 OID 16677)
-- Dependencies: 201
-- Data for Name: tbl_tag; Type: TABLE DATA; Schema: public; Owner: spa_service
--

COPY public.tbl_tag (id, name) FROM stdin;
\.


--
-- TOC entry 2279 (class 0 OID 16682)
-- Dependencies: 203
-- Data for Name: tbl_textblockdefinition; Type: TABLE DATA; Schema: public; Owner: spa_service
--

COPY public.tbl_textblockdefinition (id, definition, version) FROM stdin;
1	{"groups": {"group1": [\n{"id": "1a", "text":"Wir nehmen dazu Stellung für die Netze der ENTEGA AG und der e-netz Südhessen AG und ENTEGA Medianet GmbH.", "requires": [{"type":"xor", "ids":["1b", "1c"]}], "excludes": []} ,\n{"id": "1b", "text":"Im Gebiet der Stadt <t:city> sind wir Netzbetreiber der Sparte(n) <t:sparten>.","requires": [{"type":"and", "ids":["1a"]}], "excludes":["1c", "1d"]},\n{"id": "1c", "text":"Im Gebiet der Stadt <t:city> sind wir Netzbetreiber der Sparte(n) <t:sparten>. Bitte beteiligen Sie auch die GGEW für die Sparte(n) <f:ggew_sparten> als Träger öffentl. Belange am Verfahren.", "requires": [{"type":"and", "ids":["1a"]}], "excludes":["1b", "1d"]},\n{"id": "1d", "text":"Im Gebiet der Stadt <t:city> sind wir kein Netzbetreiber. Bitte beteiligen Sie auch die <f:andere_netzbetreiber> für die Sparte(n) <f:andere_sparten> als Träger öffentl. Belange am Verfahren.", "requires": [{"type":"and", "ids":["1a"]}], "excludes":["1b", "1d"]}\n]\n}}\n	1
\.


--
-- TOC entry 2281 (class 0 OID 16687)
-- Dependencies: 205
-- Data for Name: tbl_user; Type: TABLE DATA; Schema: public; Owner: spa_service
--

COPY public.tbl_user (id, first_name, last_name, username) FROM stdin;
2	Test	Mitarbeiter	spa_multi
\.


--
-- TOC entry 2282 (class 0 OID 16693)
-- Dependencies: 206
-- Data for Name: tbl_user2department; Type: TABLE DATA; Schema: public; Owner: spa_service
--

COPY public.tbl_user2department (user_id, department_id) FROM stdin;
\.


--
-- TOC entry 2284 (class 0 OID 16698)
-- Dependencies: 208
-- Data for Name: tbl_workflowdata; Type: TABLE DATA; Schema: public; Owner: spa_service
--

COPY public.tbl_workflowdata (id, draft, initial_state, "position", statement_id, textblockdefinition_id) FROM stdin;
\.


--
-- TOC entry 2310 (class 0 OID 0)
-- Dependencies: 183
-- Name: tbl_attachment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spa_service
--

SELECT pg_catalog.setval('public.tbl_attachment_id_seq', 1, false);


--
-- TOC entry 2311 (class 0 OID 0)
-- Dependencies: 185
-- Name: tbl_comment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spa_service
--

SELECT pg_catalog.setval('public.tbl_comment_id_seq', 36, true);


--
-- TOC entry 2312 (class 0 OID 0)
-- Dependencies: 187
-- Name: tbl_contact_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spa_service
--

SELECT pg_catalog.setval('public.tbl_contact_id_seq', 1, false);


--
-- TOC entry 2313 (class 0 OID 0)
-- Dependencies: 189
-- Name: tbl_department_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spa_service
--

SELECT pg_catalog.setval('public.tbl_department_id_seq', 23, true);


--
-- TOC entry 2314 (class 0 OID 0)
-- Dependencies: 191
-- Name: tbl_departmentstructure_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spa_service
--

SELECT pg_catalog.setval('public.tbl_departmentstructure_id_seq', 2, true);


--
-- TOC entry 2315 (class 0 OID 0)
-- Dependencies: 193
-- Name: tbl_reqdepartment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spa_service
--

SELECT pg_catalog.setval('public.tbl_reqdepartment_id_seq', 37, true);


--
-- TOC entry 2316 (class 0 OID 0)
-- Dependencies: 197
-- Name: tbl_statement_edit_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spa_service
--

SELECT pg_catalog.setval('public.tbl_statement_edit_log_id_seq', 1, false);


--
-- TOC entry 2317 (class 0 OID 0)
-- Dependencies: 198
-- Name: tbl_statement_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spa_service
--

SELECT pg_catalog.setval('public.tbl_statement_id_seq', 3, true);


--
-- TOC entry 2318 (class 0 OID 0)
-- Dependencies: 200
-- Name: tbl_statementtype_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spa_service
--

SELECT pg_catalog.setval('public.tbl_statementtype_id_seq', 5, true);


--
-- TOC entry 2319 (class 0 OID 0)
-- Dependencies: 202
-- Name: tbl_tag_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spa_service
--

SELECT pg_catalog.setval('public.tbl_tag_id_seq', 1, false);


--
-- TOC entry 2320 (class 0 OID 0)
-- Dependencies: 204
-- Name: tbl_textblockdefinition_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spa_service
--

SELECT pg_catalog.setval('public.tbl_textblockdefinition_id_seq', 1, true);


--
-- TOC entry 2321 (class 0 OID 0)
-- Dependencies: 207
-- Name: tbl_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spa_service
--

SELECT pg_catalog.setval('public.tbl_user_id_seq', 2, true);


--
-- TOC entry 2322 (class 0 OID 0)
-- Dependencies: 209
-- Name: tbl_workflowdata_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spa_service
--

SELECT pg_catalog.setval('public.tbl_workflowdata_id_seq', 34, true);


--
-- TOC entry 2290 (class 0 OID 0)
-- Data for Name: BLOBS; Type: BLOBS; Schema: -; Owner: -
--

BEGIN;

SELECT pg_catalog.lo_open('33052', 131072);
SELECT pg_catalog.lowrite(0, '\x44617320697374206d65696e204b6f6d6d656e7461722c207769726b6c6963682e204d61636820657320616e64657273');
SELECT pg_catalog.lo_close(0);

SELECT pg_catalog.lo_open('33053', 131072);
SELECT pg_catalog.lowrite(0, '\x44617320697374206d65696e204b6f6d6d656e7461722c207769726b6c6963682e204d61636820657320616e64657273');
SELECT pg_catalog.lo_close(0);

SELECT pg_catalog.lo_open('33054', 131072);
SELECT pg_catalog.lowrite(0, '\x44617320697374206d65696e204b6f6d6d656e7461722c207769726b6c6963682e204d61636820657320616e64657273');
SELECT pg_catalog.lo_close(0);

SELECT pg_catalog.lo_open('33055', 131072);
SELECT pg_catalog.lowrite(0, '\x44617320697374206d65696e204b6f6d6d656e7461722c207769726b6c6963682e204d61636820657320616e64657273');
SELECT pg_catalog.lo_close(0);

COMMIT;

--
-- TOC entry 2090 (class 2606 OID 16720)
-- Name: tbl_attachment2tag tbl_attachment2tag_pkey; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_attachment2tag
    ADD CONSTRAINT tbl_attachment2tag_pkey PRIMARY KEY (attachment_id, tag_id);


--
-- TOC entry 2088 (class 2606 OID 16722)
-- Name: tbl_attachment tbl_attachment_pkey; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_attachment
    ADD CONSTRAINT tbl_attachment_pkey PRIMARY KEY (id);


--
-- TOC entry 2092 (class 2606 OID 16724)
-- Name: tbl_comment tbl_comment_pkey; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_comment
    ADD CONSTRAINT tbl_comment_pkey PRIMARY KEY (id);


--
-- TOC entry 2094 (class 2606 OID 16726)
-- Name: tbl_contact tbl_contact_pkey; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_contact
    ADD CONSTRAINT tbl_contact_pkey PRIMARY KEY (id);


--
-- TOC entry 2096 (class 2606 OID 16728)
-- Name: tbl_department tbl_department_pkey; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_department
    ADD CONSTRAINT tbl_department_pkey PRIMARY KEY (id);


--
-- TOC entry 2100 (class 2606 OID 16730)
-- Name: tbl_departmentstructure tbl_departmentstructure_pkey; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_departmentstructure
    ADD CONSTRAINT tbl_departmentstructure_pkey PRIMARY KEY (id);


--
-- TOC entry 2102 (class 2606 OID 16732)
-- Name: tbl_reqdepartment tbl_reqdepartment_pkey; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_reqdepartment
    ADD CONSTRAINT tbl_reqdepartment_pkey PRIMARY KEY (id);


--
-- TOC entry 2106 (class 2606 OID 16734)
-- Name: tbl_statement2parent tbl_statement2parent_pkey; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_statement2parent
    ADD CONSTRAINT tbl_statement2parent_pkey PRIMARY KEY (parent_id, statement_id);


--
-- TOC entry 2108 (class 2606 OID 16736)
-- Name: tbl_statement_edit_log tbl_statement_edit_log_pkey; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_statement_edit_log
    ADD CONSTRAINT tbl_statement_edit_log_pkey PRIMARY KEY (id);


--
-- TOC entry 2104 (class 2606 OID 16738)
-- Name: tbl_statement tbl_statement_pkey; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_statement
    ADD CONSTRAINT tbl_statement_pkey PRIMARY KEY (id);


--
-- TOC entry 2110 (class 2606 OID 16740)
-- Name: tbl_statementtype tbl_statementtype_pkey; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_statementtype
    ADD CONSTRAINT tbl_statementtype_pkey PRIMARY KEY (id);


--
-- TOC entry 2112 (class 2606 OID 16742)
-- Name: tbl_tag tbl_tag_pkey; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_tag
    ADD CONSTRAINT tbl_tag_pkey PRIMARY KEY (id);


--
-- TOC entry 2116 (class 2606 OID 16744)
-- Name: tbl_textblockdefinition tbl_textblockdefinition_pkey; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_textblockdefinition
    ADD CONSTRAINT tbl_textblockdefinition_pkey PRIMARY KEY (id);


--
-- TOC entry 2122 (class 2606 OID 16746)
-- Name: tbl_user2department tbl_user2department_pkey; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_user2department
    ADD CONSTRAINT tbl_user2department_pkey PRIMARY KEY (department_id, user_id);


--
-- TOC entry 2118 (class 2606 OID 16748)
-- Name: tbl_user tbl_user_pkey; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_user
    ADD CONSTRAINT tbl_user_pkey PRIMARY KEY (id);


--
-- TOC entry 2124 (class 2606 OID 16750)
-- Name: tbl_workflowdata tbl_workflowdata_pkey; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_workflowdata
    ADD CONSTRAINT tbl_workflowdata_pkey PRIMARY KEY (id);


--
-- TOC entry 2120 (class 2606 OID 16752)
-- Name: tbl_user uk_k0bty7tbcye41jpxam88q5kj2; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_user
    ADD CONSTRAINT uk_k0bty7tbcye41jpxam88q5kj2 UNIQUE (username);


--
-- TOC entry 2114 (class 2606 OID 16754)
-- Name: tbl_tag uk_l2viqa2nn516nlwrac59y4cpc; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_tag
    ADD CONSTRAINT uk_l2viqa2nn516nlwrac59y4cpc UNIQUE (name);


--
-- TOC entry 2098 (class 2606 OID 16756)
-- Name: tbl_department ukm58lyyoxl755gwi2ujaff0s5g; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_department
    ADD CONSTRAINT ukm58lyyoxl755gwi2ujaff0s5g UNIQUE (name, departmentgroup);


--
-- TOC entry 2137 (class 2606 OID 16757)
-- Name: tbl_statement_edit_log fk21vfetj49asxtgjc7tsb1emu4; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_statement_edit_log
    ADD CONSTRAINT fk21vfetj49asxtgjc7tsb1emu4 FOREIGN KEY (statement_id) REFERENCES public.tbl_statement(id);


--
-- TOC entry 2139 (class 2606 OID 16762)
-- Name: tbl_user2department fk2b67y31bcp75lswktg131kvsv; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_user2department
    ADD CONSTRAINT fk2b67y31bcp75lswktg131kvsv FOREIGN KEY (user_id) REFERENCES public.tbl_user(id);


--
-- TOC entry 2130 (class 2606 OID 16767)
-- Name: tbl_reqdepartment fk3l2ko8jepnlgajr2mmwkc6193; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_reqdepartment
    ADD CONSTRAINT fk3l2ko8jepnlgajr2mmwkc6193 FOREIGN KEY (department_id) REFERENCES public.tbl_department(id);


--
-- TOC entry 2126 (class 2606 OID 16772)
-- Name: tbl_attachment2tag fk96vyparm662pb3pjpl239r4x2; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_attachment2tag
    ADD CONSTRAINT fk96vyparm662pb3pjpl239r4x2 FOREIGN KEY (attachment_id) REFERENCES public.tbl_attachment(id);


--
-- TOC entry 2131 (class 2606 OID 16777)
-- Name: tbl_reqdepartment fk9fmd88ccq8rjj2bgv9olt23km; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_reqdepartment
    ADD CONSTRAINT fk9fmd88ccq8rjj2bgv9olt23km FOREIGN KEY (workflowdata_id) REFERENCES public.tbl_workflowdata(id);


--
-- TOC entry 2135 (class 2606 OID 16782)
-- Name: tbl_statement2parent fk9j30c3acqybv5a7uvpvi1negx; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_statement2parent
    ADD CONSTRAINT fk9j30c3acqybv5a7uvpvi1negx FOREIGN KEY (parent_id) REFERENCES public.tbl_statement(id);


--
-- TOC entry 2140 (class 2606 OID 16787)
-- Name: tbl_user2department fkdfdrw8vv71mqrbyjfvh1shcsb; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_user2department
    ADD CONSTRAINT fkdfdrw8vv71mqrbyjfvh1shcsb FOREIGN KEY (department_id) REFERENCES public.tbl_department(id);


--
-- TOC entry 2132 (class 2606 OID 16792)
-- Name: tbl_statement fkg3srlmn9jbfdhl0avf8jrqhil; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_statement
    ADD CONSTRAINT fkg3srlmn9jbfdhl0avf8jrqhil FOREIGN KEY (statementtype_id) REFERENCES public.tbl_statementtype(id);


--
-- TOC entry 2128 (class 2606 OID 16797)
-- Name: tbl_comment fkgjlkbaxyvqqrmxeoxh6pb4oj7; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_comment
    ADD CONSTRAINT fkgjlkbaxyvqqrmxeoxh6pb4oj7 FOREIGN KEY (user_id) REFERENCES public.tbl_user(id);


--
-- TOC entry 2141 (class 2606 OID 16802)
-- Name: tbl_workflowdata fkgmb63he69bqfahrnw8auvc0b5; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_workflowdata
    ADD CONSTRAINT fkgmb63he69bqfahrnw8auvc0b5 FOREIGN KEY (statement_id) REFERENCES public.tbl_statement(id);


--
-- TOC entry 2125 (class 2606 OID 16807)
-- Name: tbl_attachment fkhvwav3ujkwgls0b2nx9r5egm6; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_attachment
    ADD CONSTRAINT fkhvwav3ujkwgls0b2nx9r5egm6 FOREIGN KEY (statement_id) REFERENCES public.tbl_statement(id);


--
-- TOC entry 2136 (class 2606 OID 16812)
-- Name: tbl_statement2parent fkkoery7b8wl0o219gyoqrdq7hq; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_statement2parent
    ADD CONSTRAINT fkkoery7b8wl0o219gyoqrdq7hq FOREIGN KEY (statement_id) REFERENCES public.tbl_statement(id);


--
-- TOC entry 2129 (class 2606 OID 16817)
-- Name: tbl_comment fkkscbabepj0p58s0dga8jrq8p; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_comment
    ADD CONSTRAINT fkkscbabepj0p58s0dga8jrq8p FOREIGN KEY (workflow_id) REFERENCES public.tbl_workflowdata(id);


--
-- TOC entry 2127 (class 2606 OID 16822)
-- Name: tbl_attachment2tag fkl5p46l3f5m3b3hsi0bev09cr7; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_attachment2tag
    ADD CONSTRAINT fkl5p46l3f5m3b3hsi0bev09cr7 FOREIGN KEY (tag_id) REFERENCES public.tbl_tag(id);


--
-- TOC entry 2133 (class 2606 OID 16827)
-- Name: tbl_statement fkmcyl6nrx9rnk3ofqb2w0kwy8; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_statement
    ADD CONSTRAINT fkmcyl6nrx9rnk3ofqb2w0kwy8 FOREIGN KEY (department_structure_id) REFERENCES public.tbl_departmentstructure(id);


--
-- TOC entry 2134 (class 2606 OID 16832)
-- Name: tbl_statement fkphbtui6ekoc8gyq9sfd80yfc; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_statement
    ADD CONSTRAINT fkphbtui6ekoc8gyq9sfd80yfc FOREIGN KEY (contact_id) REFERENCES public.tbl_contact(id);


--
-- TOC entry 2142 (class 2606 OID 16837)
-- Name: tbl_workflowdata fkr8j8yxhd77ajp4v32eieaiun1; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_workflowdata
    ADD CONSTRAINT fkr8j8yxhd77ajp4v32eieaiun1 FOREIGN KEY (textblockdefinition_id) REFERENCES public.tbl_textblockdefinition(id);


--
-- TOC entry 2138 (class 2606 OID 16842)
-- Name: tbl_statement_edit_log fksvcojcn7vsprb3ue2936h51xm; Type: FK CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_statement_edit_log
    ADD CONSTRAINT fksvcojcn7vsprb3ue2936h51xm FOREIGN KEY (user_id) REFERENCES public.tbl_user(id);


--
-- TOC entry 2296 (class 0 OID 0)
-- Dependencies: 6
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


-- Completed on 2020-06-29 08:40:09 CEST

--
-- PostgreSQL database dump complete
--