Project

General

Profile

« Previous | Next » 

Revision 11067

Added by Aaron Marcuse-Kubitza about 11 years ago

schemas/VegCore/VegCore.ERD.mwb: source: made name optional because some sources (e.g. records) don't have a name, and are instead identified differently. instead require name in applicable subclasses. source subclasses: added unique constraints on parent/name since the name is presumed to be identifying within the parent entity.

View differences:

schemas/VegCore/ERD/document.mwb.xml
45 45 
                      <value type="string" key="oldName">id</value>
46 46 
                      <link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
47 47 
                    </value>
48 
                    <value type="object" struct-name="db.mysql.Column" id="8222d06e-1e00-11e3-9d67-080027bcf912" struct-checksum="0x783b5183">
49 
                      <value type="int" key="autoIncrement">0</value>
50 
                      <value type="string" key="characterSetName"></value>
51 
                      <value _ptr_="0xba3e518" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
52 
                      <value type="string" key="collationName"></value>
53 
                      <value type="string" key="datatypeExplicitParams"></value>
54 
                      <value type="string" key="defaultValue"></value>
55 
                      <value type="int" key="defaultValueIsNull">0</value>
56 
                      <value _ptr_="0xba3e840" type="list" content-type="string" key="flags"/>
57 
                      <value type="int" key="isNotNull">1</value>
58 
                      <value type="int" key="length">767</value>
59 
                      <value type="int" key="precision">-1</value>
60 
                      <value type="int" key="scale">-1</value>
61 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
62 
                      <value type="string" key="comment"></value>
63 
                      <value type="string" key="name">name</value>
64 
                      <value type="string" key="oldName">name</value>
65 
                      <link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
66 
                    </value>
67 48 
                  </value>
68 49 
                  <value type="string" key="connectionString"></value>
69 50 
                  <value type="string" key="defaultCharacterSetName">utf8</value>
......
198 179 
                      <value type="string" key="oldName">id</value>
199 180 
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
200 181 
                    </value>
182 
                    <value type="object" struct-name="db.mysql.Column" id="8e39e482-23eb-11e3-ab7c-080027bcf912" struct-checksum="0x783b5183">
183 
                      <value type="int" key="autoIncrement">0</value>
184 
                      <value type="string" key="characterSetName"></value>
185 
                      <value _ptr_="0xd5f9460" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
186 
                      <value type="string" key="collationName"></value>
187 
                      <value type="string" key="datatypeExplicitParams"></value>
188 
                      <value type="string" key="defaultValue"></value>
189 
                      <value type="int" key="defaultValueIsNull">0</value>
190 
                      <value _ptr_="0xd6e3ed0" type="list" content-type="string" key="flags"/>
191 
                      <value type="int" key="isNotNull">1</value>
192 
                      <value type="int" key="length">767</value>
193 
                      <value type="int" key="precision">-1</value>
194 
                      <value type="int" key="scale">-1</value>
195 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
196 
                      <value type="string" key="comment"></value>
197 
                      <value type="string" key="name">name</value>
198 
                      <value type="string" key="oldName">name</value>
199 
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
200 
                    </value>
201 201 
                    <value type="object" struct-name="db.mysql.Column" id="1156d180-2393-11e3-a6f3-080027bcf912" struct-checksum="0x783b5183">
202 202 
                      <value type="int" key="autoIncrement">0</value>
203 203 
                      <value type="string" key="characterSetName"></value>
......
584 584 
                      <value type="string" key="oldName">fk_dataset_dataset1_idx</value>
585 585 
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
586 586 
                    </value>
587 
                    <value type="object" struct-name="db.mysql.Index" id="ad91aad6-23eb-11e3-ab7c-080027bcf912" struct-checksum="0x309b847a">
588 
                      <value _ptr_="0xc958e00" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
589 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="ca428bd2-23eb-11e3-ab7c-080027bcf912" struct-checksum="0x62630b3c">
590 
                          <value type="int" key="columnLength">0</value>
591 
                          <value type="string" key="comment"></value>
592 
                          <value type="int" key="descend">0</value>
593 
                          <link type="object" struct-name="db.Column" key="referencedColumn">1156d180-2393-11e3-a6f3-080027bcf912</link>
594 
                          <value type="string" key="name"></value>
595 
                          <link type="object" struct-name="GrtObject" key="owner">ad91aad6-23eb-11e3-ab7c-080027bcf912</link>
596 
                        </value>
597 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="ca9950ac-23eb-11e3-ab7c-080027bcf912" struct-checksum="0x62630b3c">
598 
                          <value type="int" key="columnLength">0</value>
599 
                          <value type="string" key="comment"></value>
600 
                          <value type="int" key="descend">0</value>
601 
                          <link type="object" struct-name="db.Column" key="referencedColumn">8e39e482-23eb-11e3-ab7c-080027bcf912</link>
602 
                          <value type="string" key="name"></value>
603 
                          <link type="object" struct-name="GrtObject" key="owner">ad91aad6-23eb-11e3-ab7c-080027bcf912</link>
604 
                        </value>
605 
                      </value>
606 
                      <value type="string" key="indexKind"></value>
607 
                      <value type="int" key="keyBlockSize">0</value>
608 
                      <value type="string" key="withParser"></value>
