Project

General

Profile

« Previous | Next » 

Revision 5608

schemas/vegbien.sql: Renamed taxonconcept to taxonlabel per today's conference call, where it was decided that taxonconcept contained too many unrelated fields to be purely a taxon concept

View differences:

test.xml.ref
145 145
                        </growthform>
146 146
                        <sourceaccessioncode>$OBSERVATION_ID</sourceaccessioncode>
147 147
                        <taxondetermination>
148
                            <taxonconcept_id>
149
                                <taxonconcept>
150
                                    <matched_concept_id>
151
                                        <taxonconcept>
148
                            <taxonlabel_id>
149
                                <taxonlabel>
150
                                    <matched_label_id>
151
                                        <taxonlabel>
152 152
                                            <creator_id>
153 153
                                                <party>
154 154
                                                    <creator_id>0</creator_id>
......
178 178
                                                    <2>$specific_authority</2>
179 179
                                                </_join_words>
180 180
                                            </identifyingtaxonomicname>
181
                                        </taxonconcept>
182
                                    </matched_concept_id>
181
                                        </taxonlabel>
182
                                    </matched_label_id>
183 183
                                    <author>$specific_authority</author>
184 184
                                    <family>$family</family>
185 185
                                    <genus>$genus</genus>
186 186
                                    <parent_id>
187
                                        <taxonconcept>
187
                                        <taxonlabel>
188 188
                                            <rank>$infra_rank_1</rank>
189 189
                                            <verbatimrank>$infra_rank_1</verbatimrank>
190 190
                                            <parent_id>
191
                                                <taxonconcept>
191
                                                <taxonlabel>
192 192
                                                    <rank>cultivar</rank>
193 193
                                                    <parent_id>
194
                                                        <taxonconcept>
194
                                                        <taxonlabel>
195 195
                                                            <rank>forma</rank>
196 196
                                                            <parent_id>
197
                                                                <taxonconcept>
197
                                                                <taxonlabel>
198 198
                                                                    <rank>variety</rank>
199 199
                                                                    <parent_id>
200
                                                                        <taxonconcept>
200
                                                                        <taxonlabel>
201 201
                                                                            <rank>subspecies</rank>
202 202
                                                                            <parent_id>
203
                                                                                <taxonconcept>
203
                                                                                <taxonlabel>
204 204
                                                                                    <rank>species</rank>
205 205
                                                                                    <taxonepithet>$specific_epithet</taxonepithet>
206 206
                                                                                    <parent_id>
207
                                                                                        <taxonconcept>
207
                                                                                        <taxonlabel>
208 208
                                                                                            <rank>genus</rank>
209 209
                                                                                            <taxonepithet>$genus</taxonepithet>
210 210
                                                                                            <parent_id>
211
                                                                                                <taxonconcept>
211
                                                                                                <taxonlabel>
212 212
                                                                                                    <rank>family</rank>
213 213
                                                                                                    <taxonepithet>$family</taxonepithet>
214
                                                                                                </taxonconcept>
214
                                                                                                </taxonlabel>
215 215
                                                                                            </parent_id>
216
                                                                                        </taxonconcept>
216
                                                                                        </taxonlabel>
217 217
                                                                                    </parent_id>
218
                                                                                </taxonconcept>
218
                                                                                </taxonlabel>
219 219
                                                                            </parent_id>
220
                                                                        </taxonconcept>
220
                                                                        </taxonlabel>
221 221
                                                                    </parent_id>
222
                                                                </taxonconcept>
222
                                                                </taxonlabel>
223 223
                                                            </parent_id>
224
                                                        </taxonconcept>
224
                                                        </taxonlabel>
225 225
                                                    </parent_id>
226
                                                </taxonconcept>
226
                                                </taxonlabel>
227 227
                                            </parent_id>
228 228
                                            <taxonepithet>$infra_ep_1</taxonepithet>
229
                                        </taxonconcept>
229
                                        </taxonlabel>
230 230
                                    </parent_id>
