--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'SQL_ASCII';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;

--
-- Name: session_status; Type: TYPE; Schema: public; Owner: pracro
--

CREATE TYPE session_status AS ENUM (
    'active',
    'idle',
    'committed'
);


ALTER TYPE public.session_status OWNER TO pracro;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: commits; Type: TABLE; Schema: public; Owner: pracro; Tablespace: 
--

CREATE TABLE commits (
    patientid text,
    template text,
    version text,
    "timestamp" bigint,
    uid bigint NOT NULL,
    status session_status DEFAULT 'committed'::session_status
);


ALTER TABLE public.commits OWNER TO pracro;

SET default_with_oids = true;

--
-- Name: fieldnames; Type: TABLE; Schema: public; Owner: pracro; Tablespace: 
--

CREATE TABLE fieldnames (
    name text,
    description text,
    "timestamp" bigint,
    "extract" boolean DEFAULT false,
    caption text
);


ALTER TABLE public.fieldnames OWNER TO pracro;

--
-- Name: fields; Type: TABLE; Schema: public; Owner: pracro; Tablespace: 
--

CREATE TABLE fields (
    transaction bigint,
    name text,
    value text
);


ALTER TABLE public.fields OWNER TO pracro;

--
-- Name: sessionseq; Type: SEQUENCE; Schema: public; Owner: pracro
--

CREATE SEQUENCE sessionseq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.sessionseq OWNER TO pracro;

--
-- Name: sessionseq; Type: SEQUENCE SET; Schema: public; Owner: pracro
--

SELECT pg_catalog.setval('sessionseq', 433, true);


--
-- Name: transactions; Type: TABLE; Schema: public; Owner: pracro; Tablespace: 
--

CREATE TABLE transactions (
    macro text,
    version text,
    "timestamp" bigint,
    "user" text,
    uid bigint NOT NULL,
    cid bigint
);


ALTER TABLE public.transactions OWNER TO pracro;

--
-- Name: trseq; Type: SEQUENCE; Schema: public; Owner: pracro
--

CREATE SEQUENCE trseq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.trseq OWNER TO pracro;

--
-- Name: trseq; Type: SEQUENCE SET; Schema: public; Owner: pracro
--

SELECT pg_catalog.setval('trseq', 2490, true);


--
-- Name: commits_pkey; Type: CONSTRAINT; Schema: public; Owner: pracro; Tablespace: 
--

ALTER TABLE ONLY commits
    ADD CONSTRAINT commits_pkey PRIMARY KEY (uid);


--
-- Name: transactions_pkey; Type: CONSTRAINT; Schema: public; Owner: pracro; Tablespace: 
--

ALTER TABLE ONLY transactions
    ADD CONSTRAINT transactions_pkey PRIMARY KEY (uid);


--
-- Name: x_fieldnames_name; Type: INDEX; Schema: public; Owner: pracro; Tablespace: 
--

CREATE INDEX x_fieldnames_name ON fieldnames USING btree (name);


--
-- Name: x_fields_name_tid; Type: INDEX; Schema: public; Owner: pracro; Tablespace: 
--

CREATE INDEX x_fields_name_tid ON fields USING btree (name, transaction);


--
-- Name: cid; Type: FK CONSTRAINT; Schema: public; Owner: pracro
--

ALTER TABLE ONLY transactions
    ADD CONSTRAINT cid FOREIGN KEY (cid) REFERENCES commits(uid) MATCH FULL ON DELETE CASCADE;


--
-- Name: transaction; Type: FK CONSTRAINT; Schema: public; Owner: pracro
--

ALTER TABLE ONLY fields
    ADD CONSTRAINT transaction FOREIGN KEY (transaction) REFERENCES transactions(uid) MATCH FULL ON DELETE CASCADE;


--
-- Name: 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;


--
-- PostgreSQL database dump complete
--