Project

General

Profile

« Previous | Next » 

Revision 10453

Added by Aaron Marcuse-Kubitza almost 11 years ago

schemas/VegCore/VegCore.ERD.mwb: party: added party_list array table

View differences:

schemas/VegCore/document.mwb.xml
61 61 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
62 62 
                      <value type="string" key="comment"></value>
63 63 
                      <value type="string" key="name">organization</value>
64 
                      <value type="string" key="oldName">organization_id</value>
64 
                      <value type="string" key="oldName">organization</value>
65 65 
                      <link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
66 66 
                    </value>
67 67 
                    <value type="object" struct-name="db.mysql.Column" id="c8868c00-a793-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">
......
176 176 
                      <value type="int" key="isPrimary">0</value>
177 177 
                      <value type="string" key="name">fk_party_organization1_idx</value>
178 178 
                      <value type="int" key="unique">0</value>
179 
                      <value type="string" key="oldName">fk_party_organization1</value>
179 
                      <value type="string" key="oldName">fk_party_organization1_idx</value>
180 180 
                      <link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
181 181 
                    </value>
182 182 
                  </value>
......
9681 9681 
                  <value type="string" key="comment"></value>
9682 9682 
                  <value type="string" key="oldName">specimenholder_institution</value>
9683 9683 
                </value>
9684 
                <value type="object" struct-name="db.mysql.Table" id="4001ec92-f678-11e2-9716-080027bcf912" struct-checksum="0x1a403946">
9685 
                  <value type="string" key="avgRowLength"></value>
9686 
                  <value type="int" key="checksum">0</value>
9687 
                  <value _ptr_="0xb2b0f28" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
9688 
                    <value type="object" struct-name="db.mysql.Column" id="4001ef9e-f678-11e2-9716-080027bcf912" struct-checksum="0x783b5183">
9689 
                      <value type="int" key="autoIncrement">0</value>
9690 
                      <value type="string" key="characterSetName"></value>
9691 
                      <value _ptr_="0xbc94c58" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
9692 
                      <value type="string" key="collationName"></value>
9693 
                      <value type="string" key="datatypeExplicitParams"></value>
9694 
                      <value type="string" key="defaultValue"></value>
9695 
                      <value type="int" key="defaultValueIsNull">0</value>
9696 
                      <value _ptr_="0xc692850" type="list" content-type="string" key="flags"/>
9697 
                      <value type="int" key="isNotNull">1</value>
9698 
                      <value type="int" key="length">767</value>
9699 
                      <value type="int" key="precision">-1</value>
9700 
                      <value type="int" key="scale">-1</value>
9701 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
9702 
                      <value type="string" key="comment"></value>
9703 
                      <value type="string" key="name">id</value>
9704 
                      <value type="string" key="oldName">id</value>
9705 
                      <link type="object" struct-name="GrtObject" key="owner">4001ec92-f678-11e2-9716-080027bcf912</link>
9706 
                    </value>
9707 
                    <value type="object" struct-name="db.mysql.Column" id="4001f296-f678-11e2-9716-080027bcf912" struct-checksum="0x783b5183">
9708 
                      <value type="int" key="autoIncrement">0</value>
9709 
                      <value type="string" key="characterSetName"></value>
9710 
                      <value _ptr_="0xc6a3200" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
9711 
                      <value type="string" key="collationName"></value>
9712 
                      <value type="string" key="datatypeExplicitParams"></value>
9713 
                      <value type="string" key="defaultValue"></value>
9714 
                      <value type="int" key="defaultValueIsNull">0</value>
9715 
                      <value _ptr_="0xb3b6758" type="list" content-type="string" key="flags"/>
9716 
                      <value type="int" key="isNotNull">1</value>
9717 
                      <value type="int" key="length">-1</value>
9718 
                      <value type="int" key="precision">-1</value>
9719 
                      <value type="int" key="scale">-1</value>
9720 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.int</link>
9721 
                      <value type="string" key="comment"></value>
9722 
                      <value type="string" key="name">count</value>
9723 
                      <value type="string" key="oldName">organization</value>
9724 
                      <link type="object" struct-name="GrtObject" key="owner">4001ec92-f678-11e2-9716-080027bcf912</link>
9725 
                    </value>
9726 
                  </value>
9727 
                  <value type="string" key="connectionString"></value>
9728 
                  <value type="string" key="defaultCharacterSetName">utf8</value>
9729 
                  <value type="string" key="defaultCollationName">utf8_bin</value>
9730 
                  <value type="int" key="delayKeyWrite">0</value>
9731 
                  <value _ptr_="0xc6898f8" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
9732 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="4001f692-f678-11e2-9716-080027bcf912" struct-checksum="0x70a8fc40">
9733 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
9734 
                      <value _ptr_="0xc13b6f0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
9735 
                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
9736 
                      </value>
9737 
                      <value type="int" key="deferability">0</value>
9738 
                      <value type="string" key="deleteRule">CASCADE</value>
