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

--

CREATE TABLE threatened_taxonlabel (

    taxonlabel_id integer NOT NULL

);

--

-- Name: threatened_taxonlabel_view; Type: VIEW; Schema: public; Owner: -

--

CREATE VIEW threatened_taxonlabel_view AS

    SELECT accepted_taxonlabel_descendant.descendant_id AS taxonlabel_id FROM ((taxonlabel datasource_taxonlabel JOIN taxonlabel accepted_taxonlabel ON ((accepted_taxonlabel.taxonlabel_id = datasource_taxonlabel.canon_label_id))) JOIN taxonlabel_relationship accepted_taxonlabel_descendant ON ((accepted_taxonlabel_descendant.ancestor_id = accepted_taxonlabel.taxonlabel_id))) WHERE (((datasource_taxonlabel.reference_id = (SELECT reference.reference_id FROM reference WHERE (reference.shortname = 'IUCN'::text))) AND (datasource_taxonlabel.taxonomicname IS NOT NULL)) AND (accepted_taxonlabel.rank >= 'species'::taxonrank));

--

-- Data for Name: threatened_taxonlabel; Type: TABLE DATA; Schema: public; Owner: -

--

--

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

--

ALTER TABLE ONLY threatened_taxonlabel

    ADD CONSTRAINT threatened_taxonlabel_pkey PRIMARY KEY (taxonlabel_id);

--

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

--

ALTER TABLE ONLY threatened_taxonlabel

    ADD CONSTRAINT threatened_taxonlabel_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;

--