--
-- PostgreSQL database dump
--

\connect - tilfordc

SET search_path = public, pg_catalog;

--
-- TOC entry 2 (OID 23419)
-- Name: seqname_seq; Type: SEQUENCE; Schema: public; Owner: tilfordc
--

CREATE SEQUENCE seqname_seq
    START 1
    INCREMENT 1
    MAXVALUE 9223372036854775807
    MINVALUE 1
    CACHE 1;


--
-- TOC entry 3 (OID 23421)
-- Name: class_list_seq; Type: SEQUENCE; Schema: public; Owner: tilfordc
--

CREATE SEQUENCE class_list_seq
    START 1
    INCREMENT 1
    MAXVALUE 9223372036854775807
    MINVALUE 1
    CACHE 1;


--
-- TOC entry 4 (OID 23423)
-- Name: transform_seq; Type: SEQUENCE; Schema: public; Owner: tilfordc
--

CREATE SEQUENCE transform_seq
    START 1
    INCREMENT 1
    MAXVALUE 9223372036854775807
    MINVALUE 1
    CACHE 1;


--
-- TOC entry 5 (OID 23425)
-- Name: authority_seq; Type: SEQUENCE; Schema: public; Owner: tilfordc
--

CREATE SEQUENCE authority_seq
    START 1
    INCREMENT 1
    MAXVALUE 9223372036854775807
    MINVALUE 1
    CACHE 1;


--
-- TOC entry 6 (OID 23427)
-- Name: relationship_seq; Type: SEQUENCE; Schema: public; Owner: tilfordc
--

CREATE SEQUENCE relationship_seq
    START 1
    INCREMENT 1
    MAXVALUE 9223372036854775807
    MINVALUE 1
    CACHE 1;


--
-- TOC entry 7 (OID 23429)
-- Name: mapping_seq; Type: SEQUENCE; Schema: public; Owner: tilfordc
--

CREATE SEQUENCE mapping_seq
    START 1
    INCREMENT 1
    MAXVALUE 9223372036854775807
    MINVALUE 1
    CACHE 1;


--
-- TOC entry 8 (OID 23431)
-- Name: authority; Type: TABLE; Schema: public; Owner: tilfordc
--

CREATE TABLE authority (
    authority_id integer NOT NULL,
    upper_name character varying(100),
    authname character varying(100),
    descr character varying(255)
);


--
-- TOC entry 9 (OID 23435)
-- Name: class_list; Type: TABLE; Schema: public; Owner: tilfordc
--

CREATE TABLE class_list (
    class_id integer NOT NULL,
    parent_id integer,
    seqclass character varying(20),
    descr character varying(255)
);


--
-- TOC entry 10 (OID 23439)
-- Name: relationship; Type: TABLE; Schema: public; Owner: tilfordc
--

CREATE TABLE relationship (
    type_id integer NOT NULL,
    label character varying(20),
    reads_forward character varying(50),
    reads_backward character varying(50),
    class1 integer,
    class2 integer,
    descr character varying(255)
);


--
-- TOC entry 11 (OID 23443)
-- Name: seqname; Type: TABLE; Schema: public; Owner: tilfordc
--

CREATE TABLE seqname (
    name_id integer NOT NULL,
    upper_name character varying(100),
    seqname character varying(100)
);


--
-- TOC entry 12 (OID 23447)
-- Name: species; Type: TABLE; Schema: public; Owner: tilfordc
--

CREATE TABLE species (
    tax_id integer NOT NULL,
    taxa_name character varying(255),
    upper_taxa character varying(255)
);


--
-- TOC entry 13 (OID 23451)
-- Name: species_alias; Type: TABLE; Schema: public; Owner: tilfordc
--

CREATE TABLE species_alias (
    tax_id integer,
    alias character varying(255),
    name_class character varying(50)
);


--
-- TOC entry 14 (OID 23453)
-- Name: transform; Type: TABLE; Schema: public; Owner: tilfordc
--

