Project

General

Profile

« Previous | Next » 

Revision 10498

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: tables with parent hierarchies: made parent optional, since the root(s) of the hierarchy will not have an entry for this, and any unique constraints that include this column should be ignored (which they will be if the value is NULL instead of a self-pointer)

View differences:

schemas/VegCore/document.mwb.xml
507 507 
                      <value type="string" key="collationName"></value>
508 508 
                      <value type="string" key="datatypeExplicitParams"></value>
509 509 
                      <value type="string" key="defaultValue"></value>
510 
                      <value type="int" key="defaultValueIsNull">0</value>
510 
                      <value type="int" key="defaultValueIsNull">1</value>
511 511 
                      <value _ptr_="0xab8d428" type="list" content-type="string" key="flags"/>
512 
                      <value type="int" key="isNotNull">1</value>
512 
                      <value type="int" key="isNotNull">0</value>
513 513 
                      <value type="int" key="length">767</value>
514 514 
                      <value type="int" key="precision">-1</value>
515 515 
                      <value type="int" key="scale">-1</value>
......
616 616 
                      <value _ptr_="0xab8ea70" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
617 617 
                        <link type="object">be8cc362-a6e0-11e2-95e9-080027bcf912</link>
618 618 
                      </value>
619 
                      <value type="int" key="referencedMandatory">1</value>
619 
                      <value type="int" key="referencedMandatory">0</value>
620 620 
                      <value type="string" key="updateRule">CASCADE</value>
621 621 
                      <value type="string" key="comment"></value>
622 622 
                      <value type="string" key="name">fk_source1</value>
......
689 689 
                      <value type="string" key="oldName">PRIMARY</value>
690 690 
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
691 691 
                    </value>
692 
                    <value type="object" struct-name="db.mysql.Index" id="11c10cc8-a90c-11e2-8576-080027bcf912" struct-checksum="0x309b847a">
693 
                      <value _ptr_="0xab90168" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
694 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="151fbf2c-a90c-11e2-8576-080027bcf912" struct-checksum="0x62630b3c">
695 
                          <value type="int" key="columnLength">0</value>
696 
                          <value type="string" key="comment"></value>
697 
                          <value type="int" key="descend">0</value>
698 
                          <link type="object" struct-name="db.Column" key="referencedColumn">be8cc59c-a6e0-11e2-95e9-080027bcf912</link>
699 
                          <value type="string" key="name"></value>
700 
                          <link type="object" struct-name="GrtObject" key="owner">11c10cc8-a90c-11e2-8576-080027bcf912</link>
701 
                        </value>
702 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="156de03a-a90c-11e2-8576-080027bcf912" struct-checksum="0x62630b3c">
703 
                          <value type="int" key="columnLength">0</value>
704 
                          <value type="string" key="comment"></value>
705 
                          <value type="int" key="descend">0</value>
706 
                          <link type="object" struct-name="db.Column" key="referencedColumn">d9b5781e-a90b-11e2-8576-080027bcf912</link>
707 
                          <value type="string" key="name"></value>
708 
                          <link type="object" struct-name="GrtObject" key="owner">11c10cc8-a90c-11e2-8576-080027bcf912</link>
709 
                        </value>
710 
                      </value>
711 
                      <value type="string" key="indexKind"></value>
712 
                      <value type="int" key="keyBlockSize">0</value>
713 
                      <value type="string" key="withParser"></value>
714 
                      <value type="string" key="comment"></value>
715 
                      <value type="int" key="deferability">0</value>
716 
                      <value type="string" key="indexType">UNIQUE</value>
717 
                      <value type="int" key="isPrimary">0</value>
718 
                      <value type="string" key="name">source_unique</value>
719 
                      <value type="int" key="unique">1</value>
720 
                      <value type="string" key="oldName">source_unique</value>
721 
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
722 
                    </value>
692 723 
                    <value type="object" struct-name="db.mysql.Index" id="be8ccb14-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
693 724 
                      <value _ptr_="0xab8f508" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
