Revision 11475
Added by Aaron Marcuse-Kubitza about 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 769 | 769 |
|
| 770 | 770 |
CREATE TABLE analytical_stem ( |
| 771 | 771 |
datasource varchar(255) NOT NULL, |
| 772 |
`specimenHolderInstitutions` varchar(255), |
|
| 773 |
collection varchar(255), |
|
| 774 |
`accessionNumber` varchar(255), |
|
| 775 |
`occurrenceID` varchar(255), |
|
| 776 | 772 |
country varchar(255), |
| 777 | 773 |
`stateProvince` varchar(255), |
| 778 | 774 |
county varchar(255), |
| ... | ... | |
| 799 | 795 |
stratum__name varchar(255), |
| 800 | 796 |
communities varchar(255), |
| 801 | 797 |
plot__collectors varchar(255), |
| 798 |
`specimenHolderInstitutions` varchar(255), |
|
| 799 |
collection varchar(255), |
|
| 800 |
`accessionNumber` varchar(255), |
|
| 801 |
`occurrenceID` varchar(255), |
|
| 802 | 802 |
`recordedBy` varchar(255), |
| 803 | 803 |
`recordNumber` varchar(255), |
| 804 | 804 |
`dateCollected` date, |
Also available in: Unified diff
schemas/vegbien.sql: analytical_stem_view: moved specimen-specific fields to occurrence section