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
40 40
                        </isnative>
41 41
                        <sourceaccessioncode>$id</sourceaccessioncode>
42 42
                        <taxondetermination>
43
                            <taxonlabel_id>
44
                                <taxonlabel>
45
                                    <matched_label_id>
43
                            <taxonverbatim_id>
44
                                <taxonverbatim>
45
                                    <taxonlabel_id>
46 46
                                        <taxonlabel>
47
                                            <creator_id>
48
                                                <party>
49
                                                    <creator_id>0</creator_id>
50
                                                    <organizationname>TNRS</organizationname>
51
                                                </party>
52
                                            </creator_id>
53
                                            <taxonomicname>
54
                                                <_join_words>
55
                                                    <1>$family</1>
56
                                                    <2>$genus</2>
57
                                                </_join_words>
58
                                            </taxonomicname>
59
                                        </taxonlabel>
60
                                    </matched_label_id>
61
                                    <parent_id>
62
                                        <taxonlabel>
47
                                            <matched_label_id>
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
                                                        </_join_words>
60
                                                    </taxonomicname>
61
                                                </taxonlabel>
62
                                            </matched_label_id>
63 63
                                            <parent_id>
64 64
                                                <taxonlabel>
65
                                                    <rank>cultivar</rank>
66 65
                                                    <parent_id>
67 66
                                                        <taxonlabel>
68
                                                            <rank>forma</rank>
67
                                                            <rank>cultivar</rank>
69 68
                                                            <parent_id>
70 69
                                                                <taxonlabel>
71
                                                                    <rank>variety</rank>
70
                                                                    <rank>forma</rank>
72 71
                                                                    <parent_id>
73 72
                                                                        <taxonlabel>
74
                                                                            <rank>subspecies</rank>
73
                                                                            <rank>variety</rank>
75 74
                                                                            <parent_id>
76 75
                                                                                <taxonlabel>
77
                                                                                    <rank>species</rank>
76
                                                                                    <rank>subspecies</rank>
78 77
                                                                                    <parent_id>
79 78
                                                                                        <taxonlabel>
80
                                                                                            <rank>genus</rank>
81
                                                                                            <taxonepithet>$genus</taxonepithet>
79
                                                                                            <rank>species</rank>
82 80
                                                                                            <parent_id>
83 81
                                                                                                <taxonlabel>
84
                                                                                                    <rank>family</rank>
85
                                                                                                    <taxonepithet>$family</taxonepithet>
82
                                                                                                    <rank>genus</rank>
83
                                                                                                    <taxonepithet>$genus</taxonepithet>
84
                                                                                                    <parent_id>
85
                                                                                                        <taxonlabel>
86
                                                                                                            <rank>family</rank>
87
                                                                                                            <taxonepithet>$family</taxonepithet>
88
                                                                                                        </taxonlabel>
89
                                                                                                    </parent_id>
86 90
                                                                                                </taxonlabel>
87 91
                                                                                            </parent_id>
88 92
                                                                                        </taxonlabel>
......
97 101
                                                    </parent_id>
98 102
                                                </taxonlabel>
99 103
                                            </parent_id>
104
                                            <taxonomicname>
105
                                                <_join_words>
106
                                                    <1>$family</1>
107
                                                    <2>$genus</2>
108
                                                </_join_words>
109
                                            </taxonomicname>
100 110
                                        </taxonlabel>
101
                                    </parent_id>
102
                                    <taxonomicname>
103
                                        <_join_words>
104
                                            <1>$family</1>
105
                                            <2>$genus</2>
106
                                        </_join_words>
107
                                    </taxonomicname>
108
                                    <taxonverbatim>
109
                                        <family>$family</family>
110
                                        <genus>$genus</genus>
111
                                    </taxonverbatim>
112
                                </taxonlabel>
113
                            </taxonlabel_id>
111
                                    </taxonlabel_id>
112
                                    <family>$family</family>
113
                                    <genus>$genus</genus>
114
                                </taxonverbatim>
115
                            </taxonverbatim_id>
114 116
                        </taxondetermination>
115 117
                    </taxonoccurrence>
116 118
                </locationevent>

Also available in: Unified diff