694 725 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="be8cccfe-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c">
......
735 766 
                      <value type="string" key="oldName">fk_source_party1_idx</value>
736 767 
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
737 768 
                    </value>
738 
                    <value type="object" struct-name="db.mysql.Index" id="11c10cc8-a90c-11e2-8576-080027bcf912" struct-checksum="0x309b847a">
739 
                      <value _ptr_="0xab90168" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
740 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="151fbf2c-a90c-11e2-8576-080027bcf912" struct-checksum="0x62630b3c">
741 
                          <value type="int" key="columnLength">0</value>
742 
                          <value type="string" key="comment"></value>
743 
                          <value type="int" key="descend">0</value>
744 
                          <link type="object" struct-name="db.Column" key="referencedColumn">be8cc59c-a6e0-11e2-95e9-080027bcf912</link>
745 
                          <value type="string" key="name"></value>
746 
                          <link type="object" struct-name="GrtObject" key="owner">11c10cc8-a90c-11e2-8576-080027bcf912</link>
747 
                        </value>
748 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="156de03a-a90c-11e2-8576-080027bcf912" struct-checksum="0x62630b3c">
749 
                          <value type="int" key="columnLength">0</value>
750 
                          <value type="string" key="comment"></value>
751 
                          <value type="int" key="descend">0</value>
752 
                          <link type="object" struct-name="db.Column" key="referencedColumn">d9b5781e-a90b-11e2-8576-080027bcf912</link>
753 
                          <value type="string" key="name"></value>
754 
                          <link type="object" struct-name="GrtObject" key="owner">11c10cc8-a90c-11e2-8576-080027bcf912</link>
755 
                        </value>
756 
                      </value>
757 
                      <value type="string" key="indexKind"></value>
758 
                      <value type="int" key="keyBlockSize">0</value>
759 
                      <value type="string" key="withParser"></value>
760 
                      <value type="string" key="comment"></value>
761 
                      <value type="int" key="deferability">0</value>
762 
                      <value type="string" key="indexType">UNIQUE</value>
763 
                      <value type="int" key="isPrimary">0</value>
764 
                      <value type="string" key="name">source_unique</value>
765 
                      <value type="int" key="unique">1</value>
766 
                      <value type="string" key="oldName">source_unique</value>
767 
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
768 
                    </value>
769 769 
                    <value type="object" struct-name="db.mysql.Index" id="c7c2089c-a91b-11e2-bdec-080027bcf912" struct-checksum="0x309b847a">
770 770 
                      <value _ptr_="0xab90798" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
771 771 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="c7c20a4a-a91b-11e2-bdec-080027bcf912" struct-checksum="0x62630b3c">
......
820 820 
                  <value type="int" key="commentedOut">0</value>
821 821 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
822 822 
                  <value _ptr_="0xa228d58" type="dict" key="customData"/>
823 
                  <value type="string" key="lastChangeDate">2013-04-24 14:43</value>
823 
                  <value type="string" key="lastChangeDate">2013-07-30 18:38</value>
824 824 
                  <value type="int" key="modelOnly">0</value>
825 825 
                  <value type="string" key="name">source</value>
826 826 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
2581 2581 
                      <value type="string" key="collationName"></value>
2582 2582 
                      <value type="string" key="datatypeExplicitParams"></value>
2583 2583 
                      <value type="string" key="defaultValue"></value>
2584 
                      <value type="int" key="defaultValueIsNull">0</value>
2584 
                      <value type="int" key="defaultValueIsNull">1</value>
2585 2585 
                      <value _ptr_="0xab9bf70" type="list" content-type="string" key="flags"/>
2586 
                      <value type="int" key="isNotNull">1</value>
2586 
                      <value type="int" key="isNotNull">0</value>
2587 2587 
                      <value type="int" key="length">767</value>
2588 2588 
                      <value type="int" key="precision">-1</value>
2589 2589 
                      <value type="int" key="scale">-1</value>
......
2633 2633 
                      <value _ptr_="0xab9c920" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
2634 2634 
                        <link type="object">18327370-a77d-11e2-afd5-080027bcf912</link>