CREATE TABLE transform (
    trans_id integer NOT NULL,
    transname character varying(50),
    step1 double precision,
    step2 double precision
);


--
-- TOC entry 15 (OID 23457)
-- Name: relation; Type: TABLE; Schema: public; Owner: tilfordc
--

CREATE TABLE relation (
    name1 integer,
    name2 integer,
    type_id integer,
    authority_id integer
);


--
-- TOC entry 16 (OID 23459)
-- Name: seq_class; Type: TABLE; Schema: public; Owner: tilfordc
--

CREATE TABLE seq_class (
    class_id integer,
    name_id integer,
    authority_id integer
);


--
-- TOC entry 17 (OID 23461)
-- Name: seq_species; Type: TABLE; Schema: public; Owner: tilfordc
--

CREATE TABLE seq_species (
    tax_id integer,
    name_id integer,
    authority_id integer
);


--
-- TOC entry 18 (OID 23463)
-- Name: mapping; Type: TABLE; Schema: public; Owner: tilfordc
--

CREATE TABLE mapping (
    map_id integer NOT NULL,
    name1 integer,
    start1 double precision,
    end1 double precision,
    name2 integer,
    start2 double precision,
    end2 double precision,
    trans_id integer,
    authority_id integer,
    map_score double precision,
    strand integer
);


--
-- TOC entry 19 (OID 23467)
-- Name: location; Type: TABLE; Schema: public; Owner: tilfordc
--

CREATE TABLE "location" (
    map_id integer,
    start1 double precision,
    end1 double precision,
    start2 double precision
);


--
-- TOC entry 21 (OID 3260248)
-- Name: u_thrty_pprnm; Type: INDEX; Schema: public; Owner: tilfordc
--

CREATE UNIQUE INDEX u_thrty_pprnm ON authority USING btree (upper_name);


--
-- TOC entry 23 (OID 3260249)
-- Name: u_clsslst_sqclss; Type: INDEX; Schema: public; Owner: tilfordc
--

CREATE UNIQUE INDEX u_clsslst_sqclss ON class_list USING btree (seqclass);


--
-- TOC entry 27 (OID 3260250)
-- Name: u_rltnshp_lbl; Type: INDEX; Schema: public; Owner: tilfordc
--

CREATE UNIQUE INDEX u_rltnshp_lbl ON relationship USING btree (label);


--
-- TOC entry 24 (OID 3260251)
-- Name: ifk_rltnshp_clss1; Type: INDEX; Schema: public; Owner: tilfordc
--

CREATE INDEX ifk_rltnshp_clss1 ON relationship USING btree (class1);


--
-- TOC entry 25 (OID 3260252)
-- Name: ifk_rltnshp_clss2; Type: INDEX; Schema: public; Owner: tilfordc
--

CREATE INDEX ifk_rltnshp_clss2 ON relationship USING btree (class2);


--
-- TOC entry 29 (OID 3260253)
-- Name: u_sqnm_pprnm; Type: INDEX; Schema: public; Owner: tilfordc
--

CREATE UNIQUE INDEX u_sqnm_pprnm ON seqname USING btree (upper_name);


--
-- TOC entry 31 (OID 3260254)
-- Name: ifk_spcsls_txd; Type: INDEX; Schema: public; Owner: tilfordc
--

CREATE INDEX ifk_spcsls_txd ON species_alias USING btree (tax_id);


--
-- TOC entry 33 (OID 3260255)
-- Name: rltn_nm1nm2; Type: INDEX; Schema: public; Owner: tilfordc
--

CREATE INDEX rltn_nm1nm2 ON relation USING btree (name1, name2);


--
-- TOC entry 35 (OID 3260256)
-- Name: sqclss_nmd; Type: INDEX; Schema: public; Owner: tilfordc
--

CREATE INDEX sqclss_nmd ON seq_class USING btree (name_id);


--
-- TOC entry 36 (OID 3260257)
-- Name: sqspcs_nmd; Type: INDEX; Schema: public; Owner: tilfordc
--

