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
10 10
                    <taxonoccurrence>
11 11
                        <sourceaccessioncode>$SpeciesInvID</sourceaccessioncode>
12 12
                        <taxondetermination>
13
                            <taxonlabel_id>
14
                                <taxonlabel>
15
                                    <matched_label_id>
13
                            <taxonverbatim_id>
14
                                <taxonverbatim>
15
                                    <taxonlabel_id>
16 16
                                        <taxonlabel>
17
                                            <creator_id>
18
                                                <party>
19
                                                    <creator_id>0</creator_id>
20
                                                    <organizationname>TNRS</organizationname>
21
                                                </party>
22
                                            </creator_id>
23
                                            <taxonomicname>
24
                                                <_join_words>
25
                                                    <1>$Family</1>
26
                                                    <2>$Genus</2>
27
                                                    <3>$SpeciesName</3>
28
                                                    <4>$SubSpeciesName</4>
29
                                                </_join_words>
30
                                            </taxonomicname>
31
                                        </taxonlabel>
32
                                    </matched_label_id>
33
                                    <parent_id>
34
                                        <taxonlabel>
17
                                            <matched_label_id>
18
                                                <taxonlabel>
19
                                                    <creator_id>
20
                                                        <party>
21
                                                            <creator_id>0</creator_id>
22
                                                            <organizationname>TNRS</organizationname>
23
                                                        </party>
24
                                                    </creator_id>
25
                                                    <taxonomicname>
26
                                                        <_join_words>
27
                                                            <1>$Family</1>
28
                                                            <2>$Genus</2>
29
                                                            <3>$SpeciesName</3>
30
                                                            <4>$SubSpeciesName</4>
31
                                                        </_join_words>
32
                                                    </taxonomicname>
33
                                                </taxonlabel>
34
                                            </matched_label_id>
35 35
                                            <parent_id>
36 36
                                                <taxonlabel>
37
                                                    <rank>cultivar</rank>
38 37
                                                    <parent_id>
39 38
                                                        <taxonlabel>
40
                                                            <rank>forma</rank>
39
                                                            <rank>cultivar</rank>
41 40
                                                            <parent_id>
42 41
                                                                <taxonlabel>
43
                                                                    <rank>variety</rank>
42
                                                                    <rank>forma</rank>
44 43
                                                                    <parent_id>
45 44
                                                                        <taxonlabel>
46
                                                                            <rank>subspecies</rank>
47
                                                                            <taxonepithet>$SubSpeciesName</taxonepithet>
45
                                                                            <rank>variety</rank>
48 46
                                                                            <parent_id>
49 47
                                                                                <taxonlabel>
50
                                                                                    <rank>species</rank>
51
                                                                                    <taxonepithet>$SpeciesName</taxonepithet>
48
                                                                                    <rank>subspecies</rank>
49
                                                                                    <taxonepithet>$SubSpeciesName</taxonepithet>
52 50
                                                                                    <parent_id>
53 51
                                                                                        <taxonlabel>
54
                                                                                            <rank>genus</rank>
55
                                                                                            <taxonepithet>$Genus</taxonepithet>
52
                                                                                            <rank>species</rank>
53
                                                                                            <taxonepithet>$SpeciesName</taxonepithet>
56 54
                                                                                            <parent_id>
57 55
                                                                                                <taxonlabel>
58
                                                                                                    <rank>family</rank>
59
                                                                                                    <taxonepithet>$Family</taxonepithet>
56
                                                                                                    <rank>genus</rank>
57
                                                                                                    <taxonepithet>$Genus</taxonepithet>
58
                                                                                                    <parent_id>
59
                                                                                                        <taxonlabel>
60
                                                                                                            <rank>family</rank>
61
                                                                                                            <taxonepithet>$Family</taxonepithet>
62
                                                                                                        </taxonlabel>
63
                                                                                                    </parent_id>
60 64
                                                                                                </taxonlabel>
61 65
                                                                                            </parent_id>
62 66
                                                                                        </taxonlabel>
......
71 75
                                                    </parent_id>
72 76
                                                </taxonlabel>
73 77
                                            </parent_id>
78
                                            <taxonomicname>
79
                                                <_join_words>
80
                                                    <1>$Family</1>
81
                                                    <2>$Genus</2>
82
                                                    <3>$SpeciesName</3>
83
                                                    <4>$SubSpeciesName</4>
84
                                                </_join_words>
85
                                            </taxonomicname>
74 86
                                        </taxonlabel>
75
                                    </parent_id>
76
                                    <taxonomicname>
77
                                        <_join_words>
78
                                            <1>$Family</1>
79
                                            <2>$Genus</2>
80
                                            <3>$SpeciesName</3>
81
                                            <4>$SubSpeciesName</4>
82
                                        </_join_words>
83
                                    </taxonomicname>
84
                                    <taxonverbatim>
85
                                        <family>$Family</family>
86
                                        <genus>$Genus</genus>
87
                                        <species>$SpeciesName</species>
88
                                    </taxonverbatim>
89
                                </taxonlabel>
90
                            </taxonlabel_id>
87
                                    </taxonlabel_id>
88
                                    <family>$Family</family>
89
                                    <genus>$Genus</genus>
90
                                    <species>$SpeciesName</species>
91
                                </taxonverbatim>
92
                            </taxonverbatim_id>
91 93
                        </taxondetermination>
92 94
                    </taxonoccurrence>
93 95
                </locationevent>

Also available in: Unified diff