609 
                      <value type="string" key="comment"></value>
610 
                      <value type="int" key="deferability">0</value>
611 
                      <value type="string" key="indexType">UNIQUE</value>
612 
                      <value type="int" key="isPrimary">0</value>
613 
                      <value type="string" key="name">dataset_unique</value>
614 
                      <value type="int" key="unique">1</value>
615 
                      <value type="string" key="oldName">dataset_unique</value>
616 
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
617 
                    </value>
587 618 
                  </value>
588 619 
                  <value type="string" key="maxRows"></value>
589 620 
                  <value type="string" key="mergeInsert"></value>
......
615 646 
                  <value type="int" key="commentedOut">0</value>
616 647 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
617 648 
                  <value _ptr_="0xb034dc0" type="dict" key="customData"/>
618 
                  <value type="string" key="lastChangeDate">2013-09-22 08:58</value>
649 
                  <value type="string" key="lastChangeDate">2013-09-22 18:02</value>
619 650 
                  <value type="int" key="modelOnly">0</value>
620 651 
                  <value type="string" key="name">dataset</value>
621 652 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
4007 4038 
                      <value type="string" key="oldName">id</value>
4008 4039 
                      <link type="object" struct-name="GrtObject" key="owner">049df920-a91b-11e2-bdec-080027bcf912</link>
4009 4040 
                    </value>
4041 
                    <value type="object" struct-name="db.mysql.Column" id="016697c0-23ec-11e3-ab7c-080027bcf912" struct-checksum="0x783b5183">
4042 
                      <value type="int" key="autoIncrement">0</value>
4043 
                      <value type="string" key="characterSetName"></value>
4044 
                      <value _ptr_="0xd69d450" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
4045 
                      <value type="string" key="collationName"></value>
4046 
                      <value type="string" key="datatypeExplicitParams"></value>
4047 
                      <value type="string" key="defaultValue"></value>
4048 
                      <value type="int" key="defaultValueIsNull">0</value>
4049 
                      <value _ptr_="0xd44ee58" type="list" content-type="string" key="flags"/>
4050 
                      <value type="int" key="isNotNull">1</value>
4051 
                      <value type="int" key="length">767</value>
4052 
                      <value type="int" key="precision">-1</value>
4053 
                      <value type="int" key="scale">-1</value>
4054 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
4055 
                      <value type="string" key="comment"></value>
4056 
                      <value type="string" key="name">name</value>
4057 
                      <value type="string" key="oldName">name</value>
4058 
                      <link type="object" struct-name="GrtObject" key="owner">049df920-a91b-11e2-bdec-080027bcf912</link>
4059 
                    </value>
4010 4060 
                    <value type="object" struct-name="db.mysql.Column" id="39e41094-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x783b5183">
4011 4061 
                      <value type="int" key="autoIncrement">0</value>
4012 4062 
                      <value type="string" key="characterSetName"></value>
......
4121 4171 
                      <value type="string" key="oldName">fk_organization_organization1_idx</value>
4122 4172 
                      <link type="object" struct-name="GrtObject" key="owner">049df920-a91b-11e2-bdec-080027bcf912</link>
4123 4173 
                    </value>
4174 
                    <value type="object" struct-name="db.mysql.Index" id="86e5a7d8-23ec-11e3-ab7c-080027bcf912" struct-checksum="0x309b847a">
4175 
                      <value _ptr_="0xd8263d0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
4176 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="9cd874bc-23ec-11e3-ab7c-080027bcf912" struct-checksum="0x62630b3c">
4177 
                          <value type="int" key="columnLength">0</value>
4178 
                          <value type="string" key="comment"></value>
4179 
                          <value type="int" key="descend">0</value>
4180 
                          <link type="object" struct-name="db.Column" key="referencedColumn">39e41094-23e9-11e3-ab7c-080027bcf912</link>
4181 
                          <value type="string" key="name"></value>
4182 
                          <link type="object" struct-name="GrtObject" key="owner">86e5a7d8-23ec-11e3-ab7c-080027bcf912</link>
4183 
                        </value>
4184 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="9d2565b0-23ec-11e3-ab7c-080027bcf912" struct-checksum="0x62630b3c">
4185 
                          <value type="int" key="columnLength">0</value>
4186 
                          <value type="string" key="comment"></value>
4187 
                          <value type="int" key="descend">0</value>
4188 
                          <link type="object" struct-name="db.Column" key="referencedColumn">016697c0-23ec-11e3-ab7c-080027bcf912</link>
4189 
                          <value type="string" key="name"></value>
4190 
                          <link type="object" struct-name="GrtObject" key="owner">86e5a7d8-23ec-11e3-ab7c-080027bcf912</link>
4191 
                        </value>
4192 
                      </value>
4193 
                      <value type="string" key="indexKind"></value>
4194 
                      <value type="int" key="keyBlockSize">0</value>
4195 
                      <value type="string" key="withParser"></value>
4196 
                      <value type="string" key="comment"></value>
4197 
                      <value type="int" key="deferability">0</value>
4198 
                      <value type="string" key="indexType">UNIQUE</value>
4199 
                      <value type="int" key="isPrimary">0</value>
4200 
                      <value type="string" key="name">organization_unique</value>