231 231
                                    <rank>$infra_rank_1</rank>
232 232
                                    <species>$specific_epithet</species>
233 233
                                    <verbatimrank>$infra_rank_1</verbatimrank>
234
                                </taxonconcept>
235
                            </taxonconcept_id>
234
                                </taxonlabel>
235
                            </taxonlabel_id>
236 236
                            <taxonfit>$cf_aff</taxonfit>
237 237
                        </taxondetermination>
238 238
                        <taxondetermination>
239 239
                            <isoriginal>true</isoriginal>
240
                            <taxonconcept_id>
241
                                <taxonconcept>
240
                            <taxonlabel_id>
241
                                <taxonlabel>
242 242
                                    <family>$orig_family</family>
243
                                    <matched_concept_id>
244
                                        <taxonconcept>
243
                                    <matched_label_id>
244
                                        <taxonlabel>
245 245
                                            <creator_id>
246 246
                                                <party>
247 247
                                                    <creator_id>0</creator_id>
......
254 254
                                                    <3>$orig_species</3>
255 255
                                                </_join_words>
256 256
                                            </identifyingtaxonomicname>
257
                                        </taxonconcept>
258
                                    </matched_concept_id>
257
                                        </taxonlabel>
258
                                    </matched_label_id>
259 259
                                    <parent_id>
260
                                        <taxonconcept>
260
                                        <taxonlabel>
261 261
                                            <parent_id>
262
                                                <taxonconcept>
262
                                                <taxonlabel>
263 263
                                                    <rank>cultivar</rank>
264 264
                                                    <parent_id>
265
                                                        <taxonconcept>
265
                                                        <taxonlabel>
266 266
                                                            <rank>forma</rank>
267 267
                                                            <parent_id>
268
                                                                <taxonconcept>
268
                                                                <taxonlabel>
269 269
                                                                    <rank>variety</rank>
270 270
                                                                    <parent_id>
271
                                                                        <taxonconcept>
271
                                                                        <taxonlabel>
272 272
                                                                            <rank>subspecies</rank>
273 273
                                                                            <parent_id>
274
                                                                                <taxonconcept>
274
                                                                                <taxonlabel>
275 275
                                                                                    <rank>species</rank>
276 276
                                                                                    <taxonepithet>$orig_species</taxonepithet>
277 277
                                                                                    <parent_id>
278
                                                                                        <taxonconcept>
278
                                                                                        <taxonlabel>
279 279
                                                                                            <rank>genus</rank>
280 280
                                                                                            <parent_id>
281
                                                                                                <taxonconcept>
281
                                                                                                <taxonlabel>
282 282
                                                                                                    <rank>family</rank>
283 283
                                                                                                    <taxonepithet>$orig_family</taxonepithet>
284
                                                                                                </taxonconcept>
284
                                                                                                </taxonlabel>
285 285
                                                                                            </parent_id>
286
                                                                                        </taxonconcept>
286
                                                                                        </taxonlabel>
287 287
                                                                                    </parent_id>
288
                                                                                </taxonconcept>
288
                                                                                </taxonlabel>
289 289
                                                                            </parent_id>
290
                                                                        </taxonconcept>
290
                                                                        </taxonlabel>
291 291
                                                                    </parent_id>
292
                                                                </taxonconcept>
292
                                                                </taxonlabel>
293 293
                                                            </parent_id>
294
                                                        </taxonconcept>
294
                                                        </taxonlabel>
295 295
                                                    </parent_id>
296
                                                </taxonconcept>
296
                                                </taxonlabel>
297 297
                                            </parent_id>
298
                                        </taxonconcept>
298
                                        </taxonlabel>
299 299
                                    </parent_id>
300 300
                                    <species>$orig_species</species>
301
                                </taxonconcept>
302
                            </taxonconcept_id>
301
                                </taxonlabel>
302
                            </taxonlabel_id>
303 303
                        </taxondetermination>
304 304
                        <verbatimcollectorname>
305 305
                            <_join_words>

Also available in: Unified diff