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
63 63
                                            <2>$collectionID</2>
64 64
                                        </_join>
65 65
                                    </collectioncode_dwc>
66
                                    <institution_id><referencename><name>$institutionCode</name></referencename></institution_id>
66
                                    <institution_id><sourcename><name>$institutionCode</name></sourcename></institution_id>
67 67
                                    <sourceaccessioncode>$id</sourceaccessioncode>
68 68
                                </specimenreplicate>
69 69
                            </plantobservation>
......
78 78
                                        <taxonlabel>
79 79
                                            <matched_label_id>
80 80
                                                <taxonlabel>
81
                                                    <reference_id><reference><shortname>TNRS</shortname></reference></reference_id>
81
                                                    <source_id><source><shortname>TNRS</shortname></source></source_id>
82 82
                                                    <taxonomicname>
83 83
                                                        <_join_words>
84 84
                                                            <1><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></1>
......
272 272
                            <county>$county</county>
273 273
                            <matched_place_id>
274 274
                                <place>
275
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
275
                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
276 276
                                    <coordinates_id>
277 277
                                        <coordinates>
278
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
278
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
279 279
                                            <latitude_deg>
280 280
                                                <_nullIf>
281 281
                                                    <null>0</null>

Also available in: Unified diff