CREATE INDEX sqspcs_nmd ON seq_species USING btree (name_id);


--
-- TOC entry 38 (OID 3260258)
-- Name: mppng_nm1strt1nd1; Type: INDEX; Schema: public; Owner: tilfordc
--

CREATE INDEX mppng_nm1strt1nd1 ON mapping USING btree (name1, start1, end1);


--
-- TOC entry 39 (OID 3260259)
-- Name: mppng_nm2strt2nd2; Type: INDEX; Schema: public; Owner: tilfordc
--

CREATE INDEX mppng_nm2strt2nd2 ON mapping USING btree (name2, start2, end2);


--
-- TOC entry 37 (OID 3260260)
-- Name: mppng_nm1nm2; Type: INDEX; Schema: public; Owner: tilfordc
--

CREATE INDEX mppng_nm1nm2 ON mapping USING btree (name1, name2);


--
-- TOC entry 41 (OID 3260261)
-- Name: ifk_lctn_mpd; Type: INDEX; Schema: public; Owner: tilfordc
--

CREATE INDEX ifk_lctn_mpd ON "location" USING btree (map_id);


--
-- TOC entry 34 (OID 3260262)
-- Name: rltn_nm2; Type: INDEX; Schema: public; Owner: tilfordc
--

CREATE INDEX rltn_nm2 ON relation USING btree (name2);


--
-- TOC entry 20 (OID 23433)
-- Name: pk_thrty_thrtyd; Type: CONSTRAINT; Schema: public; Owner: tilfordc
--

ALTER TABLE ONLY authority
    ADD CONSTRAINT pk_thrty_thrtyd PRIMARY KEY (authority_id);


--
-- TOC entry 22 (OID 23437)
-- Name: pk_clsslst_clssd; Type: CONSTRAINT; Schema: public; Owner: tilfordc
--

ALTER TABLE ONLY class_list
    ADD CONSTRAINT pk_clsslst_clssd PRIMARY KEY (class_id);


--
-- TOC entry 26 (OID 23441)
-- Name: pk_rltnshp_typd; Type: CONSTRAINT; Schema: public; Owner: tilfordc
--

ALTER TABLE ONLY relationship
    ADD CONSTRAINT pk_rltnshp_typd PRIMARY KEY (type_id);


--
-- TOC entry 28 (OID 23445)
-- Name: pk_sqnm_nmd; Type: CONSTRAINT; Schema: public; Owner: tilfordc
--

ALTER TABLE ONLY seqname
    ADD CONSTRAINT pk_sqnm_nmd PRIMARY KEY (name_id);


--
-- TOC entry 30 (OID 23449)
-- Name: pk_spcs_txd; Type: CONSTRAINT; Schema: public; Owner: tilfordc
--

ALTER TABLE ONLY species
    ADD CONSTRAINT pk_spcs_txd PRIMARY KEY (tax_id);


--
-- TOC entry 32 (OID 23455)
-- Name: pk_trnsfrm_trnsd; Type: CONSTRAINT; Schema: public; Owner: tilfordc
--

ALTER TABLE ONLY transform
    ADD CONSTRAINT pk_trnsfrm_trnsd PRIMARY KEY (trans_id);


--
-- TOC entry 40 (OID 23465)
-- Name: pk_mppng_mpd; Type: CONSTRAINT; Schema: public; Owner: tilfordc
--

ALTER TABLE ONLY mapping
    ADD CONSTRAINT pk_mppng_mpd PRIMARY KEY (map_id);


--
-- TOC entry 56 (OID 3260263)
-- Name: RI_ConstraintTrigger_3260263; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON relationship
    FROM class_list
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'relationship', 'class_list', 'UNSPECIFIED', 'class1', 'class_id');


--
-- TOC entry 50 (OID 3260264)
-- Name: RI_ConstraintTrigger_3260264; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON class_list
    FROM relationship
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'relationship', 'class_list', 'UNSPECIFIED', 'class1', 'class_id');


