Revision 57435
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,
|
|
124 |
oa_original_id text, |
|
125 |
oa_name text, |
|
123 |
oa_id text NOT NULL,
|
|
124 |
oa_original_id text NOT NULL,
|
|
125 |
oa_name text NOT NULL,
|
|
126 | 126 |
oa_acronym text, |
127 | 127 |
oa_country text, |
128 | 128 |
oa_url text, |
129 | 129 |
oa_collectedfrom text, |
130 |
reltype text NOT NULL DEFAULT 'suggested',
|
|
130 |
reltype text NOT NULL DEFAULT 'suggested', |
|
131 | 131 |
PRIMARY KEY (local_id, oa_id) |
132 | 132 |
); |
133 | 133 |
CREATE INDEX openaire_simrels_local_id_idx ON openaire_simrels(local_id); |
Also available in: Unified diff
some "not null"