Revision 1076
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 847 | 847 |
datasource_id integer, |
| 848 | 848 |
location_id integer, |
| 849 | 849 |
project_id integer, |
| 850 |
authoreventcode text,
|
|
| 850 |
authorlocationcode text,
|
|
| 851 | 851 |
accessioncode text, |
| 852 | 852 |
sourceaccessioncode text, |
| 853 | 853 |
previous_id integer, |
| ... | ... | |
| 3378 | 3378 |
-- |
| 3379 | 3379 |
|
| 3380 | 3380 |
ALTER TABLE ONLY locationevent |
| 3381 |
ADD CONSTRAINT locationevent_keys_datasource_authorcode UNIQUE (project_id, authoreventcode, obsstartdate);
|
|
| 3381 |
ADD CONSTRAINT locationevent_keys_datasource_authorcode UNIQUE (project_id, authorlocationcode, obsstartdate);
|
|
| 3382 | 3382 |
|
| 3383 | 3383 |
|
| 3384 | 3384 |
-- |
| ... | ... | |
| 3394 | 3394 |
-- |
| 3395 | 3395 |
|
| 3396 | 3396 |
ALTER TABLE ONLY locationevent |
| 3397 |
ADD CONSTRAINT locationevent_keys_parent_authorcode UNIQUE (parent_id, authoreventcode);
|
|
| 3397 |
ADD CONSTRAINT locationevent_keys_parent_authorcode UNIQUE (parent_id, authorlocationcode);
|
|
| 3398 | 3398 |
|
| 3399 | 3399 |
|
| 3400 | 3400 |
-- |
Also available in: Unified diff
VegBIEN: Renamed locationevent.authoreventcode to authorlocationcode to reflect that datasources usually use an author-defined code for a plot rather than a plot event