db.migration.v0.31.0.2__genoterm.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

-- GENOTerm tables
CREATE TABLE genoterm (
    id bigint NOT NULL
);

ALTER TABLE ONLY genoterm
    ADD CONSTRAINT genoterm_pkey PRIMARY KEY (id);

ALTER TABLE ONLY genoterm
    ADD CONSTRAINT genoterm_id_fk FOREIGN KEY (id) REFERENCES ontologyterm(id);