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
16 16
                        <authortaxoncode>$authorplantname</authortaxoncode>
17 17
                        <sourceaccessioncode>$taxonobservation_id</sourceaccessioncode>
18 18
                        <taxondetermination>
19
                            <taxonlabel_id>
20
                                <taxonlabel>
21
                                    <matched_label_id>
19
                            <taxonverbatim_id>
20
                                <taxonverbatim>
21
                                    <taxonlabel_id>
22 22
                                        <taxonlabel>
23
                                            <creator_id>
24
                                                <party>
25
                                                    <creator_id>0</creator_id>
26
                                                    <organizationname>TNRS</organizationname>
27
                                                </party>
28
                                            </creator_id>
29
                                            <taxonomicname>
30
                                                <_join_words>
31
                                                    <1>$Family</1>
32
                                                    <2>$Genus</2>
33
                                                    <3>$Species</3>
34
                                                    <4>$Subspecies</4>
35
                                                    <7>
23
                                            <matched_label_id>
24
                                                <taxonlabel>
25
                                                    <creator_id>
26
                                                        <party>
27
                                                            <creator_id>0</creator_id>
28
                                                            <organizationname>TNRS</organizationname>
29
                                                        </party>
30
                                                    </creator_id>
31
                                                    <taxonomicname>
36 32
                                                        <_join_words>
37
                                                            <1>var. </1>
38
                                                            <2>$Variety</2>
33
                                                            <1>$Family</1>
34
                                                            <2>$Genus</2>
35
                                                            <3>$Species</3>
36
                                                            <4>$Subspecies</4>
37
                                                            <7>
38
                                                                <_join_words>
39
                                                                    <1>var. </1>
40
                                                                    <2>$Variety</2>
41
                                                                </_join_words>
42
                                                            </7>
43
                                                            <8>
44
                                                                <_join_words>
45
                                                                    <1>fm. </1>
46
                                                                    <2>$Forma</2>
47
                                                                </_join_words>
48
                                                            </8>
39 49
                                                        </_join_words>
40
                                                    </7>
41
                                                    <8>
42
                                                        <_join_words>
43
                                                            <1>fm. </1>
44
                                                            <2>$Forma</2>
45
                                                        </_join_words>
46
                                                    </8>
47
                                                </_join_words>
48
                                            </taxonomicname>
49
                                        </taxonlabel>
50
                                    </matched_label_id>
51
                                    <creationdate><_date><date><_dateRangeStart><value>$interpretationdate</value></_dateRangeStart></date></_date></creationdate>
52
                                    <parent_id>
53
                                        <taxonlabel>
50
                                                    </taxonomicname>
51
                                                </taxonlabel>
52
                                            </matched_label_id>
53
                                            <creationdate><_date><date><_dateRangeStart><value>$interpretationdate</value></_dateRangeStart></date></_date></creationdate>
54 54
                                            <parent_id>
55 55
                                                <taxonlabel>
56
                                                    <rank>cultivar</rank>
57 56
                                                    <parent_id>
58 57
                                                        <taxonlabel>
59
                                                            <rank>forma</rank>
60
                                                            <taxonepithet>$Forma</taxonepithet>
58
                                                            <rank>cultivar</rank>
61 59
                                                            <parent_id>
62 60
                                                                <taxonlabel>
63
                                                                    <rank>variety</rank>
64
                                                                    <taxonepithet>$Variety</taxonepithet>
61
                                                                    <rank>forma</rank>
62
                                                                    <taxonepithet>$Forma</taxonepithet>
65 63
                                                                    <parent_id>
66 64
                                                                        <taxonlabel>
67
                                                                            <rank>subspecies</rank>
68
                                                                            <taxonepithet>$Subspecies</taxonepithet>
65
                                                                            <rank>variety</rank>
66
                                                                            <taxonepithet>$Variety</taxonepithet>
69 67
                                                                            <parent_id>
70 68
                                                                                <taxonlabel>
71
                                                                                    <rank>species</rank>
72
                                                                                    <taxonepithet>$Species</taxonepithet>
69
                                                                                    <rank>subspecies</rank>
70
                                                                                    <taxonepithet>$Subspecies</taxonepithet>
73 71
                                                                                    <parent_id>
74 72
                                                                                        <taxonlabel>
75
                                                                                            <rank>genus</rank>
76
                                                                                            <taxonepithet>$Genus</taxonepithet>
73
                                                                                            <rank>species</rank>
74
                                                                                            <taxonepithet>$Species</taxonepithet>
77 75
                                                                                            <parent_id>
78 76
                                                                                                <taxonlabel>
79
                                                                                                    <rank>family</rank>
80
                                                                                                    <taxonepithet>$Family</taxonepithet>
77
                                                                                                    <rank>genus</rank>
78
                                                                                                    <taxonepithet>$Genus</taxonepithet>
81 79
                                                                                                    <parent_id>
82 80
                                                                                                        <taxonlabel>
83
                                                                                                            <rank>order</rank>
84
                                                                                                            <taxonepithet>$Order</taxonepithet>
81
                                                                                                            <rank>family</rank>
82
                                                                                                            <taxonepithet>$Family</taxonepithet>
85 83
                                                                                                            <parent_id>
86 84
                                                                                                                <taxonlabel>
87
                                                                                                                    <rank>class</rank>
