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
42 42
                        <authortaxoncode>$Tree Number</authortaxoncode>
43 43
                        <sourceaccessioncode>$Id</sourceaccessioncode>
44 44
                        <taxondetermination>
45
                            <taxonlabel_id>
46
                                <taxonlabel>
47
                                    <matched_label_id>
45
                            <taxonverbatim_id>
46
                                <taxonverbatim>
47
                                    <taxonlabel_id>
48 48
                                        <taxonlabel>
49
                                            <creator_id>
50
                                                <party>
51
                                                    <creator_id>0</creator_id>
52
                                                    <organizationname>TNRS</organizationname>
53
                                                </party>
54
                                            </creator_id>
55
                                            <taxonomicname>
56
                                                <_join_words>
57
                                                    <1>$Family</1>
58
                                                    <2>$Genus</2>
59
                                                    <3>$Species</3>
60
                                                </_join_words>
61
                                            </taxonomicname>
62
                                        </taxonlabel>
63
                                    </matched_label_id>
64
                                    <parent_id>
65
                                        <taxonlabel>
49
                                            <matched_label_id>
50
                                                <taxonlabel>
51
                                                    <creator_id>
52
                                                        <party>
53
                                                            <creator_id>0</creator_id>
54
                                                            <organizationname>TNRS</organizationname>
55
                                                        </party>
56
                                                    </creator_id>
57
                                                    <taxonomicname>
58
                                                        <_join_words>
59
                                                            <1>$Family</1>
60
                                                            <2>$Genus</2>
61
                                                            <3>$Species</3>
62
                                                        </_join_words>
63
                                                    </taxonomicname>
64
                                                </taxonlabel>
65
                                            </matched_label_id>
66 66
                                            <parent_id>
67 67
                                                <taxonlabel>
68
                                                    <rank>cultivar</rank>
69 68
                                                    <parent_id>
70 69
                                                        <taxonlabel>
71
                                                            <rank>forma</rank>
70
                                                            <rank>cultivar</rank>
72 71
                                                            <parent_id>
73 72
                                                                <taxonlabel>
74
                                                                    <rank>variety</rank>
73
                                                                    <rank>forma</rank>
75 74
                                                                    <parent_id>
76 75
                                                                        <taxonlabel>
77
                                                                            <rank>subspecies</rank>
76
                                                                            <rank>variety</rank>
78 77
                                                                            <parent_id>
79 78
                                                                                <taxonlabel>
80
                                                                                    <rank>species</rank>
81
                                                                                    <taxonepithet>$Species</taxonepithet>
79
                                                                                    <rank>subspecies</rank>
82 80
                                                                                    <parent_id>
83 81
                                                                                        <taxonlabel>
84
                                                                                            <rank>genus</rank>
85
                                                                                            <taxonepithet>$Genus</taxonepithet>
82
                                                                                            <rank>species</rank>
83
                                                                                            <taxonepithet>$Species</taxonepithet>
86 84
                                                                                            <parent_id>
87 85
                                                                                                <taxonlabel>
88
                                                                                                    <rank>family</rank>
89
                                                                                                    <taxonepithet>$Family</taxonepithet>
86
                                                                                                    <rank>genus</rank>
87
                                                                                                    <taxonepithet>$Genus</taxonepithet>
88
                                                                                                    <parent_id>
89
                                                                                                        <taxonlabel>
90
                                                                                                            <rank>family</rank>
91
                                                                                                            <taxonepithet>$Family</taxonepithet>
92
                                                                                                        </taxonlabel>
93
                                                                                                    </parent_id>
90 94
                                                                                                </taxonlabel>
91 95
                                                                                            </parent_id>
92 96
                                                                                        </taxonlabel>
......
101 105
                                                    </parent_id>
102 106
                                                </taxonlabel>
103 107
                                            </parent_id>
108
                                            <taxonomicname>
109
                                                <_join_words>
110
                                                    <1>$Family</1>
111
                                                    <2>$Genus</2>
112
                                                    <3>$Species</3>
113
                                                </_join_words>
114
                                            </taxonomicname>
104 115
                                        </taxonlabel>
105
                                    </parent_id>
106
                                    <taxonomicname>
107
                                        <_join_words>
108
                                            <1>$Family</1>
109
                                            <2>$Genus</2>
110
                                            <3>$Species</3>
111
                                        </_join_words>
112
                                    </taxonomicname>
113
                                    <taxonverbatim>
114
                                        <family>$Family</family>
115
                                        <genus>$Genus</genus>
116
                                        <species>$Species</species>
117
                                    </taxonverbatim>
118
                                </taxonlabel>
119
                            </taxonlabel_id>
116
                                    </taxonlabel_id>
117
                                    <family>$Family</family>
118
                                    <genus>$Genus</genus>
119
                                    <species>$Species</species>
120
                                </taxonverbatim>
121
                            </taxonverbatim_id>
120 122
                        </taxondetermination>
121 123
                        <verbatimcollectorname>$Names of Collectors</verbatimcollectorname>
122 124
                    </taxonoccurrence>

Also available in: Unified diff