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
145 145
                        </growthform>
146 146
                        <sourceaccessioncode>$OBSERVATION_ID</sourceaccessioncode>
147 147
                        <taxondetermination>
148
                            <taxonlabel_id>
149
                                <taxonlabel>
150
                                    <matched_label_id>
148
                            <taxonverbatim_id>
149
                                <taxonverbatim>
150
                                    <taxonlabel_id>
151 151
                                        <taxonlabel>
152
                                            <creator_id>
153
                                                <party>
154
                                                    <creator_id>0</creator_id>
155
                                                    <organizationname>TNRS</organizationname>
156
                                                </party>
157
                                            </creator_id>
158
                                            <taxonomicname>
159
                                                <_join_words>
160
                                                    <1>
152
                                            <matched_label_id>
153
                                                <taxonlabel>
154
                                                    <creator_id>
155
                                                        <party>
156
                                                            <creator_id>0</creator_id>
157
                                                            <organizationname>TNRS</organizationname>
158
                                                        </party>
159
                                                    </creator_id>
160
                                                    <taxonomicname>
161 161
                                                        <_join_words>
162
                                                            <1>$family</1>
163
                                                            <2>$genus</2>
164
                                                            <3>$specific_epithet</3>
165
                                                            <5>
162
                                                            <1>
166 163
                                                                <_join_words>
167
                                                                    <1>
168
                                                                        <_if name="if has infraspecificEpithet">
169
                                                                            <cond>$infra_ep_1</cond>
170
                                                                            <then>$infra_rank_1</then>
171
                                                                        </_if>
172
                                                                    </1>
173
                                                                    <2>$infra_ep_1</2>
164
                                                                    <1>$family</1>
165
                                                                    <2>$genus</2>
166
                                                                    <3>$specific_epithet</3>
167
                                                                    <5>
168
                                                                        <_join_words>
169
                                                                            <1>
170
                                                                                <_if name="if has infraspecificEpithet">
171
                                                                                    <cond>$infra_ep_1</cond>
172
                                                                                    <then>$infra_rank_1</then>
173
                                                                                </_if>
174
                                                                            </1>
175
                                                                            <2>$infra_ep_1</2>
176
                                                                        </_join_words>
177
                                                                    </5>
174 178
                                                                </_join_words>
175
                                                            </5>
179
                                                            </1>
180
                                                            <2>$specific_authority</2>
176 181
                                                        </_join_words>
177
                                                    </1>
178
                                                    <2>$specific_authority</2>
179
                                                </_join_words>
180
                                            </taxonomicname>
181
                                        </taxonlabel>
182
                                    </matched_label_id>
183
                                    <parent_id>
184
                                        <taxonlabel>
185
                                            <rank>$infra_rank_1</rank>
186
                                            <taxonverbatim><verbatimrank>$infra_rank_1</verbatimrank></taxonverbatim>
182
                                                    </taxonomicname>
183
                                                </taxonlabel>
184
                                            </matched_label_id>
187 185
                                            <parent_id>
188 186
                                                <taxonlabel>
189
                                                    <rank>cultivar</rank>
187
                                                    <rank>$infra_rank_1</rank>
188
                                                    <taxonverbatim><verbatimrank>$infra_rank_1</verbatimrank></taxonverbatim>
190 189
                                                    <parent_id>
191 190
                                                        <taxonlabel>
192
                                                            <rank>forma</rank>
191
                                                            <rank>cultivar</rank>
193 192
                                                            <parent_id>
194 193
                                                                <taxonlabel>
195
                                                                    <rank>variety</rank>
194
                                                                    <rank>forma</rank>
196 195
                                                                    <parent_id>
197 196
                                                                        <taxonlabel>
198
                                                                            <rank>subspecies</rank>
197
                                                                            <rank>variety</rank>
199 198
                                                                            <parent_id>
200 199
                                                                                <taxonlabel>
201
                                                                                    <rank>species</rank>
202
                                                                                    <taxonepithet>$specific_epithet</taxonepithet>
200
                                                                                    <rank>subspecies</rank>
203 201
                                                                                    <parent_id>
204 202
                                                                                        <taxonlabel>
205
                                                                                            <rank>genus</rank>
206
                                                                                            <taxonepithet>$genus</taxonepithet>
