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
148 148
                                        </_join>
149 149
                                    </collectioncode_dwc>
150 150
                                    <institution_id>
151
                                        <referencename>
151
                                        <sourcename>
152 152
                                            <name>
153 153
                                                <_alt>
154 154
                                                    <0>$conceptual_darwin_2003_1_0_InstitutionCode</0>
......
156 156
                                                    <2>$dwc_terms_institutionCode</2>
157 157
                                                </_alt>
158 158
                                            </name>
159
                                        </referencename>
159
                                        </sourcename>
160 160
                                    </institution_id>
161 161
                                    <sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode>
162 162
                                </specimenreplicate>
......
192 192
                                        <taxonlabel>
193 193
                                            <matched_label_id>
194 194
                                                <taxonlabel>
195
                                                    <reference_id><reference><shortname>TNRS</shortname></reference></reference_id>
195
                                                    <source_id><source><shortname>TNRS</shortname></source></source_id>
196 196
                                                    <taxonomicname>
197 197
                                                        <_join_words>
198 198
                                                            <1>
......
641 641
                            </county>
642 642
                            <matched_place_id>
643 643
                                <place>
644
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
644
                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
645 645
                                    <coordinates_id>
646 646
                                        <coordinates>
647
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
647
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
648 648
                                            <latitude_deg>
649 649
                                                <_nullIf>
650 650
                                                    <null>0</null>

Also available in: Unified diff