Project

General

Profile

« Previous | Next » 

Revision 11066

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: party: added separate person subclass, which has the organization pointer. organization instead has a recursive parent pointer, to avoid mutual recursion between party and organization.

View differences:

schemas/VegCore/ERD/document.mwb.xml
64 64 
                      <value type="string" key="oldName">name</value>
65 65 
                      <link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
66 66 
                    </value>
67 
                    <value type="object" struct-name="db.mysql.Column" id="e5502346-f676-11e2-9716-080027bcf912" struct-checksum="0x783b5183">
68 
                      <value type="int" key="autoIncrement">0</value>
69 
                      <value type="string" key="characterSetName"></value>
70 
                      <value _ptr_="0xba3e990" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
71 
                      <value type="string" key="collationName"></value>
72 
                      <value type="string" key="datatypeExplicitParams"></value>
73 
                      <value type="string" key="defaultValue"></value>
74 
                      <value type="int" key="defaultValueIsNull">1</value>
75 
                      <value _ptr_="0xba3ecb8" type="list" content-type="string" key="flags"/>
76 
                      <value type="int" key="isNotNull">0</value>
77 
                      <value type="int" key="length">767</value>
78 
                      <value type="int" key="precision">-1</value>
79 
                      <value type="int" key="scale">-1</value>
80 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
81 
                      <value type="string" key="comment"></value>
82 
                      <value type="string" key="name">organization</value>
83 
                      <value type="string" key="oldName">organization</value>
84 
                      <link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
85 
                    </value>
86 67 
                  </value>
87 68 
                  <value type="string" key="connectionString"></value>
88 69 
                  <value type="string" key="defaultCharacterSetName">utf8</value>
89 70 
                  <value type="string" key="defaultCollationName">utf8_bin</value>
90 71 
                  <value type="int" key="delayKeyWrite">0</value>
91 72 
                  <value _ptr_="0xba3de40" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
92 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="e550209e-f676-11e2-9716-080027bcf912" struct-checksum="0x70a8fc40">
93 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">049df920-a91b-11e2-bdec-080027bcf912</link>
94 
                      <value _ptr_="0xba3f2a8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
95 
                        <link type="object">e5502346-f676-11e2-9716-080027bcf912</link>
96 
                      </value>
97 
                      <value type="int" key="deferability">0</value>
98 
                      <value type="string" key="deleteRule">CASCADE</value>
99 
                      <link type="object" struct-name="db.Index" key="index">e550389a-f676-11e2-9716-080027bcf912</link>
100 
                      <value type="int" key="mandatory">1</value>
101 
                      <value type="int" key="many">1</value>
102 
                      <value type="int" key="modelOnly">0</value>
103 
                      <link type="object" struct-name="db.Table" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
104 
                      <value _ptr_="0xba3f598" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
105 
                        <link type="object">049dfc5e-a91b-11e2-bdec-080027bcf912</link>
106 
                      </value>
107 
                      <value type="int" key="referencedMandatory">0</value>
108 
                      <value type="string" key="updateRule">CASCADE</value>
109 
                      <value type="string" key="comment"></value>
110 
                      <value type="string" key="name">fk_party_organization1</value>
111 
                      <value type="string" key="oldName">fk_party_organization1</value>
112 
                    </value>
113 73 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="be8fee8e-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">
114 74 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
115 75 
                      <value _ptr_="0xba3f608" type="list" content-type="object" content-struct-name="db.Column" key="columns">
......
176 136 
                      <value type="string" key="oldName">PRIMARY</value>
177 137 
                      <link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
178 138 
                    </value>
179 
                    <value type="object" struct-name="db.mysql.Index" id="e550389a-f676-11e2-9716-080027bcf912" struct-checksum="0x309b847a">
180 
                      <value _ptr_="0xba40030" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
181 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="e5503a2a-f676-11e2-9716-080027bcf912" struct-checksum="0x62630b3c">
182 
                          <value type="int" key="columnLength">0</value>
183 
                          <value type="string" key="comment"></value>
184 
                          <value type="int" key="descend">0</value>
185 
                          <link type="object" struct-name="db.Column" key="referencedColumn">e5502346-f676-11e2-9716-080027bcf912</link>
186 
                          <value type="string" key="name"></value>
187 
                          <link type="object" struct-name="GrtObject" key="owner">e550389a-f676-11e2-9716-080027bcf912</link>
188 
                        </value>
189 
                      </value>
190 
                      <value type="string" key="indexKind"></value>
191 
                      <value type="int" key="keyBlockSize">0</value>
192 
                      <value type="string" key="withParser"></value>
193 
                      <value type="string" key="comment"></value>
194 
                      <value type="int" key="deferability">0</value>
195 
                      <value type="string" key="indexType">INDEX</value>
196 
                      <value type="int" key="isPrimary">0</value>
197 
                      <value type="string" key="name">fk_party_organization1_idx</value>
198 
                      <value type="int" key="unique">0</value>
199 
                      <value type="string" key="oldName">fk_party_organization1_idx</value>
200 
                      <link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
201 
                    </value>
202 
                    <value type="object" struct-name="db.mysql.Index" id="96b8693a-1e00-11e3-9d67-080027bcf912" struct-checksum="0x309b847a">
203 
                      <value _ptr_="0xba40660" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
204 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="9d7d0032-1e00-11e3-9d67-080027bcf912" struct-checksum="0x62630b3c">
205 
                          <value type="int" key="columnLength">0</value>
206 
                          <value type="string" key="comment"></value>
207 
                          <value type="int" key="descend">0</value>
208 
                          <link type="object" struct-name="db.Column" key="referencedColumn">e5502346-f676-11e2-9716-080027bcf912</link>
209 
                          <value type="string" key="name"></value>
210 
                          <link type="object" struct-name="GrtObject" key="owner">96b8693a-1e00-11e3-9d67-080027bcf912</link>
211 
                        </value>
212 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="9dff86e2-1e00-11e3-9d67-080027bcf912" struct-checksum="0x62630b3c">
213 
                          <value type="int" key="columnLength">0</value>
214 
                          <value type="string" key="comment"></value>
215 
                          <value type="int" key="descend">0</value>