203
                                                                                            <rank>species</rank>
204
                                                                                            <taxonepithet>$specific_epithet</taxonepithet>
207 205
                                                                                            <parent_id>
208 206
                                                                                                <taxonlabel>
209
                                                                                                    <rank>family</rank>
210
                                                                                                    <taxonepithet>$family</taxonepithet>
207
                                                                                                    <rank>genus</rank>
208
                                                                                                    <taxonepithet>$genus</taxonepithet>
209
                                                                                                    <parent_id>
210
                                                                                                        <taxonlabel>
211
                                                                                                            <rank>family</rank>
212
                                                                                                            <taxonepithet>$family</taxonepithet>
213
                                                                                                        </taxonlabel>
214
                                                                                                    </parent_id>
211 215
                                                                                                </taxonlabel>
212 216
                                                                                            </parent_id>
213 217
                                                                                        </taxonlabel>
......
220 224
                                                            </parent_id>
221 225
                                                        </taxonlabel>
222 226
                                                    </parent_id>
227
                                                    <taxonepithet>$infra_ep_1</taxonepithet>
223 228
                                                </taxonlabel>
224 229
                                            </parent_id>
225
                                            <taxonepithet>$infra_ep_1</taxonepithet>
226
                                        </taxonlabel>
227
                                    </parent_id>
228
                                    <rank>$infra_rank_1</rank>
229
                                    <taxonomicname>
230
                                        <_join_words>
231
                                            <1>
230
                                            <rank>$infra_rank_1</rank>
231
                                            <taxonomicname>
232 232
                                                <_join_words>
233
                                                    <1>$family</1>
234
                                                    <2>$genus</2>
235
                                                    <3>$specific_epithet</3>
236
                                                    <5>
233
                                                    <1>
237 234
                                                        <_join_words>
238
                                                            <1>
239
                                                                <_if name="if has infraspecificEpithet">
240
                                                                    <cond>$infra_ep_1</cond>
241
                                                                    <then>$infra_rank_1</then>
242
                                                                </_if>
243
                                                            </1>
244
                                                            <2>$infra_ep_1</2>
235
                                                            <1>$family</1>
236
                                                            <2>$genus</2>
237
                                                            <3>$specific_epithet</3>
238
                                                            <5>
239
                                                                <_join_words>
240
                                                                    <1>
241
                                                                        <_if name="if has infraspecificEpithet">
242
                                                                            <cond>$infra_ep_1</cond>
243
                                                                            <then>$infra_rank_1</then>
244
                                                                        </_if>
245
                                                                    </1>
246
                                                                    <2>$infra_ep_1</2>
247
                                                                </_join_words>
248
                                                            </5>
245 249
                                                        </_join_words>
246
                                                    </5>
250
                                                    </1>
251
                                                    <2>$specific_authority</2>
247 252
                                                </_join_words>
248
                                            </1>
249
                                            <2>$specific_authority</2>
250
                                        </_join_words>
251
                                    </taxonomicname>
252
                                    <taxonverbatim>
253
                                        <author>$specific_authority</author>
254
                                        <family>$family</family>
255
                                        <genus>$genus</genus>
256
                                        <species>$specific_epithet</species>
257
                                        <verbatimrank>$infra_rank_1</verbatimrank>
258
                                    </taxonverbatim>
259
                                </taxonlabel>
260
                            </taxonlabel_id>
253
                                            </taxonomicname>
254
                                        </taxonlabel>
255
                                    </taxonlabel_id>
256
                                    <author>$specific_authority</author>
257
                                    <family>$family</family>
258
                                    <genus>$genus</genus>
259
                                    <species>$specific_epithet</species>
260
                                    <verbatimrank>$infra_rank_1</verbatimrank>
261
                                </taxonverbatim>
262
                            </taxonverbatim_id>
261 263
                            <taxonfit>$cf_aff</taxonfit>
262 264
                        </taxondetermination>
263 265
                        <taxondetermination>
264 266
                            <isoriginal>true</isoriginal>
265
                            <taxonlabel_id>
266
                                <taxonlabel>
267
                                    <matched_label_id>
267
                            <taxonverbatim_id>
268
                                <taxonverbatim>
269
                                    <taxonlabel_id>
268 270
                                        <taxonlabel>
