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
41 41
                            <plantobservation>
42 42
                                <specimenreplicate>
43 43
                                    <catalognumber_dwc>$accession_number</catalognumber_dwc>
44
                                    <institution_id><referencename><name>$acronym</name></referencename></institution_id>
44
                                    <institution_id><sourcename><name>$acronym</name></sourcename></institution_id>
45 45
                                </specimenreplicate>
46 46
                            </plantobservation>
47 47
                        </aggregateoccurrence>
......
53 53
                                        <taxonlabel>
54 54
                                            <matched_label_id>
55 55
                                                <taxonlabel>
56
                                                    <reference_id><reference><shortname>TNRS</shortname></reference></reference_id>
56
                                                    <source_id><source><shortname>TNRS</shortname></source></source_id>
57 57
                                                    <taxonomicname>
58 58
                                                        <_join_words>
59 59
                                                            <1><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></1>
......
166 166
                            <county>$county</county>
167 167
                            <matched_place_id>
168 168
                                <place>
169
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
169
                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
170 170
                                    <coordinates_id>
171 171
                                        <coordinates>
172
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
172
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
173 173
                                            <latitude_deg>
174 174
                                                <_nullIf>
175 175
                                                    <null>0</null>

Also available in: Unified diff