9739 
                      <link type="object" struct-name="db.Index" key="index">4001fa52-f678-11e2-9716-080027bcf912</link>
9740 
                      <value type="int" key="mandatory">0</value>
9741 
                      <value type="int" key="many">0</value>
9742 
                      <value type="int" key="modelOnly">0</value>
9743 
                      <link type="object" struct-name="db.Table" key="owner">4001ec92-f678-11e2-9716-080027bcf912</link>
9744 
                      <value _ptr_="0xc122298" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
9745 
                        <link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
9746 
                      </value>
9747 
                      <value type="int" key="referencedMandatory">1</value>
9748 
                      <value type="string" key="updateRule">CASCADE</value>
9749 
                      <value type="string" key="comment"></value>
9750 
                      <value type="string" key="name">fk_collection_source100</value>
9751 
                      <value type="string" key="oldName">fk_collection_source10</value>
9752 
                    </value>
9753 
                  </value>
9754 
                  <value _ptr_="0xc12bd28" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
9755 
                    <value type="object" struct-name="db.mysql.Index" id="4001fa52-f678-11e2-9716-080027bcf912" struct-checksum="0x309b847a">
9756 
                      <value _ptr_="0xc699d90" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
9757 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="4001fb74-f678-11e2-9716-080027bcf912" struct-checksum="0x62630b3c">
9758 
                          <value type="int" key="columnLength">0</value>
9759 
                          <value type="string" key="comment"></value>
9760 
                          <value type="int" key="descend">0</value>
9761 
                          <link type="object" struct-name="db.Column" key="referencedColumn">4001ef9e-f678-11e2-9716-080027bcf912</link>
9762 
                          <value type="string" key="name"></value>
9763 
                          <link type="object" struct-name="GrtObject" key="owner">4001fa52-f678-11e2-9716-080027bcf912</link>
9764 
                        </value>
9765 
                      </value>
9766 
                      <value type="string" key="indexKind"></value>
9767 
                      <value type="int" key="keyBlockSize">0</value>
9768 
                      <value type="string" key="withParser"></value>
9769 
                      <value type="string" key="comment"></value>
9770 
                      <value type="int" key="deferability">0</value>
9771 
                      <value type="string" key="indexType">PRIMARY</value>
9772 
                      <value type="int" key="isPrimary">1</value>
9773 
                      <value type="string" key="name">PRIMARY</value>
9774 
                      <value type="int" key="unique">0</value>
9775 
                      <value type="string" key="oldName">PRIMARY</value>
9776 
                      <link type="object" struct-name="GrtObject" key="owner">4001ec92-f678-11e2-9716-080027bcf912</link>
9777 
                    </value>
9778 
                  </value>
9779 
                  <value type="string" key="maxRows"></value>
9780 
                  <value type="string" key="mergeInsert"></value>
9781 
                  <value type="string" key="mergeUnion"></value>
9782 
                  <value type="string" key="minRows"></value>
9783 
                  <value type="string" key="nextAutoInc"></value>
9784 
                  <value type="string" key="packKeys"></value>
9785 
                  <value type="int" key="partitionCount">0</value>
9786 
                  <value _ptr_="0xc075bb8" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
9787 
                  <value type="string" key="partitionExpression"></value>
9788 
                  <value type="string" key="partitionType"></value>
9789 
                  <value type="string" key="password"></value>
9790 
                  <link type="object" struct-name="db.mysql.Index" key="primaryKey">4001fa52-f678-11e2-9716-080027bcf912</link>
9791 
                  <value type="string" key="raidChunkSize"></value>
9792 
                  <value type="string" key="raidChunks"></value>
9793 
                  <value type="string" key="raidType"></value>
9794 
                  <value type="string" key="rowFormat"></value>
9795 
                  <value type="int" key="subpartitionCount">0</value>
9796 
                  <value type="string" key="subpartitionExpression"></value>
9797 
                  <value type="string" key="subpartitionType"></value>
9798 
                  <value type="string" key="tableDataDir"></value>
9799 
                  <value type="string" key="tableEngine">InnoDB</value>
9800 
                  <value type="string" key="tableIndexDir"></value>
9801 
                  <value _ptr_="0xbd66970" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
9802 
                  <value type="int" key="isStub">0</value>
9803 
                  <value type="int" key="isSystem">0</value>
9804 
                  <value type="int" key="isTemporary">0</value>
9805 
                  <value type="string" key="temporaryScope"></value>
9806 
                  <value type="int" key="commentedOut">0</value>
9807 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
9808 
                  <value _ptr_="0xc06c7a8" type="dict" key="customData"/>
9809 
                  <value type="string" key="lastChangeDate">2013-07-26 22:00</value>
9810 
                  <value type="int" key="modelOnly">0</value>
9811 
                  <value type="string" key="name">party_list</value>
9812 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
9813 
                  <value type="string" key="temp_sql"></value>
9814 
                  <value type="string" key="comment"></value>
9815 
                  <value type="string" key="oldName"></value>
