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
16 16
                            <cover_fraction><_percent_to_fraction><value>$pctCover</value></_percent_to_fraction></cover_fraction>
17 17
                            <plantobservation>
18 18
                                <collectionnumber>$collectionNumber</collectionnumber>
19
                                <specimenreplicate><institution_id><referencename><name>$dataSourceName</name></referencename></institution_id></specimenreplicate>
19
                                <specimenreplicate><institution_id><sourcename><name>$dataSourceName</name></sourcename></institution_id></specimenreplicate>
20 20
                            </plantobservation>
21 21
                        </aggregateoccurrence>
22 22
                        <authortaxoncode>$collectionNumber</authortaxoncode>
......
30 30
                                        <taxonlabel>
31 31
                                            <matched_label_id>
32 32
                                                <taxonlabel>
33
                                                    <reference_id><reference><shortname>TNRS</shortname></reference></reference_id>
33
                                                    <source_id><source><shortname>TNRS</shortname></source></source_id>
34 34
                                                    <taxonomicname>
35 35
                                                        <_join_words>
36 36
                                                            <1><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></1>
......
154 154
                            <county>$countyParish</county>
155 155
                            <matched_place_id>
156 156
                                <place>
157
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
157
                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
158 158
                                    <coordinates_id>
159 159
                                        <coordinates>
160
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
160
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
161 161
                                            <latitude_deg>
162 162
                                                <_nullIf>
163 163
                                                    <null>0</null>

Also available in: Unified diff