Revision 4188
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 2314 | 2314 |
taxonoccurrence_id int(11) NOT NULL, |
| 2315 | 2315 |
plantconcept_id int(11) NOT NULL, |
| 2316 | 2316 |
party_id int(11), |
| 2317 |
role text NOT NULL, |
|
| 2317 |
role text DEFAULT 'unknown' NOT NULL,
|
|
| 2318 | 2318 |
determinationtype text, |
| 2319 | 2319 |
reference_id int(11), |
| 2320 | 2320 |
isoriginal int(1) DEFAULT false NOT NULL, |
| schemas/vegbien.sql | ||
|---|---|---|
| 2817 | 2817 |
taxonoccurrence_id integer NOT NULL, |
| 2818 | 2818 |
plantconcept_id integer NOT NULL, |
| 2819 | 2819 |
party_id integer, |
| 2820 |
role role NOT NULL, |
|
| 2820 |
role role DEFAULT 'unknown'::role NOT NULL,
|
|
| 2821 | 2821 |
determinationtype text, |
| 2822 | 2822 |
reference_id integer, |
| 2823 | 2823 |
isoriginal boolean DEFAULT false NOT NULL, |
Also available in: Unified diff
schemas/vegbien.sql: taxondetermination.role: Default to 'unknown' so that the field is optional