216 
                          <link type="object" struct-name="db.Column" key="referencedColumn">8222d06e-1e00-11e3-9d67-080027bcf912</link>
217 
                          <value type="string" key="name"></value>
218 
                          <link type="object" struct-name="GrtObject" key="owner">96b8693a-1e00-11e3-9d67-080027bcf912</link>
219 
                        </value>
220 
                      </value>
221 
                      <value type="string" key="indexKind"></value>
222 
                      <value type="int" key="keyBlockSize">0</value>
223 
                      <value type="string" key="withParser"></value>
224 
                      <value type="string" key="comment"></value>
225 
                      <value type="int" key="deferability">0</value>
226 
                      <value type="string" key="indexType">INDEX</value>
227 
                      <value type="int" key="isPrimary">0</value>
228 
                      <value type="string" key="name">party_unique</value>
229 
                      <value type="int" key="unique">0</value>
230 
                      <value type="string" key="oldName">party_unique</value>
231 
                      <link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
232 
                    </value>
233 139 
                  </value>
234 140 
                  <value type="string" key="maxRows"></value>
235 141 
                  <value type="string" key="mergeInsert"></value>
......
261 167 
                  <value type="int" key="commentedOut">0</value>
262 168 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
263 169 
                  <value _ptr_="0xb030220" type="dict" key="customData"/>
264 
                  <value type="string" key="lastChangeDate">2013-09-15 05:16</value>
170 
                  <value type="string" key="lastChangeDate">2013-09-22 17:48</value>
265 171 
                  <value type="int" key="modelOnly">0</value>
266 172 
                  <value type="string" key="name">party</value>
267 173 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
4101 4007 
                      <value type="string" key="oldName">id</value>
4102 4008 
                      <link type="object" struct-name="GrtObject" key="owner">049df920-a91b-11e2-bdec-080027bcf912</link>
4103 4009 
                    </value>
4010 
                    <value type="object" struct-name="db.mysql.Column" id="39e41094-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x783b5183">
4011 
                      <value type="int" key="autoIncrement">0</value>
4012 
                      <value type="string" key="characterSetName"></value>
4013 
                      <value _ptr_="0xd13ebd0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
4014 
                      <value type="string" key="collationName"></value>
4015 
                      <value type="string" key="datatypeExplicitParams"></value>
4016 
                      <value type="string" key="defaultValue"></value>
4017 
                      <value type="int" key="defaultValueIsNull">1</value>
4018 
                      <value _ptr_="0xcd5b380" type="list" content-type="string" key="flags"/>
4019 
                      <value type="int" key="isNotNull">0</value>
4020 
                      <value type="int" key="length">767</value>
4021 
                      <value type="int" key="precision">-1</value>
4022 
                      <value type="int" key="scale">-1</value>
4023 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
4024 
                      <value type="string" key="comment"></value>
4025 
                      <value type="string" key="name">parent</value>
4026 
                      <value type="string" key="oldName">parent</value>
4027 
                      <link type="object" struct-name="GrtObject" key="owner">049df920-a91b-11e2-bdec-080027bcf912</link>
4028 
                    </value>
4104 4029 
                  </value>
4105 4030 
                  <value type="string" key="connectionString"></value>
4106 4031 
                  <value type="string" key="defaultCharacterSetName">utf8</value>
4107 4032 
                  <value type="string" key="defaultCollationName">utf8_bin</value>
4108 4033 
                  <value type="int" key="delayKeyWrite">0</value>
4109 4034 
                  <value _ptr_="0xba661f0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
4035 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="39e40ed2-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x70a8fc40">
4036 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">049df920-a91b-11e2-bdec-080027bcf912</link>
4037 
                      <value _ptr_="0xccc5ac8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
4038 
                        <link type="object">39e41094-23e9-11e3-ab7c-080027bcf912</link>
4039 
                      </value>
4040 
                      <value type="int" key="deferability">0</value>
4041 
                      <value type="string" key="deleteRule">CASCADE</value>
4042 
                      <link type="object" struct-name="db.Index" key="index">39e42688-23e9-11e3-ab7c-080027bcf912</link>
4043 
                      <value type="int" key="mandatory">1</value>
4044 
                      <value type="int" key="many">1</value>
4045 
                      <value type="int" key="modelOnly">0</value>
4046 
                      <link type="object" struct-name="db.Table" key="owner">049df920-a91b-11e2-bdec-080027bcf912</link>
4047 
                      <value _ptr_="0xd433aa0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
4048 
                        <link type="object">049dfc5e-a91b-11e2-bdec-080027bcf912</link>
4049 
                      </value>
4050 
                      <value type="int" key="referencedMandatory">0</value>
4051 
                      <value type="string" key="updateRule">CASCADE</value>
4052 
                      <value type="string" key="comment"></value>
4053 
                      <value type="string" key="name">fk_organization_organization1</value>
4054 
                      <value type="string" key="oldName">fk_organization_organization1</value>
4055 
                    </value>
4110 4056 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="18e739f0-a91b-11e2-bdec-080027bcf912" struct-checksum="0x70a8fc40">
4111 4057 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
4112 4058 
                      <value _ptr_="0xba66e18" type="list" content-type="object" content-struct-name="db.Column" key="columns">
......
4152 4098 
                      <value type="string" key="oldName">PRIMARY</value>
4153 4099 
                      <link type="object" struct-name="GrtObject" key="owner">049df920-a91b-11e2-bdec-080027bcf912</link>
4154 4100 
                    </value>
4101 
                    <value type="object" struct-name="db.mysql.Index" id="39e42688-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x309b847a">
4102 
                      <value _ptr_="0xcd3b448" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
4103 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="39e4282c-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x62630b3c">
4104 
                          <value type="int" key="columnLength">0</value>
4105 
                          <value type="string" key="comment"></value>
4106 
                          <value type="int" key="descend">0</value>
4107 
                          <link type="object" struct-name="db.Column" key="referencedColumn">39e41094-23e9-11e3-ab7c-080027bcf912</link>
4108 
                          <value type="string" key="name"></value>
4109 
                          <link type="object" struct-name="GrtObject" key="owner">39e42688-23e9-11e3-ab7c-080027bcf912</link>
