Revision 57518
Added by Michele Artini almost 4 years ago
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