Project

General

Profile

« Previous | Next » 

Revision 10967

Added by Aaron Marcuse-Kubitza over 11 years ago

bugfix: schemas/VegCore/VegCore.ERD.mwb: party_list_entry: use just a single id field as the primary key, because the pkey must be a single text string in order to uniquely identify the row by a global ID

View differences:

schemas/VegCore/VegCore.pg.sql
527 527 
/*!40101 SET character_set_client = utf8 */;
528 528 
CREATE TABLE "party_list_entry" (
529 529 
  "id" text NOT NULL,
530 
  "entry" text NOT NULL,
530 
  "list" text NOT NULL,
531 
  "party" text NOT NULL,
531 532 
  "role" text DEFAULT NULL,
532 533 
  "sort_order" integer DEFAULT NULL,
533 
  PRIMARY KEY ("id","entry"),
534 
  /*KEY "fk_party_list_has_party_party1_idx" ("entry")*/CHECK (true),
535 
  /*KEY "fk_party_list_has_party_party_list1_idx" ("id")*/CHECK (true),
536 
  /*CONSTRAINT "fk_party_list_has_party_party_list1" FOREIGN KEY ("id") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
537 
  /*CONSTRAINT "fk_party_list_has_party_party1" FOREIGN KEY ("entry") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
534 
  PRIMARY KEY ("id"),
535 
  /*KEY "fk_party_list_has_party_party1_idx" ("party")*/CHECK (true),
536 
  /*KEY "fk_party_list_entry_party_list1_idx" ("list")*/CHECK (true),
537 
  /*CONSTRAINT "fk_party_list_entry_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
538 
  /*CONSTRAINT "fk_party_list_entry_party_list1" FOREIGN KEY ("list") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
539 
  /*CONSTRAINT "fk_party_list_has_party_party1" FOREIGN KEY ("party") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
538 540 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
539 541 
/*!40101 SET character_set_client = @saved_cs_client */;
540 542 

  		












  

    
      schemas/VegCore/document.mwb.xml
    
  





  10269
  10269
  
    
                      <value type="string" key="oldName">id</value>


  		




  10270
  10270
  
    
                      <link type="object" struct-name="GrtObject" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link>


  		




  10271
  10271
  
    
                    </value>


  		




  
  10272
  
    
                    <value type="object" struct-name="db.mysql.Column" id="813d5bfe-1de9-11e3-b571-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




  
  10275
  
    
                      <value _ptr_="0xba6c4e0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>


  		




  
  10276
  
    
                      <value type="string" key="collationName"></value>


  		




  
  10277
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  
  10278
  
    
                      <value type="string" key="defaultValue"></value>


  		




  
  10279
  
    
                      <value type="int" key="defaultValueIsNull">0</value>


  		




  
  10280
  
    
                      <value _ptr_="0xbbe0d48" type="list" content-type="string" key="flags"/>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  10287
  
    
                      <value type="string" key="name">list</value>


  		




  
  10288
  
    
                      <value type="string" key="oldName">party_list_id</value>


  		




  
  10289
  
    
                      <link type="object" struct-name="GrtObject" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link>


  		




  
  10290
  
    
                    </value>


  		




  10272
  10291
  
    
                    <value type="object" struct-name="db.mysql.Column" id="9d6cb150-f678-11e2-9716-080027bcf912" struct-checksum="0x783b5183">


  		




  10273
  10292
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  10274
  10293
  
    
                      <value type="string" key="characterSetName"></value>


  		




  ......




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


  		




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


  		




  10286
  10305
  
    
                      <value type="string" key="comment"></value>


  		




  10287
  
  
    
                      <value type="string" key="name">entry</value>


  		




  
  10306
  
    
                      <value type="string" key="name">party</value>


  		




  10288
  10307
  
    
                      <value type="string" key="oldName">entry</value>


  		




  10289
  10308
  
    
                      <link type="object" struct-name="GrtObject" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link>


  		




  10290
  10309
  
    
                    </value>


  		




  ......




  10332
  10351
  
    
                  <value type="string" key="defaultCollationName">utf8_bin</value>


  		




  10333
  10352
  
    
                  <value type="int" key="delayKeyWrite">0</value>


  		




  10334
  10353
  
    
                  <value _ptr_="0xb02b9e0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">


  		




  10335
  
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="9d6ca408-f678-11e2-9716-080027bcf912" struct-checksum="0x70a8fc40">


  		




  10336
  
  
    
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>


  		




  10337
  
  
    
                      <value _ptr_="0xb02cad8" type="list" content-type="object" content-struct-name="db.Column" key="columns">


  		




  10338
  
  
    
                        <link type="object">9d6ca570-f678-11e2-9716-080027bcf912</link>


  		




  
  10354
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="9d6cb042-f678-11e2-9716-080027bcf912" struct-checksum="0x70a8fc40">


  		




  
  10355
  
    
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>


  		




  
  10356
  
    
                      <value _ptr_="0xb02ceb0" type="list" content-type="object" content-struct-name="db.Column" key="columns">


  		




  
  10357
  
    
                        <link type="object">9d6cb150-f678-11e2-9716-080027bcf912</link>


  		




  10339
  10358
  
    
                      </value>


  		




  10340
  10359
  
    
                      <value type="int" key="deferability">0</value>


  		




  10341
  10360
  
    
                      <value type="string" key="deleteRule">CASCADE</value>


  		




  10342
  
  
    
                      <link type="object" struct-name="db.Index" key="index">9d6cbbd2-f678-11e2-9716-080027bcf912</link>


  		




  
  10361
  
    
                      <link type="object" struct-name="db.Index" key="index">9d6cb812-f678-11e2-9716-080027bcf912</link>


  		




  10343
  10362
  
    
                      <value type="int" key="mandatory">1</value>


  		




  10344
  10363
  
    
                      <value type="int" key="many">1</value>


  		




  10345
  10364
  
    
                      <value type="int" key="modelOnly">0</value>


  		




  10346
  10365
  
    
                      <link type="object" struct-name="db.Table" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link>


  		




  10347
  
  
    
                      <value _ptr_="0xb02ce40" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">


  		




  10348
  
  
    
                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>


  		




  
  10366
  
    
                      <value _ptr_="0xb02d238" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">


  		




  
  10367
  
    
                        <link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>


  		




  10349
  10368
  
    
                      </value>


  		




  10350
  10369
  
    
                      <value type="int" key="referencedMandatory">1</value>


  		




  10351
  10370
  
    
                      <value type="string" key="updateRule">CASCADE</value>


  		




  10352
  10371
  
    
                      <value type="string" key="comment"></value>


  		




  10353
  
  
    
                      <value type="string" key="name">fk_party_list_has_party_party_list1</value>


  		




  10354
  
  
    
                      <value type="string" key="oldName">fk_party_list_has_party_party_list1</value>


  		




  
  10372
  
    
                      <value type="string" key="name">fk_party_list_has_party_party1</value>


  		




  
  10373
  
    
                      <value type="string" key="oldName">fk_party_list_has_party_party1</value>


  		




  10355
  10374
  
    
                    </value>


  		




  10356
  
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="9d6cb042-f678-11e2-9716-080027bcf912" struct-checksum="0x70a8fc40">


  		




  10357
  
  
    
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>


  		




  10358
  
  
    
                      <value _ptr_="0xb02ceb0" type="list" content-type="object" content-struct-name="db.Column" key="columns">


  		




  10359
  
  
    
                        <link type="object">9d6cb150-f678-11e2-9716-080027bcf912</link>


  		




  
  10375
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="813d59c4-1de9-11e3-b571-080027bcf912" struct-checksum="0x70a8fc40">


  		




  
  10376
  
    
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>


  		




  
  10377
  
    
                      <value _ptr_="0xc1cada8" type="list" content-type="object" content-struct-name="db.Column" key="columns">


  		




  
  10378
  
    
                        <link type="object">813d5bfe-1de9-11e3-b571-080027bcf912</link>


  		




  10360
  10379
  
    
                      </value>


  		




  10361
  10380
  
    
                      <value type="int" key="deferability">0</value>


  		




  10362
  10381
  
    
                      <value type="string" key="deleteRule">CASCADE</value>


  		




  10363
  
  
    
                      <link type="object" struct-name="db.Index" key="index">9d6cb812-f678-11e2-9716-080027bcf912</link>


  		




  
  10382
  
    
                      <link type="object" struct-name="db.Index" key="index">813e36c8-1de9-11e3-b571-080027bcf912</link>


  		




  10364
  10383
  
    
                      <value type="int" key="mandatory">1</value>


  		




  10365
  10384
  
    
                      <value type="int" key="many">1</value>


  		




  10366
  10385
  
    
                      <value type="int" key="modelOnly">0</value>


  		




  10367
  10386
  
    
                      <link type="object" struct-name="db.Table" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link>


  		




  10368
  
  
    
                      <value _ptr_="0xb02d238" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">


  		




  10369
  
  
    
                        <link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>


  		




  
  10387
  
    
                      <value _ptr_="0xc18bca8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">


  		




  
  10388
  
    
                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>


  		




  10370
  10389
  
    
                      </value>


  		




  10371
  10390
  
    
                      <value type="int" key="referencedMandatory">1</value>


  		




  10372
  10391
  
    
                      <value type="string" key="updateRule">CASCADE</value>


  		




  10373
  10392
  
    
                      <value type="string" key="comment"></value>


  		




  10374
  
  
    
                      <value type="string" key="name">fk_party_list_has_party_party1</value>


  		




  10375
  
  
    
                      <value type="string" key="oldName">fk_party_list_has_party_party1</value>


  		




  
  10393
  
    
                      <value type="string" key="name">fk_party_list_entry_party_list1</value>


  		




  
  10394
  
    
                      <value type="string" key="oldName">fk_party_list_entry_party_list1</value>


  		




  10376
  10395
  
    
                    </value>


  		




  
  10396
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="e95a1e48-1de9-11e3-b571-080027bcf912" struct-checksum="0x70a8fc40">


  		




  
  10397
  
    
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>


  		




  
  10398
  
    
                      <value _ptr_="0xa5c10a8" type="list" content-type="object" content-struct-name="db.Column" key="columns">


  		




  
  10399
  
    
                        <link type="object">9d6ca570-f678-11e2-9716-080027bcf912</link>


  		




  
  10400
  
    
                      </value>


  		




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


  		




  
  10402
  
    
                      <value type="string" key="deleteRule">CASCADE</value>


  		




  
  10403
  
    
                      <value type="int" key="mandatory">0</value>


  		




  
  10404
  
    
                      <value type="int" key="many">0</value>


  		




  
  10405
  
    
                      <value type="int" key="modelOnly">0</value>


  		




  
  10406
  
    
                      <link type="object" struct-name="db.Table" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link>


  		




  
  10407
  
    
                      <value _ptr_="0xbbeb368" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">


  		




  
  10408
  
    
                        <link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>


  		




  
  10409
  
    
                      </value>


  		




  
  10410
  
    
                      <value type="int" key="referencedMandatory">1</value>


  		




  
  10411
  
    
                      <value type="string" key="updateRule">CASCADE</value>


  		




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


  		




  
  10413
  
    
                      <value type="string" key="name">fk_party_list_entry_record1</value>


  		




  
  10414
  
    
                      <value type="string" key="oldName">fk_party_list_entry_record1</value>


  		




  
  10415
  
    
                    </value>


  		




  10377
  10416
  
    
                  </value>


  		




  10378
  10417
  
    
                  <value _ptr_="0xb02ba30" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">


  		




  10379
  10418
  
    
                    <value type="object" struct-name="db.mysql.Index" id="9d6ca7aa-f678-11e2-9716-080027bcf912" struct-checksum="0x309b847a">


  		




  ......




  10386
  10425
  
    
                          <value type="string" key="name"></value>


  		




  10387
  10426
  
    
                          <link type="object" struct-name="GrtObject" key="owner">9d6ca7aa-f678-11e2-9716-080027bcf912</link>


  		




  10388
  10427
  
    
                        </value>


  		




  10389
  
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="9d6cb3c6-f678-11e2-9716-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




  10393
  
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">9d6cb150-f678-11e2-9716-080027bcf912</link>


  		




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


  		




  10395
  
  
    
                          <link type="object" struct-name="GrtObject" key="owner">9d6ca7aa-f678-11e2-9716-080027bcf912</link>


  		




  10396
  
  
    
                        </value>


  		




  10397
  10428
  
    
                      </value>


  		




  10398
  10429
  
    
                      <value type="string" key="indexKind"></value>


  		




  10399
  10430
  
    
                      <value type="int" key="keyBlockSize">0</value>


  		




  ......




  10430
  10461
  
    
                      <value type="string" key="oldName">fk_party_list_has_party_party1_idx</value>


  		




  10431
  10462
  
    
                      <link type="object" struct-name="GrtObject" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link>


  		




  10432
  10463
  
    
                    </value>


  		




  10433
  
  
    
                    <value type="object" struct-name="db.mysql.Index" id="9d6cbbd2-f678-11e2-9716-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




  10435
  
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="9d6cbcae-f678-11e2-9716-080027bcf912" struct-checksum="0x62630b3c">


  		




  
  10464
  
    
                    <value type="object" struct-name="db.mysql.Index" id="813e36c8-1de9-11e3-b571-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




  
  10466
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="813e62ec-1de9-11e3-b571-080027bcf912" struct-checksum="0x62630b3c">


  		




  10436
  10467
  
    
                          <value type="int" key="columnLength">0</value>


  		




  10437
  10468
  
    
                          <value type="string" key="comment"></value>


  		




  10438
  10469
  
    
                          <value type="int" key="descend">0</value>


  		




  10439
  
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">9d6ca570-f678-11e2-9716-080027bcf912</link>


  		




  
  10470
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">813d5bfe-1de9-11e3-b571-080027bcf912</link>


  		




  10440
  10471
  
    
                          <value type="string" key="name"></value>


  		




  10441
  
  
    
                          <link type="object" struct-name="GrtObject" key="owner">9d6cbbd2-f678-11e2-9716-080027bcf912</link>


  		




  
  10472
  
    
                          <link type="object" struct-name="GrtObject" key="owner">813e36c8-1de9-11e3-b571-080027bcf912</link>


  		




  10442
  10473
  
    
                        </value>


  		




  10443
  10474
  
    
                      </value>


  		




  10444
  10475
  
    
                      <value type="string" key="indexKind"></value>


  		




  ......




  10448
  10479
  
    
                      <value type="int" key="deferability">0</value>


  		




  10449
  10480
  
    
                      <value type="string" key="indexType">INDEX</value>


  		




  10450
  10481
  
    
                      <value type="int" key="isPrimary">0</value>


  		




  10451
  
  
    
                      <value type="string" key="name">fk_party_list_has_party_party_list1_idx</value>


  		




  
  10482
  
    
                      <value type="string" key="name">fk_party_list_entry_party_list1_idx</value>


  		




  10452
  10483
  
    
                      <value type="int" key="unique">0</value>


  		




  10453
  
  
    
                      <value type="string" key="oldName">fk_party_list_has_party_party_list1_idx</value>


  		




  
  10484
  
    
                      <value type="string" key="oldName">fk_party_list_entry_party_list1</value>


  		




  10454
  10485
  
    
                      <link type="object" struct-name="GrtObject" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link>


  		




  10455
  10486
  
    
                    </value>


  		




  10456
  10487
  
    
                  </value>


  		




  ......




  10484
  10515
  
    
                  <value type="int" key="commentedOut">0</value>


  		




  10485
  10516
  
    
                  <value type="string" key="createDate"></value>


  		




  10486
  10517
  
    
                  <value _ptr_="0xb02b7b8" type="dict" key="customData"/>


  		




  10487
  
  
    
                  <value type="string" key="lastChangeDate">2013-09-15 02:23</value>


  		




  
  10518
  
    
                  <value type="string" key="lastChangeDate">2013-09-15 02:31</value>


  		




  10488
  10519
  
    
                  <value type="int" key="modelOnly">0</value>


  		




  10489
  10520
  
    
                  <value type="string" key="name">party_list_entry</value>


  		




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


  		




  ......




  14218
  14249
  
    
                <value type="int" key="visible">1</value>


  		




  14219
  14250
  
    
                <value type="string" key="name"></value>


  		




  14220
  14251
  
    
              </value>


  		




  14221
  
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="9d6d1ad2-f678-11e2-9716-080027bcf912" struct-checksum="0x9baebc92">


  		




  14222
  
  
    
                <value type="string" key="caption">fk_party_list_has_party_party_list1</value>


  		




  14223
  
  
    
                <value type="real" key="captionXOffs">0.e+00</value>


  		




  14224
  
  
    
                <value type="real" key="captionYOffs">0.e+00</value>


  		




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


  		




  14226
  
  
    
                <value type="real" key="endCaptionXOffs">0.e+00</value>


  		




  14227
  
  
    
                <value type="real" key="endCaptionYOffs">0.e+00</value>


  		




  14228
  
  
    
                <value type="string" key="extraCaption"></value>


  		




  14229
  
  
    
                <value type="real" key="extraCaptionXOffs">0.e+00</value>


  		




  14230
  
  
    
                <value type="real" key="extraCaptionYOffs">0.e+00</value>


  		




  14231
  
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">9d6ca408-f678-11e2-9716-080027bcf912</link>


  		




  14232
  
  
    
                <value type="real" key="middleSegmentOffset">0.e+00</value>


  		




  14233
  
  
    
                <value type="real" key="startCaptionXOffs">0.e+00</value>


  		




  14234
  
  
    
                <value type="real" key="startCaptionYOffs">0.e+00</value>


  		




  14235
  
  
    
                <value type="int" key="drawSplit">0</value>


  		




  14236
  
  
    
                <link type="object" struct-name="model.Figure" key="endFigure">40021096-f678-11e2-9716-080027bcf912</link>


  		




  14237
  
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">9d6cbe7a-f678-11e2-9716-080027bcf912</link>


  		




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


  		




  14239
  
  
    
                <value type="int" key="visible">1</value>


  		




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


  		




  14241
  
  
    
              </value>


  		




  14242
  14252
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="9d6d2270-f678-11e2-9716-080027bcf912" struct-checksum="0x9baebc92">


  		




  14243
  14253
  
    
                <value type="string" key="caption">fk_party_list_has_party_party1</value>


  		




  14244
  14254
  
    
                <value type="real" key="captionXOffs">0.e+00</value>


  		




  ......




  15520
  15530
  
    
                <value type="int" key="visible">1</value>


  		




  15521
  15531
  
    
                <value type="string" key="name"></value>


  		




  15522
  15532
  
    
              </value>


  		




  
  15533
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="813e8be6-1de9-11e3-b571-080027bcf912" struct-checksum="0x9baebc92">


  		




  
  15534
  
    
                <value type="string" key="caption">fk_party_list_entry_party_list1</value>


  		




  
  15535
  
    
                <value type="real" key="captionXOffs">0.e+00</value>


  		




  
  15536
  
    
                <value type="real" key="captionYOffs">0.e+00</value>


  		




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


  		




  
  15538
  
    
                <value type="real" key="endCaptionXOffs">0.e+00</value>


  		




  
  15539
  
    
                <value type="real" key="endCaptionYOffs">0.e+00</value>


  		




  
  15540
  
    
                <value type="string" key="extraCaption"></value>


  		




  
  15541
  
    
                <value type="real" key="extraCaptionXOffs">0.e+00</value>


  		




  
  15542
  
    
                <value type="real" key="extraCaptionYOffs">0.e+00</value>


  		




  
  15543
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">813d59c4-1de9-11e3-b571-080027bcf912</link>


  		




  
  15544
  
    
                <value type="real" key="middleSegmentOffset">0.e+00</value>


  		




  
  15545
  
    
                <value type="real" key="startCaptionXOffs">0.e+00</value>


  		




  
  15546
  
    
                <value type="real" key="startCaptionYOffs">0.e+00</value>


  		




  
  15547
  
    
                <value type="int" key="drawSplit">0</value>


  		




  
  15548
  
    
                <link type="object" struct-name="model.Figure" key="endFigure">40021096-f678-11e2-9716-080027bcf912</link>


  		




  
  15549
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">9d6cbe7a-f678-11e2-9716-080027bcf912</link>


  		




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


  		




  
  15551
  
    
                <value type="int" key="visible">1</value>


  		




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


  		




  
  15553
  
    
              </value>


  		




  
  15554
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="e95a3c98-1de9-11e3-b571-080027bcf912" struct-checksum="0x9baebc92">


  		




  
  15555
  
    
                <value type="string" key="caption">fk_party_list_entry_record1</value>


  		




  
  15556
  
    
                <value type="real" key="captionXOffs">0.e+00</value>


  		




  
  15557
  
    
                <value type="real" key="captionYOffs">0.e+00</value>


  		




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


  		




  
  15559
  
    
                <value type="real" key="endCaptionXOffs">0.e+00</value>


  		




  
  15560
  
    
                <value type="real" key="endCaptionYOffs">0.e+00</value>


  		




  
  15561
  
    
                <value type="string" key="extraCaption"></value>


  		




  
  15562
  
    
                <value type="real" key="extraCaptionXOffs">0.e+00</value>


  		




  
  15563
  
    
                <value type="real" key="extraCaptionYOffs">0.e+00</value>


  		




  
  15564
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">e95a1e48-1de9-11e3-b571-080027bcf912</link>


  		




  
  15565
  
    
                <value type="real" key="middleSegmentOffset">0.e+00</value>


  		




  
  15566
  
    
                <value type="real" key="startCaptionXOffs">0.e+00</value>


  		




  
  15567
  
    
                <value type="real" key="startCaptionYOffs">0.e+00</value>


  		




  
  15568
  
    
                <value type="int" key="drawSplit">1</value>


  		




  
  15569
  
    
                <link type="object" struct-name="model.Figure" key="endFigure">5600079C-23BA-4A27-BDB6-87D19B80AF56</link>


  		




  
  15570
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">9d6cbe7a-f678-11e2-9716-080027bcf912</link>


  		




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


  		




  
  15572
  
    
                <value type="int" key="visible">1</value>


  		




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


  		




  
  15574
  
    
              </value>


  		




  15523
  15575
  
    
            </value>


  		




  15524
  15576
  
    
            <value type="string" key="description"></value>


  		




  15525
  15577
  
    
            <value _ptr_="0xb052618" type="list" content-type="object" content-struct-name="model.Figure" key="figures">


  		




  ......




  15792
  15844
  
    
                <value type="real" key="left">2.02e+02</value>


  		




  15793
  15845
  
    
                <value type="int" key="locked">0</value>


  		




  15794
  15846
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15795
  
  
    
                <value type="real" key="top">1.126e+03</value>


  		




  
  15847
  
    
                <value type="real" key="top">1.144e+03</value>


  		




  15796
  15848
  
    
                <value type="real" key="width">1.58e+02</value>


  		




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


  		




  15798
  15850
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15812
  15864
  
    
                <value type="real" key="left">3.84e+02</value>


  		




  15813
  15865
  
    
                <value type="int" key="locked">0</value>


  		




  15814
  15866
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15815
  
  
    
                <value type="real" key="top">1.126e+03</value>


  		




  
  15867
  
    
                <value type="real" key="top">1.144e+03</value>


  		




  15816
  15868
  
    
                <value type="real" key="width">1.14e+02</value>


  		




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


  		




  15818
  15870
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  16112
  16164
  
    
                <value type="real" key="left">3.8e+01</value>


  		




  16113
  16165
  
    
                <value type="int" key="locked">0</value>


  		




  16114
  16166
  
    
                <value type="int" key="manualSizing">0</value>


  		




  16115
  
  
    
                <value type="real" key="top">9.92e+02</value>


  		




  
  16167
  
    
                <value type="real" key="top">9.97e+02</value>


  		




  16116
  16168
  
    
                <value type="real" key="width">8.1e+01</value>


  		




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


  		




  16118
  16170
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  16578
  16630
  
    
                <value type="real" key="left">3.4e+01</value>


  		




  16579
  16631
  
    
                <value type="int" key="locked">0</value>


  		




  16580
  16632
  
    
                <value type="int" key="manualSizing">0</value>


  		




  16581
  
  
    
                <value type="real" key="top">1.138e+03</value>


  		




  
  16633
  
    
                <value type="real" key="top">1.143e+03</value>


  		




  16582
  16634
  
    
                <value type="real" key="width">1.21e+02</value>


  		




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


  		




  16584
  16636
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  16715
  16767
  
    
                <value type="int" key="expanded">1</value>


  		




  16716
  16768
  
    
                <value type="real" key="height">7.7e+01</value>


  		




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


  		




  16718
  
  
    
                <value type="real" key="left">1.59e+02</value>


  		




  
  16770
  
    
                <value type="real" key="left">1.82e+02</value>


  		




  16719
  16771
  
    
                <value type="int" key="locked">0</value>


  		




  16720
  16772
  
    
                <value type="int" key="manualSizing">0</value>


  		




  16721
  
  
    
                <value type="real" key="top">8.81e+02</value>


  		




  
  16773
  
    
                <value type="real" key="top">8.75e+02</value>


  		




  16722
  16774
  
    
                <value type="real" key="width">1.03e+02</value>


  		




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


  		




  16724
  16776
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  16733
  16785
  
    
                <value type="int" key="triggersExpanded">0</value>


  		




  16734
  16786
  
    
                <value type="string" key="color">#ffcccc</value>


  		




  16735
  16787
  
    
                <value type="int" key="expanded">1</value>


  		




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


  		




  
  16788
  
    
                <value type="real" key="height">1.46e+02</value>


  		




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


  		




  16738
  16790
  
    
                <value type="real" key="left">1.41e+02</value>


  		




  16739
  16791
  
    
                <value type="int" key="locked">0</value>


  		




  16740
  16792
  
    
                <value type="int" key="manualSizing">0</value>


  		




  16741
  
  
    
                <value type="real" key="top">9.8e+02</value>


  		




  
  16793
  
    
                <value type="real" key="top">9.74e+02</value>


  		




  16742
  16794
  
    
                <value type="real" key="width">1.39e+02</value>


  		




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


  		




  16744
  16796
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  17254
  17306
  
    
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>


  		




  17255
  17307
  
    
        <value _ptr_="0xafa7770" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>


  		




  17256
  17308
  
    
        <value _ptr_="0xa484468" type="dict" key="syncProfiles">


  		




  17257
  
  
    
          <value type="object" struct-name="db.mgmt.SyncProfile" id="b0809972-1de8-11e3-b571-080027bcf912" struct-checksum="0xc64972c2" key="">


  		




  17258
  
  
    
            <value _ptr_="0xbb58d58" type="dict" key="lastKnownDBNames">


  		




  
  17309
  
    
          <value type="object" struct-name="db.mgmt.SyncProfile" id="d80c5912-1de9-11e3-b571-080027bcf912" struct-checksum="0xc64972c2" key="">


  		




  
  17310
  
    
            <value _ptr_="0xc1be680" type="dict" key="lastKnownDBNames">


  		




  17259
  17311
  
    
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>


  		




  17260
  17312
  
    
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>


  		




  17261
  17313
  
    
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>


  		




  ......




  17503
  17555
  
    
              <value type="string" key="803980c8-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_string1</value>


  		




  17504
  17556
  
    
              <value type="string" key="8039828a-f6d1-11e2-a35e-080027bcf912">input_string</value>


  		




  17505
  17557
  
    
              <value type="string" key="80399806-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_string1_idx</value>


  		




  
  17558
  
    
              <value type="string" key="813d59c4-1de9-11e3-b571-080027bcf912">fk_party_list_entry_party_list1</value>


  		




  
  17559
  
    
              <value type="string" key="813d5bfe-1de9-11e3-b571-080027bcf912">list</value>


  		




  
  17560
  
    
              <value type="string" key="813e36c8-1de9-11e3-b571-080027bcf912">fk_party_list_entry_party_list1_idx</value>


  		




  17506
  17561
  
    
              <value type="string" key="81937b1c-ad12-11e2-b309-080027bcf912">fk_collection_source1_idx</value>


  		




  17507
  17562
  
    
              <value type="string" key="83dbd4da-f6e8-11e2-9cf1-080027bcf912">georeferencing</value>


  		




  17508
  17563
  
    
              <value type="string" key="83dbd8ae-f6e8-11e2-9cf1-080027bcf912">id</value>


  		




  ......




  17527
  17582
  
    
              <value type="string" key="9b006114-f6d2-11e2-a35e-080027bcf912">fk_taxon_scrub_record1</value>


  		




  17528
  17583
  
    
              <value type="string" key="9b6b7d6a-ad0c-11e2-b309-080027bcf912">fk_parsed_taxon_assertion_taxon_name1_idx</value>


  		




  17529
  17584
  
    
              <value type="string" key="9d6c9e9a-f678-11e2-9716-080027bcf912">party_list_entry</value>


  		




  17530
  
  
    
              <value type="string" key="9d6ca408-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party_list1</value>


  		




  17531
  17585
  
    
              <value type="string" key="9d6ca570-f678-11e2-9716-080027bcf912">id</value>


  		




  17532
  17586
  
    
              <value type="string" key="9d6ca7aa-f678-11e2-9716-080027bcf912">PRIMARY</value>


  		




  17533
  17587
  
    
              <value type="string" key="9d6cb042-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party1</value>


  		




  17534
  
  
    
              <value type="string" key="9d6cb150-f678-11e2-9716-080027bcf912">entry</value>


  		




  
  17588
  
    
              <value type="string" key="9d6cb150-f678-11e2-9716-080027bcf912">party</value>


  		




  17535
  17589
  
    
              <value type="string" key="9d6cb812-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party1_idx</value>


  		




  17536
  
  
    
              <value type="string" key="9d6cbbd2-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party_list1_idx</value>


  		




  17537
  17590
  
    
              <value type="string" key="9f4bd98c-a6fb-11e2-9461-080027bcf912">plot</value>


  		




  17538
  17591
  
    
              <value type="string" key="9f4bdd10-a6fb-11e2-9461-080027bcf912">id</value>


  		




  17539
  17592
  
    
              <value type="string" key="9f4be008-a6fb-11e2-9461-080027bcf912">fk_subplot_place1</value>


  		




  ......




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


  		




  17878
  17931
  
    
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>


  		




  17879
  17932
  
    
      <value type="string" key="caption">New Model</value>


  		




  17880
  
  
    
      <value type="string" key="dateChanged">2013-09-15 02:25</value>


  		




  
  17933
  
    
      <value type="string" key="dateChanged">2013-09-15 02:34</value>


  		




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


  		




  17882
  17935
  
    
      <value type="string" key="description"></value>


  		




  17883
  17936
  
    
      <value type="string" key="project">Name of the project</value>


  		












  

    
      schemas/VegCore/VegCore.my.sql
    
  





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


  		




  526
  526
  
    
CREATE TABLE `party_list_entry` (


  		




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


  		




  528
  
  
    
  `entry` varbinary(767) NOT NULL,


  		




  
  528
  
    
  `list` varbinary(767) NOT NULL,


  		




  
  529
  
    
  `party` varbinary(767) NOT NULL,


  		




  529
  530
  
    
  `role` varbinary(767) DEFAULT NULL,


  		




  530
  531
  
    
  `sort_order` int(11) DEFAULT NULL,


  		




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


  		




  532
  
  
    
  KEY `fk_party_list_has_party_party1_idx` (`entry`),


  		




  533
  
  
    
  KEY `fk_party_list_has_party_party_list1_idx` (`id`),


  		




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


  		




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


  		




  
  532
  
    
  PRIMARY KEY (`id`),


  		




  
  533
  
    
  KEY `fk_party_list_has_party_party1_idx` (`party`),


  		




  
  534
  
    
  KEY `fk_party_list_entry_party_list1_idx` (`list`),


  		




  
  535
  
    
  CONSTRAINT `fk_party_list_entry_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  536
  
    
  CONSTRAINT `fk_party_list_entry_party_list1` FOREIGN KEY (`list`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




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


  		




  536
  538
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


  		




  537
  539
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  538
  540
  
    

  		












Also available in:  Unified diff