Project

General

Profile

« Previous | Next » 

Revision 10452

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: party: added optional fkey to organization

View differences:

schemas/VegCore/document.mwb.xml
45 45 
                      <value type="string" key="oldName">id</value>
46 46 
                      <link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
47 47 
                    </value>
48 
                    <value type="object" struct-name="db.mysql.Column" id="e5502346-f676-11e2-9716-080027bcf912" struct-checksum="0x783b5183">
49 
                      <value type="int" key="autoIncrement">0</value>
50 
                      <value type="string" key="characterSetName"></value>
51 
                      <value _ptr_="0xbecf758" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
52 
                      <value type="string" key="collationName"></value>
53 
                      <value type="string" key="datatypeExplicitParams"></value>
54 
                      <value type="string" key="defaultValue"></value>
55 
                      <value type="int" key="defaultValueIsNull">0</value>
56 
                      <value _ptr_="0xbe4ed90" type="list" content-type="string" key="flags"/>
57 
                      <value type="int" key="isNotNull">0</value>
58 
                      <value type="int" key="length">767</value>
59 
                      <value type="int" key="precision">-1</value>
60 
                      <value type="int" key="scale">-1</value>
61 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
62 
                      <value type="string" key="comment"></value>
63 
                      <value type="string" key="name">organization</value>
64 
                      <value type="string" key="oldName">organization_id</value>
65 
                      <link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
66 
                    </value>
48 67 
                    <value type="object" struct-name="db.mysql.Column" id="c8868c00-a793-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">
49 68 
                      <value type="int" key="autoIncrement">0</value>
50 69 
                      <value type="string" key="characterSetName"></value>
......
91 110 
                      <value type="string" key="name">fk_collection_source10</value>
92 111 
                      <value type="string" key="oldName">fk_collection_source10</value>
93 112 
                    </value>
113 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="e550209e-f676-11e2-9716-080027bcf912" struct-checksum="0x70a8fc40">
114 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">049df920-a91b-11e2-bdec-080027bcf912</link>
115 
                      <value _ptr_="0xc164140" type="list" content-type="object" content-struct-name="db.Column" key="columns">
116 
                        <link type="object">e5502346-f676-11e2-9716-080027bcf912</link>
117 
                      </value>
118 
                      <value type="int" key="deferability">0</value>
119 
                      <value type="string" key="deleteRule">CASCADE</value>
120 
                      <link type="object" struct-name="db.Index" key="index">e550389a-f676-11e2-9716-080027bcf912</link>
121 
                      <value type="int" key="mandatory">1</value>
122 
                      <value type="int" key="many">1</value>
123 
                      <value type="int" key="modelOnly">0</value>
124 
                      <link type="object" struct-name="db.Table" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
125 
                      <value _ptr_="0xbe854d8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
126 
                        <link type="object">049dfc5e-a91b-11e2-bdec-080027bcf912</link>
127 
                      </value>
128 
                      <value type="int" key="referencedMandatory">0</value>
129 
                      <value type="string" key="updateRule">CASCADE</value>
130 
                      <value type="string" key="comment"></value>
131 
                      <value type="string" key="name">fk_party_organization1</value>
132 
                      <value type="string" key="oldName">fk_party_organization1</value>
133 
                    </value>
94 134 
                  </value>
95 135 
                  <value _ptr_="0xb2bedd0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
96 136 
                    <value type="object" struct-name="db.mysql.Index" id="be8feb50-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
......
116 156 
                      <value type="string" key="oldName">PRIMARY</value>
117 157 
                      <link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
118 158 
                    </value>
159 
                    <value type="object" struct-name="db.mysql.Index" id="e550389a-f676-11e2-9716-080027bcf912" struct-checksum="0x309b847a">
160 
                      <value _ptr_="0xc09c838" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
161 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="e5503a2a-f676-11e2-9716-080027bcf912" struct-checksum="0x62630b3c">
162 
                          <value type="int" key="columnLength">0</value>
163 
                          <value type="string" key="comment"></value>
164 
                          <value type="int" key="descend">0</value>
165 
                          <link type="object" struct-name="db.Column" key="referencedColumn">e5502346-f676-11e2-9716-080027bcf912</link>
166 
                          <value type="string" key="name"></value>
167 
                          <link type="object" struct-name="GrtObject" key="owner">e550389a-f676-11e2-9716-080027bcf912</link>
168 
                        </value>
169 
                      </value>
170 
                      <value type="string" key="indexKind"></value>
171 
                      <value type="int" key="keyBlockSize">0</value>
172 
                      <value type="string" key="withParser"></value>
173 
                      <value type="string" key="comment"></value>
174 
                      <value type="int" key="deferability">0</value>
175 
                      <value type="string" key="indexType">INDEX</value>
176 
                      <value type="int" key="isPrimary">0</value>
177 
                      <value type="string" key="name">fk_party_organization1_idx</value>
178 
                      <value type="int" key="unique">0</value>
179 
                      <value type="string" key="oldName">fk_party_organization1</value>
180 
                      <link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
181 
                    </value>
119 182 
                  </value>
120 183 
                  <value type="string" key="maxRows"></value>
121 184 
                  <value type="string" key="mergeInsert"></value>
......
147 210 
                  <value type="int" key="commentedOut">0</value>
148 211 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
149 212 
                  <value _ptr_="0xab48690" type="dict" key="customData"/>
