db.migration.v0.22.0.7__clterm_cmoterm.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of agr_curation_api Show documentation

This software is for using the curation api as a library

There is a newer version: v0.35.0

-- CLTerm tables
CREATE TABLE clterm (
    curie character varying(255) NOT NULL
);

ALTER TABLE ONLY clterm
    ADD CONSTRAINT clterm_pkey PRIMARY KEY (curie);

ALTER TABLE ONLY clterm
    ADD CONSTRAINT clterm_curie_fk FOREIGN KEY (curie) REFERENCES anatomicalterm(curie);


CREATE TABLE clterm_aud (
    curie character varying(255) NOT NULL,
    rev integer NOT NULL
);

ALTER TABLE clterm_aud
    ADD CONSTRAINT clterm_aud_pkey PRIMARY KEY (curie, rev);

ALTER TABLE ONLY clterm_aud
    ADD CONSTRAINT clterm_aud_curie_rev_fk FOREIGN KEY (curie, rev) REFERENCES anatomicalterm_aud(curie, rev);

-- CMOTerm tables
CREATE TABLE cmoterm (
    curie character varying(255) NOT NULL
);

ALTER TABLE ONLY cmoterm
    ADD CONSTRAINT cmoterm_pkey PRIMARY KEY (curie);

ALTER TABLE ONLY cmoterm
    ADD CONSTRAINT cmoterm_curie_fk FOREIGN KEY (curie) REFERENCES ontologyterm(curie);

CREATE TABLE cmoterm_aud (
    curie character varying(255) NOT NULL,
    rev integer NOT NULL
);

ALTER TABLE cmoterm_aud
    ADD CONSTRAINT cmoterm_aud_pkey PRIMARY KEY (curie, rev);

ALTER TABLE ONLY cmoterm_aud
    ADD CONSTRAINT cmoterm_aud_curie_rev_fk FOREIGN KEY (curie, rev) REFERENCES ontologyterm_aud(curie, rev);