Project

General

Profile

« Previous | Next » 

Revision 5655

schemas/vegbien.sql: taxonlabel: Moved non-scoping fields to new taxonverbatim subclass table, which contains the component parts of the taxonlabel

View differences:

test.xml.ref
292 292
                                            </identifyingtaxonomicname>
293 293
                                        </taxonlabel>
294 294
                                    </matched_label_id>
295
                                    <author>
296
                                        <_alt>
297
                                            <1>$dwc_terms_scientificNameAuthorship</1>
298
                                            <2>$conceptual_darwin_2003_1_0_ScientificNameAuthor</2>
299
                                            <3>$dwc_dwcore_AuthorYearOfScientificName</3>
300
                                        </_alt>
301
                                    </author>
302
                                    <binomial>
303
                                        <_alt>
304
                                            <0>$conceptual_darwin_2003_1_0_ScientificName</0>
305
                                            <1>$dwc_dwcore_ScientificName</1>
306
                                            <2>$dwc_terms_scientificName</2>
307
                                        </_alt>
308
                                    </binomial>
309 295
                                    <creationdate>
310 296
                                        <_alt>
311 297
                                            <1><_date><date><_dateRangeStart><value>$dwc_terms_dateIdentified</value></_dateRangeStart></date></_date></1>
......
352 338
                                            </path>
353 339
                                        </_simplifyPath>
354 340
                                    </creator_id>
355
                                    <family>
356
                                        <_alt>
357
                                            <0>$conceptual_darwin_2003_1_0_Family</0>
358
                                            <1>$dwc_dwcore_Family</1>
359
                                            <2>$dwc_terms_family</2>
360
                                        </_alt>
361
                                    </family>
362
                                    <genus>
363
                                        <_alt>
364
                                            <0>$conceptual_darwin_2003_1_0_Genus</0>
365
                                            <1>$dwc_dwcore_Genus</1>
366
                                            <2>$dwc_terms_genus</2>
367
                                        </_alt>
368
                                    </genus>
369 341
                                    <identifyingtaxonomicname>
370 342
                                        <_join_words>
371 343
                                            <1>
......
535 507
                                            </taxonepithet>
536 508
                                        </taxonlabel>
537 509
                                    </parent_id>
538
                                    <species>
539
                                        <_alt>
540
                                            <0>$conceptual_darwin_2003_1_0_Species</0>
541
                                            <1>$dwc_dwcore_SpecificEpithet</1>
542
                                            <2>$dwc_terms_specificEpithet</2>
543
                                        </_alt>
544
                                    </species>
510
                                    <taxonverbatim>
511
                                        <author>
512
                                            <_alt>
513
                                                <1>$dwc_terms_scientificNameAuthorship</1>
514
                                                <2>$conceptual_darwin_2003_1_0_ScientificNameAuthor</2>
515
                                                <3>$dwc_dwcore_AuthorYearOfScientificName</3>
516
                                            </_alt>
517
                                        </author>
518
                                        <binomial>
519
                                            <_alt>
520
                                                <0>$conceptual_darwin_2003_1_0_ScientificName</0>
521
                                                <1>$dwc_dwcore_ScientificName</1>
522
                                                <2>$dwc_terms_scientificName</2>
523
                                            </_alt>
524
                                        </binomial>
525
                                        <family>
526
                                            <_alt>
527
                                                <0>$conceptual_darwin_2003_1_0_Family</0>
528
                                                <1>$dwc_dwcore_Family</1>
529
                                                <2>$dwc_terms_family</2>
530
                                            </_alt>
531
                                        </family>
532
                                        <genus>
533
                                            <_alt>
534
                                                <0>$conceptual_darwin_2003_1_0_Genus</0>
535
                                                <1>$dwc_dwcore_Genus</1>
536
                                                <2>$dwc_terms_genus</2>
537
                                            </_alt>
538
                                        </genus>
539
                                        <species>
540
                                            <_alt>
541
                                                <0>$conceptual_darwin_2003_1_0_Species</0>
542
                                                <1>$dwc_dwcore_SpecificEpithet</1>
543
                                                <2>$dwc_terms_specificEpithet</2>
544
                                            </_alt>
545
                                        </species>
546
                                    </taxonverbatim>
545 547
                                </taxonlabel>
546 548
                            </taxonlabel_id>
547 549
                            <determinationdate>
......
648 650
        </path>
649 651
    </_simplifyPath>
650 652
</VegBIEN>
651
Inserted 37 new rows into database
653
Inserted 39 new rows into database

Also available in: Unified diff