9816 
                </value>
9817 
                <value type="object" struct-name="db.mysql.Table" id="9d6c9e9a-f678-11e2-9716-080027bcf912" struct-checksum="0x1a403946">
9818 
                  <value type="string" key="avgRowLength"></value>
9819 
                  <value type="int" key="checksum">0</value>
9820 
                  <value _ptr_="0xc3917e8" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
9821 
                    <value type="object" struct-name="db.mysql.Column" id="9d6ca570-f678-11e2-9716-080027bcf912" struct-checksum="0x783b5183">
9822 
                      <value type="int" key="autoIncrement">0</value>
9823 
                      <value type="string" key="characterSetName"></value>
9824 
                      <value _ptr_="0xc7042d0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
9825 
                      <value type="string" key="collationName"></value>
9826 
                      <value type="string" key="datatypeExplicitParams"></value>
9827 
                      <value type="string" key="defaultValue"></value>
9828 
                      <value type="int" key="defaultValueIsNull">0</value>
9829 
                      <value _ptr_="0xc1d4bb8" type="list" content-type="string" key="flags"/>
9830 
                      <value type="int" key="isNotNull">1</value>
9831 
                      <value type="int" key="length">767</value>
9832 
                      <value type="int" key="precision">-1</value>
9833 
                      <value type="int" key="scale">-1</value>
9834 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
9835 
                      <value type="string" key="comment"></value>
9836 
                      <value type="string" key="name">id</value>
9837 
                      <value type="string" key="oldName">party_list_id</value>
9838 
                      <link type="object" struct-name="GrtObject" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link>
9839 
                    </value>
9840 
                    <value type="object" struct-name="db.mysql.Column" id="9d6cb150-f678-11e2-9716-080027bcf912" struct-checksum="0x783b5183">
9841 
                      <value type="int" key="autoIncrement">0</value>
9842 
                      <value type="string" key="characterSetName"></value>
9843 
                      <value _ptr_="0xc253548" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
9844 
                      <value type="string" key="collationName"></value>
9845 
                      <value type="string" key="datatypeExplicitParams"></value>
9846 
                      <value type="string" key="defaultValue"></value>
9847 
                      <value type="int" key="defaultValueIsNull">0</value>
9848 
                      <value _ptr_="0xc253578" type="list" content-type="string" key="flags"/>
9849 
                      <value type="int" key="isNotNull">1</value>
9850 
                      <value type="int" key="length">767</value>
9851 
                      <value type="int" key="precision">-1</value>
9852 
                      <value type="int" key="scale">-1</value>
9853 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
9854 
                      <value type="string" key="comment"></value>
9855 
                      <value type="string" key="name">entry</value>
9856 
                      <value type="string" key="oldName">party_id</value>
9857 
                      <link type="object" struct-name="GrtObject" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link>
9858 
                    </value>
9859 
                    <value type="object" struct-name="db.mysql.Column" id="43f70d90-f679-11e2-9716-080027bcf912" struct-checksum="0x783b5183">
9860 
                      <value type="int" key="autoIncrement">0</value>
9861 
                      <value type="string" key="characterSetName"></value>
9862 
                      <value _ptr_="0xc8aca70" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
9863 
                      <value type="string" key="collationName"></value>
9864 
                      <value type="string" key="datatypeExplicitParams"></value>
9865 
                      <value type="string" key="defaultValue"></value>
9866 
                      <value type="int" key="defaultValueIsNull">0</value>
9867 
                      <value _ptr_="0xc219ce8" type="list" content-type="string" key="flags"/>
9868 
                      <value type="int" key="isNotNull">0</value>
9869 
                      <value type="int" key="length">-1</value>
9870 
                      <value type="int" key="precision">-1</value>
9871 
                      <value type="int" key="scale">-1</value>
9872 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.int</link>
9873 
                      <value type="string" key="comment"></value>
9874 
                      <value type="string" key="name">sort_order</value>
9875 
                      <value type="string" key="oldName"></value>
9876 
                      <link type="object" struct-name="GrtObject" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link>
9877 
                    </value>
9878 
                  </value>
9879 
                  <value type="string" key="connectionString"></value>
9880 
                  <value type="string" key="defaultCharacterSetName">utf8</value>
9881 
                  <value type="string" key="defaultCollationName">utf8_bin</value>
9882 
                  <value type="int" key="delayKeyWrite">0</value>
9883 
                  <value _ptr_="0xc4f6a28" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
9884 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="9d6ca408-f678-11e2-9716-080027bcf912" struct-checksum="0x70a8fc40">
9885 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>
9886 
                      <value _ptr_="0xc6f5810" type="list" content-type="object" content-struct-name="db.Column" key="columns">
9887 
                        <link type="object">9d6ca570-f678-11e2-9716-080027bcf912</link>
9888 
                      </value>
9889 
                      <value type="int" key="deferability">0</value>
9890 
                      <value type="string" key="deleteRule">CASCADE</value>
