deploy/db/V_08_CREATE_DB.sql

--
-- 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,
    size bigint,
    "timestamp" timestamp without time zone
);


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 character varying(255) 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 2299 (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" timestamp without time zone NOT NULL,
    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 2300 (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_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 187 (class 1259 OID 16636)
-- 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 2301 (class 0 OID 0)
-- Dependencies: 187
-- 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 188 (class 1259 OID 16638)
-- 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 189 (class 1259 OID 16644)
-- 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 2302 (class 0 OID 0)
-- Dependencies: 189
-- 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 190 (class 1259 OID 16646)
-- 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 191 (class 1259 OID 16649)
-- 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 2303 (class 0 OID 0)
-- Dependencies: 191
-- 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 192 (class 1259 OID 16651)
-- Name: tbl_statement; Type: TABLE; Schema: public; Owner: spa_service
--

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


ALTER TABLE public.tbl_statement OWNER TO spa_service;

--
-- TOC entry 193 (class 1259 OID 16657)
-- 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 194 (class 1259 OID 16660)
-- 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) NOT NULL,
    "timestamp" timestamp without time zone NOT NULL,
    statement_id bigint NOT NULL,
    user_id bigint NOT NULL
);


ALTER TABLE public.tbl_statement_edit_log OWNER TO spa_service;

--
-- TOC entry 195 (class 1259 OID 16663)
-- 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 2304 (class 0 OID 0)
-- Dependencies: 195
-- 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 196 (class 1259 OID 16665)
-- 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 2305 (class 0 OID 0)
-- Dependencies: 196
-- 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 197 (class 1259 OID 16667)
-- 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 198 (class 1259 OID 16670)
-- 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 2306 (class 0 OID 0)
-- Dependencies: 198
-- 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 199 (class 1259 OID 16672)
-- Name: tbl_tag; Type: TABLE; Schema: public; Owner: spa_service
--

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


ALTER TABLE public.tbl_tag OWNER TO spa_service;

--
-- TOC entry 200 (class 1259 OID 16678)
-- 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 201 (class 1259 OID 16684)
-- 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: 201
-- 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 202 (class 1259 OID 16686)
-- Name: tbl_user; Type: TABLE; Schema: public; Owner: spa_service
--

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


ALTER TABLE public.tbl_user OWNER TO spa_service;

--
-- TOC entry 203 (class 1259 OID 16692)
-- 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 204 (class 1259 OID 16695)
-- 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: 204
-- 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 205 (class 1259 OID 16697)
-- 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 NOT NULL,
    textblockdefinition_id bigint NOT NULL
);


ALTER TABLE public.tbl_workflowdata OWNER TO spa_service;

--
-- TOC entry 206 (class 1259 OID 16703)
-- 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: 206
-- 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 207 (class 1259 OID 16705)
-- Name: vw_statement_reqdepartment_users; Type: VIEW; Schema: public; Owner: spa_service
--

CREATE VIEW public.vw_statement_reqdepartment_users AS
 SELECT row_number() OVER (ORDER BY u.id) AS id,
    u.id AS user_id,
    u.first_name,
    u.last_name,
    u.username AS user_name,
    u.email_address,
    wd.statement_id,
    wd.id AS workflow_id,
    ud.department_id,
    d.name AS department_name,
    d.departmentgroup AS department_group
   FROM ((((public.tbl_user u
     JOIN public.tbl_user2department ud ON ((ud.user_id = u.id)))
     JOIN public.tbl_department d ON ((ud.department_id = d.id)))
     JOIN public.tbl_reqdepartment rd ON ((rd.department_id = d.id)))
     JOIN public.tbl_workflowdata wd ON ((wd.id = rd.workflowdata_id)));


ALTER TABLE public.vw_statement_reqdepartment_users OWNER TO spa_service;

--
-- TOC entry 208 (class 1259 OID 16710)
-- Name: vw_statement_search; Type: VIEW; Schema: public; Owner: spa_service
--

