Revision 10739
Added by Aaron Marcuse-Kubitza about 11 years ago
| schema.sql | ||
|---|---|---|
| 70 | 70 |
"Allow partial matches?" boolean, |
| 71 | 71 |
"Sort by source" boolean, |
| 72 | 72 |
"Constrain by higher taxonomy" boolean, |
| 73 |
CONSTRAINT download_settings_pkey PRIMARY KEY (id ) |
|
| 73 |
CONSTRAINT download_settings_pkey PRIMARY KEY (id ), |
|
| 74 |
CONSTRAINT download_settings_id_fkey FOREIGN KEY (id) |
|
| 75 |
REFERENCES "TNRS".batch (id) MATCH SIMPLE |
|
| 76 |
ON UPDATE CASCADE ON DELETE CASCADE |
|
| 74 | 77 |
) |
| 75 | 78 |
WITH ( |
| 76 | 79 |
OIDS=FALSE |
Also available in: Unified diff
inputs/.TNRS/schema.sql: download_settings.id: added fkey to batch.id to create a 1:1 relationship with optional participation by download_settings. note that this relationship happens to be the same as SQL inheritance, as used in VegCore, but in this case, the 1:1 relationship is not related to inheritance.