2635 2635 
                      </value>
2636 
                      <value type="int" key="referencedMandatory">1</value>
2636 
                      <value type="int" key="referencedMandatory">0</value>
2637 2637 
                      <value type="string" key="updateRule">CASCADE</value>
2638 2638 
                      <value type="string" key="comment"></value>
2639 2639 
                      <value type="string" key="name">fk_taxon_taxon1</value>
......
2727 2727 
                      <value type="string" key="oldName">PRIMARY</value>
2728 2728 
                      <link type="object" struct-name="GrtObject" key="owner">1832712c-a77d-11e2-afd5-080027bcf912</link>
2729 2729 
                    </value>
2730 
                    <value type="object" struct-name="db.mysql.Index" id="18328522-a77d-11e2-afd5-080027bcf912" struct-checksum="0x309b847a">
2731 
                      <value _ptr_="0xab9ee18" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
2732 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="183286d0-a77d-11e2-afd5-080027bcf912" struct-checksum="0x62630b3c">
2733 
                          <value type="int" key="columnLength">0</value>
2734 
                          <value type="string" key="comment"></value>
2735 
                          <value type="int" key="descend">0</value>
2736 
                          <link type="object" struct-name="db.Column" key="referencedColumn">18327514-a77d-11e2-afd5-080027bcf912</link>
2737 
                          <value type="string" key="name"></value>
2738 
                          <link type="object" struct-name="GrtObject" key="owner">18328522-a77d-11e2-afd5-080027bcf912</link>
2739 
                        </value>
2740 
                      </value>
2741 
                      <value type="string" key="indexKind"></value>
2742 
                      <value type="int" key="keyBlockSize">0</value>
2743 
                      <value type="string" key="withParser"></value>
2744 
                      <value type="string" key="comment"></value>
2745 
                      <value type="int" key="deferability">0</value>
2746 
                      <value type="string" key="indexType">UNIQUE</value>
2747 
                      <value type="int" key="isPrimary">0</value>
2748 
                      <value type="string" key="name">taxon_concept_unique_name</value>
2749 
                      <value type="int" key="unique">1</value>
2750 
                      <value type="string" key="oldName">taxon_concept_unique_name</value>
2751 
                      <link type="object" struct-name="GrtObject" key="owner">1832712c-a77d-11e2-afd5-080027bcf912</link>
2752 
                    </value>
2730 2753 
                    <value type="object" struct-name="db.mysql.Index" id="18327c76-a77d-11e2-afd5-080027bcf912" struct-checksum="0x309b847a">
2731 2754 
                      <value _ptr_="0xab9d978" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
2732 2755 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="18327e2e-a77d-11e2-afd5-080027bcf912" struct-checksum="0x62630b3c">
......
2796 2819 
                      <value type="string" key="oldName">fk_taxon_concept_taxon_concept1_idx</value>
2797 2820 
                      <link type="object" struct-name="GrtObject" key="owner">1832712c-a77d-11e2-afd5-080027bcf912</link>
2798 2821 
                    </value>
2799 
                    <value type="object" struct-name="db.mysql.Index" id="18328522-a77d-11e2-afd5-080027bcf912" struct-checksum="0x309b847a">
2800 
                      <value _ptr_="0xab9ee18" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
2801 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="183286d0-a77d-11e2-afd5-080027bcf912" struct-checksum="0x62630b3c">
2802 
                          <value type="int" key="columnLength">0</value>
2803 
                          <value type="string" key="comment"></value>
2804 
                          <value type="int" key="descend">0</value>
2805 
                          <link type="object" struct-name="db.Column" key="referencedColumn">18327514-a77d-11e2-afd5-080027bcf912</link>
2806 
                          <value type="string" key="name"></value>
2807 
                          <link type="object" struct-name="GrtObject" key="owner">18328522-a77d-11e2-afd5-080027bcf912</link>
2808 
                        </value>
2809 
                      </value>
2810 
                      <value type="string" key="indexKind"></value>
2811 
                      <value type="int" key="keyBlockSize">0</value>
