Revision 3316
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 2115 | 2115 |
CREATE TABLE taxonoccurrence ( |
| 2116 | 2116 |
taxonoccurrence_id int(11) NOT NULL, |
| 2117 | 2117 |
locationevent_id int(11), |
| 2118 |
sourceaccessioncode text, |
|
| 2118 | 2119 |
verbatimcollectorname text, |
| 2119 | 2120 |
growthform text, |
| 2120 | 2121 |
iscultivated int(1), |
| ... | ... | |
| 2176 | 2177 |
taxonoccurrence_id int(11) NOT NULL AUTO_INCREMENT, |
| 2177 | 2178 |
datasource_id int(11) NOT NULL, |
| 2178 | 2179 |
plantobservation_id int(11), |
| 2179 |
sourceaccessioncode text, |
|
| 2180 | 2180 |
institution_id int(11), |
| 2181 | 2181 |
collectioncode_dwc text, |
| 2182 | 2182 |
catalognumber_dwc text, |
Also available in: Unified diff
schemas/vegbien.sql: taxonoccurrence: Added sourceaccessioncode so that taxonoccurrences can be uniquely identified in plots data