4201 
                      <value type="int" key="unique">1</value>
4202 
                      <value type="string" key="oldName">organization_unique</value>
4203 
                      <link type="object" struct-name="GrtObject" key="owner">049df920-a91b-11e2-bdec-080027bcf912</link>
4204 
                    </value>
4124 4205 
                  </value>
4125 4206 
                  <value type="string" key="maxRows"></value>
4126 4207 
                  <value type="string" key="mergeInsert"></value>
......
4152 4233 
                  <value type="int" key="commentedOut">0</value>
4153 4234 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
4154 4235 
                  <value _ptr_="0xba65fc8" type="dict" key="customData"/>
4155 
                  <value type="string" key="lastChangeDate">2013-09-22 17:44</value>
4236 
                  <value type="string" key="lastChangeDate">2013-09-22 18:08</value>
4156 4237 
                  <value type="int" key="modelOnly">0</value>
4157 4238 
                  <value type="string" key="name">organization</value>
4158 4239 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
12665 12746 
                      <value type="string" key="collationName"></value>
12666 12747 
                      <value type="string" key="datatypeExplicitParams"></value>
12667 12748 
                      <value type="string" key="defaultValue"></value>
12668 
                      <value type="int" key="defaultValueIsNull">0</value>
12749 
                      <value type="int" key="defaultValueIsNull">1</value>
12669 12750 
                      <value _ptr_="0xbae6960" type="list" content-type="string" key="flags"/>
12670 
                      <value type="int" key="isNotNull">1</value>
12751 
                      <value type="int" key="isNotNull">0</value>
12671 12752 
                      <value type="int" key="length">767</value>
12672 12753 
                      <value type="int" key="precision">-1</value>
12673 12754 
                      <value type="int" key="scale">-1</value>
......
12726 12807 
                      <value type="string" key="oldName">PRIMARY</value>
12727 12808 
                      <link type="object" struct-name="GrtObject" key="owner">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
12728 12809 
                    </value>
12729 
                    <value type="object" struct-name="db.mysql.Index" id="afc422b8-1df9-11e3-bbb6-080027bcf912" struct-checksum="0x309b847a">
12730 
                      <value _ptr_="0xbae7388" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
12731 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="afc424f2-1df9-11e3-bbb6-080027bcf912" struct-checksum="0x62630b3c">
12732 
                          <value type="int" key="columnLength">0</value>
12733 
                          <value type="string" key="comment"></value>
12734 
                          <value type="int" key="descend">0</value>
12735 
                          <link type="object" struct-name="db.Column" key="referencedColumn">afc40c10-1df9-11e3-bbb6-080027bcf912</link>
12736 
                          <value type="string" key="name"></value>
12737 
                          <link type="object" struct-name="GrtObject" key="owner">afc422b8-1df9-11e3-bbb6-080027bcf912</link>
12738 
                        </value>
12739 
                      </value>
12740 
                      <value type="string" key="indexKind"></value>
12741 
                      <value type="int" key="keyBlockSize">0</value>
12742 
                      <value type="string" key="withParser"></value>
12743 
                      <value type="string" key="comment"></value>
12744 
                      <value type="int" key="deferability">0</value>
12745 
                      <value type="string" key="indexType">UNIQUE</value>
12746 
                      <value type="int" key="isPrimary">0</value>
12747 
                      <value type="string" key="name">source_unique</value>
12748 
                      <value type="int" key="unique">1</value>
12749 
                      <value type="string" key="oldName">source_unique</value>
12750 
                      <link type="object" struct-name="GrtObject" key="owner">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
12751 
                    </value>
12752 12810 
                  </value>
12753 12811 
                  <value type="string" key="maxRows"></value>
12754 12812 
                  <value type="string" key="mergeInsert"></value>
......
12780 12838 
                  <value type="int" key="commentedOut">0</value>
12781 12839 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
12782 12840 
                  <value _ptr_="0xbae5c88" type="dict" key="customData"/>
12783 
                  <value type="string" key="lastChangeDate">2013-09-21 19:19</value>
12841 
                  <value type="string" key="lastChangeDate">2013-09-22 18:00</value>
12784 12842 
                  <value type="int" key="modelOnly">0</value>
12785 12843 
                  <value type="string" key="name">source</value>
12786 12844 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
12811 12869 
                      <value type="string" key="oldName">id</value>
12812 12870 
                      <link type="object" struct-name="GrtObject" key="owner">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
12813 12871 
                    </value>
12872 
                    <value type="object" struct-name="db.mysql.Column" id="e96e2084-23eb-11e3-ab7c-080027bcf912" struct-checksum="0x783b5183">
12873 
                      <value type="int" key="autoIncrement">0</value>
12874 
                      <value type="string" key="characterSetName"></value>
12875 
                      <value _ptr_="0xcf216a0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
12876 
                      <value type="string" key="collationName"></value>
12877 
                      <value type="string" key="datatypeExplicitParams"></value>
12878 
                      <value type="string" key="defaultValue"></value>
12879 
                      <value type="int" key="defaultValueIsNull">0</value>
12880 
                      <value _ptr_="0xcf369e0" type="list" content-type="string" key="flags"/>
12881 
                      <value type="int" key="isNotNull">1</value>
