--
-- PostgreSQL database dump
--

-- Dumped from database version 9.2.8
-- Dumped by pg_dump version 9.2.8
-- Started on 2014-09-18 13:01:12 CAT

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

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 330 (class 1259 OID 17318)
-- Name: programinstance; Type: TABLE; Schema: public; Owner: dhis; Tablespace: 
--

CREATE TABLE programinstance (
    programinstanceid integer NOT NULL,
    uid character varying(11),
    created timestamp without time zone,
    lastupdated timestamp without time zone,
    dateofincident timestamp without time zone NOT NULL,
    enrollmentdate timestamp without time zone NOT NULL,
    enddate timestamp without time zone,
    followup boolean,
    status integer,
    trackedentityinstanceid integer,
    programid integer NOT NULL,
    trackedentitycommentid integer
);


ALTER TABLE public.programinstance OWNER TO dhis;

--
-- TOC entry 2988 (class 0 OID 17318)
-- Dependencies: 330
-- Data for Name: programinstance; Type: TABLE DATA; Schema: public; Owner: dhis
--

COPY programinstance (programinstanceid, uid, created, lastupdated, dateofincident, enrollmentdate, enddate, followup, status, trackedentityinstanceid, programid, trackedentitycommentid) FROM stdin;
1456	OrD7U4HnTdb	2014-08-01 14:45:48.973	2014-08-01 14:48:33.294	2014-08-01 14:45:48.973	2014-08-01 14:45:48.973	2014-08-01 14:48:33.294	f	1	1455	342	\N
2164	dcf9SqCdDlg	2014-09-08 18:26:11.834	2014-09-08 18:26:11.834	2014-09-08 18:26:11.834	2014-09-08 18:26:11.834	\N	f	0	\N	2162	\N
329	wZ9PiD2OMv7	2014-07-16 10:13:54.028	2014-07-16 10:13:54.028	2014-07-16 10:13:54.028	2014-07-16 10:13:54.028	\N	f	0	\N	327	\N
2589	IpFQT5LuBCj	2014-09-17 13:03:14.274	2014-09-17 13:03:37.207	2014-08-01 00:00:00	2014-08-01 00:00:00	2014-09-17 13:03:37.207	f	1	2588	342	\N
2595	J0ELyFh2DDl	2014-09-17 14:54:59.772	2014-09-17 14:54:59.772	2014-09-17 14:54:59.771	2014-09-17 14:54:59.771	\N	f	0	\N	2593	\N
562	AwxgcjR4Y7Z	2014-07-24 14:50:22.691	2014-07-24 14:50:22.691	2014-07-24 14:50:22.691	2014-07-24 14:50:22.691	\N	f	0	\N	560	\N
1442	mz5bz73RYGM	2014-08-01 10:42:10.795	2014-08-01 10:42:10.795	2014-08-01 10:42:10.794	2014-08-01 10:42:10.794	\N	f	0	\N	1440	\N
\.


--
-- TOC entry 2876 (class 2606 OID 17322)
-- Name: programinstance_pkey; Type: CONSTRAINT; Schema: public; Owner: dhis; Tablespace: 
--

ALTER TABLE ONLY programinstance
    ADD CONSTRAINT programinstance_pkey PRIMARY KEY (programinstanceid);


--
-- TOC entry 2878 (class 2606 OID 19981)
-- Name: programinstance_uid_key; Type: CONSTRAINT; Schema: public; Owner: dhis; Tablespace: 
--

ALTER TABLE ONLY programinstance
    ADD CONSTRAINT programinstance_uid_key UNIQUE (uid);


--
-- TOC entry 2874 (class 1259 OID 20100)
-- Name: index_programinstance; Type: INDEX; Schema: public; Owner: dhis; Tablespace: 
--

CREATE INDEX index_programinstance ON programinstance USING btree (programinstanceid);


--
-- TOC entry 2881 (class 2606 OID 19264)
-- Name: fk_programinstance_commentid; Type: FK CONSTRAINT; Schema: public; Owner: dhis
--

ALTER TABLE ONLY programinstance
    ADD CONSTRAINT fk_programinstance_commentid FOREIGN KEY (trackedentitycommentid) REFERENCES trackedentitycomment(trackedentitycommentid);


--
-- TOC entry 2880 (class 2606 OID 19259)
-- Name: fk_programinstance_programid; Type: FK CONSTRAINT; Schema: public; Owner: dhis
--

ALTER TABLE ONLY programinstance
    ADD CONSTRAINT fk_programinstance_programid FOREIGN KEY (programid) REFERENCES program(programid);


--
-- TOC entry 2879 (class 2606 OID 19254)
-- Name: fk_programinstance_trackedentityinstanceid; Type: FK CONSTRAINT; Schema: public; Owner: dhis
--

ALTER TABLE ONLY programinstance
    ADD CONSTRAINT fk_programinstance_trackedentityinstanceid FOREIGN KEY (trackedentityinstanceid) REFERENCES trackedentityinstance(trackedentityinstanceid);


-- Completed on 2014-09-18 13:01:12 CAT

--
-- PostgreSQL database dump complete
--