9891 
                      <link type="object" struct-name="db.Index" key="index">9d6cbbd2-f678-11e2-9716-080027bcf912</link>
9892 
                      <value type="int" key="mandatory">1</value>
9893 
                      <value type="int" key="many">1</value>
9894 
                      <value type="int" key="modelOnly">0</value>
9895 
                      <link type="object" struct-name="db.Table" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link>
9896 
                      <value _ptr_="0xc704258" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
9897 
                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
9898 
                      </value>
9899 
                      <value type="int" key="referencedMandatory">1</value>
9900 
                      <value type="string" key="updateRule">CASCADE</value>
9901 
                      <value type="string" key="comment"></value>
9902 
                      <value type="string" key="name">fk_party_list_has_party_party_list1</value>
9903 
                      <value type="string" key="oldName">fk_party_list_has_party_party_list1</value>
9904 
                    </value>
9905 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="9d6cb042-f678-11e2-9716-080027bcf912" struct-checksum="0x70a8fc40">
9906 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
9907 
                      <value _ptr_="0xc281dc8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
9908 
                        <link type="object">9d6cb150-f678-11e2-9716-080027bcf912</link>
9909 
                      </value>
9910 
                      <value type="int" key="deferability">0</value>
9911 
                      <value type="string" key="deleteRule">CASCADE</value>
9912 
                      <link type="object" struct-name="db.Index" key="index">9d6cb812-f678-11e2-9716-080027bcf912</link>
9913 
                      <value type="int" key="mandatory">1</value>
9914 
                      <value type="int" key="many">1</value>
9915 
                      <value type="int" key="modelOnly">0</value>
9916 
                      <link type="object" struct-name="db.Table" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link>
9917 
                      <value _ptr_="0xc253500" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
9918 
                        <link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>
9919 
                      </value>
9920 
                      <value type="int" key="referencedMandatory">1</value>
9921 
                      <value type="string" key="updateRule">CASCADE</value>
9922 
                      <value type="string" key="comment"></value>
9923 
                      <value type="string" key="name">fk_party_list_has_party_party1</value>
9924 
                      <value type="string" key="oldName">fk_party_list_has_party_party1</value>
9925 
                    </value>
9926 
                  </value>
9927 
                  <value _ptr_="0xc25c0f0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
9928 
                    <value type="object" struct-name="db.mysql.Index" id="9d6ca7aa-f678-11e2-9716-080027bcf912" struct-checksum="0x309b847a">
9929 
                      <value _ptr_="0xc1cf670" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
9930 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="9d6ca8b8-f678-11e2-9716-080027bcf912" struct-checksum="0x62630b3c">
9931 
                          <value type="int" key="columnLength">0</value>
9932 
                          <value type="string" key="comment"></value>
9933 
                          <value type="int" key="descend">0</value>
9934 
                          <link type="object" struct-name="db.Column" key="referencedColumn">9d6ca570-f678-11e2-9716-080027bcf912</link>
9935 
                          <value type="string" key="name"></value>
9936 
                          <link type="object" struct-name="GrtObject" key="owner">9d6ca7aa-f678-11e2-9716-080027bcf912</link>
9937 
                        </value>
9938 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="9d6cb3c6-f678-11e2-9716-080027bcf912" struct-checksum="0x62630b3c">
9939 
                          <value type="int" key="columnLength">0</value>
9940 
                          <value type="string" key="comment"></value>
9941 
                          <value type="int" key="descend">0</value>
9942 
                          <link type="object" struct-name="db.Column" key="referencedColumn">9d6cb150-f678-11e2-9716-080027bcf912</link>
9943 
                          <value type="string" key="name"></value>
9944 
                          <link type="object" struct-name="GrtObject" key="owner">9d6ca7aa-f678-11e2-9716-080027bcf912</link>
9945 
                        </value>
9946 
                      </value>
9947 
                      <value type="string" key="indexKind"></value>
9948 
                      <value type="int" key="keyBlockSize">0</value>
9949 
                      <value type="string" key="withParser"></value>
9950 
                      <value type="string" key="comment"></value>
9951 
                      <value type="int" key="deferability">0</value>
9952 
                      <value type="string" key="indexType">PRIMARY</value>
9953 
                      <value type="int" key="isPrimary">1</value>
9954 
                      <value type="string" key="name">PRIMARY</value>
9955 
                      <value type="int" key="unique">0</value>
9956 
                      <value type="string" key="oldName">PRIMARY</value>
9957 
                      <link type="object" struct-name="GrtObject" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link>
9958 
                    </value>
9959 
                    <value type="object" struct-name="db.mysql.Index" id="9d6cb812-f678-11e2-9716-080027bcf912" struct-checksum="0x309b847a">
9960 
                      <value _ptr_="0xc8b2fa8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
9961 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="9d6cb90c-f678-11e2-9716-080027bcf912" struct-checksum="0x62630b3c">
9962 
                          <value type="int" key="columnLength">0</value>