12882 
                      <value type="int" key="length">767</value>
12883 
                      <value type="int" key="precision">-1</value>
12884 
                      <value type="int" key="scale">-1</value>
12885 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
12886 
                      <value type="string" key="comment"></value>
12887 
                      <value type="string" key="name">name</value>
12888 
                      <value type="string" key="oldName">name</value>
12889 
                      <link type="object" struct-name="GrtObject" key="owner">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
12890 
                    </value>
12814 12891 
                    <value type="object" struct-name="db.mysql.Column" id="26132e1a-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x783b5183">
12815 12892 
                      <value type="int" key="autoIncrement">0</value>
12816 12893 
                      <value type="string" key="characterSetName"></value>
......
12925 13002 
                      <value type="string" key="oldName">fk_person_organization1_idx</value>
12926 13003 
                      <link type="object" struct-name="GrtObject" key="owner">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
12927 13004 
                    </value>
13005 
                    <value type="object" struct-name="db.mysql.Index" id="a76e6760-23ec-11e3-ab7c-080027bcf912" struct-checksum="0x309b847a">
13006 
                      <value _ptr_="0xd24f6f8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
13007 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="a76e68e6-23ec-11e3-ab7c-080027bcf912" struct-checksum="0x62630b3c">
13008 
                          <value type="int" key="columnLength">0</value>
13009 
                          <value type="string" key="comment"></value>
13010 
                          <value type="int" key="descend">0</value>
13011 
                          <link type="object" struct-name="db.Column" key="referencedColumn">26132e1a-23e9-11e3-ab7c-080027bcf912</link>
13012 
                          <value type="string" key="name"></value>
13013 
                          <link type="object" struct-name="GrtObject" key="owner">a76e6760-23ec-11e3-ab7c-080027bcf912</link>
13014 
                        </value>
13015 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="b15254d0-23ec-11e3-ab7c-080027bcf912" struct-checksum="0x62630b3c">
13016 
                          <value type="int" key="columnLength">0</value>
13017 
                          <value type="string" key="comment"></value>
13018 
                          <value type="int" key="descend">0</value>
13019 
                          <link type="object" struct-name="db.Column" key="referencedColumn">e96e2084-23eb-11e3-ab7c-080027bcf912</link>
13020 
                          <value type="string" key="name"></value>
13021 
                          <link type="object" struct-name="GrtObject" key="owner">a76e6760-23ec-11e3-ab7c-080027bcf912</link>
13022 
                        </value>
13023 
                      </value>
13024 
                      <value type="string" key="indexKind"></value>
13025 
                      <value type="int" key="keyBlockSize">0</value>
13026 
                      <value type="string" key="withParser"></value>
13027 
                      <value type="string" key="comment"></value>
13028 
                      <value type="int" key="deferability">0</value>
13029 
                      <value type="string" key="indexType">UNIQUE</value>
13030 
                      <value type="int" key="isPrimary">0</value>
13031 
                      <value type="string" key="name">person_unique</value>
13032 
                      <value type="int" key="unique">1</value>
13033 
                      <value type="string" key="oldName">person_unique</value>
13034 
                      <link type="object" struct-name="GrtObject" key="owner">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
13035 
                    </value>
12928 13036 
                  </value>
12929 13037 
                  <value type="string" key="maxRows"></value>
12930 13038 
                  <value type="string" key="mergeInsert"></value>
......
12956 13064 
                  <value type="int" key="commentedOut">0</value>
12957 13065 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
12958 13066 
                  <value _ptr_="0xc8e6148" type="dict" key="customData"/>
12959 
                  <value type="string" key="lastChangeDate">2013-09-22 17:43</value>
13067 
                  <value type="string" key="lastChangeDate">2013-09-22 18:08</value>
12960 13068 
                  <value type="int" key="modelOnly">0</value>
12961 13069 
                  <value type="string" key="name">person</value>
12962 13070 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
15986 16094 
                <value type="int" key="triggersExpanded">0</value>
15987 16095 
                <value type="string" key="color">#99ccff</value>
15988 16096 
                <value type="int" key="expanded">1</value>
15989 
                <value type="real" key="height">1.69e+02</value>
16097 
                <value type="real" key="height">1.92e+02</value>
15990 16098 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15991 
                <value type="real" key="left">4.e+01</value>
16099 
                <value type="real" key="left">4.5e+01</value>
15992 16100 
                <value type="int" key="locked">0</value>
15993 16101 
                <value type="int" key="manualSizing">0</value>
15994 
                <value type="real" key="top">6.74e+02</value>
16102 
                <value type="real" key="top">6.69e+02</value>
15995 16103 
                <value type="real" key="width">9.2e+01</value>
15996 16104 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15997 16105 
                <value type="int" key="visible">1</value>
......
16008 16116 
                <value type="int" key="expanded">1</value>
16009 16117 
                <value type="real" key="height">1.e+02</value>
16010 16118 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16011 
                <value type="real" key="left">1.46e+02</value>
16119 
                <value type="real" key="left">1.49e+02</value>
16012 16120 
                <value type="int" key="locked">0</value>
16013 16121 
                <value type="int" key="manualSizing">0</value>
16014 16122 
                <value type="real" key="top">5.2e+02</value>
