--
-- Name: hl7_message_validation; Type: TABLE; Schema: public; Owner: epoiseau; Tablespace: 
--

CREATE TABLE hl7_message_validation (
    id integer NOT NULL,
    message_oid character varying(255),
    referenced_standard text,
    context_validation text,
    message_metadata text,
    result_overview text,
    summary_results text,
    detailed_results text,
    parsing_result text,
    active boolean,
    mirth_input_id integer
);

	
--
-- Name: hl7_message_validation_id_seq; Type: SEQUENCE; Schema: public; Owner: epoiseau
--

CREATE SEQUENCE hl7_message_validation_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;





--
-- Name: id; Type: DEFAULT; Schema: public; Owner: epoiseau
--

ALTER TABLE hl7_message_validation ALTER COLUMN id SET DEFAULT nextval('hl7_message_validation_id_seq');


--
-- Name: hl7_message_validation_pkey; Type: CONSTRAINT; Schema: public; Owner: epoiseau; Tablespace: 
--

ALTER TABLE ONLY hl7_message_validation
    ADD CONSTRAINT hl7_message_validation_pkey PRIMARY KEY (id);


--
-- Name: hl7_message_validation_mirth_input_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: epoiseau
--

ALTER TABLE ONLY hl7_message_validation
    ADD CONSTRAINT hl7_message_validation_mirth_input_id_fkey FOREIGN KEY (mirth_input_id) REFERENCES mirth_input(id);


--
-- PostgreSQL database dump complete
--
