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
116 116
                        </growthform>
117 117
                        <sourceaccessioncode>$PlotObsID</sourceaccessioncode>
118 118
                        <taxondetermination>
119
                            <taxonconcept_id>
120
                                <taxonconcept>
121
                                    <matched_concept_id>
122
                                        <taxonconcept>
119
                            <taxonlabel_id>
120
                                <taxonlabel>
121
                                    <matched_label_id>
122
                                        <taxonlabel>
123 123
                                            <creator_id>
124 124
                                                <party>
125 125
                                                    <creator_id>0</creator_id>
......
149 149
                                                    <2>$auth</2>
150 150
                                                </_join_words>
151 151
                                            </identifyingtaxonomicname>
152
                                        </taxonconcept>
153
                                    </matched_concept_id>
152
                                        </taxonlabel>
153
                                    </matched_label_id>
154 154
                                    <author>$auth</author>
155 155
                                    <family>$Family</family>
156 156
                                    <genus>$Genus</genus>
157 157
                                    <parent_id>
158
                                        <taxonconcept>
158
                                        <taxonlabel>
159 159
                                            <rank>$infra_rank_1</rank>
160 160
                                            <verbatimrank>$infra_rank_1</verbatimrank>
161 161
                                            <parent_id>
162
                                                <taxonconcept>
162
                                                <taxonlabel>
163 163
                                                    <rank>cultivar</rank>
164 164
                                                    <parent_id>
165
                                                        <taxonconcept>
165
                                                        <taxonlabel>
166 166
                                                            <rank>forma</rank>
167 167
                                                            <parent_id>
168
                                                                <taxonconcept>
168
                                                                <taxonlabel>
169 169
                                                                    <rank>variety</rank>
170 170
                                                                    <parent_id>
171
                                                                        <taxonconcept>
171
                                                                        <taxonlabel>
172 172
                                                                            <rank>subspecies</rank>
173 173
                                                                            <parent_id>
174
                                                                                <taxonconcept>
174
                                                                                <taxonlabel>
175 175
                                                                                    <rank>species</rank>
176 176
                                                                                    <taxonepithet>$Species</taxonepithet>
177 177
                                                                                    <parent_id>
178
                                                                                        <taxonconcept>
178
                                                                                        <taxonlabel>
179 179
                                                                                            <rank>genus</rank>
180 180
                                                                                            <taxonepithet>$Genus</taxonepithet>
181 181
                                                                                            <parent_id>
182
                                                                                                <taxonconcept>
182
                                                                                                <taxonlabel>
183 183
                                                                                                    <rank>family</rank>
184 184
                                                                                                    <taxonepithet>$Family</taxonepithet>
185
                                                                                                </taxonconcept>
185
                                                                                                </taxonlabel>
186 186
                                                                                            </parent_id>
187
                                                                                        </taxonconcept>
187
                                                                                        </taxonlabel>
188 188
                                                                                    </parent_id>
189
                                                                                </taxonconcept>
189
                                                                                </taxonlabel>
190 190
                                                                            </parent_id>
191
                                                                        </taxonconcept>
191
                                                                        </taxonlabel>
192 192
                                                                    </parent_id>
193
                                                                </taxonconcept>
193
                                                                </taxonlabel>
194 194
                                                            </parent_id>
195
                                                        </taxonconcept>
195
                                                        </taxonlabel>
196 196
                                                    </parent_id>
197
                                                </taxonconcept>
197
                                                </taxonlabel>
198 198
                                            </parent_id>
199 199
                                            <taxonepithet>$infra_ep_1</taxonepithet>
200
                                        </taxonconcept>
200
                                        </taxonlabel>
201 201
                                    </parent_id>
202 202
                                    <rank>$infra_rank_1</rank>
203 203
                                    <species>$Species</species>
204 204
                                    <verbatimrank>$infra_rank_1</verbatimrank>
205
                                </taxonconcept>
206
                            </taxonconcept_id>