CREATE VIEW public.vw_statement_search AS
 SELECT s.id,
    s.business_key,
    s.city,
    s.district,
    s.due_date,
    s.finished,
    s.receipt_date,
    s.title,
    s.statementtype_id,
    s.contact_db_id,
    upper((((((((((s.id)::text || '|@|'::text) || (COALESCE(t.name, ''::character varying))::text) || '|@|'::text) || ((COALESCE(s.title, ''::character varying))::text || '|@|'::text)) || (COALESCE(s.city, ''::character varying))::text) || '|@|'::text) || (COALESCE(s.district, ''::character varying))::text) || '|@|'::text)) AS searchfield
   FROM public.tbl_statement s,
    public.tbl_statementtype t
  WHERE (s.statementtype_id = t.id);


ALTER TABLE public.vw_statement_search OWNER TO spa_service;

--
-- TOC entry 209 (class 1259 OID 16715)
-- Name: vw_statement_search_user; Type: VIEW; Schema: public; Owner: spa_service
--

CREATE VIEW public.vw_statement_search_user AS
 SELECT DISTINCT s.id,
    s.business_key,
    s.city,
    s.district,
    s.due_date,
    s.finished,
    s.receipt_date,
    s.title,
    s.statementtype_id,
    s.contact_db_id,
    e.user_id,
    upper((((((((((s.id)::text || '|@|'::text) || (COALESCE(t.name, ''::character varying))::text) || '|@|'::text) || ((COALESCE(s.title, ''::character varying))::text || '|@|'::text)) || (COALESCE(s.city, ''::character varying))::text) || '|@|'::text) || (COALESCE(s.district, ''::character varying))::text) || '|@|'::text)) AS searchfield
   FROM public.tbl_statement s,
    public.tbl_statementtype t,
    public.tbl_statement_edit_log e
  WHERE ((s.statementtype_id = t.id) AND (e.statement_id = s.id));


ALTER TABLE public.vw_statement_search_user OWNER TO spa_service;