--
-- TOC entry 51 (OID 3260265)
-- Name: RI_ConstraintTrigger_3260265; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON class_list
    FROM relationship
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'relationship', 'class_list', 'UNSPECIFIED', 'class1', 'class_id');


--
-- TOC entry 57 (OID 3260266)
-- Name: RI_ConstraintTrigger_3260266; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON relationship
    FROM class_list
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'relationship', 'class_list', 'UNSPECIFIED', 'class2', 'class_id');


--
-- TOC entry 52 (OID 3260267)
-- Name: RI_ConstraintTrigger_3260267; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON class_list
    FROM relationship
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'relationship', 'class_list', 'UNSPECIFIED', 'class2', 'class_id');


--
-- TOC entry 53 (OID 3260268)
-- Name: RI_ConstraintTrigger_3260268; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON class_list
    FROM relationship
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'relationship', 'class_list', 'UNSPECIFIED', 'class2', 'class_id');


--
-- TOC entry 74 (OID 3260269)
-- Name: RI_ConstraintTrigger_3260269; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON species_alias
    FROM species
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'species_alias', 'species', 'UNSPECIFIED', 'tax_id', 'tax_id');


--
-- TOC entry 72 (OID 3260270)
-- Name: RI_ConstraintTrigger_3260270; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON species
    FROM species_alias
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'species_alias', 'species', 'UNSPECIFIED', 'tax_id', 'tax_id');


--
-- TOC entry 73 (OID 3260271)
-- Name: RI_ConstraintTrigger_3260271; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON species
    FROM species_alias
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'species_alias', 'species', 'UNSPECIFIED', 'tax_id', 'tax_id');


--
-- TOC entry 77 (OID 3260272)
-- Name: RI_ConstraintTrigger_3260272; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON relation
    FROM seqname
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'relation', 'seqname', 'UNSPECIFIED', 'name1', 'name_id');


--
-- TOC entry 60 (OID 3260273)
-- Name: RI_ConstraintTrigger_3260273; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON seqname
    FROM relation
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'relation', 'seqname', 'UNSPECIFIED', 'name1', 'name_id');


--
-- TOC entry 61 (OID 3260274)
-- Name: RI_ConstraintTrigger_3260274; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON seqname
    FROM relation
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'relation', 'seqname', 'UNSPECIFIED', 'name1', 'name_id');


--
-- TOC entry 78 (OID 3260275)
-- Name: RI_ConstraintTrigger_3260275; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON relation
    FROM seqname
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'relation', 'seqname', 'UNSPECIFIED', 'name2', 'name_id');


--
-- TOC entry 62 (OID 3260276)
-- Name: RI_ConstraintTrigger_3260276; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON seqname
    FROM relation
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'relation', 'seqname', 'UNSPECIFIED', 'name2', 'name_id');


--
-- TOC entry 63 (OID 3260277)
-- Name: RI_ConstraintTrigger_3260277; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON seqname
    FROM relation
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'relation', 'seqname', 'UNSPECIFIED', 'name2', 'name_id');


--
-- TOC entry 79 (OID 3260278)
-- Name: RI_ConstraintTrigger_3260278; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON relation
    FROM relationship
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'relation', 'relationship', 'UNSPECIFIED', 'type_id', 'type_id');


--
-- TOC entry 58 (OID 3260279)
-- Name: RI_ConstraintTrigger_3260279; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON relationship
    FROM relation
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'relation', 'relationship', 'UNSPECIFIED', 'type_id', 'type_id');


--
-- TOC entry 59 (OID 3260280)
-- Name: RI_ConstraintTrigger_3260280; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON relationship
    FROM relation
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'relation', 'relationship', 'UNSPECIFIED', 'type_id', 'type_id');