205
                                </taxonlabel>
206
                            </taxonlabel_id>
207 207
                            <taxonfit>$cfaff</taxonfit>
208 208
                        </taxondetermination>
209 209
                        <taxondetermination>
210 210
                            <isoriginal>true</isoriginal>
211
                            <taxonconcept_id>
212
                                <taxonconcept>
211
                            <taxonlabel_id>
212
                                <taxonlabel>
213 213
                                    <family>$OrigFamily</family>
214 214
                                    <genus>$OrigGenus</genus>
215
                                    <matched_concept_id>
216
                                        <taxonconcept>
215
                                    <matched_label_id>
216
                                        <taxonlabel>
217 217
                                            <creator_id>
218 218
                                                <party>
219 219
                                                    <creator_id>0</creator_id>
......
227 227
                                                    <3>$OrigSpecies</3>
228 228
                                                </_join_words>
229 229
                                            </identifyingtaxonomicname>
230
                                        </taxonconcept>
231
                                    </matched_concept_id>
230
                                        </taxonlabel>
231
                                    </matched_label_id>
232 232
                                    <parent_id>
233
                                        <taxonconcept>
233
                                        <taxonlabel>
234 234
                                            <parent_id>
235
                                                <taxonconcept>
235
                                                <taxonlabel>
236 236
                                                    <rank>cultivar</rank>
237 237
                                                    <parent_id>
238
                                                        <taxonconcept>
238
                                                        <taxonlabel>
239 239
                                                            <rank>forma</rank>
240 240
                                                            <parent_id>
241
                                                                <taxonconcept>
241
                                                                <taxonlabel>
242 242
                                                                    <rank>variety</rank>
243 243
                                                                    <parent_id>
244
                                                                        <taxonconcept>
244
                                                                        <taxonlabel>
245 245
                                                                            <rank>subspecies</rank>
246 246
                                                                            <parent_id>
247
                                                                                <taxonconcept>
247
                                                                                <taxonlabel>
248 248
                                                                                    <rank>species</rank>
249 249
                                                                                    <taxonepithet>$OrigSpecies</taxonepithet>
250 250
                                                                                    <parent_id>
251
                                                                                        <taxonconcept>
251
                                                                                        <taxonlabel>
252 252
                                                                                            <rank>genus</rank>
253 253
                                                                                            <taxonepithet>$OrigGenus</taxonepithet>
254 254
                                                                                            <parent_id>
255
                                                                                                <taxonconcept>
255
                                                                                                <taxonlabel>
256 256
                                                                                                    <rank>family</rank>
257 257
                                                                                                    <taxonepithet>$OrigFamily</taxonepithet>
258
                                                                                                </taxonconcept>
258
                                                                                                </taxonlabel>
259 259
                                                                                            </parent_id>
260
                                                                                        </taxonconcept>
260
                                                                                        </taxonlabel>
261 261
                                                                                    </parent_id>
262
                                                                                </taxonconcept>
262
                                                                                </taxonlabel>
263 263
                                                                            </parent_id>
264
                                                                        </taxonconcept>
264
                                                                        </taxonlabel>
265 265
                                                                    </parent_id>
266
                                                                </taxonconcept>
266
                                                                </taxonlabel>
267 267
                                                            </parent_id>
268
                                                        </taxonconcept>
268
                                                        </taxonlabel>
269 269
                                                    </parent_id>
270
                                                </taxonconcept>
270
                                                </taxonlabel>
271 271
                                            </parent_id>
272
                                        </taxonconcept>
272
                                        </taxonlabel>
273 273
                                    </parent_id>
274 274
                                    <species>$OrigSpecies</species>
275
                                </taxonconcept>
276
                            </taxonconcept_id>
275
                                </taxonlabel>
276
                            </taxonlabel_id>
277 277
                        </taxondetermination>
278 278
                        <verbatimcollectorname>
279 279
                            <_join_words>

Also available in: Unified diff