Revision 3911
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 174 | 174 |
coverindex_id int(11), |
| 175 | 175 |
occurrencestatus_dwc text DEFAULT 'present' NOT NULL, |
| 176 | 176 |
method_id int(11), |
| 177 |
notes text, |
|
| 177 | 178 |
accessioncode text |
| 178 | 179 |
); |
| 179 | 180 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 395 | 395 |
coverindex_id integer, |
| 396 | 396 |
occurrencestatus_dwc occurrencestatus_dwc DEFAULT 'present'::occurrencestatus_dwc NOT NULL, |
| 397 | 397 |
method_id integer, |
| 398 |
notes text, |
|
| 398 | 399 |
accessioncode text |
| 399 | 400 |
); |
| 400 | 401 |
|
Also available in: Unified diff
schemas/vegbien.sql: aggregateoccurrence: Added notes, to serve the purpose that specimenreplicate.description previously did. specimenreplicate.description is not appropriate for plots data, and often not appropriate even for specimens data, which uses fieldNotes as a general notes field rather than a description of the specimen.