4110 
                        </value>
4111 
                      </value>
4112 
                      <value type="string" key="indexKind"></value>
4113 
                      <value type="int" key="keyBlockSize">0</value>
4114 
                      <value type="string" key="withParser"></value>
4115 
                      <value type="string" key="comment"></value>
4116 
                      <value type="int" key="deferability">0</value>
4117 
                      <value type="string" key="indexType">INDEX</value>
4118 
                      <value type="int" key="isPrimary">0</value>
4119 
                      <value type="string" key="name">fk_organization_organization1_idx</value>
4120 
                      <value type="int" key="unique">0</value>
4121 
                      <value type="string" key="oldName">fk_organization_organization1_idx</value>
4122 
                      <link type="object" struct-name="GrtObject" key="owner">049df920-a91b-11e2-bdec-080027bcf912</link>
4123 
                    </value>
4155 4124 
                  </value>
4156 4125 
                  <value type="string" key="maxRows"></value>
4157 4126 
                  <value type="string" key="mergeInsert"></value>
......
4183 4152 
                  <value type="int" key="commentedOut">0</value>
4184 4153 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
4185 4154 
                  <value _ptr_="0xba65fc8" type="dict" key="customData"/>
4186 
                  <value type="string" key="lastChangeDate">2013-04-19 11:00</value>
4155 
                  <value type="string" key="lastChangeDate">2013-09-22 17:44</value>
4187 4156 
                  <value type="int" key="modelOnly">0</value>
4188 4157 
                  <value type="string" key="name">organization</value>