9963 
                          <value type="string" key="comment"></value>
9964 
                          <value type="int" key="descend">0</value>
9965 
                          <link type="object" struct-name="db.Column" key="referencedColumn">9d6cb150-f678-11e2-9716-080027bcf912</link>
9966 
                          <value type="string" key="name"></value>
9967 
                          <link type="object" struct-name="GrtObject" key="owner">9d6cb812-f678-11e2-9716-080027bcf912</link>
9968 
                        </value>
9969 
                      </value>
9970 
                      <value type="string" key="indexKind"></value>
9971 
                      <value type="int" key="keyBlockSize">0</value>
9972 
                      <value type="string" key="withParser"></value>
9973 
                      <value type="string" key="comment"></value>
9974 
                      <value type="int" key="deferability">0</value>
9975 
                      <value type="string" key="indexType">INDEX</value>
9976 
                      <value type="int" key="isPrimary">0</value>
9977 
                      <value type="string" key="name">fk_party_list_has_party_party1_idx</value>
9978 
                      <value type="int" key="unique">0</value>
9979 
                      <value type="string" key="oldName">fk_party_list_has_party_party1</value>
9980 
                      <link type="object" struct-name="GrtObject" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link>
9981 
                    </value>
9982 
                    <value type="object" struct-name="db.mysql.Index" id="9d6cbbd2-f678-11e2-9716-080027bcf912" struct-checksum="0x309b847a">
9983 
                      <value _ptr_="0xc284b00" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
9984 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="9d6cbcae-f678-11e2-9716-080027bcf912" struct-checksum="0x62630b3c">
9985 
                          <value type="int" key="columnLength">0</value>
9986 
                          <value type="string" key="comment"></value>
9987 
                          <value type="int" key="descend">0</value>
9988 
                          <link type="object" struct-name="db.Column" key="referencedColumn">9d6ca570-f678-11e2-9716-080027bcf912</link>
9989 
                          <value type="string" key="name"></value>
9990 
                          <link type="object" struct-name="GrtObject" key="owner">9d6cbbd2-f678-11e2-9716-080027bcf912</link>
9991 
                        </value>
9992 
                      </value>
9993 
                      <value type="string" key="indexKind"></value>
9994 
                      <value type="int" key="keyBlockSize">0</value>
9995 
                      <value type="string" key="withParser"></value>
9996 
                      <value type="string" key="comment"></value>
9997 
                      <value type="int" key="deferability">0</value>
9998 
                      <value type="string" key="indexType">INDEX</value>
9999 
                      <value type="int" key="isPrimary">0</value>
10000 
                      <value type="string" key="name">fk_party_list_has_party_party_list1_idx</value>
10001 
                      <value type="int" key="unique">0</value>
10002 
                      <value type="string" key="oldName">fk_party_list_has_party_party_list1</value>
10003 
                      <link type="object" struct-name="GrtObject" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link>
10004 
                    </value>
10005 
                  </value>
10006 
                  <value type="string" key="maxRows"></value>
10007 
                  <value type="string" key="mergeInsert"></value>
10008 
                  <value type="string" key="mergeUnion"></value>
10009 
                  <value type="string" key="minRows"></value>
10010 
                  <value type="string" key="nextAutoInc"></value>
10011 
                  <value type="string" key="packKeys"></value>
10012 
                  <value type="int" key="partitionCount">0</value>
10013 
                  <value _ptr_="0xc6f5718" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
10014 
                  <value type="string" key="partitionExpression"></value>
10015 
                  <value type="string" key="partitionType"></value>
10016 
                  <value type="string" key="password"></value>
10017 
                  <link type="object" struct-name="db.mysql.Index" key="primaryKey">9d6ca7aa-f678-11e2-9716-080027bcf912</link>
10018 
                  <value type="string" key="raidChunkSize"></value>
10019 
                  <value type="string" key="raidChunks"></value>
10020 
                  <value type="string" key="raidType"></value>
10021 
                  <value type="string" key="rowFormat"></value>
10022 
                  <value type="int" key="subpartitionCount">0</value>
10023 
                  <value type="string" key="subpartitionExpression"></value>
10024 
                  <value type="string" key="subpartitionType"></value>
10025 
                  <value type="string" key="tableDataDir"></value>
10026 
                  <value type="string" key="tableEngine">InnoDB</value>
10027 
                  <value type="string" key="tableIndexDir"></value>
10028 
                  <value _ptr_="0xc6f56b8" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
10029 
                  <value type="int" key="isStub">0</value>
10030 
                  <value type="int" key="isSystem">0</value>
10031 
                  <value type="int" key="isTemporary">0</value>
10032 
                  <value type="string" key="temporaryScope"></value>
10033 
                  <value type="int" key="commentedOut">0</value>
10034 
                  <value type="string" key="createDate"></value>
10035 
                  <value _ptr_="0xc506128" type="dict" key="customData"/>
10036 
                  <value type="string" key="lastChangeDate">2013-07-26 22:01</value>
