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
16 16
                        <authortaxoncode>$authorplantname</authortaxoncode>
17 17
                        <sourceaccessioncode>$taxonobservation_id</sourceaccessioncode>
18 18
                        <taxondetermination>
19
                            <taxonconcept_id>
20
                                <taxonconcept>
21
                                    <matched_concept_id>
22
                                        <taxonconcept>
19
                            <taxonlabel_id>
20
                                <taxonlabel>
21
                                    <matched_label_id>
22
                                        <taxonlabel>
23 23
                                            <creator_id>
24 24
                                                <party>
25 25
                                                    <creator_id>0</creator_id>
......
46 46
                                                    </8>
47 47
                                                </_join_words>
48 48
                                            </identifyingtaxonomicname>
49
                                        </taxonconcept>
50
                                    </matched_concept_id>
49
                                        </taxonlabel>
50
                                    </matched_label_id>
51 51
                                    <family>$Family</family>
52 52
                                    <genus>$Genus</genus>
53 53
                                    <parent_id>
54
                                        <taxonconcept>
54
                                        <taxonlabel>
55 55
                                            <parent_id>
56
                                                <taxonconcept>
56
                                                <taxonlabel>
57 57
                                                    <rank>cultivar</rank>
58 58
                                                    <parent_id>
59
                                                        <taxonconcept>
59
                                                        <taxonlabel>
60 60
                                                            <rank>forma</rank>
61 61
                                                            <taxonepithet>$Forma</taxonepithet>
62 62
                                                            <parent_id>
63
                                                                <taxonconcept>
63
                                                                <taxonlabel>
64 64
                                                                    <rank>variety</rank>
65 65
                                                                    <taxonepithet>$Variety</taxonepithet>
66 66
                                                                    <parent_id>
67
                                                                        <taxonconcept>
67
                                                                        <taxonlabel>
68 68
                                                                            <rank>subspecies</rank>
69 69
                                                                            <taxonepithet>$Subspecies</taxonepithet>
70 70
                                                                            <parent_id>
71
                                                                                <taxonconcept>
71
                                                                                <taxonlabel>
72 72
                                                                                    <rank>species</rank>
73 73
                                                                                    <taxonepithet>$Species</taxonepithet>
74 74
                                                                                    <parent_id>
75
                                                                                        <taxonconcept>
75
                                                                                        <taxonlabel>
76 76
                                                                                            <rank>genus</rank>
77 77
                                                                                            <taxonepithet>$Genus</taxonepithet>
78 78
                                                                                            <parent_id>
79
                                                                                                <taxonconcept>
79
                                                                                                <taxonlabel>
80 80
                                                                                                    <rank>family</rank>
81 81
                                                                                                    <taxonepithet>$Family</taxonepithet>
82 82
                                                                                                    <parent_id>
83
                                                                                                        <taxonconcept>
83
                                                                                                        <taxonlabel>
84 84
                                                                                                            <rank>order</rank>
85 85
                                                                                                            <taxonepithet>$Order</taxonepithet>
86 86
                                                                                                            <parent_id>
87
                                                                                                                <taxonconcept>
87
                                                                                                                <taxonlabel>
88 88
                                                                                                                    <rank>class</rank>
89 89
                                                                                                                    <taxonepithet>$Class</taxonepithet>
90 90
                                                                                                                    <parent_id>
91
                                                                                                                        <taxonconcept>
91
                                                                                                                        <taxonlabel>
92 92
                                                                                                                            <rank>phylum</rank>
93 93
                                                                                                                            <parent_id>
94
                                                                                                                                <taxonconcept>
94
                                                                                                                                <taxonlabel>
95 95
                                                                                                                                    <rank>kingdom</rank>
96 96
                                                                                                                                    <taxonepithet>$Kingdom</taxonepithet>
97
                                                                                                                                </taxonconcept>
97
                                                                                                                                </taxonlabel>
98 98
                                                                                                                            </parent_id>
99
                                                                                                                        </taxonconcept>
99
                                                                                                                        </taxonlabel>
100 100
                                                                                                                    </parent_id>
101
                                                                                                                </taxonconcept>
101
                                                                                                                </taxonlabel>
102 102
                                                                                                            </parent_id>
103
                                                                                                        </taxonconcept>
103
                                                                                                        </taxonlabel>
104 104
                                                                                                    </parent_id>
105
                                                                                                </taxonconcept>
105
                                                                                                </taxonlabel>
106 106
                                                                                            </parent_id>
107
                                                                                        </taxonconcept>
107
                                                                                        </taxonlabel>
108 108
                                                                                    </parent_id>
109
                                                                                </taxonconcept>
109
                                                                                </taxonlabel>
110 110
                                                                            </parent_id>
111
                                                                        </taxonconcept>
111
                                                                        </taxonlabel>
112 112
                                                                    </parent_id>
113
                                                                </taxonconcept>
113
                                                                </taxonlabel>
114 114
                                                            </parent_id>
115
                                                        </taxonconcept>
115
                                                        </taxonlabel>
116 116
                                                    </parent_id>
117
                                                </taxonconcept>
117
                                                </taxonlabel>
118 118
                                            </parent_id>
119
                                        </taxonconcept>
119
                                        </taxonlabel>
120 120
                                    </parent_id>
121 121
                                    <species>$Species</species>
122 122
                                    <creationdate><_date><date><_dateRangeStart><value>$interpretationdate</value></_dateRangeStart></date></_date></creationdate>
123
                                </taxonconcept>
124
                            </taxonconcept_id>
123
                                </taxonlabel>
124
                            </taxonlabel_id>
125 125
                            <taxonfit>$taxonfit</taxonfit>
126 126
                            <determinationdate><_date><date><_dateRangeStart><value>$interpretationdate</value></_dateRangeStart></date></_date></determinationdate>
127 127
                        </taxondetermination>
128 128
                        <taxondetermination>
129 129
                            <isoriginal>true</isoriginal>
130
                            <taxonconcept_id>
131
                                <taxonconcept>
132
                                    <matched_concept_id>
133
                                        <taxonconcept>
130
                            <taxonlabel_id>
131
                                <taxonlabel>
132
                                    <matched_label_id>
133
                                        <taxonlabel>
134 134
                                            <creator_id>
135 135
                                                <party>
136 136
                                                    <creator_id>0</creator_id>
......
138 138
                                                </party>
139 139
                                            </creator_id>
140 140
                                            <identifyingtaxonomicname>$authorplantname</identifyingtaxonomicname>
141
                                        </taxonconcept>
142
                                    </matched_concept_id>
141
                                        </taxonlabel>
142
                                    </matched_label_id>
143 143
                                    <taxonomicname>$authorplantname</taxonomicname>
144
                                </taxonconcept>
145
                            </taxonconcept_id>
144
                                </taxonlabel>
145
                            </taxonlabel_id>
146 146
                        </taxondetermination>
147 147
                    </taxonoccurrence>
148 148
                </locationevent>

Also available in: Unified diff