......
16526 16634 
                <value type="int" key="triggersExpanded">0</value>
16527 16635 
                <value type="string" key="color">#ffcccc</value>
16528 16636 
                <value type="int" key="expanded">1</value>
16529 
                <value type="real" key="height">7.7e+01</value>
16637 
                <value type="real" key="height">5.4e+01</value>
16530 16638 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16531 
                <value type="real" key="left">1.3e+01</value>
16639 
                <value type="real" key="left">2.1e+01</value>
16532 16640 
                <value type="int" key="locked">0</value>
16533 16641 
                <value type="int" key="manualSizing">0</value>
16534 
                <value type="real" key="top">9.69e+02</value>
16642 
                <value type="real" key="top">9.56e+02</value>
16535 16643 
                <value type="real" key="width">7.9e+01</value>
16536 16644 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16537 16645 
                <value type="int" key="visible">1</value>
......
16992 17100 
                <value type="int" key="triggersExpanded">0</value>
16993 17101 
                <value type="string" key="color">#ffcccc</value>
16994 17102 
                <value type="int" key="expanded">1</value>
16995 
                <value type="real" key="height">7.7e+01</value>
17103 
                <value type="real" key="height">1.e+02</value>
16996 17104 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16997 
                <value type="real" key="left">9.e+00</value>
17105 
                <value type="real" key="left">7.e+00</value>
16998 17106 
                <value type="int" key="locked">0</value>
16999 17107 
                <value type="int" key="manualSizing">0</value>
17000 
                <value type="real" key="top">1.196e+03</value>
17108 
                <value type="real" key="top">1.175e+03</value>
17001 17109 
                <value type="real" key="width">1.21e+02</value>
17002 17110 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17003 17111 
                <value type="int" key="visible">1</value>
......
17134 17242 
                <value type="int" key="expanded">1</value>
17135 17243 
                <value type="real" key="height">7.7e+01</value>
17136 17244 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
17137 
                <value type="real" key="left">1.81e+02</value>
17245 
                <value type="real" key="left">1.95e+02</value>
17138 17246 
                <value type="int" key="locked">0</value>
17139 17247 
                <value type="int" key="manualSizing">0</value>
17140 
                <value type="real" key="top">8.31e+02</value>
17248 
                <value type="real" key="top">8.06e+02</value>
17141 17249 
                <value type="real" key="width">1.03e+02</value>
17142 17250 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17143 17251 
                <value type="int" key="visible">1</value>
......
17154 17262 
                <value type="int" key="expanded">1</value>
17155 17263 
                <value type="real" key="height">1.46e+02</value>
17156 17264 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
17157 
                <value type="real" key="left">1.4e+02</value>
17265 
                <value type="real" key="left">1.54e+02</value>
17158 17266 
                <value type="int" key="locked">0</value>
17159 17267 
                <value type="int" key="manualSizing">0</value>
17160 
                <value type="real" key="top">9.35e+02</value>
17268 
                <value type="real" key="top">9.1e+02</value>
17161 17269 
                <value type="real" key="width">1.39e+02</value>
17162 17270 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17163 17271 
                <value type="int" key="visible">1</value>
......
17549 17657 
                <value type="int" key="expanded">1</value>
17550 17658 
                <value type="real" key="height">1.e+02</value>
17551 17659 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
17552 
                <value type="real" key="left">1.e+01</value>
17660 
                <value type="real" key="left">1.8e+01</value>
17553 17661 
                <value type="int" key="locked">0</value>
17554 17662 
                <value type="int" key="manualSizing">0</value>
17555 17663 
                <value type="real" key="top">5.36e+02</value>
......
17567 17675 
                <value type="int" key="triggersExpanded">0</value>
17568 17676 
                <value type="string" key="color">#ffcccc</value>
17569 17677 
                <value type="int" key="expanded">1</value>
17570 
                <value type="real" key="height">7.7e+01</value>
17678 
                <value type="real" key="height">1.e+02</value>
17571 17679 
                <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>
17680 
                <value type="real" key="left">5.9e+01</value>
17573 17681 
                <value type="int" key="locked">0</value>
17574 17682 
                <value type="int" key="manualSizing">0</value>
17575 
                <value type="real" key="top">1.081e+03</value>
17683 
                <value type="real" key="top">1.042e+03</value>
17576 17684 
                <value type="real" key="width">9.e+01</value>
17577 17685 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17578 17686 
                <value type="int" key="visible">1</value>
......
17723 17831 
              <value type="string" key="name"></value>
17724 17832 
            </value>
17725 17833 
            <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>
17834 
              <link type="object">39C6F66E-A650-49AE-8EDD-9D8A567EFBEA</link>
17727 17835 
            </value>
17728 17836 
            <value type="int" key="updateBlocked">0</value>
17729 17837 
            <value type="real" key="width">1.6215e+03</value>
......
17737 17845 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17738 17846 
        <value _ptr_="0xba3c650" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17739 17847 
        <value _ptr_="0xb030e28" type="dict" key="syncProfiles">
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">
17848 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="dae7ad2c-23ec-11e3-ab7c-080027bcf912" struct-checksum="0xc64972c2" key="">
17849 
            <value _ptr_="0xdc190e0" type="dict" key="lastKnownDBNames">
