Project

General

Profile

« Previous | Next » 

Revision 5657

schemas/vegbien.sql: Link taxondetermination to taxonverbatim (which is a subclass of taxonlabel) instead of directly to taxonlabel. This will enable later having multiple taxonverbatims for one taxonlabel.

View differences:

test.xml.ref
7 7
                <locationevent>
8 8
                    <taxonoccurrence>
9 9
                        <taxondetermination>
10
                            <taxonlabel_id>
11
                                <taxonlabel>
12
                                    <matched_label_id>
10
                            <taxonverbatim_id>
11
                                <taxonverbatim>
12
                                    <taxonlabel_id>
13 13
                                        <taxonlabel>
14
                                            <creator_id>
15
                                                <party>
16
                                                    <creator_id>0</creator_id>
17
                                                    <organizationname>TNRS</organizationname>
18
                                                </party>
19
                                            </creator_id>
14
                                            <matched_label_id>
15
                                                <taxonlabel>
16
                                                    <creator_id>
17
                                                        <party>
18
                                                            <creator_id>0</creator_id>
19
                                                            <organizationname>TNRS</organizationname>
20
                                                        </party>
21
                                                    </creator_id>
22
                                                    <taxonomicname>$name_txt</taxonomicname>
23
                                                </taxonlabel>
24
                                            </matched_label_id>
25
                                            <_taxonlabel_set_parent_id><parent_id><taxonlabel><sourceaccessioncode>$parent tax_id</sourceaccessioncode></taxonlabel></parent_id></_taxonlabel_set_parent_id>
26
                                            <rank>$rank</rank>
27
                                            <sourceaccessioncode>$tax_id</sourceaccessioncode>
28
                                            <taxonepithet>$name_txt</taxonepithet>
20 29
                                            <taxonomicname>$name_txt</taxonomicname>
21 30
                                        </taxonlabel>
22
                                    </matched_label_id>
23
                                    <_taxonlabel_set_parent_id><parent_id><taxonlabel><sourceaccessioncode>$parent tax_id</sourceaccessioncode></taxonlabel></parent_id></_taxonlabel_set_parent_id>
24
                                    <rank>$rank</rank>
25
                                    <sourceaccessioncode>$tax_id</sourceaccessioncode>
26
                                    <taxonepithet>$name_txt</taxonepithet>
27
                                    <taxonomicname>$name_txt</taxonomicname>
28
                                    <taxonverbatim><verbatimrank>$rank</verbatimrank></taxonverbatim>
29
                                </taxonlabel>
30
                            </taxonlabel_id>
31
                                    </taxonlabel_id>
32
                                    <verbatimrank>$rank</verbatimrank>
33
                                </taxonverbatim>
34
                            </taxonverbatim_id>
31 35
                        </taxondetermination>
32 36
                    </taxonoccurrence>
33 37
                </locationevent>

Also available in: Unified diff