4189 4158 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
12819 12788 
                  <value type="string" key="comment">where something came from; a "reference [...] cited within the database" ("VegBank":http://reference.VegBank.vegpath.org); = VegBank.vegpath.org?reference</value>
12820 12789 
                  <value type="string" key="oldName">source</value>
12821 12790 
                </value>
12791 
                <value type="object" struct-name="db.mysql.Table" id="174e1b4c-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x1a403946">
12792 
                  <value type="string" key="avgRowLength"></value>
12793 
                  <value type="int" key="checksum">0</value>
12794 
                  <value _ptr_="0xc6b7490" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
12795 
                    <value type="object" struct-name="db.mysql.Column" id="174e1e76-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x783b5183">
12796 
                      <value type="int" key="autoIncrement">0</value>
12797 
                      <value type="string" key="characterSetName"></value>
12798 
                      <value _ptr_="0xc8a5348" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
12799 
                      <value type="string" key="collationName"></value>
12800 
                      <value type="string" key="datatypeExplicitParams"></value>
12801 
                      <value type="string" key="defaultValue"></value>
12802 
                      <value type="int" key="defaultValueIsNull">0</value>
12803 
                      <value _ptr_="0xc9dd258" type="list" content-type="string" key="flags"/>
12804 
                      <value type="int" key="isNotNull">1</value>
12805 
                      <value type="int" key="length">767</value>
12806 
                      <value type="int" key="precision">-1</value>
12807 
                      <value type="int" key="scale">-1</value>
12808 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
12809 
                      <value type="string" key="comment"></value>
12810 
                      <value type="string" key="name">id</value>
12811 
                      <value type="string" key="oldName">id</value>
12812 
                      <link type="object" struct-name="GrtObject" key="owner">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
12813 
                    </value>
12814 
                    <value type="object" struct-name="db.mysql.Column" id="26132e1a-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x783b5183">
12815 
                      <value type="int" key="autoIncrement">0</value>
12816 
                      <value type="string" key="characterSetName"></value>
12817 
                      <value _ptr_="0xc511a70" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
12818 
                      <value type="string" key="collationName"></value>
12819 
                      <value type="string" key="datatypeExplicitParams"></value>
12820 
                      <value type="string" key="defaultValue"></value>
12821 
                      <value type="int" key="defaultValueIsNull">1</value>
12822 
                      <value _ptr_="0xd39ada8" type="list" content-type="string" key="flags"/>
12823 
                      <value type="int" key="isNotNull">0</value>
12824 
                      <value type="int" key="length">767</value>
12825 
                      <value type="int" key="precision">-1</value>
12826 
                      <value type="int" key="scale">-1</value>
12827 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
12828 
                      <value type="string" key="comment"></value>
12829 
                      <value type="string" key="name">organization</value>
12830 
                      <value type="string" key="oldName">organization</value>
12831 
                      <link type="object" struct-name="GrtObject" key="owner">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
12832 
                    </value>
12833 
                  </value>
12834 
                  <value type="string" key="connectionString"></value>
12835 
                  <value type="string" key="defaultCharacterSetName">utf8</value>
12836 
                  <value type="string" key="defaultCollationName">utf8_bin</value>
12837 
                  <value type="int" key="delayKeyWrite">0</value>
12838 
                  <value _ptr_="0xd396cd0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
12839 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="26132be0-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x70a8fc40">
12840 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">049df920-a91b-11e2-bdec-080027bcf912</link>
12841 
                      <value _ptr_="0xd326308" type="list" content-type="object" content-struct-name="db.Column" key="columns">
12842 
                        <link type="object">26132e1a-23e9-11e3-ab7c-080027bcf912</link>
12843 
                      </value>
12844 
                      <value type="int" key="deferability">0</value>
12845 
                      <value type="string" key="deleteRule">CASCADE</value>
12846 
                      <link type="object" struct-name="db.Index" key="index">26134602-23e9-11e3-ab7c-080027bcf912</link>
12847 
                      <value type="int" key="mandatory">1</value>
12848 
                      <value type="int" key="many">1</value>
12849 
                      <value type="int" key="modelOnly">0</value>
12850 
                      <link type="object" struct-name="db.Table" key="owner">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
12851 
                      <value _ptr_="0xc2c9600" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
12852 
                        <link type="object">049dfc5e-a91b-11e2-bdec-080027bcf912</link>
12853 
                      </value>
12854 
                      <value type="int" key="referencedMandatory">0</value>
12855 
                      <value type="string" key="updateRule">CASCADE</value>
12856 
                      <value type="string" key="comment"></value>
12857 
                      <value type="string" key="name">fk_person_organization1</value>
12858 
                      <value type="string" key="oldName">fk_person_organization1</value>
12859 
                    </value>
12860 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="174e216e-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x70a8fc40">
12861 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
12862 
                      <value _ptr_="0xbb4e820" type="list" content-type="object" content-struct-name="db.Column" key="columns">
12863 
                        <link type="object">174e1e76-23e9-11e3-ab7c-080027bcf912</link>
12864 
                      </value>
12865 
                      <value type="int" key="deferability">0</value>
12866 
                      <value type="string" key="deleteRule">CASCADE</value>
12867 
                      <value type="int" key="mandatory">0</value>
12868 
                      <value type="int" key="many">0</value>
12869 
                      <value type="int" key="modelOnly">0</value>
12870 
                      <link type="object" struct-name="db.Table" key="owner">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
12871 
                      <value _ptr_="0xc49f5e0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
12872 
                        <link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>
12873 
                      </value>
12874 
                      <value type="int" key="referencedMandatory">1</value>
12875 
                      <value type="string" key="updateRule">CASCADE</value>
12876 
                      <value type="string" key="comment"></value>
12877 
                      <value type="string" key="name">fk_organization_party10</value>
12878 
                      <value type="string" key="oldName">fk_organization_party10</value>
12879 
                    </value>
12880 
                  </value>
12881 
                  <value _ptr_="0xd445140" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
12882 
                    <value type="object" struct-name="db.mysql.Index" id="174e238a-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x309b847a">
12883 
                      <value _ptr_="0xcbf75e0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
12884 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="174e2498-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x62630b3c">
12885 
                          <value type="int" key="columnLength">0</value>
12886 
                          <value type="string" key="comment"></value>
12887 
                          <value type="int" key="descend">0</value>
12888 
                          <link type="object" struct-name="db.Column" key="referencedColumn">174e1e76-23e9-11e3-ab7c-080027bcf912</link>
12889 
                          <value type="string" key="name"></value>
12890 
                          <link type="object" struct-name="GrtObject" key="owner">174e238a-23e9-11e3-ab7c-080027bcf912</link>
12891 
                        </value>
12892 
                      </value>
12893 
                      <value type="string" key="indexKind"></value>
12894 
                      <value type="int" key="keyBlockSize">0</value>
12895 
                      <value type="string" key="withParser"></value>
12896 
                      <value type="string" key="comment"></value>
12897 
                      <value type="int" key="deferability">0</value>
12898 
                      <value type="string" key="indexType">PRIMARY</value>
12899 
                      <value type="int" key="isPrimary">1</value>
12900 
                      <value type="string" key="name">PRIMARY</value>
12901 
                      <value type="int" key="unique">0</value>
12902 
                      <value type="string" key="oldName">PRIMARY</value>
12903 
                      <link type="object" struct-name="GrtObject" key="owner">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
12904 
                    </value>
12905 
                    <value type="object" struct-name="db.mysql.Index" id="26134602-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x309b847a">
12906 
                      <value _ptr_="0xce1f960" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
12907 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="2613479c-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x62630b3c">
12908 
                          <value type="int" key="columnLength">0</value>
12909 
                          <value type="string" key="comment"></value>
12910 
                          <value type="int" key="descend">0</value>
12911 
                          <link type="object" struct-name="db.Column" key="referencedColumn">26132e1a-23e9-11e3-ab7c-080027bcf912</link>
12912 
                          <value type="string" key="name"></value>
12913 
                          <link type="object" struct-name="GrtObject" key="owner">26134602-23e9-11e3-ab7c-080027bcf912</link>
12914 
                        </value>
12915 
                      </value>
12916 
                      <value type="string" key="indexKind"></value>
12917 
                      <value type="int" key="keyBlockSize">0</value>
12918 
                      <value type="string" key="withParser"></value>
12919 
                      <value type="string" key="comment"></value>
12920 
                      <value type="int" key="deferability">0</value>
12921 
                      <value type="string" key="indexType">INDEX</value>
12922 
                      <value type="int" key="isPrimary">0</value>
12923 
                      <value type="string" key="name">fk_person_organization1_idx</value>
12924 
                      <value type="int" key="unique">0</value>
12925 
                      <value type="string" key="oldName">fk_person_organization1_idx</value>
12926 
                      <link type="object" struct-name="GrtObject" key="owner">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
12927 
                    </value>
12928 
                  </value>
12929 
                  <value type="string" key="maxRows"></value>
12930 
                  <value type="string" key="mergeInsert"></value>
12931 
                  <value type="string" key="mergeUnion"></value>
12932 
                  <value type="string" key="minRows"></value>
12933 
                  <value type="string" key="nextAutoInc"></value>
12934 
                  <value type="string" key="packKeys"></value>
12935 
                  <value type="int" key="partitionCount">0</value>
12936 
                  <value _ptr_="0xcd53580" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
12937 
                  <value type="string" key="partitionExpression"></value>
12938 
                  <value type="string" key="partitionType"></value>
12939 
                  <value type="string" key="password"></value>
12940 
                  <link type="object" struct-name="db.mysql.Index" key="primaryKey">174e238a-23e9-11e3-ab7c-080027bcf912</link>
12941 
                  <value type="string" key="raidChunkSize"></value>
12942 
                  <value type="string" key="raidChunks"></value>
12943 
                  <value type="string" key="raidType"></value>
12944 
                  <value type="string" key="rowFormat"></value>
12945 
                  <value type="int" key="subpartitionCount">0</value>
12946 
                  <value type="string" key="subpartitionExpression"></value>
12947 
                  <value type="string" key="subpartitionType"></value>
12948 
                  <value type="string" key="tableDataDir"></value>
12949 
                  <value type="string" key="tableEngine">InnoDB</value>
12950 
                  <value type="string" key="tableIndexDir"></value>
12951 
                  <value _ptr_="0xc2f9d60" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
12952 
                  <value type="int" key="isStub">0</value>
12953 
                  <value type="int" key="isSystem">0</value>
12954 
                  <value type="int" key="isTemporary">0</value>
12955 
                  <value type="string" key="temporaryScope"></value>
12956 
                  <value type="int" key="commentedOut">0</value>
12957 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
12958 
                  <value _ptr_="0xc8e6148" type="dict" key="customData"/>
12959 
                  <value type="string" key="lastChangeDate">2013-09-22 17:43</value>
12960 
                  <value type="int" key="modelOnly">0</value>
12961 
                  <value type="string" key="name">person</value>
12962 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
12963 
                  <value type="string" key="temp_sql"></value>
12964 
                  <value type="string" key="comment"></value>
12965 
                  <value type="string" key="oldName">person</value>
12966 
                </value>
12822 12967 
              </value>
12823 12968 
              <value _ptr_="0xba3d7d8" type="list" content-type="object" content-struct-name="db.mysql.View" key="views"/>
12824 12969 
              <value type="string" key="defaultCharacterSetName">utf8</value>
......
14197 14342 
                <value type="int" key="visible">1</value>
14198 14343 
                <value type="string" key="name"></value>
14199 14344 
              </value>
14200 
              <value type="object" struct-name="workbench.physical.Connection" id="e550409c-f676-11e2-9716-080027bcf912" struct-checksum="0x9baebc92">
14201 
                <value type="string" key="caption">fk_party_organization1</value>
14202 
                <value type="real" key="captionXOffs">0.e+00</value>
14203 
                <value type="real" key="captionYOffs">0.e+00</value>
14204 
                <value type="string" key="comment"></value>
14205 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
14206 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
14207 
                <value type="string" key="extraCaption"></value>
14208 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
14209 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
14210 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">e550209e-f676-11e2-9716-080027bcf912</link>
14211 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
14212 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
14213 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
14214 
                <value type="int" key="drawSplit">0</value>
14215 
                <link type="object" struct-name="model.Figure" key="endFigure">049e0d16-a91b-11e2-bdec-080027bcf912</link>
14216 
                <link type="object" struct-name="model.Figure" key="startFigure">EE4765B7-0391-4132-8813-84A6E788C01D</link>
14217 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14218 
                <value type="int" key="visible">1</value>
14219 
                <value type="string" key="name"></value>
14220 
              </value>
14221 14345 
              <value type="object" struct-name="workbench.physical.Connection" id="40027d56-f678-11e2-9716-080027bcf912" struct-checksum="0x9baebc92">
14222 14346 
                <value type="string" key="caption">fk_collection_source100</value>
14223 14347 
                <value type="real" key="captionXOffs">0.e+00</value>
......
15772 15896 
                <value type="int" key="visible">1</value>
15773 15897 
                <value type="string" key="name"></value>
15774 15898 
              </value>
15899 
              <value type="object" struct-name="workbench.physical.Connection" id="174ed7e4-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x9baebc92">
15900 
                <value type="string" key="caption">fk_organization_party10</value>
15901 
                <value type="real" key="captionXOffs">0.e+00</value>
15902 
                <value type="real" key="captionYOffs">0.e+00</value>
15903 
                <value type="string" key="comment"></value>
15904 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15905 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15906 
                <value type="string" key="extraCaption"></value>
15907 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15908 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15909 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">174e216e-23e9-11e3-ab7c-080027bcf912</link>
15910 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15911 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15912 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15913 
                <value type="int" key="drawSplit">0</value>
15914 
                <link type="object" struct-name="model.Figure" key="endFigure">EE4765B7-0391-4132-8813-84A6E788C01D</link>
15915 
                <link type="object" struct-name="model.Figure" key="startFigure">174e3636-23e9-11e3-ab7c-080027bcf912</link>
15916 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15917 
                <value type="int" key="visible">1</value>
15918 
                <value type="string" key="name"></value>
15919 
              </value>
15920 
              <value type="object" struct-name="workbench.physical.Connection" id="26134e54-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x9baebc92">
15921 
                <value type="string" key="caption">fk_person_organization1</value>
15922 
                <value type="real" key="captionXOffs">0.e+00</value>
15923 
                <value type="real" key="captionYOffs">0.e+00</value>
15924 
                <value type="string" key="comment"></value>
15925 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15926 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15927 
                <value type="string" key="extraCaption"></value>
15928 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15929 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15930 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">26132be0-23e9-11e3-ab7c-080027bcf912</link>
15931 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15932 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15933 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15934 
                <value type="int" key="drawSplit">0</value>
15935 
                <link type="object" struct-name="model.Figure" key="endFigure">049e0d16-a91b-11e2-bdec-080027bcf912</link>
15936 
                <link type="object" struct-name="model.Figure" key="startFigure">174e3636-23e9-11e3-ab7c-080027bcf912</link>
15937 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15938 
                <value type="int" key="visible">1</value>
15939 
                <value type="string" key="name"></value>
15940 
              </value>
15941 
              <value type="object" struct-name="workbench.physical.Connection" id="39e42e9e-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x9baebc92">
15942 
                <value type="string" key="caption">fk_organization_organization1</value>
15943 
                <value type="real" key="captionXOffs">0.e+00</value>
15944 
                <value type="real" key="captionYOffs">0.e+00</value>
15945 
                <value type="string" key="comment"></value>
15946 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15947 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15948 
                <value type="string" key="extraCaption"></value>
15949 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15950 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15951 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">39e40ed2-23e9-11e3-ab7c-080027bcf912</link>
15952 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15953 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15954 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15955 
                <value type="int" key="drawSplit">0</value>
15956 
                <link type="object" struct-name="model.Figure" key="endFigure">049e0d16-a91b-11e2-bdec-080027bcf912</link>
15957 
                <link type="object" struct-name="model.Figure" key="startFigure">049e0d16-a91b-11e2-bdec-080027bcf912</link>
15958 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15959 
                <value type="int" key="visible">1</value>
15960 
                <value type="string" key="name"></value>
15961 
              </value>
15775 15962 
            </value>
15776 15963 
            <value type="string" key="description"></value>
15777 15964 
            <value _ptr_="0xbaec680" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
16339 16526 
                <value type="int" key="triggersExpanded">0</value>
16340 16527 
                <value type="string" key="color">#ffcccc</value>
16341 16528 
                <value type="int" key="expanded">1</value>
16342 
                <value type="real" key="height">1.e+02</value>
16529 
                <value type="real" key="height">7.7e+01</value>
16343 16530 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16344 
                <value type="real" key="left">1.2e+01</value>
16531 
                <value type="real" key="left">1.3e+01</value>
16345 16532 
                <value type="int" key="locked">0</value>
16346 16533 
                <value type="int" key="manualSizing">0</value>
16347 
                <value type="real" key="top">9.86e+02</value>
16348 
                <value type="real" key="width">8.1e+01</value>
16534 
                <value type="real" key="top">9.69e+02</value>
16535 
                <value type="real" key="width">7.9e+01</value>
16349 16536 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16350 16537 
                <value type="int" key="visible">1</value>
16351 16538 
                <value type="string" key="name">party</value>
......
16805 16992 
                <value type="int" key="triggersExpanded">0</value>
16806 16993 
                <value type="string" key="color">#ffcccc</value>
16807 16994 
                <value type="int" key="expanded">1</value>
16808 
                <value type="real" key="height">5.4e+01</value>
16995 
                <value type="real" key="height">7.7e+01</value>
16809 16996 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16810 
                <value type="real" key="left">8.e+00</value>
16997 
                <value type="real" key="left">9.e+00</value>
16811 16998 
                <value type="int" key="locked">0</value>
16812 16999 
                <value type="int" key="manualSizing">0</value>
16813 
                <value type="real" key="top">1.129e+03</value>
17000 
                <value type="real" key="top">1.196e+03</value>
16814 17001 
                <value type="real" key="width">1.21e+02</value>
16815 17002 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16816 17003 
                <value type="int" key="visible">1</value>
......
16947 17134 
                <value type="int" key="expanded">1</value>
16948 17135 
                <value type="real" key="height">7.7e+01</value>
16949 17136 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16950 
                <value type="real" key="left">1.87e+02</value>
17137 
                <value type="real" key="left">1.81e+02</value>
16951 17138 
                <value type="int" key="locked">0</value>
16952 17139 
                <value type="int" key="manualSizing">0</value>
16953 
                <value type="real" key="top">8.59e+02</value>
17140 
                <value type="real" key="top">8.31e+02</value>
16954 17141 
                <value type="real" key="width">1.03e+02</value>
16955 17142 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16956 17143 
                <value type="int" key="visible">1</value>
......
16967 17154 
                <value type="int" key="expanded">1</value>
16968 17155 
                <value type="real" key="height">1.46e+02</value>
16969 17156 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16970 
                <value type="real" key="left">1.46e+02</value>
17157 
                <value type="real" key="left">1.4e+02</value>
16971 17158 
                <value type="int" key="locked">0</value>
16972 17159 
                <value type="int" key="manualSizing">0</value>
16973 
                <value type="real" key="top">9.63e+02</value>
17160 
                <value type="real" key="top">9.35e+02</value>
16974 17161 
                <value type="real" key="width">1.39e+02</value>
16975 17162 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16976 17163 
                <value type="int" key="visible">1</value>
......
17371 17558 
                <value type="int" key="visible">1</value>
17372 17559 
                <value type="string" key="name">source</value>
17373 17560 
              </value>
17561 
              <value type="object" struct-name="workbench.physical.TableFigure" id="174e3636-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x3b14eccb">
17562 
                <value type="int" key="columnsExpanded">1</value>
17563 
                <value type="int" key="foreignKeysExpanded">0</value>
17564 
                <value type="int" key="indicesExpanded">0</value>
17565 
                <value type="int" key="summarizeDisplay">-1</value>
17566 
                <link type="object" struct-name="db.Table" key="table">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
17567 
                <value type="int" key="triggersExpanded">0</value>
17568 
                <value type="string" key="color">#ffcccc</value>
17569 
                <value type="int" key="expanded">1</value>
17570 
                <value type="real" key="height">7.7e+01</value>
17571 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
17572 
                <value type="real" key="left">4.5e+01</value>
17573 
                <value type="int" key="locked">0</value>
17574 
                <value type="int" key="manualSizing">0</value>
17575 
                <value type="real" key="top">1.081e+03</value>
17576 
                <value type="real" key="width">9.e+01</value>
17577 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17578 
                <value type="int" key="visible">1</value>
17579 
                <value type="string" key="name">person</value>
17580 
              </value>
17374 17581 
            </value>
17375 17582 
            <value type="real" key="height">1.2865e+03</value>
17376 17583 
            <value _ptr_="0xbaec6d0" type="list" content-type="object" content-struct-name="model.Layer" key="layers">
......
17500 17707 
                <link type="object">f9d27532-1dc5-11e3-838b-410b6ef2c3ca</link>
17501 17708 
                <link type="object">0de3d5b8-1dec-11e3-b571-080027bcf912</link>
17502 17709 
                <link type="object">afc4521a-1df9-11e3-bbb6-080027bcf912</link>
17710 
                <link type="object">174e3636-23e9-11e3-ab7c-080027bcf912</link>
17503 17711 
              </value>
17504 17712 
              <value _ptr_="0xbb3bbc8" type="list" content-type="object" content-struct-name="model.Group" key="groups"/>
17505 17713 
              <value type="real" key="height">1.2865e+03</value>
......
17514 17722 
              <value type="int" key="visible">1</value>
17515 17723 
              <value type="string" key="name"></value>
17516 17724 
            </value>
17517 
            <value _ptr_="0xbaec758" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17725 
            <value _ptr_="0xbaec758" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17726 
              <link type="object">174e3636-23e9-11e3-ab7c-080027bcf912</link>
17727 
            </value>
17518 17728 
            <value type="int" key="updateBlocked">0</value>
17519 17729 
            <value type="real" key="width">1.6215e+03</value>
17520 17730 
            <value type="real" key="x">0.e+00</value>
......
17527 17737 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17528 17738 
        <value _ptr_="0xba3c650" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17529 17739 
        <value _ptr_="0xb030e28" type="dict" key="syncProfiles">
17530 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="59792a84-239e-11e3-ab7c-080027bcf912" struct-checksum="0xc64972c2" key="">
17531 
            <value _ptr_="0xc9239f0" type="dict" key="lastKnownDBNames">
17740 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="57ea697a-23ea-11e3-ab7c-080027bcf912" struct-checksum="0xc64972c2" key="">
17741 
            <value _ptr_="0xd5abf90" type="dict" key="lastKnownDBNames">
17532 17742 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17533 17743 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
17534 17744 
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
17579 17789 
              <value type="string" key="165389fc-a7a7-11e2-8ba6-080027bcf912">cultivated</value>
17580 17790 
              <value type="string" key="16538c2c-a7a7-11e2-8ba6-080027bcf912">traits</value>
17581 17791 
              <value type="string" key="165395c8-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value>
17792 
              <value type="string" key="174e1b4c-23e9-11e3-ab7c-080027bcf912">person</value>
17793 
              <value type="string" key="174e1e76-23e9-11e3-ab7c-080027bcf912">id</value>
17794 
              <value type="string" key="174e216e-23e9-11e3-ab7c-080027bcf912">fk_organization_party10</value>
17795 
              <value type="string" key="174e238a-23e9-11e3-ab7c-080027bcf912">PRIMARY</value>
17582 17796 
              <value type="string" key="17d59e68-a794-11e2-84c3-080027bcf912">info</value>
17583 17797 
              <value type="string" key="181c8a8a-0077-11e3-906b-080027bcf912">height_min_m</value>
17584 17798 
              <value type="string" key="1832712c-a77d-11e2-afd5-080027bcf912">taxon_concept</value>
......
17619 17833 
              <value type="string" key="251c29a8-f67b-11e2-aebb-080027bcf912">fk_event_party_list1</value>
17620 17834 
              <value type="string" key="251c2b92-f67b-11e2-aebb-080027bcf912">participants</value>
17621 17835 
              <value type="string" key="251c57de-f67b-11e2-aebb-080027bcf912">fk_event_party_list1_idx</value>
17836 
              <value type="string" key="26132be0-23e9-11e3-ab7c-080027bcf912">fk_person_organization1</value>
17837 
              <value type="string" key="26132e1a-23e9-11e3-ab7c-080027bcf912">organization</value>
17838 
              <value type="string" key="26134602-23e9-11e3-ab7c-080027bcf912">fk_person_organization1_idx</value>
17622 17839 
              <value type="string" key="2673b9ee-f9bc-11e2-a599-080027bcf912">subplot</value>
17623 17840 
              <value type="string" key="2673bdc2-f9bc-11e2-a599-080027bcf912">id</value>
17624 17841 
              <value type="string" key="2673d532-f9bc-11e2-a599-080027bcf912">PRIMARY</value>
......
17646 17863 
              <value type="string" key="329238b6-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1_idx</value>
17647 17864 
              <value type="string" key="3587a3e0-1dc6-11e3-838b-410b6ef2c3ca">fk_reobservable_taxon_occurrence1</value>
17648 17865 
              <value type="string" key="35cce77e-f6df-11e2-b6d1-080027bcf912">corrected_geoplace</value>
17866 
              <value type="string" key="39e40ed2-23e9-11e3-ab7c-080027bcf912">fk_organization_organization1</value>
17867 
              <value type="string" key="39e41094-23e9-11e3-ab7c-080027bcf912">parent</value>
17868 
              <value type="string" key="39e42688-23e9-11e3-ab7c-080027bcf912">fk_organization_organization1_idx</value>
17649 17869 
              <value type="string" key="3bc7bb2e-f6d8-11e2-b6d1-080027bcf912">verbatim</value>
17650 17870 
              <value type="string" key="3d9b10bc-a7a1-11e2-b667-080027bcf912">taxon_determination</value>
17651 17871 
              <value type="string" key="3d9b13d2-a7a1-11e2-b667-080027bcf912">id</value>
......
17814 18034 
              <value type="string" key="913a6e06-008a-11e3-9629-080027bcf912">fk_soil_observation_record1</value>
17815 18035 
              <value type="string" key="92fc2776-1be6-11e3-af49-080027bcf912">defining_data</value>
17816 18036 
              <value type="string" key="94ad6c18-f6c7-11e2-a35e-080027bcf912">dimensions</value>
17817 
              <value type="string" key="96b8693a-1e00-11e3-9d67-080027bcf912">party_unique</value>
17818 18037 
              <value type="string" key="98e532e4-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1</value>
17819 18038 
              <value type="string" key="98e534d8-008a-11e3-9629-080027bcf912">place_observation</value>
17820 18039 
              <value type="string" key="98e5491e-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1_idx</value>
......
18033 18252 
              <value type="string" key="dda7bbf8-0072-11e3-906b-080027bcf912">fk_stratum_event_sampling_event2</value>
18034 18253 
              <value type="string" key="dda7bdec-0072-11e3-906b-080027bcf912">parent_event</value>
18035 18254 
              <value type="string" key="dda7d480-0072-11e3-906b-080027bcf912">fk_stratum_event_sampling_event2_idx</value>
18036 
              <value type="string" key="e550209e-f676-11e2-9716-080027bcf912">fk_party_organization1</value>
18037 
              <value type="string" key="e5502346-f676-11e2-9716-080027bcf912">organization</value>
18038 
              <value type="string" key="e550389a-f676-11e2-9716-080027bcf912">fk_party_organization1_idx</value>
18039 18255 
              <value type="string" key="e95a1e48-1de9-11e3-b571-080027bcf912">fk_party_list_entry_record1</value>
18040 18256 
              <value type="string" key="eb778868-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1</value>
18041 18257 
              <value type="string" key="eb778aac-ad01-11e2-b309-080027bcf912">collection_event</value>
......
18154 18370 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18155 18371 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18156 18372 
      <value type="string" key="caption">New Model</value>
18157 
      <value type="string" key="dateChanged">2013-09-22 08:58</value>
18373 
      <value type="string" key="dateChanged">2013-09-22 17:51</value>
18158 18374 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18159 18375 
      <value type="string" key="description"></value>
18160 18376 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
495 495 
/*!40101 SET character_set_client = utf8 */;
496 496 
CREATE TABLE `organization` (
497 497 
  `id` varbinary(767) NOT NULL,
498 
  `parent` varbinary(767) DEFAULT NULL,
498 499 
  PRIMARY KEY (`id`),
500 
  KEY `fk_organization_organization1_idx` (`parent`),
501 
  CONSTRAINT `fk_organization_organization1` FOREIGN KEY (`parent`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
499 502 
  CONSTRAINT `fk_organization_party1` FOREIGN KEY (`id`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
500 503 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
501 504 
/*!40101 SET character_set_client = @saved_cs_client */;
......
516 519 
CREATE TABLE `party` (
517 520 
  `id` varbinary(767) NOT NULL,
518 521 
  `name` varbinary(767) NOT NULL,
519 
  `organization` varbinary(767) DEFAULT NULL,
520 522 
  PRIMARY KEY (`id`),
521 
  KEY `fk_party_organization1_idx` (`organization`),
522 
  KEY `party_unique` (`organization`,`name`),
523 523 
  CONSTRAINT `fk_collection_source10` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
524 
  CONSTRAINT `fk_party_organization1` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
525 524 
  CONSTRAINT `fk_party_source1` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
526 525 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
527 526 
/*!40101 SET character_set_client = @saved_cs_client */;
......
583 582 
/*!40000 ALTER TABLE `party_list_entry` ENABLE KEYS */;
584 583 

  		




  585
  584
  
    
--


  		




  
  585
  
    
-- Table structure for table `person`


  		




  
  586
  
    
--


  		




  
  587
  
    

  		




  
  588
  
    
/*!40101 SET @saved_cs_client     = @@character_set_client */;


  		




  
  589
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  
  590
  
    
CREATE TABLE `person` (


  		




  
  591
  
    
  `id` varbinary(767) NOT NULL,


  		




  
  592
  
    
  `organization` varbinary(767) DEFAULT NULL,


  		




  
  593
  
    
  PRIMARY KEY (`id`),


  		




  
  594
  
    
  KEY `fk_person_organization1_idx` (`organization`),


  		




  
  595
  
    
  CONSTRAINT `fk_person_organization1` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  596
  
    
  CONSTRAINT `fk_organization_party10` FOREIGN KEY (`id`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  597
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


  		




  
  598
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  
  599
  
    

  		




  
  600
  
    
--


  		




  
  601
  
    
-- Dumping data for table `person`


  		




  
  602
  
    
--


  		




  
  603
  
    

  		




  
  604
  
    
/*!40000 ALTER TABLE `person` DISABLE KEYS */;


  		




  
  605
  
    
/*!40000 ALTER TABLE `person` ENABLE KEYS */;


  		




  
  606
  
    

  		




  
  607
  
    
--


  		




  586
  608
  
    
-- Table structure for table `place`


  		




  587
  609
  
    
--


  		




  588
  610
  
    

  		












  

    
      schemas/VegCore/VegCore.pg.sql
    
  





  497
  497
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  498
  498
  
    
CREATE TABLE "organization" (


  		




  499
  499
  
    
  "id" text NOT NULL,


  		




  
  500
  
    
  "parent" text DEFAULT NULL,


  		




  500
  501
  
    
  PRIMARY KEY ("id"),


  		




  
  502
  
    
  /*KEY "fk_organization_organization1_idx" ("parent")*/CHECK (true),


  		




  
  503
  
    
  /*CONSTRAINT "fk_organization_organization1" FOREIGN KEY ("parent") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  501
  504
  
    
  /*CONSTRAINT "fk_organization_party1" FOREIGN KEY ("id") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  502
  505
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;


  		




  503
  506
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  ......




  518
  521
  
    
CREATE TABLE "party" (


  		




  519
  522
  
    
  "id" text NOT NULL,


  		




  520
  523
  
    
  "name" text NOT NULL,


  		




  521
  
  
    
  "organization" text DEFAULT NULL,


  		




  522
  524
  
    
  PRIMARY KEY ("id"),


  		




  523
  
  
    
  /*KEY "fk_party_organization1_idx" ("organization")*/CHECK (true),


  		




  524
  
  
    
  /*KEY "party_unique" ("organization","name")*/CHECK (true),


  		




  525
  525
  
    
  /*CONSTRAINT "fk_collection_source10" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  526
  
  
    
  /*CONSTRAINT "fk_party_organization1" FOREIGN KEY ("organization") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  527
  526
  
    
  /*CONSTRAINT "fk_party_source1" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  528
  527
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;


  		




  529
  528
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  ......




  585
  584
  
    
/*!40000 ALTER TABLE "party_list_entry" ENABLE KEYS */;


  		




  586
  585
  
    

  		




  587
  586
  
    
--


  		




  
  587
  
    
-- Table structure for table "person"


  		




  
  588
  
    
--


  		




  
  589
  
    

  		




  
  590
  
    
/*!40101 SET @saved_cs_client     = @@character_set_client */;


  		




  
  591
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  
  592
  
    
CREATE TABLE "person" (


  		




  
  593
  
    
  "id" text NOT NULL,


  		




  
  594
  
    
  "organization" text DEFAULT NULL,


  		




  
  595
  
    
  PRIMARY KEY ("id"),


  		




  
  596
  
    
  /*KEY "fk_person_organization1_idx" ("organization")*/CHECK (true),


  		




  
  597
  
    
  /*CONSTRAINT "fk_person_organization1" FOREIGN KEY ("organization") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  598
  
    
  /*CONSTRAINT "fk_organization_party10" FOREIGN KEY ("id") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  599
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;


  		




  
  600
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  
  601
  
    

  		




  
  602
  
    
--


  		




  
  603
  
    
-- Dumping data for table "person"


  		




  
  604
  
    
--


  		




  
  605
  
    

  		




  
  606
  
    
/*!40000 ALTER TABLE "person" DISABLE KEYS */;


  		




  
  607
  
    
/*!40000 ALTER TABLE "person" ENABLE KEYS */;


  		




  
  608
  
    

  		




  
  609
  
    
--


  		




  588
  610
  
    
-- Table structure for table "place"


  		




  589
  611
  
    
--


  		




  590
  612
  
    

  		












Also available in:  Unified diff