 -- Data for Name: patient; Type: TABLE DATA; Schema: public; Owner: postgres
 --
 
-COPY patient (pat_name, dob, local_pat_id, mpi_pat_id, gender) FROM stdin;
+COPY patient (pat_name, dob, local_pat_id, mpi_pat_id, gender, height, weight) FROM stdin;
 \.
 
 



--
-- Name: exams_derived_values; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE exams_derived_values (
    exam_uid text NOT NULL,
    std_name text NOT NULL,
    value text NOT NULL,
    unit text NOT NULL,
    algorithm text
);


ALTER TABLE public.exams_derived_values OWNER TO postgres;

--
-- Name: TABLE exams_derived_values; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE exams_derived_values IS 'This is for exam level data that has to be calculated. The data sources would often come from teh examsMappedValues table, and the algorithm used would be a stored procedure, listed in dictAlgorithms ';


--
-- Name: exams_mapped_values; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE exams_mapped_values (
    exam_uid text NOT NULL,
    std_name text NOT NULL,
    value text NOT NULL,
    unit text NOT NULL
);


ALTER TABLE public.exams_mapped_values OWNER TO postgres;

--
-- Name: exams_to_process; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--


--

CREATE VIEW derived_scanner_version AS
    SELECT derived_view.std_name, derived_view.unit, derived_view.scope, known_scanners.model, known_scanners.group_id FROM derived_view, known_scanners WHERE ((derived_view.version_id)::oid = (known_scanners.version_id)::oid) ORDER BY known_scanners.version_id;


ALTER TABLE public.derived_scanner_version OWNER TO postgres;