269
                                            <creator_id>
270
                                                <party>
271
                                                    <creator_id>0</creator_id>
272
                                                    <organizationname>TNRS</organizationname>
273
                                                </party>
274
                                            </creator_id>
275
                                            <taxonomicname>
276
                                                <_join_words>
277
                                                    <1>$orig_family</1>
278
                                                    <3>$orig_species</3>
279
                                                </_join_words>
280
                                            </taxonomicname>
281
                                        </taxonlabel>
282
                                    </matched_label_id>
283
                                    <parent_id>
284
                                        <taxonlabel>
271
                                            <matched_label_id>
272
                                                <taxonlabel>
273
                                                    <creator_id>
274
                                                        <party>
275
                                                            <creator_id>0</creator_id>
276
                                                            <organizationname>TNRS</organizationname>
277
                                                        </party>
278
                                                    </creator_id>
279
                                                    <taxonomicname>
280
                                                        <_join_words>
281
                                                            <1>$orig_family</1>
282
                                                            <3>$orig_species</3>
283
                                                        </_join_words>
284
                                                    </taxonomicname>
285
                                                </taxonlabel>
286
                                            </matched_label_id>
285 287
                                            <parent_id>
286 288
                                                <taxonlabel>
287
                                                    <rank>cultivar</rank>
288 289
                                                    <parent_id>
289 290
                                                        <taxonlabel>
290
                                                            <rank>forma</rank>
291
                                                            <rank>cultivar</rank>
291 292
                                                            <parent_id>
292 293
                                                                <taxonlabel>
293
                                                                    <rank>variety</rank>
294
                                                                    <rank>forma</rank>
294 295
                                                                    <parent_id>
295 296
                                                                        <taxonlabel>
296
                                                                            <rank>subspecies</rank>
297
                                                                            <rank>variety</rank>
297 298
                                                                            <parent_id>
298 299
                                                                                <taxonlabel>
299
                                                                                    <rank>species</rank>
300
                                                                                    <taxonepithet>$orig_species</taxonepithet>
300
                                                                                    <rank>subspecies</rank>
301 301
                                                                                    <parent_id>
302 302
                                                                                        <taxonlabel>
303
                                                                                            <rank>genus</rank>
303
                                                                                            <rank>species</rank>
304
                                                                                            <taxonepithet>$orig_species</taxonepithet>
304 305
                                                                                            <parent_id>
305 306
                                                                                                <taxonlabel>
306
                                                                                                    <rank>family</rank>
307
                                                                                                    <taxonepithet>$orig_family</taxonepithet>
307
                                                                                                    <rank>genus</rank>
308
                                                                                                    <parent_id>
309
                                                                                                        <taxonlabel>
310
                                                                                                            <rank>family</rank>
311
                                                                                                            <taxonepithet>$orig_family</taxonepithet>
312
                                                                                                        </taxonlabel>
313
                                                                                                    </parent_id>
308 314
                                                                                                </taxonlabel>
309 315
                                                                                            </parent_id>
310 316
                                                                                        </taxonlabel>
......
319 325
                                                    </parent_id>
320 326
                                                </taxonlabel>
321 327
                                            </parent_id>
328
                                            <taxonomicname>
329
                                                <_join_words>
330
                                                    <1>$orig_family</1>
331
                                                    <3>$orig_species</3>
332
                                                </_join_words>
333
                                            </taxonomicname>
322 334
                                        </taxonlabel>
323
                                    </parent_id>
324
                                    <taxonomicname>
325
                                        <_join_words>
326
                                            <1>$orig_family</1>
327
                                            <3>$orig_species</3>
328
                                        </_join_words>
329
                                    </taxonomicname>
330
                                    <taxonverbatim>
331
                                        <family>$orig_family</family>
332
                                        <species>$orig_species</species>
333
                                    </taxonverbatim>
334
                                </taxonlabel>
335
                            </taxonlabel_id>
335
                                    </taxonlabel_id>
336
                                    <family>$orig_family</family>
337
                                    <species>$orig_species</species>
338
                                </taxonverbatim>
339
                            </taxonverbatim_id>
336 340
                        </taxondetermination>
337 341
                        <verbatimcollectorname>
338 342
                            <_join_words>

Also available in: Unified diff