Revision 3316
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/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, |
| schemas/vegbien.sql | ||
|---|---|---|
| 2607 | 2607 |
CREATE TABLE taxonoccurrence ( |
| 2608 | 2608 |
taxonoccurrence_id integer NOT NULL, |
| 2609 | 2609 |
locationevent_id integer, |
| 2610 |
sourceaccessioncode text, |
|
| 2610 | 2611 |
verbatimcollectorname text, |
| 2611 | 2612 |
growthform growthform, |
| 2612 | 2613 |
iscultivated boolean, |
| ... | ... | |
| 2672 | 2673 |
CREATE TABLE specimenreplicate ( |
| 2673 | 2674 |
datasource_id integer NOT NULL, |
| 2674 | 2675 |
plantobservation_id integer, |
| 2675 |
sourceaccessioncode text, |
|
| 2676 | 2676 |
institution_id integer, |
| 2677 | 2677 |
collectioncode_dwc text, |
| 2678 | 2678 |
catalognumber_dwc text, |
Also available in: Unified diff
schemas/vegbien.sql: taxonoccurrence: Added sourceaccessioncode so that taxonoccurrences can be uniquely identified in plots data