Project

General

Profile

« Previous | Next » 

Revision 57518

View differences:

schema.sql
120 120

  
121 121
CREATE TABLE openaire_simrels (
122 122
	local_id         text REFERENCES organizations(id) ON UPDATE CASCADE,
123
 	oa_id            text NOT NULL,
124 123
	oa_original_id   text NOT NULL,
125 124
	oa_name          text NOT NULL,
126 125
	oa_acronym       text,
......
128 127
	oa_url           text,
129 128
	oa_collectedfrom text,
130 129
	reltype          text NOT NULL DEFAULT 'suggested',
131
	PRIMARY KEY (local_id, oa_id)
130
	PRIMARY KEY (local_id, oa_original_id)
132 131
);
133 132
CREATE INDEX openaire_simrels_local_id_idx ON openaire_simrels(local_id);
134 133

  

Also available in: Unified diff