db.migration.v0.13.0.2__agr_curation_api.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

-- Create AlleleMutationTypeSlotAnnotation tables
CREATE TABLE allelemutationtypeslotannotation (
	id bigint CONSTRAINT allelemutationtypeslotannotation_pkey PRIMARY KEY,
	singleallele_curie varchar(255)
	);

ALTER TABLE allelemutationtypeslotannotation
	ADD CONSTRAINT allelemutationtypeslotannotationtype_id_fk
		FOREIGN KEY (id) REFERENCES slotannotation (id);
		
ALTER TABLE allelemutationtypeslotannotation
	ADD CONSTRAINT allelemutationtypeslotannotationtype_singleallele_curie_fk
		FOREIGN KEY (singleallele_curie) REFERENCES allele (curie);	

CREATE TABLE allelemutationtypeslotannotation_aud (
	id bigint,
	singleallele_curie varchar(255),
	rev integer NOT NULL,
	PRIMARY KEY (id, rev)
);

ALTER TABLE allelemutationtypeslotannotation_aud
	ADD CONSTRAINT allelemutationtypeslotannotation_aud_id_rev_fk
		FOREIGN KEY (id, rev) REFERENCES slotannotation_aud;

CREATE TABLE allelemutationtypeslotannotation_soterm (
	allelemutationtypeslotannotation_id bigint NOT NULL,
	mutationtypes_curie varchar(255) NOT NULL
);

ALTER TABLE allelemutationtypeslotannotation_soterm
	ADD CONSTRAINT allelemutationtypeslotannotation_aud_amsa_id_fk
		FOREIGN KEY (allelemutationtypeslotannotation_id) REFERENCES allelemutationtypeslotannotation (id);
		
ALTER TABLE allelemutationtypeslotannotation_soterm
	ADD CONSTRAINT allelemutationtypeslotannotation_aud_mutationtypes_curie_fk
		FOREIGN KEY (mutationtypes_curie) REFERENCES soterm (curie);
		
CREATE TABLE allelemutationtypeslotannotation_soterm_aud (
	allelemutationtypeslotannotation_id bigint NOT NULL,
	mutationtypes_curie varchar(255) NOT NULL,
	rev integer NOT NULL,
	revtype smallint,
	PRIMARY KEY (rev, allelemutationtypeslotannotation_id, mutationtypes_curie)
);

ALTER TABLE allelemutationtypeslotannotation_soterm_aud
	ADD CONSTRAINT allelemutationtypeslotannotation_aud_rev_fk
		FOREIGN KEY (rev) REFERENCES revinfo (rev);