150 
                  <value type="string" key="lastChangeDate">2013-04-23 11:36</value>
213 
                  <value type="string" key="lastChangeDate">2013-07-26 21:43</value>
151 214 
                  <value type="int" key="modelOnly">0</value>
152 215 
                  <value type="string" key="name">party</value>
153 216 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
8685 8748 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.set</link>
8686 8749 
                      <value type="string" key="comment"></value>
8687 8750 
                      <value type="string" key="name">lat_long_in_place_ranks</value>
8688 
                      <value type="string" key="oldName">lat_long_in_ranks</value>
8751 
                      <value type="string" key="oldName">lat_long_in_place_ranks</value>
8689 8752 
                      <link type="object" struct-name="GrtObject" key="owner">245083fa-a763-11e2-aa10-080027bcf912</link>
8690 8753 
                    </value>
8691 8754 
                  </value>
......
11710 11773 
                <value type="int" key="visible">1</value>
11711 11774 
                <value type="string" key="name"></value>
11712 11775 
              </value>
11776 
              <value type="object" struct-name="workbench.physical.Connection" id="e550409c-f676-11e2-9716-080027bcf912" struct-checksum="0x9baebc92">
11777 
                <value type="string" key="caption">fk_party_organization1</value>
11778 
                <value type="real" key="captionXOffs">0.e+00</value>
11779 
                <value type="real" key="captionYOffs">0.e+00</value>
11780 
                <value type="string" key="comment"></value>
11781 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
11782 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
11783 
                <value type="string" key="extraCaption"></value>
11784 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11785 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11786 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">e550209e-f676-11e2-9716-080027bcf912</link>
11787 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11788 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11789 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11790 
                <value type="int" key="drawSplit">0</value>
11791 
                <link type="object" struct-name="model.Figure" key="endFigure">049e0d16-a91b-11e2-bdec-080027bcf912</link>
11792 
                <link type="object" struct-name="model.Figure" key="startFigure">EE4765B7-0391-4132-8813-84A6E788C01D</link>
11793 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11794 
                <value type="int" key="visible">1</value>
11795 
                <value type="string" key="name"></value>
11796 
              </value>
11713 11797 
            </value>
11714 11798 
            <value type="string" key="description"></value>
11715 11799 
            <value _ptr_="0xb340678" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
12297 12381 
                <value type="int" key="triggersExpanded">0</value>
12298 12382 
                <value type="string" key="color">#99ccff</value>
12299 12383 
                <value type="int" key="expanded">1</value>
12300 
                <value type="real" key="height">7.7e+01</value>
12384 
                <value type="real" key="height">1.e+02</value>
12301 12385 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12302 
                <value type="real" key="left">3.9e+01</value>
12386 
                <value type="real" key="left">3.8e+01</value>
12303 12387 
                <value type="int" key="locked">0</value>
12304 12388 
                <value type="int" key="manualSizing">0</value>
12305 12389 
                <value type="real" key="top">8.15e+02</value>
12306 
                <value type="real" key="width">7.9e+01</value>
12390 
                <value type="real" key="width">8.1e+01</value>
12307 12391 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12308 12392 
                <value type="int" key="visible">1</value>
12309 12393 
                <value type="string" key="name">party</value>
......
12765 12849 
                <value type="int" key="expanded">1</value>
12766 12850 
                <value type="real" key="height">7.7e+01</value>
12767 12851 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12768 
                <value type="real" key="left">1.8e+01</value>
12852 
                <value type="real" key="left">2.4e+01</value>
12769 12853 
                <value type="int" key="locked">0</value>
12770 12854 
                <value type="int" key="manualSizing">0</value>
12771 
                <value type="real" key="top">9.33e+02</value>
12855 
                <value type="real" key="top">9.49e+02</value>
12772 12856 
                <value type="real" key="width">1.21e+02</value>
12773 12857 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12774 12858 
                <value type="int" key="visible">1</value>
......
13151 13235 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
13152 13236 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
13153 13237 
      <value type="string" key="caption">New Model</value>
13154 
      <value type="string" key="dateChanged">2013-07-26 21:28</value>
13238 
      <value type="string" key="dateChanged">2013-07-26 21:44</value>
13155 13239 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
13156 13240 
      <value type="string" key="description"></value>
13157 13241 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
376 376 
/*!40101 SET character_set_client = utf8 */;
377 377 
CREATE TABLE `party` (
378 378 
  `id` varbinary(767) NOT NULL,
379 
  `organization` varbinary(767) DEFAULT NULL,
379 380 
  `info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
380 381 
  PRIMARY KEY (`id`),
381 
  CONSTRAINT `fk_collection_source10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
382 
  KEY `fk_party_organization1_idx` (`organization`),
383 
  CONSTRAINT `fk_collection_source10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
384 
  CONSTRAINT `fk_party_organization1` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
382 385 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
383 386 
/*!40101 SET character_set_client = @saved_cs_client */;
384 387 

  		












  

    
      schemas/VegCore/VegCore.pg.sql
    
  





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


  		




  379
  379
  
    
CREATE TABLE "party" (


  		




  380
  380
  
    
  "id" text NOT NULL,


  		




  
  381
  
    
  "organization" text DEFAULT NULL,


  		




  381
  382
  
    
  "info" hstore DEFAULT NULL,


  		




  382
  383
  
    
  PRIMARY KEY ("id"),


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  385
  388
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  386
  389
  
    

  		












Also available in:  Unified diff