--
-- TOC entry 2079 (class 2604 OID 16720)
-- 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 2080 (class 2604 OID 16721)
-- 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 2081 (class 2604 OID 16722)
-- 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 2082 (class 2604 OID 16723)
-- 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 2083 (class 2604 OID 16724)
-- 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 2084 (class 2604 OID 16725)
-- 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 2085 (class 2604 OID 16726)
-- 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 2086 (class 2604 OID 16727)
-- 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 2087 (class 2604 OID 16728)
-- 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 2088 (class 2604 OID 16729)
-- 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 2089 (class 2604 OID 16730)
-- 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 2288 (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 2289 (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 2290 (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 2291 (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 2262 (class 0 OID 16611)
-- Dependencies: 181
-- Data for Name: tbl_attachment; Type: TABLE DATA; Schema: public; Owner: spa_service
--



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



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



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

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


--
-- TOC entry 2269 (class 0 OID 16638)
-- Dependencies: 188
-- Data for Name: tbl_departmentstructure; Type: TABLE DATA; Schema: public; Owner: spa_service
--

INSERT INTO public.tbl_departmentstructure VALUES (2, '{
"Ort#Ortsteil" : {
"provides": ["Strom", "Gas", "Wasser", "Straßenbeleuchtung"],
"departments" : {
"Allgemein": ["Medianet", "Wasser", "Gas HD"],
"Regionalstelle Darmstadt": ["Strom Planung/Bau", "Strom Betrieb", "Gas Planung/Bau","Gas Betrieb","Straßenbeleuchtung"],
"Regionalstelle Groß-Umstadt": ["Strom Planung/Bau", "Strom Betrieb", "Gas Planung/Bau","Gas Betrieb","Straßenbeleuchtung"],
"Regionalstelle Heppenheim": ["Strom Planung/Bau", "Strom Betrieb", "Gas Planung/Bau","Gas Betrieb","Straßenbeleuchtung"]
}
},
"Heppenheim#Heppenheim" : {
"provides": ["Strom", "Gas", "Wasser", "Straßenbeleuchtung"],
"departments" : {
"Regionalstelle Heppenheim": ["Strom Planung/Bau", "Strom Betrieb", "Gas Planung/Bau","Gas Betrieb","Straßenbeleuchtung"]
}
},
"Darmstadt#Darmstadt" : {
"provides": ["Strom", "Gas", "Wasser", "Straßenbeleuchtung"],
"departments" : {
"Regionalstelle Darmstadt": ["Strom Planung/Bau", "Strom Betrieb", "Gas Planung/Bau","Gas Betrieb","Straßenbeleuchtung"]
}
},
"Groß-Umstadt#Groß-Umstadt" : {
"provides": ["Strom", "Gas", "Wasser", "Straßenbeleuchtung"],
"departments" : {
"Regionalstelle Groß-Umstadt": ["Strom Planung/Bau", "Strom Betrieb", "Gas Planung/Bau","Gas Betrieb","Straßenbeleuchtung"]
}
}

}', 1);


--
-- TOC entry 2271 (class 0 OID 16646)
-- Dependencies: 190
-- Data for Name: tbl_reqdepartment; Type: TABLE DATA; Schema: public; Owner: spa_service
--



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



--
-- TOC entry 2274 (class 0 OID 16657)
-- Dependencies: 193
-- Data for Name: tbl_statement2parent; Type: TABLE DATA; Schema: public; Owner: spa_service
--



--
-- TOC entry 2275 (class 0 OID 16660)
-- Dependencies: 194
-- Data for Name: tbl_statement_edit_log; Type: TABLE DATA; Schema: public; Owner: spa_service
--



--
-- TOC entry 2278 (class 0 OID 16667)
-- Dependencies: 197
-- Data for Name: tbl_statementtype; Type: TABLE DATA; Schema: public; Owner: spa_service
--

INSERT INTO public.tbl_statementtype VALUES (1, 'Bauleitplanung');
INSERT INTO public.tbl_statementtype VALUES (2, 'Mitverlegungsanfrage');
INSERT INTO public.tbl_statementtype VALUES (3, 'Bauvoranfrage');
INSERT INTO public.tbl_statementtype VALUES (4, 'Planfeststellungsverfahren');
INSERT INTO public.tbl_statementtype VALUES (5, 'Formlose Anfrage');


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

INSERT INTO public.tbl_tag VALUES ('email-text', 'Emailanfrage');
INSERT INTO public.tbl_tag VALUES ('email', 'Email');
INSERT INTO public.tbl_tag VALUES ('outbox', 'Ausgang');
INSERT INTO public.tbl_tag VALUES ('consideration', 'Abwägungsergebnis');
INSERT INTO public.tbl_tag VALUES ('statement', 'Stellungnahme');
INSERT INTO public.tbl_tag VALUES ('cover-letter', 'Anschreiben');
INSERT INTO public.tbl_tag VALUES ('overview', 'Übersicht');
INSERT INTO public.tbl_tag VALUES ('expertise', 'Gutachten');
INSERT INTO public.tbl_tag VALUES ('plan', 'Plan');
INSERT INTO public.tbl_tag VALUES ('explanatory-report', 'Erläuterungsbericht');


--
-- TOC entry 2281 (class 0 OID 16678)
-- Dependencies: 200
-- Data for Name: tbl_textblockdefinition; Type: TABLE DATA; Schema: public; Owner: spa_service
--

INSERT INTO public.tbl_textblockdefinition VALUES (1, '{
    "groups": [
        {
            "groupName": "group1",
            "textBlocks": [
                {
                    "excludes": [],
                    "id": "1a",
                    "requires": [
                        {
                            "ids": [
                                "1b",
                                "1c"
                            ],
                            "type": "xor"
                        }
                    ],
                    "text": "Wir nehmen dazu Stellung für die Netze der ENTEGA AG und der e-netz Südhessen AG und ENTEGA Medianet GmbH."
                },
                {
                    "excludes": [
                        "1c",
                        "1d"
                    ],
                    "id": "1b",
                    "requires": [
                        {
                            "ids": [
                                "1a"
                            ],
                            "type": "and"
                        }
                    ],
                    "text": "Im Gebiet der Stadt <t:city> sind wir Netzbetreiber der Sparte(n) <t:sectors>."
                },
                {
                    "excludes": [
                        "1b",
                        "1d"
                    ],
                    "id": "1c",
                    "requires": [
                        {
                            "ids": [
                                "1a"
                            ],
                            "type": "and"
                        }
                    ],
                    "text": "Im Gebiet der Stadt <t:city> sind wir Netzbetreiber der Sparte(n) <t:sectors>. Bitte beteiligen Sie auch die GGEW für die Sparte(n) <f:ggew_sparten> als Träger Öffentl. Belange am Verfahren."
                },
                {
                    "excludes": [
                        "1b",
                        "1d"
                    ],
                    "id": "1d",
                    "requires": [
                        {
                            "ids": [
                                "1a"
                            ],
                            "type": "and"
                        }
                    ],
                    "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."
                },
                 {
                    "excludes": [ ],
                    "id": "1e",
                    "requires": [ ],
                    "text": "Test block I Infodata:\n**Contact data:**\n* Community: <t:c-community>\n* CommunitySuffix: <t:c-communitySuffix>\n* Company: <t:c-company>\n* Email: <t:c-email>\n* FirstName: <t:c-firstName>\n* LastName: <t:c-lastName>\n* HouseNumber: <t:c-houseNumber>\n* PostCode: <t:c-postCode>\n* Salutation: <t:c-salutation>\n* Street: <t:c-street>\n* Title: <t:c-title>\n**Info data:**\n* Title: <t:title>\n* DueDate: <t:dueDate>\n* ReceiptDate: <t:receiptDate>\n* id:  <t:id>\n* City: <t:city>\n* District: <t:district>\n"
             }
        
            ]
        },
        {
            "groupName": "group2",
            "textBlocks": [
                {
                    "excludes": [],
                    "id": "select test",
                    "requires": [],
                    "text": "**Das ist ein select Test**\nWählen sie eine Zahl zwischen null und neun:\nSie haben die <s:numbers> gewählt.\n"
                },
                {
                    "excludes": [],
                    "id": "date test",
                    "requires": [],
                    "text": "**Das ist ein Datum Test**\nWählen sie ein Datum:\nSie haben die <d:date1> gewählt.\n"
                }
            ]
        }
    ],
    "negativeGroups" : [
         {
            "groupName": "negative group",
            "textBlocks": [
                {
                    "excludes": [],
                    "id": "negative 1",
                    "requires": [],
                    "text": "Wir sind in ihrem Gebiet nicht zuständig. Bitte wenden Sie sich an ihren lokalen Energieversorger.\n"
                },
                {
                    "excludes": [],
                    "id": "negative 2",
                    "requires": [],
                    "text": "Ihre Anfrage beinhaltet nicht genug Informationen, so dass wir eine Stellungnahme zu Ihrem Sachverhalt abgeben können.\n\nBitte reichen Sie die benötiten Unterlagen erneut ein oder wenden sich an unseren Sachbearbeiter."
                }
            ]
        }
    ],
    "selects": {
        "numbers": [
            "null",
            "eins",
            "zwei",
            "drei",
            "vier",
            "fünf",
            "sechs",
            "sieben",
            "acht",
            "neun"
        ]
    }
}', 1);


--
-- TOC entry 2283 (class 0 OID 16686)
-- Dependencies: 202
-- Data for Name: tbl_user; Type: TABLE DATA; Schema: public; Owner: spa_service
--

INSERT INTO public.tbl_user VALUES (3, 'Spa', 'Admin', 'spa_admin', NULL);
INSERT INTO public.tbl_user VALUES (5, 'Test', 'Kunde', 'spa_customer', NULL);
INSERT INTO public.tbl_user VALUES (2, 'Test', 'Mitarbeiter', 'spa_multi', 'statement-oic@planeit.de');
INSERT INTO public.tbl_user VALUES (6, 'Test', 'Fachbereichsarbeiter', 'spa_division_member', 'statement-user1@planeit.de');
INSERT INTO public.tbl_user VALUES (4, 'Test', 'Genehmiger', 'spa_approver', 'statement-approver@planeit.de');
INSERT INTO public.tbl_user VALUES (7, 'Test', 'Sachbearbeiter', 'spa_oic', 'statement-oic@planeit.de');


--
-- TOC entry 2284 (class 0 OID 16692)
-- Dependencies: 203
-- Data for Name: tbl_user2department; Type: TABLE DATA; Schema: public; Owner: spa_service
--

INSERT INTO public.tbl_user2department VALUES (6, 5);


--
-- TOC entry 2286 (class 0 OID 16697)
-- Dependencies: 205
-- Data for Name: tbl_workflowdata; Type: TABLE DATA; Schema: public; Owner: spa_service
--



--
-- 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, true);


--
-- 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', 1, true);


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

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


--
-- TOC entry 2313 (class 0 OID 0)
-- Dependencies: 189
-- 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 2314 (class 0 OID 0)
-- Dependencies: 191
-- Name: tbl_reqdepartment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spa_service
--

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


--
-- TOC entry 2315 (class 0 OID 0)
-- Dependencies: 195
-- 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 2316 (class 0 OID 0)
-- Dependencies: 196
-- Name: tbl_statement_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spa_service
--

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


--
-- TOC entry 2317 (class 0 OID 0)
-- Dependencies: 198
-- 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 2318 (class 0 OID 0)
-- Dependencies: 201
-- 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 2319 (class 0 OID 0)
-- Dependencies: 204
-- 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 2320 (class 0 OID 0)
-- Dependencies: 206
-- Name: tbl_workflowdata_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spa_service
--

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


--
-- TOC entry 2292 (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 2113 (class 2606 OID 16732)
-- Name: tbl_tag pk_tbl_tag_id; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

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


--
-- TOC entry 2093 (class 2606 OID 16734)
-- 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 2091 (class 2606 OID 16736)
-- 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 2095 (class 2606 OID 16738)
-- 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 2097 (class 2606 OID 16740)
-- 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 2101 (class 2606 OID 16742)
-- 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 2103 (class 2606 OID 16744)
-- 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 2107 (class 2606 OID 16746)
-- 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 2109 (class 2606 OID 16748)
-- 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 2105 (class 2606 OID 16750)
-- 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 2111 (class 2606 OID 16752)
-- 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 2117 (class 2606 OID 16754)
-- 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 2123 (class 2606 OID 16756)
-- 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 2119 (class 2606 OID 16758)
-- 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 2125 (class 2606 OID 16760)
-- 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 2115 (class 2606 OID 16762)
-- Name: tbl_tag u_tbl_tag_id; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_tag
    ADD CONSTRAINT u_tbl_tag_id UNIQUE (id);


--
-- TOC entry 2121 (class 2606 OID 16764)
-- 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 2099 (class 2606 OID 16766)
-- 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 2127 (class 2606 OID 16768)
-- Name: tbl_workflowdata uq_wfd_statementId; Type: CONSTRAINT; Schema: public; Owner: spa_service
--

ALTER TABLE ONLY public.tbl_workflowdata
    ADD CONSTRAINT "uq_wfd_statementId" UNIQUE (statement_id);


--
-- TOC entry 2139 (class 2606 OID 16769)
-- 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 2141 (class 2606 OID 16774)
-- 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 2133 (class 2606 OID 16779)
-- 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 2129 (class 2606 OID 16784)
-- 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 2134 (class 2606 OID 16789)
-- 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 2137 (class 2606 OID 16794)
-- 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 2142 (class 2606 OID 16799)
-- 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 2135 (class 2606 OID 16804)
-- 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 2131 (class 2606 OID 16809)
-- 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 2143 (class 2606 OID 16814)
-- 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 2128 (class 2606 OID 16819)
-- 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 2138 (class 2606 OID 16824)
-- 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 2132 (class 2606 OID 16829)
-- 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 2130 (class 2606 OID 16834)
-- 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 2136 (class 2606 OID 16839)
-- 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 2144 (class 2606 OID 16844)
-- 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 2140 (class 2606 OID 16849)
-- 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);