2812 
                      <value type="string" key="withParser"></value>
2813 
                      <value type="string" key="comment"></value>
2814 
                      <value type="int" key="deferability">0</value>
2815 
                      <value type="string" key="indexType">UNIQUE</value>
2816 
                      <value type="int" key="isPrimary">0</value>
2817 
                      <value type="string" key="name">taxon_concept_unique_name</value>
2818 
                      <value type="int" key="unique">1</value>
2819 
                      <value type="string" key="oldName">taxon_concept_unique_name</value>
2820 
                      <link type="object" struct-name="GrtObject" key="owner">1832712c-a77d-11e2-afd5-080027bcf912</link>
2821 
                    </value>
2822 2822 
                  </value>
2823 2823 
                  <value type="string" key="maxRows"></value>
2824 2824 
                  <value type="string" key="mergeInsert"></value>
......
2850 2850 
                  <value type="int" key="commentedOut">0</value>
2851 2851 
                  <value type="string" key="createDate">2013-04-17 09:37</value>
2852 2852 
                  <value _ptr_="0xab9adc8" type="dict" key="customData"/>
2853 
                  <value type="string" key="lastChangeDate">2013-04-24 14:32</value>
2853 
                  <value type="string" key="lastChangeDate">2013-07-30 18:38</value>
2854 2854 
                  <value type="int" key="modelOnly">0</value>
2855 2855 
                  <value type="string" key="name">taxon_concept</value>
2856 2856 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
4572 4572 
                      <value type="string" key="collationName"></value>
4573 4573 
                      <value type="string" key="datatypeExplicitParams"></value>
4574 4574 
                      <value type="string" key="defaultValue"></value>
4575 
                      <value type="int" key="defaultValueIsNull">0</value>
4575 
                      <value type="int" key="defaultValueIsNull">1</value>
4576 4576 
                      <value _ptr_="0xabb9628" type="list" content-type="string" key="flags"/>
4577 
                      <value type="int" key="isNotNull">1</value>
4577 
                      <value type="int" key="isNotNull">0</value>
4578 4578 
                      <value type="int" key="length">767</value>
4579 4579 
                      <value type="int" key="precision">-1</value>
4580 4580 
                      <value type="int" key="scale">-1</value>
......
4702 4702 
                      <value _ptr_="0xabbb240" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
4703 4703 
                        <link type="object">c67276b0-a7a0-11e2-b667-080027bcf912</link>
4704 4704 
                      </value>
4705 
                      <value type="int" key="referencedMandatory">1</value>
4705 
                      <value type="int" key="referencedMandatory">0</value>
4706 4706 
                      <value type="string" key="updateRule">CASCADE</value>
4707 4707 
                      <value type="string" key="comment"></value>
4708 4708 
                      <value type="string" key="name">fk_event1</value>
......
4875 4875 
                  <value type="int" key="commentedOut">0</value>
4876 4876 
                  <value type="string" key="createDate">2013-04-17 13:52</value>
4877 4877 
                  <value _ptr_="0xabb8950" type="dict" key="customData"/>
4878 
                  <value type="string" key="lastChangeDate">2013-07-26 22:14</value>
4878 
                  <value type="string" key="lastChangeDate">2013-07-30 18:38</value>
4879 4879 
                  <value type="int" key="modelOnly">0</value>
4880 4880 
                  <value type="string" key="name">event</value>
4881 4881 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
14099 14099 
              <value type="int" key="visible">1</value>
14100 14100 
              <value type="string" key="name"></value>
14101 14101 
            </value>
14102 
            <value _ptr_="0xac125c8" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
14102 
            <value _ptr_="0xac125c8" type="list" content-type="object" content-struct-name="model.Object" key="selection">
14103 
              <link type="object">8932D751-419A-4213-960A-F4E3E44763CD</link>
14104 
            </value>
14103 14105 
            <value type="int" key="updateBlocked">0</value>
14104 14106 
            <value type="real" key="width">1.6215e+03</value>
14105 14107 
            <value type="real" key="x">0.e+00</value>