17850 
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17742 17851 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17743 17852 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
17744 17853 
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
18013 18122 
              <value type="string" key="813d5bfe-1de9-11e3-b571-080027bcf912">list</value>
18014 18123 
              <value type="string" key="813e36c8-1de9-11e3-b571-080027bcf912">fk_party_list_entry_party_list1_idx</value>
18015 18124 
              <value type="string" key="81937b1c-ad12-11e2-b309-080027bcf912">fk_collection_source1_idx</value>
18016 
              <value type="string" key="8222d06e-1e00-11e3-9d67-080027bcf912">name</value>
18017 18125 
              <value type="string" key="83cc6526-236c-11e3-a6f3-080027bcf912">name</value>
18018 18126 
              <value type="string" key="83dbd4da-f6e8-11e2-9cf1-080027bcf912">georeferencing</value>
18019 18127 
              <value type="string" key="83dbd8ae-f6e8-11e2-9cf1-080027bcf912">id</value>
......
18025 18133 
              <value type="string" key="8535e306-006c-11e3-895c-080027bcf912">stratum</value>
18026 18134 
              <value type="string" key="8535e982-006c-11e3-895c-080027bcf912">PRIMARY</value>
18027 18135 
              <value type="string" key="8542fbb8-a793-11e2-84c3-080027bcf912">info</value>
18136 
              <value type="string" key="86e5a7d8-23ec-11e3-ab7c-080027bcf912">organization_unique</value>
18028 18137 
              <value type="string" key="873d44bc-1df1-11e3-bbb6-080027bcf912">fk_source_party1</value>
18029 18138 
              <value type="string" key="873d473c-1df1-11e3-bbb6-080027bcf912">contacts</value>
18030 18139 
              <value type="string" key="8b8a694e-a792-11e2-84c3-080027bcf912">name</value>
18031 18140 
              <value type="string" key="8c119224-238a-11e3-a6f3-080027bcf912">fk_party_source1</value>
18141 
              <value type="string" key="8e39e482-23eb-11e3-ab7c-080027bcf912">name</value>
18032 18142 
              <value type="string" key="8ed70288-ad14-11e2-9617-080027bcf912">PRIMARY</value>
18033 18143 
              <value type="string" key="8f0c3678-f978-11e2-9f36-080027bcf912">rank</value>
18034 18144 
              <value type="string" key="913a6e06-008a-11e3-9629-080027bcf912">fk_soil_observation_record1</value>
......
18059 18169 
              <value type="string" key="a3e070f8-a77c-11e2-afd5-080027bcf912">fk_parsed_taxon_assertion_taxon_name1</value>
18060 18170 
              <value type="string" key="a45bf56a-f980-11e2-8a2e-080027bcf912">fk_subplot_place2</value>
18061 18171 
              <value type="string" key="a60e3a24-ad15-11e2-9617-080027bcf912">specimen_unique_in_collection_by_accession_number</value>
18172 
              <value type="string" key="a76e6760-23ec-11e3-ab7c-080027bcf912">person_unique</value>
18062 18173 
              <value type="string" key="a8348424-a78f-11e2-84c3-080027bcf912">geovalid</value>
18063 18174 
              <value type="string" key="a841b894-f6c0-11e2-af44-080027bcf912">fk_sampling_event_method1</value>
18064 18175 
              <value type="string" key="a841ba7e-f6c0-11e2-af44-080027bcf912">method</value>
......
18070 18181 
              <value type="string" key="ab56b99c-1ddc-11e3-bd5f-080027bcf912">fk_aggregate_observation_taxa_sampling_event1</value>
18071 18182 
              <value type="string" key="ab56bc12-1ddc-11e3-bd5f-080027bcf912">sampling_event</value>
18072 18183 
              <value type="string" key="ab56d2f6-1ddc-11e3-bd5f-080027bcf912">fk_aggregate_observation_taxa_sampling_event1_idx</value>
18184 
              <value type="string" key="ad91aad6-23eb-11e3-ab7c-080027bcf912">dataset_unique</value>
18073 18185 
              <value type="string" key="ae7761fe-008a-11e3-9629-080027bcf912">fk_soil_observation_subplace1</value>
18074 18186 
              <value type="string" key="ae7763ca-008a-11e3-9629-080027bcf912">measurement_spot</value>
18075 18187 
              <value type="string" key="ae777b3a-008a-11e3-9629-080027bcf912">fk_soil_observation_subplace1_idx</value>
......
18082 18194 
              <value type="string" key="afc40c10-1df9-11e3-bbb6-080027bcf912">name</value>
18083 18195 
              <value type="string" key="afc4158e-1df9-11e3-bbb6-080027bcf912">info</value>
18084 18196 
              <value type="string" key="afc41fc0-1df9-11e3-bbb6-080027bcf912">PRIMARY</value>
18085 
              <value type="string" key="afc422b8-1df9-11e3-bbb6-080027bcf912">source_unique</value>
18086 18197 
              <value type="string" key="b19ab98a-a6e9-11e2-98a6-080027bcf912">PRIMARY</value>
18087 18198 
              <value type="string" key="b3ac613c-0086-11e3-ac06-080027bcf912">fk_reobservable_presence_reobservable1</value>
