Project

General

Profile

« Previous | Next » 

Revision 4076

schemas/vegbien.sql: Moved collectionnumber from specimenreplicate to plantobservation to replace authorplantcode, since these terms are used analogously in plots and specimens data. This code is really the DwC recordNumber (VegBIEN collectionnumber), which "serves as a link between field notes and an Occurrence record, such as a specimen [or plots data] collector's number" (http://rs.tdwg.org/dwc/terms/#recordNumber). Also, this prevents a specimenreplicate from incorrectly being created when plots data provides an authorplantcode.

View differences:

import.specimens.xml.ref
291 291
                    <count>$IndividualCount</count>
292 292
                    <notes>$FieldNotes</notes>
293 293
                    <plantobservation>
294
                        <authorplantcode>
294
                        <collectionnumber>
295 295
                            <_alt>
296 296
                                <1>$CollectorNumber</1>
297 297
                                <2>$FieldNumber</2>
298 298
                            </_alt>
299
                        </authorplantcode>
299
                        </collectionnumber>
300 300
                        <definedvalue fkey="tablerecord_id">
301 301
                            <userdefined_id>
302 302
                                <userdefined>
......
309 309
                        <specimenreplicate>
310 310
                            <catalognumber_dwc><_if name="if indirect voucher"><else>$CatalogNumberNumeric</else></_if></catalognumber_dwc>
311 311
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
312
                            <collectionnumber>
313
                                <_alt>
314
                                    <1>$CollectorNumber</1>
315
                                    <2>$FieldNumber</2>
316
                                </_alt>
317
                            </collectionnumber>
318 312
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
319 313
                            <sourceaccessioncode>$GlobalUniqueIdentifier</sourceaccessioncode>
320 314
                        </specimenreplicate>

Also available in: Unified diff