......
14112 14114 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
14113 14115 
        <value _ptr_="0xab85450" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
14114 14116 
        <value _ptr_="0xa229c20" type="dict" key="syncProfiles">
14115 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="707e8ab8-f981-11e2-8a2e-080027bcf912" struct-checksum="0xc64972c2" key="">
14116 
            <value _ptr_="0xc1f9880" type="dict" key="lastKnownDBNames">
14117 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="1daf169e-f982-11e2-8a2e-080027bcf912" struct-checksum="0xc64972c2" key="">
14118 
            <value _ptr_="0xc071f60" type="dict" key="lastKnownDBNames">
14117 14119 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
14118 14120 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
14119 14121 
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
14635 14637 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
14636 14638 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
14637 14639 
      <value type="string" key="caption">New Model</value>
14638 
      <value type="string" key="dateChanged">2013-07-30 18:36</value>
14640 
      <value type="string" key="dateChanged">2013-07-30 18:40</value>
14639 14641 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
14640 14642 
      <value type="string" key="description"></value>
14641 14643 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
134 134 
/*!40101 SET character_set_client = utf8 */;
135 135 
CREATE TABLE `event` (
136 136 
  `id` varbinary(767) NOT NULL,
137 
  `parent` varbinary(767) NOT NULL,
137 
  `parent` varbinary(767) DEFAULT NULL,
138 138 
  `name` varbinary(767) DEFAULT NULL,
139 139 
  `date_range` varbinary(767) DEFAULT NULL,
140 140 
  `place` varbinary(767) DEFAULT NULL,
......
755 755 
/*!40101 SET character_set_client = utf8 */;
756 756 
CREATE TABLE `source` (
757 757 
  `id` varbinary(767) NOT NULL,
758 
  `parent` varbinary(767) NOT NULL,
758 
  `parent` varbinary(767) DEFAULT NULL,
759 759 
  `name` varbinary(767) NOT NULL,
760 760 
  `first_publisher` varbinary(767) DEFAULT NULL,
761 761 
  `owner` varbinary(767) DEFAULT NULL,
......
978 978 
CREATE TABLE `taxon_concept` (
979 979 
  `id` varbinary(767) NOT NULL,
980 980 
  `according_to` varbinary(767) NOT NULL,
981 
  `parent` varbinary(767) NOT NULL,
981 
  `parent` varbinary(767) DEFAULT NULL,
982 982 
  `accepted_taxon_concept` varbinary(767) DEFAULT NULL,
983 983 
  PRIMARY KEY (`id`),
984 984 
  UNIQUE KEY `taxon_concept_unique_name` (`according_to`),
schemas/VegCore/VegCore.pg.sql
136 136 
/*!40101 SET character_set_client = utf8 */;
137 137 
CREATE TABLE "event" (
138 138 
  "id" text NOT NULL,
139 
  "parent" text NOT NULL,
139 
  "parent" text DEFAULT NULL,
140 140 
  "name" text DEFAULT NULL,
141 141 
  "date_range" text DEFAULT NULL,
142 142 
  "place" text DEFAULT NULL,
......
757 757 
/*!40101 SET character_set_client = utf8 */;
758 758 
CREATE TABLE "source" (
759 759 
  "id" text NOT NULL,
760 
  "parent" text NOT NULL,
760 
  "parent" text DEFAULT NULL,
761 761 
  "name" text NOT NULL,
762 762 
  "first_publisher" text DEFAULT NULL,
763 763 
  "owner" text DEFAULT NULL,
......
980 980 
CREATE TABLE "taxon_concept" (
981 981 
  "id" text NOT NULL,
982 982 
  "according_to" text NOT NULL,
983 
  "parent" text NOT NULL,
983 
  "parent" text DEFAULT NULL,
984 984 
  "accepted_taxon_concept" text DEFAULT NULL,
985 985 
  PRIMARY KEY ("id"),
986 986 
  /*CONSTRAINT "taxon_concept_unique_name" */UNIQUE ("according_to"),

Also available in: Unified diff