10037 
                  <value type="int" key="modelOnly">0</value>
10038 
                  <value type="string" key="name">party_list_entry</value>
10039 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
10040 
                  <value type="string" key="temp_sql"></value>
10041 
                  <value type="string" key="comment"></value>
10042 
                  <value type="string" key="oldName">party_list_has_party</value>
10043 
                </value>
9684 10044 
              </value>
9685 10045 
              <value _ptr_="0xb2be738" type="list" content-type="object" content-struct-name="db.mysql.View" key="views"/>
9686 10046 
              <value type="string" key="defaultCharacterSetName">utf8</value>
......
11794 12154 
                <value type="int" key="visible">1</value>
11795 12155 
                <value type="string" key="name"></value>
11796 12156 
              </value>
12157 
              <value type="object" struct-name="workbench.physical.Connection" id="40027d56-f678-11e2-9716-080027bcf912" struct-checksum="0x9baebc92">
12158 
                <value type="string" key="caption">fk_collection_source100</value>
12159 
                <value type="real" key="captionXOffs">0.e+00</value>
12160 
                <value type="real" key="captionYOffs">0.e+00</value>
12161 
                <value type="string" key="comment"></value>
12162 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12163 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12164 
                <value type="string" key="extraCaption"></value>
12165 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12166 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12167 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">4001f692-f678-11e2-9716-080027bcf912</link>
12168 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12169 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12170 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12171 
                <value type="int" key="drawSplit">1</value>
12172 
                <link type="object" struct-name="model.Figure" key="endFigure">5600079C-23BA-4A27-BDB6-87D19B80AF56</link>
12173 
                <link type="object" struct-name="model.Figure" key="startFigure">40021096-f678-11e2-9716-080027bcf912</link>
12174 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12175 
                <value type="int" key="visible">1</value>
12176 
                <value type="string" key="name"></value>
12177 
              </value>
12178 
              <value type="object" struct-name="workbench.physical.Connection" id="9d6d1ad2-f678-11e2-9716-080027bcf912" struct-checksum="0x9baebc92">
12179 
                <value type="string" key="caption">fk_party_list_has_party_party_list1</value>
12180 
                <value type="real" key="captionXOffs">0.e+00</value>
12181 
                <value type="real" key="captionYOffs">0.e+00</value>
12182 
                <value type="string" key="comment"></value>
12183 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12184 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12185 
                <value type="string" key="extraCaption"></value>
12186 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12187 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12188 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">9d6ca408-f678-11e2-9716-080027bcf912</link>
12189 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12190 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12191 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12192 
                <value type="int" key="drawSplit">0</value>
12193 
                <link type="object" struct-name="model.Figure" key="endFigure">40021096-f678-11e2-9716-080027bcf912</link>
12194 
                <link type="object" struct-name="model.Figure" key="startFigure">9d6cbe7a-f678-11e2-9716-080027bcf912</link>
12195 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12196 
                <value type="int" key="visible">1</value>
12197 
                <value type="string" key="name"></value>
12198 
              </value>
12199 
              <value type="object" struct-name="workbench.physical.Connection" id="9d6d2270-f678-11e2-9716-080027bcf912" struct-checksum="0x9baebc92">
12200 
                <value type="string" key="caption">fk_party_list_has_party_party1</value>
12201 
                <value type="real" key="captionXOffs">0.e+00</value>
12202 
                <value type="real" key="captionYOffs">0.e+00</value>
12203 
                <value type="string" key="comment"></value>
12204 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12205 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12206 
                <value type="string" key="extraCaption"></value>
12207 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12208 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12209 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">9d6cb042-f678-11e2-9716-080027bcf912</link>
12210 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12211 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12212 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12213 
                <value type="int" key="drawSplit">0</value>
12214 
                <link type="object" struct-name="model.Figure" key="endFigure">EE4765B7-0391-4132-8813-84A6E788C01D</link>
12215 
                <link type="object" struct-name="model.Figure" key="startFigure">9d6cbe7a-f678-11e2-9716-080027bcf912</link>
12216 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12217 
                <value type="int" key="visible">1</value>
12218 
                <value type="string" key="name"></value>
12219 
              </value>
11797 12220 
            </value>
11798 12221 
            <value type="string" key="description"></value>
11799 12222 
            <value _ptr_="0xb340678" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
12849 13272 
                <value type="int" key="expanded">1</value>
12850 13273 
                <value type="real" key="height">7.7e+01</value>
12851 13274 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12852 
                <value type="real" key="left">2.4e+01</value>
13275 
                <value type="real" key="left">1.1e+01</value>
12853 13276 
                <value type="int" key="locked">0</value>
12854 13277 
                <value type="int" key="manualSizing">0</value>
12855 
                <value type="real" key="top">9.49e+02</value>
13278 
                <value type="real" key="top">9.5e+02</value>
12856 13279 
                <value type="real" key="width">1.21e+02</value>
12857 13280 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12858 13281 
                <value type="int" key="visible">1</value>
