Revision 61899
Added by Michele Artini over 1 year ago
| modules/dnet-isti/trunk/src/main/resources/eu/dnetlib/isti/sql/create_affiliations_tables.sql | ||
|---|---|---|
| 15 | 15 |
pid varchar(32) REFERENCES persons(id), |
| 16 | 16 |
gid varchar(16) REFERENCES groups(id), |
| 17 | 17 |
year int, |
| 18 |
PRIMARY KEY (pid, gid, year) |
|
| 18 |
PRIMARY KEY (pid, gid, year), |
|
| 19 |
FOREIGN KEY (pid) REFERENCES persons(id), |
|
| 20 |
FOREIGN KEY (gid) REFERENCES groups(id) |
|
| 19 | 21 |
); |
| 20 | 22 |
|
| 21 | 23 |
INSERT INTO groups(id, name, type) VALUES ('UNKNOWN', 'UNKNOWN', 'UNKNOWN');
|
Also available in: Unified diff