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
39 39
                        </authortaxoncode>
40 40
                        <sourceaccessioncode>$MeasureID</sourceaccessioncode>
41 41
                        <taxondetermination>
42
                            <taxonlabel_id>
43
                                <taxonlabel>
44
                                    <matched_label_id>
42
                            <taxonverbatim_id>
43
                                <taxonverbatim>
44
                                    <taxonlabel_id>
45 45
                                        <taxonlabel>
46
                                            <creator_id>
47
                                                <party>
48
                                                    <creator_id>0</creator_id>
49
                                                    <organizationname>TNRS</organizationname>
50
                                                </party>
51
                                            </creator_id>
52
                                            <taxonomicname>
53
                                                <_join_words>
54
                                                    <1>
46
                                            <matched_label_id>
47
                                                <taxonlabel>
48
                                                    <creator_id>
49
                                                        <party>
50
                                                            <creator_id>0</creator_id>
51
                                                            <organizationname>TNRS</organizationname>
52
                                                        </party>
53
                                                    </creator_id>
54
                                                    <taxonomicname>
55 55
                                                        <_join_words>
56
                                                            <1>$Family</1>
57
                                                            <2>$Genus</2>
58
                                                            <3>$SpeciesName</3>
59
                                                            <4>$SubSpeciesName</4>
56
                                                            <1>
57
                                                                <_join_words>
58
                                                                    <1>$Family</1>
59
                                                                    <2>$Genus</2>
60
                                                                    <3>$SpeciesName</3>
61
                                                                    <4>$SubSpeciesName</4>
62
                                                                </_join_words>
63
                                                            </1>
64
                                                            <2>$SpeciesAuthority</2>
60 65
                                                        </_join_words>
61
                                                    </1>
62
                                                    <2>$SpeciesAuthority</2>
63
                                                </_join_words>
64
                                            </taxonomicname>
65
                                        </taxonlabel>
66
                                    </matched_label_id>
67
                                    <parent_id>
68
                                        <taxonlabel>
66
                                                    </taxonomicname>
67
                                                </taxonlabel>
68
                                            </matched_label_id>
69 69
                                            <parent_id>
70 70
                                                <taxonlabel>
71
                                                    <rank>cultivar</rank>
72 71
                                                    <parent_id>
73 72
                                                        <taxonlabel>
74
                                                            <rank>forma</rank>
73
                                                            <rank>cultivar</rank>
75 74
                                                            <parent_id>
76 75
                                                                <taxonlabel>
77
                                                                    <rank>variety</rank>
76
                                                                    <rank>forma</rank>
78 77
                                                                    <parent_id>
79 78
                                                                        <taxonlabel>
80
                                                                            <rank>subspecies</rank>
81
                                                                            <taxonepithet>$SubSpeciesName</taxonepithet>
79
                                                                            <rank>variety</rank>
82 80
                                                                            <parent_id>
83 81
                                                                                <taxonlabel>
84
                                                                                    <rank>species</rank>
85
                                                                                    <taxonepithet>$SpeciesName</taxonepithet>
82
                                                                                    <rank>subspecies</rank>
83
                                                                                    <taxonepithet>$SubSpeciesName</taxonepithet>
86 84
                                                                                    <parent_id>
87 85
                                                                                        <taxonlabel>
88
                                                                                            <rank>genus</rank>
89
                                                                                            <taxonepithet>$Genus</taxonepithet>
86
                                                                                            <rank>species</rank>
87
                                                                                            <taxonepithet>$SpeciesName</taxonepithet>
90 88
                                                                                            <parent_id>
91 89
                                                                                                <taxonlabel>
92
                                                                                                    <rank>family</rank>
93
                                                                                                    <taxonepithet>$Family</taxonepithet>
90
                                                                                                    <rank>genus</rank>
91
                                                                                                    <taxonepithet>$Genus</taxonepithet>
92
                                                                                                    <parent_id>
93
                                                                                                        <taxonlabel>
94
                                                                                                            <rank>family</rank>
95
                                                                                                            <taxonepithet>$Family</taxonepithet>
96
                                                                                                        </taxonlabel>
97
                                                                                                    </parent_id>
94 98
                                                                                                </taxonlabel>
95 99
                                                                                            </parent_id>
96 100
                                                                                        </taxonlabel>
......
105 109
                                                    </parent_id>
106 110
                                                </taxonlabel>
107 111
                                            </parent_id>
108
                                        </taxonlabel>
109
                                    </parent_id>
110
                                    <taxonomicname>
111
                                        <_join_words>
112
                                            <1>
112
                                            <taxonomicname>
113 113
                                                <_join_words>
114
                                                    <1>$Family</1>
115
                                                    <2>$Genus</2>
116
                                                    <3>$SpeciesName</3>
117
                                                    <4>$SubSpeciesName</4>
114
                                                    <1>
115
                                                        <_join_words>
116
                                                            <1>$Family</1>
117
                                                            <2>$Genus</2>
118
                                                            <3>$SpeciesName</3>
119
                                                            <4>$SubSpeciesName</4>
120
                                                        </_join_words>
121
                                                    </1>
122
                                                    <2>$SpeciesAuthority</2>
118 123
                                                </_join_words>
119
                                            </1>
120
                                            <2>$SpeciesAuthority</2>
121
                                        </_join_words>
122
                                    </taxonomicname>
123
                                    <taxonverbatim>
124
                                        <author>$SpeciesAuthority</author>
125
                                        <family>$Family</family>
126
                                        <genus>$Genus</genus>
127
                                        <species>$SpeciesName</species>
128
                                    </taxonverbatim>
129
                                </taxonlabel>
130
                            </taxonlabel_id>
124
                                            </taxonomicname>
125
                                        </taxonlabel>
126
                                    </taxonlabel_id>
127
                                    <author>$SpeciesAuthority</author>
128
                                    <family>$Family</family>
129
                                    <genus>$Genus</genus>
130
                                    <species>$SpeciesName</species>
131
                                </taxonverbatim>
132
                            </taxonverbatim_id>
131 133
                        </taxondetermination>
132 134
                    </taxonoccurrence>
133 135
                </locationevent>

Also available in: Unified diff