Project

General

Profile

« Previous | Next » 

Revision 10978

Added by Aaron Marcuse-Kubitza about 11 years ago

schemas/VegCore/VegCore.ERD.mwb: party: added required name field

View differences:

schemas/VegCore/VegCore.pg.sql
514 514 
/*!40101 SET character_set_client = utf8 */;
515 515 
CREATE TABLE "party" (
516 516 
  "id" text NOT NULL,
517 
  "name" text NOT NULL,
517 518 
  "organization" text DEFAULT NULL,
518 519 
  "info" hstore DEFAULT NULL,
519 520 
  PRIMARY KEY ("id"),
520 521 
  /*KEY "fk_party_organization1_idx" ("organization")*/CHECK (true),
521 
  /*CONSTRAINT "fk_party_organization1" FOREIGN KEY ("organization") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
522 
  /*CONSTRAINT "fk_collection_source10" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
522 
  /*KEY "party_unique" ("organization","name")*/CHECK (true),
523 
  /*CONSTRAINT "fk_collection_source10" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
524 
  /*CONSTRAINT "fk_party_organization1" FOREIGN KEY ("organization") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
523 525 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
524 526 
/*!40101 SET character_set_client = @saved_cs_client */;
525 527 

  		












  

    
      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="8222d06e-1e00-11e3-9d67-080027bcf912" struct-checksum="0x783b5183">


  		




  
  49
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  
  50
  
    
                      <value type="string" key="characterSetName"></value>


  		




  
  51
  
    
                      <value _ptr_="0xc67df28" 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_="0xc5a4ca8" type="list" content-type="string" key="flags"/>


  		




  
  57
  
    
                      <value type="int" key="isNotNull">1</value>


  		




  
  58
  
    
                      <value type="int" key="length">767</value>


  		




  
  59
  
    
                      <value type="int" key="precision">-1</value>


  		




  
  60
  
    
                      <value type="int" key="scale">-1</value>


  		




  
  61
  
    
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>


  		




  
  62
  
    
                      <value type="string" key="comment"></value>


  		




  
  63
  
    
                      <value type="string" key="name">name</value>


  		




  
  64
  
    
                      <value type="string" key="oldName"></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="e5502346-f676-11e2-9716-080027bcf912" struct-checksum="0x783b5183">


  		




  49
  68
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  50
  69
  
    
                      <value type="string" key="characterSetName"></value>


  		




  ......




  179
  198
  
    
                      <value type="string" key="oldName">fk_party_organization1_idx</value>


  		




  180
  199
  
    
                      <link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>


  		




  181
  200
  
    
                    </value>


  		




  
  201
  
    
                    <value type="object" struct-name="db.mysql.Index" id="96b8693a-1e00-11e3-9d67-080027bcf912" struct-checksum="0x309b847a">


  		




  
  202
  
    
                      <value _ptr_="0xc71fc48" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">


  		




  
  203
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="9d7d0032-1e00-11e3-9d67-080027bcf912" struct-checksum="0x62630b3c">


  		




  
  204
  
    
                          <value type="int" key="columnLength">0</value>


  		




  
  205
  
    
                          <value type="string" key="comment"></value>


  		




  
  206
  
    
                          <value type="int" key="descend">0</value>


  		




  
  207
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">e5502346-f676-11e2-9716-080027bcf912</link>


  		




  
  208
  
    
                          <value type="string" key="name"></value>


  		




  
  209
  
    
                          <link type="object" struct-name="GrtObject" key="owner">96b8693a-1e00-11e3-9d67-080027bcf912</link>


  		




  
  210
  
    
                        </value>


  		




  
  211
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="9dff86e2-1e00-11e3-9d67-080027bcf912" struct-checksum="0x62630b3c">


  		




  
  212
  
    
                          <value type="int" key="columnLength">0</value>


  		




  
  213
  
    
                          <value type="string" key="comment"></value>


  		




  
  214
  
    
                          <value type="int" key="descend">0</value>


  		




  
  215
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">8222d06e-1e00-11e3-9d67-080027bcf912</link>


  		




  
  216
  
    
                          <value type="string" key="name"></value>


  		




  
  217
  
    
                          <link type="object" struct-name="GrtObject" key="owner">96b8693a-1e00-11e3-9d67-080027bcf912</link>


  		




  
  218
  
    
                        </value>


  		




  
  219
  
    
                      </value>


  		




  
  220
  
    
                      <value type="string" key="indexKind"></value>


  		




  
  221
  
    
                      <value type="int" key="keyBlockSize">0</value>


  		




  
  222
  
    
                      <value type="string" key="withParser"></value>


  		




  
  223
  
    
                      <value type="string" key="comment"></value>


  		




  
  224
  
    
                      <value type="int" key="deferability">0</value>


  		




  
  225
  
    
                      <value type="string" key="indexType">INDEX</value>


  		




  
  226
  
    
                      <value type="int" key="isPrimary">0</value>


  		




  
  227
  
    
                      <value type="string" key="name">party_unique</value>


  		




  
  228
  
    
                      <value type="int" key="unique">0</value>


  		




  
  229
  
    
                      <value type="string" key="oldName"></value>


  		




  
  230
  
    
                      <link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>


  		




  
  231
  
    
                    </value>


  		




  182
  232
  
    
                  </value>


  		




  183
  233
  
    
                  <value type="string" key="maxRows"></value>


  		




  184
  234
  
    
                  <value type="string" key="mergeInsert"></value>


  		




  ......




  210
  260
  
    
                  <value type="int" key="commentedOut">0</value>


  		




  211
  261
  
    
                  <value type="string" key="createDate">2013-04-16 14:58</value>


  		




  212
  262
  
    
                  <value _ptr_="0xaa5b090" type="dict" key="customData"/>


  		




  213
  
  
    
                  <value type="string" key="lastChangeDate">2013-07-26 21:43</value>


  		




  
  263
  
    
                  <value type="string" key="lastChangeDate">2013-09-15 05:16</value>


  		




  214
  264
  
    
                  <value type="int" key="modelOnly">0</value>


  		




  215
  265
  
    
                  <value type="string" key="name">party</value>


  		




  216
  266
  
    
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>


  		




  ......




  16295
  16345
  
    
                <value type="int" key="triggersExpanded">0</value>


  		




  16296
  16346
  
    
                <value type="string" key="color">#ffcccc</value>


  		




  16297
  16347
  
    
                <value type="int" key="expanded">1</value>


  		




  16298
  
  
    
                <value type="real" key="height">1.e+02</value>


  		




  
  16348
  
    
                <value type="real" key="height">1.23e+02</value>


  		




  16299
  16349
  
    
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>


  		




  16300
  16350
  
    
                <value type="real" key="left">3.9e+01</value>


  		




  16301
  16351
  
    
                <value type="int" key="locked">0</value>


  		




  16302
  16352
  
    
                <value type="int" key="manualSizing">0</value>


  		




  16303
  
  
    
                <value type="real" key="top">9.45e+02</value>


  		




  
  16353
  
    
                <value type="real" key="top">9.33e+02</value>


  		




  16304
  16354
  
    
                <value type="real" key="width">8.1e+01</value>


  		




  16305
  16355
  
    
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>


  		




  16306
  16356
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  16766
  16816
  
    
                <value type="real" key="left">3.5e+01</value>


  		




  16767
  16817
  
    
                <value type="int" key="locked">0</value>


  		




  16768
  16818
  
    
                <value type="int" key="manualSizing">0</value>


  		




  16769
  
  
    
                <value type="real" key="top">1.091e+03</value>


  		




  
  16819
  
    
                <value type="real" key="top">1.098e+03</value>


  		




  16770
  16820
  
    
                <value type="real" key="width">1.21e+02</value>


  		




  16771
  16821
  
    
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>


  		




  16772
  16822
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  17470
  17520
  
    
              <value type="int" key="visible">1</value>


  		




  17471
  17521
  
    
              <value type="string" key="name"></value>


  		




  17472
  17522
  
    
            </value>


  		




  17473
  
  
    
            <value _ptr_="0xb52ce88" type="list" content-type="object" content-struct-name="model.Object" key="selection">


  		




  17474
  
  
    
              <link type="object">049e0d16-a91b-11e2-bdec-080027bcf912</link>


  		




  17475
  
  
    
            </value>


  		




  
  17523
  
    
            <value _ptr_="0xb52ce88" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>


  		




  17476
  17524
  
    
            <value type="int" key="updateBlocked">0</value>


  		




  17477
  17525
  
    
            <value type="real" key="width">1.6215e+03</value>


  		




  17478
  17526
  
    
            <value type="real" key="x">0.e+00</value>


  		




  ......




  18114
  18162
  
    
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">


  		




  18115
  18163
  
    
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>


  		




  18116
  18164
  
    
      <value type="string" key="caption">New Model</value>


  		




  18117
  
  
    
      <value type="string" key="dateChanged">2013-09-15 05:12</value>


  		




  
  18165
  
    
      <value type="string" key="dateChanged">2013-09-15 05:16</value>


  		




  18118
  18166
  
    
      <value type="string" key="dateCreated">2012-01-19 14:06</value>


  		




  18119
  18167
  
    
      <value type="string" key="description"></value>


  		




  18120
  18168
  
    
      <value type="string" key="project">Name of the project</value>


  		












  

    
      schemas/VegCore/VegCore.my.sql
    
  





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


  		




  513
  513
  
    
CREATE TABLE `party` (


  		




  514
  514
  
    
  `id` varbinary(767) NOT NULL,


  		




  
  515
  
    
  `name` varbinary(767) NOT NULL,


  		




  515
  516
  
    
  `organization` varbinary(767) DEFAULT NULL,


  		




  516
  517
  
    
  `info` set('hstore') COLLATE utf8_bin DEFAULT NULL,


  		




  517
  518
  
    
  PRIMARY KEY (`id`),


  		




  518
  519
  
    
  KEY `fk_party_organization1_idx` (`organization`),


  		




  519
  
  
    
  CONSTRAINT `fk_party_organization1` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  520
  
  
    
  CONSTRAINT `fk_collection_source10` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  520
  
    
  KEY `party_unique` (`organization`,`name`),


  		




  
  521
  
    
  CONSTRAINT `fk_collection_source10` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  522
  
    
  CONSTRAINT `fk_party_organization1` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  521
  523
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


  		




  522
  524
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  523
  525
  
    

  		












Also available in:  Unified diff