18088 18199 
              <value type="string" key="b55f115c-a792-11e2-84c3-080027bcf912">name</value>
......
18253 18364 
              <value type="string" key="dda7bdec-0072-11e3-906b-080027bcf912">parent_event</value>
18254 18365 
              <value type="string" key="dda7d480-0072-11e3-906b-080027bcf912">fk_stratum_event_sampling_event2_idx</value>
18255 18366 
              <value type="string" key="e95a1e48-1de9-11e3-b571-080027bcf912">fk_party_list_entry_record1</value>
18367 
              <value type="string" key="e96e2084-23eb-11e3-ab7c-080027bcf912">name</value>
18256 18368 
              <value type="string" key="eb778868-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1</value>
18257 18369 
              <value type="string" key="eb778aac-ad01-11e2-b309-080027bcf912">collection_event</value>
18258 18370 
              <value type="string" key="eb77b1da-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1_idx</value>
......
18370 18482 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18371 18483 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18372 18484 
      <value type="string" key="caption">New Model</value>
18373 
      <value type="string" key="dateChanged">2013-09-22 17:51</value>
18485 
      <value type="string" key="dateChanged">2013-09-22 18:09</value>
18374 18486 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18375 18487 
      <value type="string" key="description"></value>
18376 18488 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
125 125 
/*!40101 SET character_set_client = utf8 */;
126 126 
CREATE TABLE `dataset` (
127 127 
  `id` varbinary(767) NOT NULL,
128 
  `name` varbinary(767) NOT NULL,
128 129 
  `parent` varbinary(767) DEFAULT NULL COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by data_source. e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the data_source).',
129 130 
  `data_source` varbinary(767) DEFAULT NULL COMMENT 'where the data in the dataset came from (as opposed to where the metadata *about* the dataset came from, which is in source, inherited from traceable)',
130 131 
  `first_publisher` varbinary(767) DEFAULT NULL,
131 132 
  `data_owners` varbinary(767) DEFAULT NULL COMMENT 'parties who must be given attribution, such as copyrightholders',
132 133 
  `contacts` varbinary(767) DEFAULT NULL,
133 134 
  PRIMARY KEY (`id`),
135 
  UNIQUE KEY `dataset_unique` (`parent`,`name`),
134 136 
  KEY `fk_source_party2_idx` (`first_publisher`),
135 137 
  KEY `fk_source_party_list1_idx` (`data_owners`),
136 138 
  KEY `fk_source_party1_idx` (`contacts`),
137 139 
  KEY `fk_dataset_source2_idx` (`data_source`),
138 140 
  KEY `fk_dataset_dataset1_idx` (`parent`),
