Project

General

Profile

« Previous | Next » 

Revision 6179

schemas/vegbien.sql: Renamed reference -> source to make this table more broadly applicable, and because this now stores the datasource metadata

View differences:

test.xml.ref
81 81
                                        </_alt>
82 82
                                    </catalognumber_dwc>
83 83
                                    <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
84
                                    <institution_id><referencename><name>$InstitutionCode</name></referencename></institution_id>
84
                                    <institution_id><sourcename><name>$InstitutionCode</name></sourcename></institution_id>
85 85
                                    <sourceaccessioncode>$GlobalUniqueIdentifier</sourceaccessioncode>
86 86
                                </specimenreplicate>
87 87
                            </plantobservation>
......
96 96
                                        <taxonlabel>
97 97
                                            <matched_label_id>
98 98
                                                <taxonlabel>
99
                                                    <reference_id><reference><shortname>TNRS</shortname></reference></reference_id>
99
                                                    <source_id><source><shortname>TNRS</shortname></source></source_id>
100 100
                                                    <taxonomicname>
101 101
                                                        <_join_words>
102 102
                                                            <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
......
309 309
                            <county>$County</county>
310 310
                            <matched_place_id>
311 311
                                <place>
312
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
312
                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
313 313
                                    <coordinates_id>
314 314
                                        <coordinates>
315
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
315
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
316 316
                                            <latitude_deg>
317 317
                                                <_nullIf>
318 318
                                                    <null>0</null>

Also available in: Unified diff