--
-- TOC entry 80 (OID 3260281)
-- Name: RI_ConstraintTrigger_3260281; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON relation
    FROM authority
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'relation', 'authority', 'UNSPECIFIED', 'authority_id', 'authority_id');


--
-- TOC entry 42 (OID 3260282)
-- Name: RI_ConstraintTrigger_3260282; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON authority
    FROM relation
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'relation', 'authority', 'UNSPECIFIED', 'authority_id', 'authority_id');


--
-- TOC entry 43 (OID 3260283)
-- Name: RI_ConstraintTrigger_3260283; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON authority
    FROM relation
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'relation', 'authority', 'UNSPECIFIED', 'authority_id', 'authority_id');


--
-- TOC entry 81 (OID 3260284)
-- Name: RI_ConstraintTrigger_3260284; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON seq_class
    FROM class_list
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'seq_class', 'class_list', 'UNSPECIFIED', 'class_id', 'class_id');


--
-- TOC entry 54 (OID 3260285)
-- Name: RI_ConstraintTrigger_3260285; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON class_list
    FROM seq_class
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'seq_class', 'class_list', 'UNSPECIFIED', 'class_id', 'class_id');


--
-- TOC entry 55 (OID 3260286)
-- Name: RI_ConstraintTrigger_3260286; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON class_list
    FROM seq_class
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'seq_class', 'class_list', 'UNSPECIFIED', 'class_id', 'class_id');


--
-- TOC entry 82 (OID 3260287)
-- Name: RI_ConstraintTrigger_3260287; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON seq_class
    FROM seqname
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'seq_class', 'seqname', 'UNSPECIFIED', 'name_id', 'name_id');


--
-- TOC entry 64 (OID 3260288)
-- Name: RI_ConstraintTrigger_3260288; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON seqname
    FROM seq_class
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'seq_class', 'seqname', 'UNSPECIFIED', 'name_id', 'name_id');


--
-- TOC entry 65 (OID 3260289)
-- Name: RI_ConstraintTrigger_3260289; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON seqname
    FROM seq_class
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'seq_class', 'seqname', 'UNSPECIFIED', 'name_id', 'name_id');


--
-- TOC entry 83 (OID 3260290)
-- Name: RI_ConstraintTrigger_3260290; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON seq_class
    FROM authority
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'seq_class', 'authority', 'UNSPECIFIED', 'authority_id', 'authority_id');


--
-- TOC entry 44 (OID 3260291)
-- Name: RI_ConstraintTrigger_3260291; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON authority
    FROM seq_class
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'seq_class', 'authority', 'UNSPECIFIED', 'authority_id', 'authority_id');


--
-- TOC entry 45 (OID 3260292)
-- Name: RI_ConstraintTrigger_3260292; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON authority
    FROM seq_class
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'seq_class', 'authority', 'UNSPECIFIED', 'authority_id', 'authority_id');


--
-- TOC entry 84 (OID 3260293)
-- Name: RI_ConstraintTrigger_3260293; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON seq_species
    FROM seqname
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'seq_species', 'seqname', 'UNSPECIFIED', 'name_id', 'name_id');


--
-- TOC entry 66 (OID 3260294)
-- Name: RI_ConstraintTrigger_3260294; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON seqname
    FROM seq_species
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'seq_species', 'seqname', 'UNSPECIFIED', 'name_id', 'name_id');


--
-- TOC entry 67 (OID 3260295)
-- Name: RI_ConstraintTrigger_3260295; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON seqname
    FROM seq_species
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'seq_species', 'seqname', 'UNSPECIFIED', 'name_id', 'name_id');


--
-- TOC entry 85 (OID 3260296)
-- Name: RI_ConstraintTrigger_3260296; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON seq_species
    FROM authority
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'seq_species', 'authority', 'UNSPECIFIED', 'authority_id', 'authority_id');


--
-- TOC entry 46 (OID 3260297)
-- Name: RI_ConstraintTrigger_3260297; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON authority
    FROM seq_species
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'seq_species', 'authority', 'UNSPECIFIED', 'authority_id', 'authority_id');