139 
  CONSTRAINT `fk_dataset_source2` FOREIGN KEY (`data_source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
141 
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
140 142 
  CONSTRAINT `fk_dataset_dataset1` FOREIGN KEY (`parent`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
141 143 
  CONSTRAINT `fk_dataset_source1` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
144 
  CONSTRAINT `fk_dataset_source2` FOREIGN KEY (`data_source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
142 145 
  CONSTRAINT `fk_dataset_traceable1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
143 
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
144 146 
  CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
145 147 
  CONSTRAINT `fk_source_party_list1` FOREIGN KEY (`data_owners`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
146 148 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements';
......
495 497 
/*!40101 SET character_set_client = utf8 */;
496 498 
CREATE TABLE `organization` (
497 499 
  `id` varbinary(767) NOT NULL,
500 
  `name` varbinary(767) NOT NULL,
498 501 
  `parent` varbinary(767) DEFAULT NULL,
499 502 
  PRIMARY KEY (`id`),
503 
  UNIQUE KEY `organization_unique` (`parent`,`name`),
500 504 
  KEY `fk_organization_organization1_idx` (`parent`),
501 505 
  CONSTRAINT `fk_organization_organization1` FOREIGN KEY (`parent`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
502 506 
  CONSTRAINT `fk_organization_party1` FOREIGN KEY (`id`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
......
518 522 
/*!40101 SET character_set_client = utf8 */;
519 523 
CREATE TABLE `party` (
520 524 
  `id` varbinary(767) NOT NULL,
521 
  `name` varbinary(767) NOT NULL,
522 525 
  PRIMARY KEY (`id`),
523 526 
  CONSTRAINT `fk_collection_source10` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
524 527 
  CONSTRAINT `fk_party_source1` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
......
589 592 
/*!40101 SET character_set_client = utf8 */;
590 593 
CREATE TABLE `person` (
591 594 
  `id` varbinary(767) NOT NULL,
595 
  `name` varbinary(767) NOT NULL,
592 596 
  `organization` varbinary(767) DEFAULT NULL,
593 597 
  PRIMARY KEY (`id`),
598 
  UNIQUE KEY `person_unique` (`organization`,`name`),
594 599 
  KEY `fk_person_organization1_idx` (`organization`),
595 600 
  CONSTRAINT `fk_person_organization1` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
596 601 
  CONSTRAINT `fk_organization_party10` FOREIGN KEY (`id`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
......
866 871 
/*!40101 SET character_set_client = utf8 */;
867 872 
CREATE TABLE `source` (
868 873 
  `id` varbinary(767) NOT NULL,
869 
  `name` varbinary(767) NOT NULL,
874 
  `name` varbinary(767) DEFAULT NULL,
870 875 
  `info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
871 
  PRIMARY KEY (`id`),
872 
  UNIQUE KEY `source_unique` (`name`)
876 
  PRIMARY KEY (`id`)
873 877 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='where something came from; a "reference [...] cited within the database" ("VegBank":http://reference.VegBank.vegpath.org); = VegBank.vegpath.org?reference';
874 878 
/*!40101 SET character_set_client = @saved_cs_client */;
875 879 

  		












  

    
      schemas/VegCore/VegCore.pg.sql
    
  





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


  		




  128
  128
  
    
CREATE TABLE "dataset" (


  		




  129
  129
  
    
  "id" text NOT NULL,


  		




  
  130
  
    
  "name" text NOT NULL,


  		




  130
  131
  
    
  "parent" text DEFAULT NULL /*COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by data_source. e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the data_source).'*/,


  		




  131
  132
  
    
  "data_source" text DEFAULT NULL /*COMMENT 'where the data in the dataset came from (as opposed to where the metadata *about* the dataset came from, which is in source, inherited from traceable)'*/,


  		




  132
  133
  
    
  "first_publisher" text DEFAULT NULL,


  		




  133
  134
  
    
  "data_owners" text DEFAULT NULL /*COMMENT 'parties who must be given attribution, such as copyrightholders'*/,


  		




  134
  135
  
    
  "contacts" text DEFAULT NULL,


  		




  135
  136
  
    
  PRIMARY KEY ("id"),


  		




  
  137
  
    
  /*CONSTRAINT "dataset_unique" */UNIQUE ("parent","name"),


  		




  136
  138
  
    
  /*KEY "fk_source_party2_idx" ("first_publisher")*/CHECK (true),


  		




  137
  139
  
    
  /*KEY "fk_source_party_list1_idx" ("data_owners")*/CHECK (true),


  		




  138
  140
  
    
  /*KEY "fk_source_party1_idx" ("contacts")*/CHECK (true),


  		




  139
  141
  
    
  /*KEY "fk_dataset_source2_idx" ("data_source")*/CHECK (true),


  		




  140
  142
  
    
  /*KEY "fk_dataset_dataset1_idx" ("parent")*/CHECK (true),


  		




  141
  
  
    
  /*CONSTRAINT "fk_dataset_source2" FOREIGN KEY ("data_source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  143
  
    
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  142
  144
  
    
  /*CONSTRAINT "fk_dataset_dataset1" FOREIGN KEY ("parent") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  143
  145
  
    
  /*CONSTRAINT "fk_dataset_source1" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  146
  
    
  /*CONSTRAINT "fk_dataset_source2" FOREIGN KEY ("data_source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  144
  147
  
    
  /*CONSTRAINT "fk_dataset_traceable1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  145
  
  
    
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  146
  148
  
    
  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  147
  149
  
    
  /*CONSTRAINT "fk_source_party_list1" FOREIGN KEY ("data_owners") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  148
  150
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements'*/;


  		




  ......




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


  		




  498
  500
  
    
CREATE TABLE "organization" (


  		




  499
  501
  
    
  "id" text NOT NULL,


  		




  
  502
  
    
  "name" text NOT NULL,


  		




  500
  503
  
    
  "parent" text DEFAULT NULL,


  		




  501
  504
  
    
  PRIMARY KEY ("id"),


  		




  
  505
  
    
  /*CONSTRAINT "organization_unique" */UNIQUE ("parent","name"),


  		




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


  		




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


  		




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


  		




  ......




  520
  524
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  521
  525
  
    
CREATE TABLE "party" (


  		




  522
  526
  
    
  "id" text NOT NULL,


  		




  523
  
  
    
  "name" text NOT NULL,


  		




  524
  527
  
    
  PRIMARY KEY ("id"),


  		




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


  		




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


  		




  ......




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


  		




  592
  595
  
    
CREATE TABLE "person" (


  		




  593
  596
  
    
  "id" text NOT NULL,


  		




  
  597
  
    
  "name" text NOT NULL,


  		




  594
  598
  
    
  "organization" text DEFAULT NULL,


  		




  595
  599
  
    
  PRIMARY KEY ("id"),


  		




  
  600
  
    
  /*CONSTRAINT "person_unique" */UNIQUE ("organization","name"),


  		




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


  		




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


  		




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


  		




  ......




  868
  873
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  869
  874
  
    
CREATE TABLE "source" (


  		




  870
  875
  
    
  "id" text NOT NULL,


  		




  871
  
  
    
  "name" text NOT NULL,


  		




  
  876
  
    
  "name" text DEFAULT NULL,


  		




  872
  877
  
    
  "info" hstore DEFAULT NULL,


  		




  873
  
  
    
  PRIMARY KEY ("id"),


  		




  874
  
  
    
  /*CONSTRAINT "source_unique" */UNIQUE ("name")


  		




  
  878
  
    
  PRIMARY KEY ("id")


  		




  875
  879
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='where something came from; a "reference [...] cited within the database" ("VegBank":http://reference.VegBank.vegpath.org); = VegBank.vegpath.org?reference'*/;


  		




  876
  880
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  877
  881
  
    

  		












Also available in:  Unified diff