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
25 25
                                <specimenreplicate>
26 26
                                    <catalognumber_dwc>$CatalogNO</catalognumber_dwc>
27 27
                                    <collectioncode_dwc>$CollectionCD</collectioncode_dwc>
28
                                    <institution_id><referencename><name>$InstitutionCD</name></referencename></institution_id>
28
                                    <institution_id><sourcename><name>$InstitutionCD</name></sourcename></institution_id>
29 29
                                </specimenreplicate>
30 30
                            </plantobservation>
31 31
                        </aggregateoccurrence>
......
38 38
                                        <taxonlabel>
39 39
                                            <matched_label_id>
40 40
                                                <taxonlabel>
41
                                                    <reference_id><reference><shortname>TNRS</shortname></reference></reference_id>
41
                                                    <source_id><source><shortname>TNRS</shortname></source></source_id>
42 42
                                                    <taxonomicname>
43 43
                                                        <_join_words>
44 44
                                                            <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
......
146 146
                                        <taxonlabel>
147 147
                                            <matched_label_id>
148 148
                                                <taxonlabel>
149
                                                    <reference_id><reference><shortname>TNRS</shortname></reference></reference_id>
149
                                                    <source_id><source><shortname>TNRS</shortname></source></source_id>
150 150
                                                    <taxonomicname>
151 151
                                                        <_join_words>
152 152
                                                            <1><_taxon_family_require_std><family>$GBIFFamilyOriginal</family></_taxon_family_require_std></1>
......
248 248
                            <county>$County</county>
249 249
                            <matched_place_id>
250 250
                                <place>
251
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
251
                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
252 252
                                    <coordinates_id>
253 253
                                        <coordinates>
254
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
254
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
255 255
                                            <latitude_deg>
256 256
                                                <_nullIf>
257 257
                                                    <null>0</null>

Also available in: Unified diff