Revision 7044
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1412 | 1412 |
CREATE TABLE taxondetermination ( |
| 1413 | 1413 |
taxondetermination_id int(11) NOT NULL, |
| 1414 | 1414 |
taxonoccurrence_id int(11) NOT NULL, |
| 1415 |
source_id int(11) NOT NULL, |
|
| 1415 | 1416 |
taxonverbatim_id int(11) NOT NULL, |
| 1416 | 1417 |
party_id int(11), |
| 1417 | 1418 |
role varchar(255) DEFAULT 'unknown' NOT NULL, |
| 1418 | 1419 |
determinationtype varchar(255), |
| 1419 |
source_id int(11), |
|
| 1420 | 1420 |
isoriginal int(1) DEFAULT false NOT NULL, |
| 1421 | 1421 |
iscurrent int(1) DEFAULT false NOT NULL, |
| 1422 | 1422 |
taxonfit varchar(255), |
Also available in: Unified diff
schemas/vegbien.sql: taxondetermination: Added scoping source_id field to allow other datasources (e.g. TNRS) to make taxondeterminations. (Repurposed existing non-scoping source_id.)