788 |
788 |
<value type="string" key="oldName">id</value>
|
789 |
789 |
<link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
|
790 |
790 |
</value>
|
|
791 |
<value type="object" struct-name="db.mysql.Column" id="ed1eb468-ad0e-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
|
|
792 |
<value type="int" key="autoIncrement">0</value>
|
|
793 |
<value type="string" key="characterSetName"></value>
|
|
794 |
<value _ptr_="0xbd77d10" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
795 |
<value type="string" key="collationName"></value>
|
|
796 |
<value type="string" key="datatypeExplicitParams"></value>
|
|
797 |
<value type="string" key="defaultValue"></value>
|
|
798 |
<value type="int" key="defaultValueIsNull">0</value>
|
|
799 |
<value _ptr_="0xbd77d98" type="list" content-type="string" key="flags"/>
|
|
800 |
<value type="int" key="isNotNull">1</value>
|
|
801 |
<value type="int" key="length">767</value>
|
|
802 |
<value type="int" key="precision">-1</value>
|
|
803 |
<value type="int" key="scale">-1</value>
|
|
804 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
|
805 |
<value type="string" key="comment"></value>
|
|
806 |
<value type="string" key="name">institution</value>
|
|
807 |
<value type="string" key="oldName">organization_id</value>
|
|
808 |
<link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
|
|
809 |
</value>
|
|
810 |
<value type="object" struct-name="db.mysql.Column" id="45a3f404-ad0f-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
|
|
811 |
<value type="int" key="autoIncrement">0</value>
|
|
812 |
<value type="string" key="characterSetName"></value>
|
|
813 |
<value _ptr_="0xc230190" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
814 |
<value type="string" key="collationName"></value>
|
|
815 |
<value type="string" key="datatypeExplicitParams"></value>
|
|
816 |
<value type="string" key="defaultValue"></value>
|
|
817 |
<value type="int" key="defaultValueIsNull">0</value>
|
|
818 |
<value _ptr_="0xbcafc60" type="list" content-type="string" key="flags"/>
|
|
819 |
<value type="int" key="isNotNull">1</value>
|
|
820 |
<value type="int" key="length">767</value>
|
|
821 |
<value type="int" key="precision">-1</value>
|
|
822 |
<value type="int" key="scale">-1</value>
|
|
823 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
|
824 |
<value type="string" key="comment"></value>
|
|
825 |
<value type="string" key="name">name</value>
|
|
826 |
<value type="string" key="oldName"></value>
|
|
827 |
<link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
|
|
828 |
</value>
|
791 |
829 |
</value>
|
792 |
830 |
<value type="string" key="connectionString"></value>
|
793 |
831 |
<value type="string" key="defaultCharacterSetName">utf8</value>
|
... | ... | |
815 |
853 |
<value type="string" key="name">fk_collection_source1</value>
|
816 |
854 |
<value type="string" key="oldName">fk_collection_source1</value>
|
817 |
855 |
</value>
|
|
856 |
<value type="object" struct-name="db.mysql.ForeignKey" id="ed1eb2a6-ad0e-11e2-b309-080027bcf912" struct-checksum="0x70a8fc40">
|
|
857 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">049df920-a91b-11e2-bdec-080027bcf912</link>
|
|
858 |
<value _ptr_="0xbf39440" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
859 |
<link type="object">ed1eb468-ad0e-11e2-b309-080027bcf912</link>
|
|
860 |
</value>
|
|
861 |
<value type="int" key="deferability">0</value>
|
|
862 |
<value type="string" key="deleteRule">CASCADE</value>
|
|
863 |
<link type="object" struct-name="db.Index" key="index">ed1ec98a-ad0e-11e2-b309-080027bcf912</link>
|
|
864 |
<value type="int" key="mandatory">1</value>
|
|
865 |
<value type="int" key="many">1</value>
|
|
866 |
<value type="int" key="modelOnly">0</value>
|
|
867 |
<link type="object" struct-name="db.Table" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
|
|
868 |
<value _ptr_="0xbe6a288" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
869 |
<link type="object">049dfc5e-a91b-11e2-bdec-080027bcf912</link>
|
|
870 |
</value>
|
|
871 |
<value type="int" key="referencedMandatory">1</value>
|
|
872 |
<value type="string" key="updateRule">CASCADE</value>
|
|
873 |
<value type="string" key="comment"></value>
|
|
874 |
<value type="string" key="name">fk_collection_organization1</value>
|
|
875 |
<value type="string" key="oldName">fk_collection_organization1</value>
|
|
876 |
</value>
|
818 |
877 |
</value>
|
819 |
878 |
<value _ptr_="0xa70f460" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
820 |
879 |
<value type="object" struct-name="db.mysql.Index" id="be8dfdd6-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
|
... | ... | |
840 |
899 |
<value type="string" key="oldName">PRIMARY</value>
|
841 |
900 |
<link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
|
842 |
901 |
</value>
|
|
902 |
<value type="object" struct-name="db.mysql.Index" id="ed1ec98a-ad0e-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
|
|
903 |
<value _ptr_="0xb20a1b0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
904 |
<value type="object" struct-name="db.mysql.IndexColumn" id="ed1ecb1a-ad0e-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
|
|
905 |
<value type="int" key="columnLength">0</value>
|
|
906 |
<value type="string" key="comment"></value>
|
|
907 |
<value type="int" key="descend">0</value>
|
|
908 |
<link type="object" struct-name="db.Column" key="referencedColumn">ed1eb468-ad0e-11e2-b309-080027bcf912</link>
|
|
909 |
<value type="string" key="name"></value>
|
|
910 |
<link type="object" struct-name="GrtObject" key="owner">ed1ec98a-ad0e-11e2-b309-080027bcf912</link>
|
|
911 |
</value>
|
|
912 |
</value>
|
|
913 |
<value type="string" key="indexKind"></value>
|
|
914 |
<value type="int" key="keyBlockSize">0</value>
|
|
915 |
<value type="string" key="withParser"></value>
|
|
916 |
<value type="string" key="comment"></value>
|
|
917 |
<value type="int" key="deferability">0</value>
|
|
918 |
<value type="string" key="indexType">INDEX</value>
|
|
919 |
<value type="int" key="isPrimary">0</value>
|
|
920 |
<value type="string" key="name">fk_collection_organization1_idx</value>
|
|
921 |
<value type="int" key="unique">0</value>
|
|
922 |
<value type="string" key="oldName">fk_collection_organization1</value>
|
|
923 |
<link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
|
|
924 |
</value>
|
|
925 |
<value type="object" struct-name="db.mysql.Index" id="6b54505e-ad0f-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
|
|
926 |
<value _ptr_="0xbec0eb8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
927 |
<value type="object" struct-name="db.mysql.IndexColumn" id="6dd2beb0-ad0f-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
|
|
928 |
<value type="int" key="columnLength">0</value>
|
|
929 |
<value type="string" key="comment"></value>
|
|
930 |
<value type="int" key="descend">0</value>
|
|
931 |
<link type="object" struct-name="db.Column" key="referencedColumn">ed1eb468-ad0e-11e2-b309-080027bcf912</link>
|
|
932 |
<value type="string" key="name"></value>
|
|
933 |
<link type="object" struct-name="GrtObject" key="owner">6b54505e-ad0f-11e2-b309-080027bcf912</link>
|
|
934 |
</value>
|
|
935 |
<value type="object" struct-name="db.mysql.IndexColumn" id="6e294b90-ad0f-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
|
|
936 |
<value type="int" key="columnLength">0</value>
|
|
937 |
<value type="string" key="comment"></value>
|
|
938 |
<value type="int" key="descend">0</value>
|
|
939 |
<link type="object" struct-name="db.Column" key="referencedColumn">45a3f404-ad0f-11e2-b309-080027bcf912</link>
|
|
940 |
<value type="string" key="name"></value>
|
|
941 |
<link type="object" struct-name="GrtObject" key="owner">6b54505e-ad0f-11e2-b309-080027bcf912</link>
|
|
942 |
</value>
|
|
943 |
</value>
|
|
944 |
<value type="string" key="indexKind"></value>
|
|
945 |
<value type="int" key="keyBlockSize">0</value>
|
|
946 |
<value type="string" key="withParser"></value>
|
|
947 |
<value type="string" key="comment"></value>
|
|
948 |
<value type="int" key="deferability">0</value>
|
|
949 |
<value type="string" key="indexType">UNIQUE</value>
|
|
950 |
<value type="int" key="isPrimary">0</value>
|
|
951 |
<value type="string" key="name">collection_unique</value>
|
|
952 |
<value type="int" key="unique">1</value>
|
|
953 |
<value type="string" key="oldName"></value>
|
|
954 |
<link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
|
|
955 |
</value>
|
843 |
956 |
</value>
|
844 |
957 |
<value type="string" key="maxRows"></value>
|
845 |
958 |
<value type="string" key="mergeInsert"></value>
|
... | ... | |
871 |
984 |
<value type="int" key="commentedOut">0</value>
|
872 |
985 |
<value type="string" key="createDate">2013-04-16 14:58</value>
|
873 |
986 |
<value _ptr_="0xa2107d0" type="dict" key="customData"/>
|
874 |
|
<value type="string" key="lastChangeDate">2013-04-19 09:16</value>
|
|
987 |
<value type="string" key="lastChangeDate">2013-04-24 11:47</value>
|
875 |
988 |
<value type="int" key="modelOnly">0</value>
|
876 |
989 |
<value type="string" key="name">collection</value>
|
877 |
990 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
|
... | ... | |
1712 |
1825 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
1713 |
1826 |
<value type="string" key="comment"></value>
|
1714 |
1827 |
<value type="string" key="name">matched_taxon_concept</value>
|
1715 |
|
<value type="string" key="oldName">matched_taxon</value>
|
|
1828 |
<value type="string" key="oldName">matched_taxon_concept</value>
|
1716 |
1829 |
<link type="object" struct-name="GrtObject" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link>
|
1717 |
1830 |
</value>
|
1718 |
1831 |
<value type="object" struct-name="db.mysql.Column" id="4c32a89c-a76a-11e2-92a3-080027bcf912" struct-checksum="0x783b5183">
|
... | ... | |
1846 |
1959 |
<value type="int" key="isPrimary">0</value>
|
1847 |
1960 |
<value type="string" key="name">fk_parsed_taxon_assertion_taxon_name1_idx</value>
|
1848 |
1961 |
<value type="int" key="unique">0</value>
|
1849 |
|
<value type="string" key="oldName">fk_parsed_taxon_assertion_taxon_name1</value>
|
|
1962 |
<value type="string" key="oldName">fk_parsed_taxon_assertion_taxon_name1_idx</value>
|
1850 |
1963 |
<link type="object" struct-name="GrtObject" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link>
|
1851 |
1964 |
</value>
|
1852 |
1965 |
</value>
|
... | ... | |
1927 |
2040 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
1928 |
2041 |
<value type="string" key="comment"></value>
|
1929 |
2042 |
<value type="string" key="name">taxon_concept</value>
|
1930 |
|
<value type="string" key="oldName">taxon</value>
|
|
2043 |
<value type="string" key="oldName">taxon_concept</value>
|
1931 |
2044 |
<link type="object" struct-name="GrtObject" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>
|
1932 |
2045 |
</value>
|
1933 |
2046 |
</value>
|
... | ... | |
2104 |
2217 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
2105 |
2218 |
<value type="string" key="comment"></value>
|
2106 |
2219 |
<value type="string" key="name">taxon_concept</value>
|
2107 |
|
<value type="string" key="oldName">taxon</value>
|
|
2220 |
<value type="string" key="oldName">taxon_concept</value>
|
2108 |
2221 |
<link type="object" struct-name="GrtObject" key="owner">be8ea786-a6e0-11e2-95e9-080027bcf912</link>
|
2109 |
2222 |
</value>
|
2110 |
2223 |
</value>
|
... | ... | |
2318 |
2431 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
2319 |
2432 |
<value type="string" key="comment"></value>
|
2320 |
2433 |
<value type="string" key="name">accepted_taxon_concept</value>
|
2321 |
|
<value type="string" key="oldName">accepted_taxon</value>
|
|
2434 |
<value type="string" key="oldName">accepted_taxon_concept</value>
|
2322 |
2435 |
<link type="object" struct-name="GrtObject" key="owner">1832712c-a77d-11e2-afd5-080027bcf912</link>
|
2323 |
2436 |
</value>
|
2324 |
2437 |
</value>
|
... | ... | |
11553 |
11666 |
<value type="int" key="visible">1</value>
|
11554 |
11667 |
<value type="string" key="name"></value>
|
11555 |
11668 |
</value>
|
|
11669 |
<value type="object" struct-name="workbench.physical.Connection" id="ed1ed15a-ad0e-11e2-b309-080027bcf912" struct-checksum="0x9baebc92">
|
|
11670 |
<value type="string" key="caption">fk_collection_organization1</value>
|
|
11671 |
<value type="real" key="captionXOffs">0.e+00</value>
|
|
11672 |
<value type="real" key="captionYOffs">0.e+00</value>
|
|
11673 |
<value type="string" key="comment"></value>
|
|
11674 |
<value type="real" key="endCaptionXOffs">0.e+00</value>
|
|
11675 |
<value type="real" key="endCaptionYOffs">0.e+00</value>
|
|
11676 |
<value type="string" key="extraCaption"></value>
|
|
11677 |
<value type="real" key="extraCaptionXOffs">0.e+00</value>
|
|
11678 |
<value type="real" key="extraCaptionYOffs">0.e+00</value>
|
|
11679 |
<link type="object" struct-name="db.ForeignKey" key="foreignKey">ed1eb2a6-ad0e-11e2-b309-080027bcf912</link>
|
|
11680 |
<value type="real" key="middleSegmentOffset">0.e+00</value>
|
|
11681 |
<value type="real" key="startCaptionXOffs">0.e+00</value>
|
|
11682 |
<value type="real" key="startCaptionYOffs">0.e+00</value>
|
|
11683 |
<value type="int" key="drawSplit">1</value>
|
|
11684 |
<link type="object" struct-name="model.Figure" key="endFigure">049e0d16-a91b-11e2-bdec-080027bcf912</link>
|
|
11685 |
<link type="object" struct-name="model.Figure" key="startFigure">CC059D8C-291E-4748-A685-7668D0CFA36C</link>
|
|
11686 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
|
|
11687 |
<value type="int" key="visible">1</value>
|
|
11688 |
<value type="string" key="name"></value>
|
|
11689 |
</value>
|
11556 |
11690 |
</value>
|
11557 |
11691 |
<value type="string" key="description"></value>
|
11558 |
11692 |
<value _ptr_="0xa781890" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
|
... | ... | |
12100 |
12234 |
<value type="int" key="triggersExpanded">0</value>
|
12101 |
12235 |
<value type="string" key="color">#CCCC33</value>
|
12102 |
12236 |
<value type="int" key="expanded">1</value>
|
12103 |
|
<value type="real" key="height">5.4e+01</value>
|
|
12237 |
<value type="real" key="height">1.e+02</value>
|
12104 |
12238 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
|
12105 |
12239 |
<value type="real" key="left">1.277e+03</value>
|
12106 |
12240 |
<value type="int" key="locked">0</value>
|
12107 |
12241 |
<value type="int" key="manualSizing">0</value>
|
12108 |
|
<value type="real" key="top">6.35e+02</value>
|
|
12242 |
<value type="real" key="top">5.9e+02</value>
|
12109 |
12243 |
<value type="real" key="width">1.06e+02</value>
|
12110 |
12244 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
|
12111 |
12245 |
<value type="int" key="visible">1</value>
|
... | ... | |
12899 |
13033 |
<value type="int" key="visible">1</value>
|
12900 |
13034 |
<value type="string" key="name"></value>
|
12901 |
13035 |
</value>
|
12902 |
|
<value _ptr_="0xa781968" type="list" content-type="object" content-struct-name="model.Object" key="selection">
|
12903 |
|
<link type="object">71dceeac-a780-11e2-afd5-080027bcf912</link>
|
12904 |
|
<link type="object">71daccd0-a780-11e2-afd5-080027bcf912</link>
|
12905 |
|
</value>
|
|
13036 |
<value _ptr_="0xa781968" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
|
12906 |
13037 |
<value type="int" key="updateBlocked">0</value>
|
12907 |
13038 |
<value type="real" key="width">1.6215e+03</value>
|
12908 |
13039 |
<value type="real" key="x">0.e+00</value>
|
... | ... | |
12997 |
13128 |
<value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
|
12998 |
13129 |
<value type="string" key="author">Aaron Marcuse-Kubitza</value>
|
12999 |
13130 |
<value type="string" key="caption">New Model</value>
|
13000 |
|
<value type="string" key="dateChanged">2013-04-24 11:34</value>
|
|
13131 |
<value type="string" key="dateChanged">2013-04-24 11:48</value>
|
13001 |
13132 |
<value type="string" key="dateCreated">2012-01-19 14:06</value>
|
13002 |
13133 |
<value type="string" key="description"></value>
|
13003 |
13134 |
<value type="string" key="project">Name of the project</value>
|
schemas/VegCore/VegCore.ERD.mwb: collection: added institution, name to identify and scope the collection