--
-- TOC entry 47 (OID 3260298)
-- Name: RI_ConstraintTrigger_3260298; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON authority
    FROM seq_species
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'seq_species', 'authority', 'UNSPECIFIED', 'authority_id', 'authority_id');


--
-- TOC entry 86 (OID 3260299)
-- Name: RI_ConstraintTrigger_3260299; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON mapping
    FROM seqname
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'mapping', 'seqname', 'UNSPECIFIED', 'name1', 'name_id');


--
-- TOC entry 68 (OID 3260300)
-- Name: RI_ConstraintTrigger_3260300; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON seqname
    FROM mapping
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'mapping', 'seqname', 'UNSPECIFIED', 'name1', 'name_id');


--
-- TOC entry 69 (OID 3260301)
-- Name: RI_ConstraintTrigger_3260301; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON seqname
    FROM mapping
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'mapping', 'seqname', 'UNSPECIFIED', 'name1', 'name_id');


--
-- TOC entry 87 (OID 3260302)
-- Name: RI_ConstraintTrigger_3260302; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON mapping
    FROM seqname
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'mapping', 'seqname', 'UNSPECIFIED', 'name2', 'name_id');


--
-- TOC entry 70 (OID 3260303)
-- Name: RI_ConstraintTrigger_3260303; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON seqname
    FROM mapping
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'mapping', 'seqname', 'UNSPECIFIED', 'name2', 'name_id');


--
-- TOC entry 71 (OID 3260304)
-- Name: RI_ConstraintTrigger_3260304; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON seqname
    FROM mapping
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'mapping', 'seqname', 'UNSPECIFIED', 'name2', 'name_id');


--
-- TOC entry 88 (OID 3260305)
-- Name: RI_ConstraintTrigger_3260305; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON mapping
    FROM transform
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'mapping', 'transform', 'UNSPECIFIED', 'trans_id', 'trans_id');


--
-- TOC entry 75 (OID 3260306)
-- Name: RI_ConstraintTrigger_3260306; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON transform
    FROM mapping
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'mapping', 'transform', 'UNSPECIFIED', 'trans_id', 'trans_id');


--
-- TOC entry 76 (OID 3260307)
-- Name: RI_ConstraintTrigger_3260307; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON transform
    FROM mapping
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'mapping', 'transform', 'UNSPECIFIED', 'trans_id', 'trans_id');


--
-- TOC entry 89 (OID 3260308)
-- Name: RI_ConstraintTrigger_3260308; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON mapping
    FROM authority
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'mapping', 'authority', 'UNSPECIFIED', 'authority_id', 'authority_id');


--
-- TOC entry 48 (OID 3260309)
-- Name: RI_ConstraintTrigger_3260309; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON authority
    FROM mapping
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'mapping', 'authority', 'UNSPECIFIED', 'authority_id', 'authority_id');


--
-- TOC entry 49 (OID 3260310)
-- Name: RI_ConstraintTrigger_3260310; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON authority
    FROM mapping
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'mapping', 'authority', 'UNSPECIFIED', 'authority_id', 'authority_id');


--
-- TOC entry 92 (OID 3260311)
-- Name: RI_ConstraintTrigger_3260311; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON "location"
    FROM mapping
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'location', 'mapping', 'UNSPECIFIED', 'map_id', 'map_id');


--
-- TOC entry 90 (OID 3260312)
-- Name: RI_ConstraintTrigger_3260312; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON mapping
    FROM "location"
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'location', 'mapping', 'UNSPECIFIED', 'map_id', 'map_id');


--
-- TOC entry 91 (OID 3260313)
-- Name: RI_ConstraintTrigger_3260313; Type: TRIGGER; Schema: public; Owner: tilfordc
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON mapping
    FROM "location"
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'location', 'mapping', 'UNSPECIFIED', 'map_id', 'map_id');