-- Name: stemtag; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE stemtag (

    stemtag_id integer NOT NULL,

    stemobservation_id integer NOT NULL,

    tag text NOT NULL,

    iscurrent boolean DEFAULT true NOT NULL

);

--

-- Name: stemtag_stemtag_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

CREATE SEQUENCE stemtag_stemtag_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

-- Name: stemtag_stemtag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

ALTER SEQUENCE stemtag_stemtag_id_seq OWNED BY stemtag.stemtag_id;

--

-- Name: stemtag_id; Type: DEFAULT; Schema: public; Owner: -

--

ALTER TABLE stemtag ALTER COLUMN stemtag_id SET DEFAULT nextval('stemtag_stemtag_id_seq'::regclass);

--

-- Name: stemtag_current_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE ONLY stemtag

    ADD CONSTRAINT stemtag_current_unique UNIQUE (stemobservation_id, iscurrent);

--

-- Name: stemtag_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE ONLY stemtag

    ADD CONSTRAINT stemtag_pkey PRIMARY KEY (stemtag_id);

--

-- Name: stemtag_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE ONLY stemtag

    ADD CONSTRAINT stemtag_unique UNIQUE (stemobservation_id, tag);

--

-- Name: stemtag_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY stemtag

    ADD CONSTRAINT stemtag_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;

--