Revision 605
Added by Aaron Marcuse-Kubitza about 13 years ago
| vegbien.for_wiki.sql | ||
|---|---|---|
| 22 | 22 |
( |
| 23 | 23 |
locationevent_id serial NOT NULL, |
| 24 | 24 |
previous_id integer, |
| 25 |
location_id integer NOT NULL,
|
|
| 25 |
location_id integer, |
|
| 26 | 26 |
project_id integer, |
| 27 | 27 |
authoreventcode character varying(30), |
| 28 | 28 |
"... (truncated) ..." integer, |
| ... | ... | |
| 33 | 33 |
CREATE TABLE taxonoccurrence -- VegBank's taxonobservation table. |
| 34 | 34 |
( |
| 35 | 35 |
taxonoccurrence_id serial NOT NULL, |
| 36 |
locationevent_id integer NOT NULL,
|
|
| 36 |
locationevent_id integer, |
|
| 37 | 37 |
authorplantname character varying(255), |
| 38 | 38 |
reference_id integer, |
| 39 | 39 |
taxoninferencearea double precision, |
Also available in: Unified diff
vegbien.sql: Made several pointers to parent elements optional to deal with specimens data that might not have a location, etc.