Revision 605
Added by Aaron Marcuse-Kubitza about 13 years ago
| vegbien.for_ERD.my.sql | ||
|---|---|---|
| 172 | 172 |
( |
| 173 | 173 |
locationevent_id int(11) NOT NULL AUTO_INCREMENT, |
| 174 | 174 |
previous_id int(11), |
| 175 |
location_id int(11) NOT NULL,
|
|
| 175 |
location_id int(11), |
|
| 176 | 176 |
project_id int(11), |
| 177 | 177 |
authoreventcode character varying(30), |
| 178 | 178 |
`... (truncated) ...` int(11), |
| ... | ... | |
| 192 | 192 |
CREATE TABLE taxonoccurrence -- VegBank's taxonobservation table. |
| 193 | 193 |
( |
| 194 | 194 |
taxonoccurrence_id int(11) NOT NULL AUTO_INCREMENT, |
| 195 |
locationevent_id int(11) NOT NULL,
|
|
| 195 |
locationevent_id int(11), |
|
| 196 | 196 |
authorplantname character varying(255), |
| 197 | 197 |
reference_id int(11), |
| 198 | 198 |
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.