......
13018 13441 
                <value type="int" key="visible">1</value>
13019 13442 
                <value type="string" key="name">&lt; place</value>
13020 13443 
              </value>
13444 
              <value type="object" struct-name="workbench.physical.TableFigure" id="40021096-f678-11e2-9716-080027bcf912" struct-checksum="0x3b14eccb">
13445 
                <value type="int" key="columnsExpanded">1</value>
13446 
                <value type="int" key="foreignKeysExpanded">0</value>
13447 
                <value type="int" key="indicesExpanded">0</value>
13448 
                <value type="int" key="summarizeDisplay">-1</value>
13449 
                <link type="object" struct-name="db.Table" key="table">4001ec92-f678-11e2-9716-080027bcf912</link>
13450 
                <value type="int" key="triggersExpanded">0</value>
13451 
                <value type="string" key="color">#99ccff</value>
13452 
                <value type="int" key="expanded">1</value>
13453 
                <value type="real" key="height">7.7e+01</value>
13454 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13455 
                <value type="real" key="left">1.9e+02</value>
13456 
                <value type="int" key="locked">0</value>
13457 
                <value type="int" key="manualSizing">0</value>
13458 
                <value type="real" key="top">1.012e+03</value>
13459 
                <value type="real" key="width">1.03e+02</value>
13460 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13461 
                <value type="int" key="visible">1</value>
13462 
                <value type="string" key="name">party_list</value>
13463 
              </value>
13464 
              <value type="object" struct-name="workbench.physical.TableFigure" id="9d6cbe7a-f678-11e2-9716-080027bcf912" struct-checksum="0x3b14eccb">
13465 
                <value type="int" key="columnsExpanded">1</value>
13466 
                <value type="int" key="foreignKeysExpanded">0</value>
13467 
                <value type="int" key="indicesExpanded">0</value>
13468 
                <value type="int" key="summarizeDisplay">-1</value>
13469 
                <link type="object" struct-name="db.Table" key="table">9d6c9e9a-f678-11e2-9716-080027bcf912</link>
13470 
                <value type="int" key="triggersExpanded">0</value>
13471 
                <value type="string" key="color">#99ccff</value>
13472 
                <value type="int" key="expanded">1</value>
13473 
                <value type="real" key="height">1.e+02</value>
13474 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13475 
                <value type="real" key="left">1.55e+02</value>
13476 
                <value type="int" key="locked">0</value>
13477 
                <value type="int" key="manualSizing">0</value>
13478 
                <value type="real" key="top">8.71e+02</value>
13479 
                <value type="real" key="width">1.39e+02</value>
13480 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13481 
                <value type="int" key="visible">1</value>
13482 
                <value type="string" key="name">party_list_entry</value>
13483 
              </value>
13021 13484 
            </value>
13022 13485 
            <value type="real" key="height">1.2865e+03</value>
13023 13486 
            <value _ptr_="0xb3406c8" type="list" content-type="object" content-struct-name="model.Layer" key="layers">
......
13126 13589 
                <link type="object">d1f23ed8-aca2-11e2-a207-080027bcf912</link>
13127 13590 
                <link type="object">5d420074-aca6-11e2-a207-080027bcf912</link>
13128 13591 
                <link type="object">b37c6080-acf9-11e2-bb78-080027bcf912</link>
13592 
                <link type="object">40021096-f678-11e2-9716-080027bcf912</link>
13593 
                <link type="object">9d6cbe7a-f678-11e2-9716-080027bcf912</link>
13129 13594 
              </value>
13130 13595 
              <value _ptr_="0xb379510" type="list" content-type="object" content-struct-name="model.Group" key="groups"/>
13131 13596 
              <value type="real" key="height">1.2865e+03</value>
......
13235 13700 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
13236 13701 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
13237 13702 
      <value type="string" key="caption">New Model</value>
13238 
      <value type="string" key="dateChanged">2013-07-26 21:44</value>
13703 
      <value type="string" key="dateChanged">2013-07-26 22:01</value>
13239 13704 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
13240 13705 
      <value type="string" key="description"></value>
13241 13706 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
393 393 
/*!40000 ALTER TABLE `party` ENABLE KEYS */;
394 394 

  		




  395
  395
  
    
--


  		




  
  396
  
    
-- Table structure for table `party_list`


  		




  
  397
  
    
--


  		




  
  398
  
    

  		




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


  		




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


  		




  
  401
  
    