88
                                                                                                                    <taxonepithet>$Class</taxonepithet>
85
                                                                                                                    <rank>order</rank>
86
                                                                                                                    <taxonepithet>$Order</taxonepithet>
89 87
                                                                                                                    <parent_id>
90 88
                                                                                                                        <taxonlabel>
91
                                                                                                                            <rank>phylum</rank>
89
                                                                                                                            <rank>class</rank>
90
                                                                                                                            <taxonepithet>$Class</taxonepithet>
92 91
                                                                                                                            <parent_id>
93 92
                                                                                                                                <taxonlabel>
94
                                                                                                                                    <rank>kingdom</rank>
95
                                                                                                                                    <taxonepithet>$Kingdom</taxonepithet>
93
                                                                                                                                    <rank>phylum</rank>
94
                                                                                                                                    <parent_id>
95
                                                                                                                                        <taxonlabel>
96
                                                                                                                                            <rank>kingdom</rank>
97
                                                                                                                                            <taxonepithet>$Kingdom</taxonepithet>
98
                                                                                                                                        </taxonlabel>
99
                                                                                                                                    </parent_id>
96 100
                                                                                                                                </taxonlabel>
97 101
                                                                                                                            </parent_id>
98 102
                                                                                                                        </taxonlabel>
......
115 119
                                                    </parent_id>
116 120
                                                </taxonlabel>
117 121
                                            </parent_id>
118
                                        </taxonlabel>
119
                                    </parent_id>
120
                                    <taxonomicname>
121
                                        <_join_words>
122
                                            <1>$Family</1>
123
                                            <2>$Genus</2>
124
                                            <3>$Species</3>
125
                                            <4>$Subspecies</4>
126
                                            <7>
122
                                            <taxonomicname>
127 123
                                                <_join_words>
128
                                                    <1>var. </1>
129
                                                    <2>$Variety</2>
124
                                                    <1>$Family</1>
125
                                                    <2>$Genus</2>
126
                                                    <3>$Species</3>
127
                                                    <4>$Subspecies</4>
128
                                                    <7>
129
                                                        <_join_words>
130
                                                            <1>var. </1>
131
                                                            <2>$Variety</2>
132
                                                        </_join_words>
133
                                                    </7>
134
                                                    <8>
135
                                                        <_join_words>
136
                                                            <1>fm. </1>
137
                                                            <2>$Forma</2>
138
                                                        </_join_words>
139
                                                    </8>
130 140
                                                </_join_words>
131
                                            </7>
132
                                            <8>
133
                                                <_join_words>
134
                                                    <1>fm. </1>
135
                                                    <2>$Forma</2>
136
                                                </_join_words>
137
                                            </8>
138
                                        </_join_words>
139
                                    </taxonomicname>
140
                                    <taxonverbatim>
141
                                        <family>$Family</family>
142
                                        <genus>$Genus</genus>
143
                                        <species>$Species</species>
144
                                    </taxonverbatim>
145
                                </taxonlabel>
146
                            </taxonlabel_id>
141
                                            </taxonomicname>
142
                                        </taxonlabel>
143
                                    </taxonlabel_id>
144
                                    <family>$Family</family>
145
                                    <genus>$Genus</genus>
146
                                    <species>$Species</species>
147
                                </taxonverbatim>
148
                            </taxonverbatim_id>
147 149
                            <determinationdate><_date><date><_dateRangeStart><value>$interpretationdate</value></_dateRangeStart></date></_date></determinationdate>
148 150
                            <taxonfit>$taxonfit</taxonfit>
149 151
                        </taxondetermination>
150 152
                        <taxondetermination>
151 153
                            <isoriginal>true</isoriginal>
152
                            <taxonlabel_id>
153
                                <taxonlabel>
154
                                    <matched_label_id>
154
                            <taxonverbatim_id>
155
                                <taxonverbatim>
156
                                    <taxonlabel_id>
155 157
                                        <taxonlabel>
156
                                            <creator_id>
157
                                                <party>
158
                                                    <creator_id>0</creator_id>
159
                                                    <organizationname>TNRS</organizationname>
160
                                                </party>
161
                                            </creator_id>
158
                                            <matched_label_id>
159
                                                <taxonlabel>
160
                                                    <creator_id>
161
                                                        <party>
162
                                                            <creator_id>0</creator_id>
163
                                                            <organizationname>TNRS</organizationname>
164
                                                        </party>
165
                                                    </creator_id>
166
                                                    <taxonomicname>$authorplantname</taxonomicname>
167
                                                </taxonlabel>
168
                                            </matched_label_id>
162 169
                                            <taxonomicname>$authorplantname</taxonomicname>
163 170
                                        </taxonlabel>
164
                                    </matched_label_id>
165
                                    <taxonomicname>$authorplantname</taxonomicname>
166
                                    <taxonverbatim><binomial>$authorplantname</binomial></taxonverbatim>
167
                                </taxonlabel>
168
                            </taxonlabel_id>
171
                                    </taxonlabel_id>
172
                                    <binomial>$authorplantname</binomial>
173
                                </taxonverbatim>
174
                            </taxonverbatim_id>
169 175
                        </taxondetermination>
170 176
                    </taxonoccurrence>
171 177
                </locationevent>

Also available in: Unified diff