CREATE TABLE `party_list` (


  		




  
  402
  
    
  `id` varbinary(767) NOT NULL,


  		




  
  403
  
    
  `count` int(11) NOT NULL,


  		




  
  404
  
    
  PRIMARY KEY (`id`),


  		




  
  405
  
    
  CONSTRAINT `fk_collection_source100` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




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


  		




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


  		




  
  408
  
    

  		




  
  409
  
    
--


  		




  
  410
  
    
-- Dumping data for table `party_list`


  		




  
  411
  
    
--


  		




  
  412
  
    

  		




  
  413
  
    
/*!40000 ALTER TABLE `party_list` DISABLE KEYS */;


  		




  
  414
  
    
/*!40000 ALTER TABLE `party_list` ENABLE KEYS */;


  		




  
  415
  
    

  		




  
  416
  
    
--


  		




  
  417
  
    
-- Table structure for table `party_list_entry`


  		




  
  418
  
    
--


  		




  
  419
  
    

  		




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


  		




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


  		




  
  422
  
    
CREATE TABLE `party_list_entry` (


  		




  
  423
  
    
  `id` varbinary(767) NOT NULL,


  		




  
  424
  
    
  `entry` varbinary(767) NOT NULL,


  		




  
  425
  
    
  `sort_order` int(11) DEFAULT NULL,


  		




  
  426
  
    
  PRIMARY KEY (`id`,`entry`),


  		




  
  427
  
    
  KEY `fk_party_list_has_party_party1_idx` (`entry`),


  		




  
  428
  
    
  KEY `fk_party_list_has_party_party_list1_idx` (`id`),


  		




  
  429
  
    
  CONSTRAINT `fk_party_list_has_party_party_list1` FOREIGN KEY (`id`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  430
  
    
  CONSTRAINT `fk_party_list_has_party_party1` FOREIGN KEY (`entry`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




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


  		




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


  		




  
  433
  
    

  		




  
  434
  
    
--


  		




  
  435
  
    
-- Dumping data for table `party_list_entry`


  		




  
  436
  
    
--


  		




  
  437
  
    

  		




  
  438
  
    
/*!40000 ALTER TABLE `party_list_entry` DISABLE KEYS */;


  		




  
  439
  
    
/*!40000 ALTER TABLE `party_list_entry` ENABLE KEYS */;


  		




  
  440
  
    

  		




  
  441
  
    
--


  		




  396
  442
  
    
-- Table structure for table `place`


  		




  397
  443
  
    
--


  		




  398
  444
  
    

  		












  

    
      schemas/VegCore/VegCore.pg.sql
    
  





  395
  395
  
    
/*!40000 ALTER TABLE "party" ENABLE KEYS */;


  		




  396
  396
  
    

  		




  397
  397
  
    
--


  		




  
  398
  
    
-- Table structure for table "party_list"


  		




  
  399
  
    
--


  		




  
  400
  
    

  		




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


  		




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


  		




  
  403
  
    
CREATE TABLE "party_list" (


  		




  
  404
  
    
  "id" text NOT NULL,


  		




  
  405
  
    
  "count" integer NOT NULL,


  		




  
  406
  
    
  PRIMARY KEY ("id"),


  		




  
  407
  
    
  /*CONSTRAINT "fk_collection_source100" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




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


  		




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


  		




  
  410
  
    

  		




  
  411
  
    
--


  		




  
  412
  
    
-- Dumping data for table "party_list"


  		




  
  413
  
    
--


  		




  
  414
  
    

  		




  
  415
  
    
/*!40000 ALTER TABLE "party_list" DISABLE KEYS */;


  		




  
  416
  
    
/*!40000 ALTER TABLE "party_list" ENABLE KEYS */;


  		




  
  417
  
    

  		




  
  418
  
    
--


  		




  
  419
  
    
-- Table structure for table "party_list_entry"


  		




  
  420
  
    
--


  		




  
  421
  
    

  		




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


  		




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


  		




  
  424
  
    
CREATE TABLE "party_list_entry" (


  		




  
  425
  
    
  "id" text NOT NULL,


  		




  
  426
  
    
  "entry" text NOT NULL,


  		




  
  427
  
    
  "sort_order" integer DEFAULT NULL,


  		




  
  428
  
    
  PRIMARY KEY ("id","entry"),


  		




  
  429
  
    
  /*KEY "fk_party_list_has_party_party1_idx" ("entry")*/CHECK (true),


  		




  
  430
  
    
  /*KEY "fk_party_list_has_party_party_list1_idx" ("id")*/CHECK (true),


  		




  
  431
  
    
  /*CONSTRAINT "fk_party_list_has_party_party_list1" FOREIGN KEY ("id") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  432
  
    
  /*CONSTRAINT "fk_party_list_has_party_party1" FOREIGN KEY ("entry") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




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


  		




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


  		




  
  435
  
    

  		




  
  436
  
    
--


  		




  
  437
  
    
-- Dumping data for table "party_list_entry"


  		




  
  438
  
    
--


  		




  
  439
  
    

  		




  
  440
  
    
/*!40000 ALTER TABLE "party_list_entry" DISABLE KEYS */;


  		




  
  441
  
    
/*!40000 ALTER TABLE "party_list_entry" ENABLE KEYS */;


  		




  
  442
  
    

  		




  
  443
  
    
--


  		




  398
  444
  
    
-- Table structure for table "place"


  		




  399
  445
  
    
--


  		




  400
  446
  
    

  		












Also available in:  Unified diff