Project

General

Profile

« Previous | Next » 

Revision 10968

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: removed relationship table, because this is too general, and custom relationships between entities are better indicated in the applicable hstore extender field for the table in question. record: split into record and traceable tables, where record is instead the record in the source data, and traceable indicates that a row has associated source information.

View differences:

schemas/VegCore/VegCore.pg.sql
86 86 
  /*CONSTRAINT "collection_unique" */UNIQUE ("institution","name"),
87 87 
  /*KEY "fk_collection_organization1_idx" ("institution")*/CHECK (true),
88 88 
  /*KEY "fk_collection_source1_idx" ("id")*/CHECK (true),
89 
  /*CONSTRAINT "fk_collection_organization1" FOREIGN KEY ("institution") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
90 
  /*CONSTRAINT "fk_collection_source1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
89 
  /*CONSTRAINT "fk_collection_source1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
90 
  /*CONSTRAINT "fk_collection_organization1" FOREIGN KEY ("institution") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
91 91 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"the collection within the institution where a specimen is held" ("Brad Boyle":https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/collectionCode)'*/;
92 92 
/*!40101 SET character_set_client = @saved_cs_client */;
93 93 

  		




  ......




  109
  109
  
    
  "name" text NOT NULL,


  		




  110
  110
  
    
  "info" hstore DEFAULT NULL,


  		




  111
  111
  
    
  PRIMARY KEY ("id"),


  		




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


  		




  
  112
  
    
  /*CONSTRAINT "fk_community_record1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  113
  113
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A community type is an abstract grouping of organisms that tend to co-occur on the landscape due to shared ecological requirements or preferences. May be designated by syntaxon or physiognomic types." ([[VegCore#VegX|VegX]])'*/;


  		




  114
  114
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  115
  115
  
    

  		




  ......




  157
  157
  
    
  /*KEY "fk_event_place1_idx" ("place")*/CHECK (true),


  		




  158
  158
  
    
  /*KEY "fk_event1_idx" ("parent")*/CHECK (true),


  		




  159
  159
  
    
  /*KEY "fk_event_party_list1_idx" ("participants")*/CHECK (true),


  		




  
  160
  
    
  /*CONSTRAINT "fk_event_party_list1" FOREIGN KEY ("participants") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  161
  
    
  /*CONSTRAINT "fk_event_record1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  160
  162
  
    
  /*CONSTRAINT "fk_event1" FOREIGN KEY ("parent") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  161
  
  
    
  /*CONSTRAINT "fk_event_party_list1" FOREIGN KEY ("participants") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  162
  
  
    
  /*CONSTRAINT "fk_event_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




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


  		




  
  163
  
    
  /*CONSTRAINT "fk_event_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  164
  164
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"an action that occurs at a place and during a period of text/*time*/" ("DwC":http://rs.tdwg.org/dwc/terms/#Event)'*/;


  		




  165
  165
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  166
  166
  
    

  		




  ......




  182
  182
  
    
  "name" text NOT NULL,


  		




  183
  183
  
    
  "info" hstore DEFAULT NULL,


  		




  184
  184
  
    
  PRIMARY KEY ("id"),


  		




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


  		




  
  185
  
    
  /*CONSTRAINT "fk_geological_context_record1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  186
  186
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"information pertaining to a location within a geological context, such as stratigraphy" ("DwC":http://rs.tdwg.org/dwc/terms/#GeologicalContext)'*/;


  		




  187
  187
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  188
  188
  
    

  		




  ......




  258
  258
  
    
  /*KEY "fk_georef_place1_idx" ("input_place")*/CHECK (true),


  		




  259
  259
  
    
  /*KEY "fk_georeferencing_party_list1_idx" ("georeferenced_by")*/CHECK (true),


  		




  260
  260
  
    
  /*KEY "fk_georeferencing_geoplace1_idx" ("geoplace")*/CHECK (true),


  		




  
  261
  
    
  /*CONSTRAINT "fk_geovalidation_record100" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  261
  262
  
    
  /*CONSTRAINT "fk_georeferencing_geoplace1" FOREIGN KEY ("geoplace") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  262
  263
  
    
  /*CONSTRAINT "fk_georeferencing_party_list1" FOREIGN KEY ("georeferenced_by") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  263
  
  
    
  /*CONSTRAINT "fk_georef_place1" FOREIGN KEY ("input_place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




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


  		




  
  264
  
    
  /*CONSTRAINT "fk_georef_place1" FOREIGN KEY ("input_place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  265
  265
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='also stored GNRS results'*/;


  		




  266
  266
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  267
  267
  
    

  		




  ......




  441
  441
  
    
  "info" hstore DEFAULT NULL,


  		




  442
  442
  
    
  PRIMARY KEY ("id"),


  		




  443
  443
  
    
  /*KEY "fk_method_method1_idx" ("parent")*/CHECK (true),


  		




  444
  
  
    
  /*CONSTRAINT "fk_method_method1" FOREIGN KEY ("parent") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




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


  		




  
  444
  
    
  /*CONSTRAINT "fk_method_record1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  445
  
    
  /*CONSTRAINT "fk_method_method1" FOREIGN KEY ("parent") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  446
  446
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A specific method definition followed in the creation of the dataset. Each method links to a protocol and literature citation reference. A protocol may have many method or steps." ("VegX":http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/methods/method)'*/;


  		




  447
  447
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  448
  448
  
    

  		




  ......




  486
  486
  
    
  "info" hstore DEFAULT NULL,


  		




  487
  487
  
    
  PRIMARY KEY ("id"),


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  492
  492
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  493
  493
  
    

  		




  ......




  508
  508
  
    
  "id" text NOT NULL,


  		




  509
  509
  
    
  "count" integer NOT NULL,


  		




  510
  510
  
    
  PRIMARY KEY ("id"),


  		




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


  		




  
  511
  
    
  /*CONSTRAINT "fk_collection_source100" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




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


  		




  513
  513
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  514
  514
  
    

  		




  ......




  534
  534
  
    
  PRIMARY KEY ("id"),


  		




  535
  535
  
    
  /*KEY "fk_party_list_has_party_party1_idx" ("party")*/CHECK (true),


  		




  536
  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),


  		




  
  537
  
    
  /*CONSTRAINT "fk_party_list_has_party_party1" FOREIGN KEY ("party") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  538
  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)


  		




  
  539
  
    
  /*CONSTRAINT "fk_party_list_entry_record1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




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


  		




  541
  541
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  542
  542
  
    

  		




  ......




  564
  564
  
    
  PRIMARY KEY ("id"),


  		




  565
  565
  
    
  /*KEY "fk_place1_idx" ("parent")*/CHECK (true),


  		




  566
  566
  
    
  /*KEY "fk_place_geopath1_idx" ("geopath")*/CHECK (true),


  		




  
  567
  
    
  /*CONSTRAINT "fk_place_record1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  567
  568
  
    
  /*CONSTRAINT "fk_place1" FOREIGN KEY ("parent") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  568
  
  
    
  /*CONSTRAINT "fk_place_geopath1" FOREIGN KEY ("geopath") REFERENCES "geopath" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




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


  		




  
  569
  
    
  /*CONSTRAINT "fk_place_geopath1" FOREIGN KEY ("geopath") REFERENCES "geopath" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  570
  570
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A spatial region" ("DwC":http://rs.tdwg.org/dwc/terms/#dcterms:Location) or point'*/;


  		




  571
  571
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  572
  572
  
    

  		




  ......




  669
  669
  
    
CREATE TABLE "record" (


  		




  670
  670
  
    
  "id" text NOT NULL,


  		




  671
  671
  
    
  "source" text NOT NULL,


  		




  672
  
  
    
  "source_id_scope" text DEFAULT NULL,


  		




  673
  672
  
    
  "source_record_id" text DEFAULT NULL,


  		




  674
  
  
    
  "info" hstore DEFAULT NULL,


  		




  675
  673
  
    
  PRIMARY KEY ("id"),


  		




  676
  
  
    
  /*CONSTRAINT "record_unique" */UNIQUE ("source","source_id_scope","source_record_id"),


  		




  
  674
  
    
  /*CONSTRAINT "record_unique" */UNIQUE ("source","source_record_id"),


  		




  677
  675
  
    
  /*KEY "fk_record_source1_idx" ("source")*/CHECK (true),


  		




  678
  
  
    
  /*CONSTRAINT "fk_record_source1" FOREIGN KEY ("source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  676
  
    
  /*CONSTRAINT "fk_record_source10" FOREIGN KEY ("source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  677
  
    
  /*CONSTRAINT "fk_record_source2" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  679
  678
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;


  		




  680
  679
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  681
  680
  
    

  		




  ......




  695
  694
  
    
CREATE TABLE "referenced_class" (


  		




  696
  695
  
    
  "id" text NOT NULL,


  		




  697
  696
  
    
  PRIMARY KEY ("id"),


  		




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


  		




  
  697
  
    
  /*CONSTRAINT "fk_example_record10" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  699
  698
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;


  		




  700
  699
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  701
  700
  
    

  		




  ......




  707
  706
  
    
/*!40000 ALTER TABLE "referenced_class" ENABLE KEYS */;


  		




  708
  707
  
    

  		




  709
  708
  
    
--


  		




  710
  
  
    
-- Table structure for table "relationship"


  		




  711
  
  
    
--


  		




  712
  
  
    

  		




  713
  
  
    
/*!40101 SET @saved_cs_client     = @@character_set_client */;


  		




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


  		




  715
  
  
    
CREATE TABLE "relationship" (


  		




  716
  
  
    
  "id" text NOT NULL,


  		




  717
  
  
    
  "record" text NOT NULL,


  		




  718
  
  
    
  "related_record" text NOT NULL,


  		




  719
  
  
    
  "info" hstore DEFAULT NULL,


  		




  720
  
  
    
  PRIMARY KEY ("id"),


  		




  721
  
  
    
  /*KEY "fk_relationship_record1_idx" ("record")*/CHECK (true),


  		




  722
  
  
    
  /*KEY "fk_relationship_related_record_idx" ("related_record")*/CHECK (true),


  		




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


  		




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


  		




  725
  
  
    
  /*CONSTRAINT "fk_relationship_related_record" FOREIGN KEY ("related_record") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  726
  
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"information pertaining to relationships between resources (instances of data records, such as Occurrences, Taxa, Locations, Events)" ("DwC":http://rs.tdwg.org/dwc/terms/#ResourceRelationship)'*/;


  		




  727
  
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  728
  
  
    

  		




  729
  
  
    
--


  		




  730
  
  
    
-- Dumping data for table "relationship"


  		




  731
  
  
    
--


  		




  732
  
  
    

  		




  733
  
  
    
/*!40000 ALTER TABLE "relationship" DISABLE KEYS */;


  		




  734
  
  
    
/*!40000 ALTER TABLE "relationship" ENABLE KEYS */;


  		




  735
  
  
    

  		




  736
  
  
    
--


  		




  737
  709
  
    
-- Table structure for table "reobservable"


  		




  738
  710
  
    
--


  		




  739
  711
  
    

  		




  ......




  817
  789
  
    
  PRIMARY KEY ("id"),


  		




  818
  790
  
    
  /*KEY "fk_soil_observation_place_observation1_idx" ("place_observation")*/CHECK (true),


  		




  819
  791
  
    
  /*KEY "fk_soil_observation_subplace1_idx" ("measurement_spot")*/CHECK (true),


  		




  820
  
  
    
  /*CONSTRAINT "fk_soil_observation_place_observation1" FOREIGN KEY ("place_observation") REFERENCES "place_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




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


  		




  822
  
  
    
  /*CONSTRAINT "fk_soil_observation_subplace1" FOREIGN KEY ("measurement_spot") REFERENCES "subplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  792
  
    
  /*CONSTRAINT "fk_soil_observation_subplace1" FOREIGN KEY ("measurement_spot") REFERENCES "subplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  793
  
    
  /*CONSTRAINT "fk_soil_observation_record1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  794
  
    
  /*CONSTRAINT "fk_soil_observation_place_observation1" FOREIGN KEY ("place_observation") REFERENCES "place_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  823
  795
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]''s soil'*/;


  		




  824
  796
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  825
  797
  
    

  		




  ......




  1148
  1120
  
    
  PRIMARY KEY ("id"),


  		




  1149
  1121
  
    
  /*KEY "fk_taxon_assertion_taxon_string1_idx" ("string")*/CHECK (true),


  		




  1150
  1122
  
    
  /*KEY "fk_taxon_assertion_taxon_name1_idx" ("taxon")*/CHECK (true),


  		




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


  		




  1152
  
  
    
  /*CONSTRAINT "fk_taxon_assertion_taxon_name1" FOREIGN KEY ("taxon") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1153
  
  
    
  /*CONSTRAINT "fk_taxon_assertion_taxon_string1" FOREIGN KEY ("string") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  1123
  
    
  /*CONSTRAINT "fk_qualified_taxon_record1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  1124
  
    
  /*CONSTRAINT "fk_taxon_assertion_taxon_string1" FOREIGN KEY ("string") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  1125
  
    
  /*CONSTRAINT "fk_taxon_assertion_taxon_name1" FOREIGN KEY ("taxon") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  1154
  1126
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;


  		




  1155
  1127
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  1156
  1128
  
    

  		




  ......




  1237
  1209
  
    
  PRIMARY KEY ("id"),


  		




  1238
  1210
  
    
  /*KEY "fk_taxon_concept_taxon_string10_idx" ("unique_name")*/CHECK (true),


  		




  1239
  1211
  
    
  /*KEY "fk_taxon_name_taxon_path1_idx" ("taxon_path")*/CHECK (true),


  		




  
  1212
  
    
  /*CONSTRAINT "fk_taxon_record10" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1240
  1213
  
    
  /*CONSTRAINT "fk_taxon_concept_taxon_string10" FOREIGN KEY ("unique_name") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1241
  
  
    
  /*CONSTRAINT "fk_taxon_name_taxon_path1" FOREIGN KEY ("taxon_path") REFERENCES "taxon_path" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




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


  		




  
  1214
  
    
  /*CONSTRAINT "fk_taxon_name_taxon_path1" FOREIGN KEY ("taxon_path") REFERENCES "taxon_path" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  1243
  1215
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;


  		




  1244
  1216
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  1245
  1217
  
    

  		




  ......




  1299
  1271
  
    
  PRIMARY KEY ("id"),


  		




  1300
  1272
  
    
  /*KEY "fk_taxon_occurrence_taxon_determination3_idx" ("current_observation")*/CHECK (true),


  		




  1301
  1273
  
    
  /*KEY "fk_taxon_occurrence_place1_idx" ("within_place")*/CHECK (true),


  		




  1302
  
  
    
  /*CONSTRAINT "fk_taxon_occurrence_place1" FOREIGN KEY ("within_place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




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


  		




  1304
  
  
    
  /*CONSTRAINT "fk_taxon_occurrence_taxon_determination3" FOREIGN KEY ("current_observation") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  1274
  
    
  /*CONSTRAINT "fk_taxon_occurrence_taxon_determination3" FOREIGN KEY ("current_observation") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  1275
  
    
  /*CONSTRAINT "fk_taxon_occurrence_record1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  1276
  
    
  /*CONSTRAINT "fk_taxon_occurrence_place1" FOREIGN KEY ("within_place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  1305
  1277
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;


  		




  1306
  1278
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  1307
  1279
  
    

  		




  ......




  1374
  1346
  
    
  /*KEY "fk_parsed_taxon_assertion_taxon_name1_idx" ("matched_taxon_concept")*/CHECK (true),


  		




  1375
  1347
  
    
  /*KEY "fk_taxon_scrub_taxon_assertion1_idx" ("parsed_taxon_assertion")*/CHECK (true),


  		




  1376
  1348
  
    
  /*KEY "fk_taxon_scrub_taxon_string1_idx" ("input_string")*/CHECK (true),


  		




  
  1349
  
    
  /*CONSTRAINT "fk_taxon_scrub_record1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1377
  1350
  
    
  /*CONSTRAINT "fk_parsed_taxon_assertion_taxon_name1" FOREIGN KEY ("matched_taxon_concept") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




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


  		




  1379
  1351
  
    
  /*CONSTRAINT "fk_taxon_scrub_taxon_assertion1" FOREIGN KEY ("parsed_taxon_assertion") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1380
  1352
  
    
  /*CONSTRAINT "fk_taxon_scrub_taxon_string1" FOREIGN KEY ("input_string") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  1381
  1353
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;


  		




  ......




  1406
  1378
  
    

  		




  1407
  1379
  
    
/*!40000 ALTER TABLE "taxon_string" DISABLE KEYS */;


  		




  1408
  1380
  
    
/*!40000 ALTER TABLE "taxon_string" ENABLE KEYS */;


  		




  
  1381
  
    

  		




  
  1382
  
    
--


  		




  
  1383
  
    
-- Table structure for table "traceable"


  		




  
  1384
  
    
--


  		




  
  1385
  
    

  		




  
  1386
  
    
/*!40101 SET @saved_cs_client     = @@character_set_client */;


  		




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


  		




  
  1388
  
    
CREATE TABLE "traceable" (


  		




  
  1389
  
    
  "id" text NOT NULL,


  		




  
  1390
  
    
  "source" text DEFAULT NULL,


  		




  
  1391
  
    
  PRIMARY KEY ("id"),


  		




  
  1392
  
    
  /*CONSTRAINT "record_unique" */UNIQUE ("source"),


  		




  
  1393
  
    
  /*KEY "fk_record_source1_idx" ("source")*/CHECK (true),


  		




  
  1394
  
    
  /*CONSTRAINT "fk_record_source1" FOREIGN KEY ("source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




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


  		




  
  1396
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  
  1397
  
    

  		




  
  1398
  
    
--


  		




  
  1399
  
    
-- Dumping data for table "traceable"


  		




  
  1400
  
    
--


  		




  
  1401
  
    

  		




  
  1402
  
    
/*!40000 ALTER TABLE "traceable" DISABLE KEYS */;


  		




  
  1403
  
    
/*!40000 ALTER TABLE "traceable" ENABLE KEYS */;


  		




  1409
  1404
  
    
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;


  		




  1410
  1405
  
    

  		




  1411
  1406
  
    
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;


  		












  

    
      schemas/VegCore/document.mwb.xml
    
  





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


  		




  219
  219
  
    
                  <value type="string" key="oldName">party</value>


  		




  220
  220
  
    
                </value>


  		




  221
  
  
    
                <value type="object" struct-name="db.mysql.Table" id="be8ce932-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">


  		




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


  		




  223
  
  
    
                  <value type="int" key="checksum">0</value>


  		




  224
  
  
    
                  <value _ptr_="0xafaafa8" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">


  		




  225
  
  
    
                    <value type="object" struct-name="db.mysql.Column" id="be8cebb2-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  233
  
  
    
                      <value _ptr_="0xafabcd8" type="list" content-type="string" key="flags"/>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  240
  
  
    
                      <value type="string" key="name">id</value>


  		




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


  		




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


  		




  243
  
  
    
                    </value>


  		




  244
  
  
    
                    <value type="object" struct-name="db.mysql.Column" id="be8ced88-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  252
  
  
    
                      <value _ptr_="0xafac150" type="list" content-type="string" key="flags"/>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  259
  
  
    
                      <value type="string" key="name">record</value>


  		




  260
  
  
    
                      <value type="string" key="oldName">record</value>


  		




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


  		




  262
  
  
    
                    </value>


  		




  263
  
  
    
                    <value type="object" struct-name="db.mysql.Column" id="be8cef2c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  271
  
  
    
                      <value _ptr_="0xafac5c8" type="list" content-type="string" key="flags"/>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  278
  
  
    
                      <value type="string" key="name">related_record</value>


  		




  279
  
  
    
                      <value type="string" key="oldName">related_record</value>


  		




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


  		




  281
  
  
    
                    </value>


  		




  282
  
  
    
                    <value type="object" struct-name="db.mysql.Column" id="95e0feca-a793-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




  287
  
  
    
                      <value type="string" key="datatypeExplicitParams">('hstore')</value>


  		




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


  		




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


  		




  290
  
  
    
                      <value _ptr_="0xafaca40" type="list" content-type="string" key="flags"/>


  		




  291
  
  
    
                      <value type="int" key="isNotNull">0</value>


  		




  292
  
  
    
                      <value type="int" key="length">-1</value>


  		




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


  		




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


  		




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


  		




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


  		




  297
  
  
    
                      <value type="string" key="name">info</value>


  		




  298
  
  
    
                      <value type="string" key="oldName">info</value>


  		




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


  		




  300
  
  
    
                    </value>


  		




  301
  
  
    
                  </value>


  		




  302
  
  
    
                  <value type="string" key="connectionString"></value>


  		




  303
  
  
    
                  <value type="string" key="defaultCharacterSetName">utf8</value>


  		




  304
  
  
    
                  <value type="string" key="defaultCollationName">utf8_bin</value>


  		




  305
  
  
    
                  <value type="int" key="delayKeyWrite">0</value>


  		




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


  		




  307
  
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="be8cf9fe-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">


  		




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


  		




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


  		




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


  		




  311
  
  
    
                      </value>


  		




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


  		




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


  		




  314
  
  
    
                      <link type="object" struct-name="db.Index" key="index">be8cf0d0-a6e0-11e2-95e9-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  318
  
  
    
                      <link type="object" struct-name="db.Table" key="owner">be8ce932-a6e0-11e2-95e9-080027bcf912</link>


  		




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


  		




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


  		




  321
  
  
    
                      </value>


  		




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


  		




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


  		




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


  		




  325
  
  
    
                      <value type="string" key="name">fk_relationship_record1</value>


  		




  326
  
  
    
                      <value type="string" key="oldName">fk_relationship_record1</value>


  		




  327
  
  
    
                    </value>


  		




  328
  
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="be8cfb66-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">


  		




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


  		




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


  		




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


  		




  332
  
  
    
                      </value>


  		




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


  		




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


  		




  335
  
  
    
                      <link type="object" struct-name="db.Index" key="index">be8cf42c-a6e0-11e2-95e9-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  339
  
  
    
                      <link type="object" struct-name="db.Table" key="owner">be8ce932-a6e0-11e2-95e9-080027bcf912</link>


  		




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


  		




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


  		




  342
  
  
    
                      </value>


  		




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


  		




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


  		




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


  		




  346
  
  
    
                      <value type="string" key="name">fk_relationship_record2</value>


  		




  347
  
  
    
                      <value type="string" key="oldName">fk_relationship_record2</value>


  		




  348
  
  
    
                    </value>


  		




  349
  
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="be8cfcb0-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">


  		




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


  		




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


  		




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


  		




  353
  
  
    
                      </value>


  		




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


  		




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


  		




  356
  
  
    
                      <link type="object" struct-name="db.Index" key="index">be8cf71a-a6e0-11e2-95e9-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  360
  
  
    
                      <link type="object" struct-name="db.Table" key="owner">be8ce932-a6e0-11e2-95e9-080027bcf912</link>


  		




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


  		




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


  		




  363
  
  
    
                      </value>


  		




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


  		




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


  		




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


  		




  367
  
  
    
                      <value type="string" key="name">fk_relationship_related_record</value>


  		




  368
  
  
    
                      <value type="string" key="oldName">fk_relationship_related_record</value>


  		




  369
  
  
    
                    </value>


  		




  370
  
  
    
                  </value>


  		




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


  		




  372
  
  
    
                    <value type="object" struct-name="db.mysql.Index" id="be8cf0d0-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




  374
  
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="be8cf2ec-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




  378
  
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">be8cebb2-a6e0-11e2-95e9-080027bcf912</link>


  		




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


  		




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


  		




  381
  
  
    
                        </value>


  		




  382
  
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  388
  
  
    
                      <value type="string" key="indexType">PRIMARY</value>


  		




  389
  
  
    
                      <value type="int" key="isPrimary">1</value>


  		




  390
  
  
    
                      <value type="string" key="name">PRIMARY</value>


  		




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


  		




  392
  
  
    
                      <value type="string" key="oldName">PRIMARY</value>


  		




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


  		




  394
  
  
    
                    </value>


  		




  395
  
  
    
                    <value type="object" struct-name="db.mysql.Index" id="be8cf42c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




  397
  
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="be8cf5e4-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




  401
  
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">be8ced88-a6e0-11e2-95e9-080027bcf912</link>


  		




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


  		




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


  		




  404
  
  
    
                        </value>


  		




  405
  
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  413
  
  
    
                      <value type="string" key="name">fk_relationship_record1_idx</value>


  		




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


  		




  415
  
  
    
                      <value type="string" key="oldName">fk_relationship_record1_idx</value>


  		




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


  		




  417
  
  
    
                    </value>


  		




  418
  
  
    
                    <value type="object" struct-name="db.mysql.Index" id="be8cf71a-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




  420
  
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="be8cf8c8-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




  424
  
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">be8cef2c-a6e0-11e2-95e9-080027bcf912</link>


  		




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


  		




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


  		




  427
  
  
    
                        </value>


  		




  428
  
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  436
  
  
    
                      <value type="string" key="name">fk_relationship_related_record_idx</value>


  		




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


  		




  438
  
  
    
                      <value type="string" key="oldName">fk_relationship_related_record_idx</value>


  		




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


  		




  440
  
  
    
                    </value>


  		




  441
  
  
    
                  </value>


  		




  442
  
  
    
                  <value type="string" key="maxRows"></value>


  		




  443
  
  
    
                  <value type="string" key="mergeInsert"></value>


  		




  444
  
  
    
                  <value type="string" key="mergeUnion"></value>


  		




  445
  
  
    
                  <value type="string" key="minRows"></value>


  		




  446
  
  
    
                  <value type="string" key="nextAutoInc"></value>


  		




  447
  
  
    
                  <value type="string" key="packKeys"></value>


  		




  448
  
  
    
                  <value type="int" key="partitionCount">0</value>


  		




  449
  
  
    
                  <value _ptr_="0xafab810" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>


  		




  450
  
  
    
                  <value type="string" key="partitionExpression"></value>


  		




  451
  
  
    
                  <value type="string" key="partitionType"></value>


  		




  452
  
  
    
                  <value type="string" key="password"></value>


  		




  453
  
  
    
                  <link type="object" struct-name="db.mysql.Index" key="primaryKey">be8cf0d0-a6e0-11e2-95e9-080027bcf912</link>


  		




  454
  
  
    
                  <value type="string" key="raidChunkSize"></value>


  		




  455
  
  
    
                  <value type="string" key="raidChunks"></value>


  		




  456
  
  
    
                  <value type="string" key="raidType"></value>


  		




  457
  
  
    
                  <value type="string" key="rowFormat"></value>


  		




  458
  
  
    
                  <value type="int" key="subpartitionCount">0</value>


  		




  459
  
  
    
                  <value type="string" key="subpartitionExpression"></value>


  		




  460
  
  
    
                  <value type="string" key="subpartitionType"></value>


  		




  461
  
  
    
                  <value type="string" key="tableDataDir"></value>


  		




  462
  
  
    
                  <value type="string" key="tableEngine">InnoDB</value>


  		




  463
  
  
    
                  <value type="string" key="tableIndexDir"></value>


  		




  464
  
  
    
                  <value _ptr_="0xafab7b0" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>


  		




  465
  
  
    
                  <value type="int" key="isStub">0</value>


  		




  466
  
  
    
                  <value type="int" key="isSystem">0</value>


  		




  467
  
  
    
                  <value type="int" key="isTemporary">0</value>


  		




  468
  
  
    
                  <value type="string" key="temporaryScope"></value>


  		




  469
  
  
    
                  <value type="int" key="commentedOut">0</value>


  		




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


  		




  471
  
  
    
                  <value _ptr_="0xafa4bf8" type="dict" key="customData"/>


  		




  472
  
  
    
                  <value type="string" key="lastChangeDate">2013-04-24 14:35</value>


  		




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


  		




  474
  
  
    
                  <value type="string" key="name">relationship</value>


  		




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


  		




  476
  
  
    
                  <value type="string" key="temp_sql"></value>


  		




  477
  
  
    
                  <value type="string" key="comment">"information pertaining to relationships between resources (instances of data records, such as Occurrences, Taxa, Locations, Events)" ("DwC":http://rs.tdwg.org/dwc/terms/#ResourceRelationship)</value>


  		




  478
  
  
    
                  <value type="string" key="oldName">relationship</value>


  		




  479
  
  
    
                </value>


  		




  480
  221
  
    
                <value type="object" struct-name="db.mysql.Table" id="be8cc04c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">


  		




  481
  222
  
    
                  <value type="string" key="avgRowLength"></value>


  		




  482
  223
  
    
                  <value type="int" key="checksum">0</value>


  		




  ......




  1443
  1184
  
    
                      <value type="string" key="collationName"></value>


  		




  1444
  1185
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  1445
  1186
  
    
                      <value type="string" key="defaultValue"></value>


  		




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


  		




  
  1187
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




  1447
  1188
  
    
                      <value _ptr_="0xafbc478" type="list" content-type="string" key="flags"/>


  		




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


  		




  
  1189
  
    
                      <value type="int" key="isNotNull">0</value>


  		




  1449
  1190
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




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


  		




  ......




  1455
  1196
  
    
                      <value type="string" key="oldName">source</value>


  		




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


  		




  1457
  1198
  
    
                    </value>


  		




  1458
  
  
    
                    <value type="object" struct-name="db.mysql.Column" id="ea3bec44-acef-11e2-bdae-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  1465
  
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




  1466
  
  
    
                      <value _ptr_="0xafbc8f0" type="list" content-type="string" key="flags"/>


  		




  1467
  
  
    
                      <value type="int" key="isNotNull">0</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  1473
  
  
    
                      <value type="string" key="name">source_id_scope</value>


  		




  1474
  
  
    
                      <value type="string" key="oldName">source_id_scope</value>


  		




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


  		




  1476
  
  
    
                    </value>


  		




  1477
  
  
    
                    <value type="object" struct-name="db.mysql.Column" id="a09e45d4-a79d-11e2-a346-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  1484
  
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




  1485
  
  
    
                      <value _ptr_="0xafbcd68" type="list" content-type="string" key="flags"/>


  		




  1486
  
  
    
                      <value type="int" key="isNotNull">0</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  1492
  
  
    
                      <value type="string" key="name">source_record_id</value>


  		




  1493
  
  
    
                      <value type="string" key="oldName">source_record_id</value>


  		




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


  		




  1495
  
  
    
                    </value>


  		




  1496
  
  
    
                    <value type="object" struct-name="db.mysql.Column" id="43f62c16-ad1a-11e2-9d85-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




  1501
  
  
    
                      <value type="string" key="datatypeExplicitParams">('hstore')</value>


  		




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


  		




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


  		




  1504
  
  
    
                      <value _ptr_="0xafbd1e0" type="list" content-type="string" key="flags"/>


  		




  1505
  
  
    
                      <value type="int" key="isNotNull">0</value>


  		




  1506
  
  
    
                      <value type="int" key="length">-1</value>


  		




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


  		




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


  		




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


  		




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


  		




  1511
  
  
    
                      <value type="string" key="name">info</value>


  		




  1512
  
  
    
                      <value type="string" key="oldName">info</value>


  		




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


  		




  1514
  
  
    
                    </value>


  		




  1515
  1199
  
    
                  </value>


  		




  1516
  1200
  
    
                  <value type="string" key="connectionString"></value>


  		




  1517
  1201
  
    
                  <value type="string" key="defaultCharacterSetName">utf8</value>


  		




  ......




  1533
  1217
  
    
                      <value _ptr_="0xafbd648" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">


  		




  1534
  1218
  
    
                        <link type="object">be8cc362-a6e0-11e2-95e9-080027bcf912</link>


  		




  1535
  1219
  
    
                      </value>


  		




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


  		




  
  1220
  
    
                      <value type="int" key="referencedMandatory">0</value>


  		




  1537
  1221
  
    
                      <value type="string" key="updateRule">CASCADE</value>


  		




  1538
  1222
  
    
                      <value type="string" key="comment"></value>


  		




  1539
  1223
  
    
                      <value type="string" key="name">fk_record_source1</value>


  		




  ......




  1574
  1258
  
    
                          <value type="string" key="name"></value>


  		




  1575
  1259
  
    
                          <link type="object" struct-name="GrtObject" key="owner">fbf69d1e-a79d-11e2-a346-080027bcf912</link>


  		




  1576
  1260
  
    
                        </value>


  		




  1577
  
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="f7e2cd36-acef-11e2-bdae-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




  1581
  
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">ea3bec44-acef-11e2-bdae-080027bcf912</link>


  		




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


  		




  1583
  
  
    
                          <link type="object" struct-name="GrtObject" key="owner">fbf69d1e-a79d-11e2-a346-080027bcf912</link>


  		




  1584
  
  
    
                        </value>


  		




  1585
  
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="f8383cda-acef-11e2-bdae-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




  1589
  
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">a09e45d4-a79d-11e2-a346-080027bcf912</link>


  		




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


  		




  1591
  
  
    
                          <link type="object" struct-name="GrtObject" key="owner">fbf69d1e-a79d-11e2-a346-080027bcf912</link>


  		




  1592
  
  
    
                        </value>


  		




  1593
  1261
  
    
                      </value>


  		




  1594
  1262
  
    
                      <value type="string" key="indexKind"></value>


  		




  1595
  1263
  
    
                      <value type="int" key="keyBlockSize">0</value>


  		




  ......




  1657
  1325
  
    
                  <value type="int" key="commentedOut">0</value>


  		




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


  		




  1659
  1327
  
    
                  <value _ptr_="0xa4892c8" type="dict" key="customData"/>


  		




  1660
  
  
    
                  <value type="string" key="lastChangeDate">2013-04-24 13:05</value>


  		




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


  		




  1661
  1329
  
    
                  <value type="int" key="modelOnly">0</value>


  		




  1662
  
  
    
                  <value type="string" key="name">record</value>


  		




  
  1330
  
    
                  <value type="string" key="name">traceable</value>


  		




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


  		




  1664
  1332
  
    
                  <value type="string" key="temp_sql"></value>


  		




  1665
  1333
  
    
                  <value type="string" key="comment"></value>


  		




  1666
  
  
    
                  <value type="string" key="oldName">record</value>


  		




  
  1334
  
    
                  <value type="string" key="oldName">traceable</value>


  		




  1667
  1335
  
    
                </value>


  		




  1668
  1336
  
    
                <value type="object" struct-name="db.mysql.Table" id="be8e3ecc-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">


  		




  1669
  1337
  
    
                  <value type="string" key="avgRowLength"></value>


  		




  ......




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


  		




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


  		




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


  		




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


  		




  
  9956
  
    
                      <value type="string" key="oldName">list</value>


  		




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


  		




  10290
  9958
  
    
                    </value>


  		




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


  		




  ......




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


  		




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


  		




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


  		




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


  		




  
  9975
  
    
                      <value type="string" key="oldName">party</value>


  		




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


  		




  10309
  9977
  
    
                    </value>


  		




  10310
  9978
  
    
                    <value type="object" struct-name="db.mysql.Column" id="77c740cc-1de8-11e3-b571-080027bcf912" struct-checksum="0x783b5183">


  		




  ......




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


  		




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


  		




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


  		




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


  		




  
  10152
  
    
                      <value type="string" key="oldName">fk_party_list_entry_party_list1_idx</value>


  		




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


  		




  10486
  10154
  
    
                    </value>


  		




  10487
  10155
  
    
                  </value>


  		




  ......




  12703
  12371
  
    
                  <value type="string" key="comment"></value>


  		




  12704
  12372
  
    
                  <value type="string" key="oldName">taxon_occurrence</value>


  		




  12705
  12373
  
    
                </value>


  		




  
  12374
  
    
                <value type="object" struct-name="db.mysql.Table" id="0de39e86-1dec-11e3-b571-080027bcf912" struct-checksum="0x1a403946">


  		




  
  12375
  
    
                  <value type="string" key="avgRowLength"></value>


  		




  
  12376
  
    
                  <value type="int" key="checksum">0</value>


  		




  
  12377
  
    
                  <value _ptr_="0xbaad830" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">


  		




  
  12378
  
    
                    <value type="object" struct-name="db.mysql.Column" id="0de3a2aa-1dec-11e3-b571-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  12386
  
    
                      <value _ptr_="0xbb7ce70" type="list" content-type="string" key="flags"/>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  12393
  
    
                      <value type="string" key="name">id</value>


  		




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


  		




  
  12395
  
    
                      <link type="object" struct-name="GrtObject" key="owner">0de39e86-1dec-11e3-b571-080027bcf912</link>


  		




  
  12396
  
    
                    </value>


  		




  
  12397
  
    
                    <value type="object" struct-name="db.mysql.Column" id="0de3a61a-1dec-11e3-b571-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  12405
  
    
                      <value _ptr_="0xc120260" type="list" content-type="string" key="flags"/>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  12412
  
    
                      <value type="string" key="name">source</value>


  		




  
  12413
  
    
                      <value type="string" key="oldName">source</value>


  		




  
  12414
  
    
                      <link type="object" struct-name="GrtObject" key="owner">0de39e86-1dec-11e3-b571-080027bcf912</link>


  		




  
  12415
  
    
                    </value>


  		




  
  12416
  
    
                    <value type="object" struct-name="db.mysql.Column" id="0de3ab06-1dec-11e3-b571-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  12423
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




  
  12424
  
    
                      <value _ptr_="0xbafba80" type="list" content-type="string" key="flags"/>


  		




  
  12425
  
    
                      <value type="int" key="isNotNull">0</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  12431
  
    
                      <value type="string" key="name">source_record_id</value>


  		




  
  12432
  
    
                      <value type="string" key="oldName">source_record_id</value>


  		




  
  12433
  
    
                      <link type="object" struct-name="GrtObject" key="owner">0de39e86-1dec-11e3-b571-080027bcf912</link>


  		




  
  12434
  
    
                    </value>


  		




  
  12435
  
    
                  </value>


  		




  
  12436
  
    
                  <value type="string" key="connectionString"></value>


  		




  
  12437
  
    
                  <value type="string" key="defaultCharacterSetName">utf8</value>


  		




  
  12438
  
    
                  <value type="string" key="defaultCollationName">utf8_bin</value>


  		




  
  12439
  
    
                  <value type="int" key="delayKeyWrite">0</value>


  		




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


  		




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


  		




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


  		




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


  		




  
  12444
  
    
                        <link type="object">0de3a61a-1dec-11e3-b571-080027bcf912</link>


  		




  
  12445
  
    
                      </value>


  		




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


  		




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


  		




  
  12448
  
    
                      <link type="object" struct-name="db.Index" key="index">0de3ba38-1dec-11e3-b571-080027bcf912</link>


  		




  
  12449
  
    
                      <value type="int" key="mandatory">1</value>


  		




  
  12450
  
    
                      <value type="int" key="many">1</value>


  		




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


  		




  
  12452
  
    
                      <link type="object" struct-name="db.Table" key="owner">0de39e86-1dec-11e3-b571-080027bcf912</link>


  		




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


  		




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


  		




  
  12455
  
    
                      </value>


  		




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


  		




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


  		




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


  		




  
  12459
  
    
                      <value type="string" key="name">fk_record_source10</value>


  		




  
  12460
  
    
                      <value type="string" key="oldName">fk_record_source10</value>


  		




  
  12461
  
    
                    </value>


  		




  
  12462
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="8e2b8e78-1dec-11e3-b571-080027bcf912" struct-checksum="0x70a8fc40">


  		




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


  		




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


  		




  
  12465
  
    
                        <link type="object">0de3a2aa-1dec-11e3-b571-080027bcf912</link>


  		




  
  12466
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  12472
  
    
                      <link type="object" struct-name="db.Table" key="owner">0de39e86-1dec-11e3-b571-080027bcf912</link>


  		




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


  		




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


  		




  
  12475
  
    
                      </value>


  		




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


  		




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


  		




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


  		




  
  12479
  
    
                      <value type="string" key="name">fk_record_source2</value>


  		




  
  12480
  
    
                      <value type="string" key="oldName">fk_record_source2</value>


  		




  
  12481
  
    
                    </value>


  		




  
  12482
  
    
                  </value>


  		




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


  		




  
  12484
  
    
                    <value type="object" struct-name="db.mysql.Index" id="0de3b22c-1dec-11e3-b571-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




  
  12486
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="0de3b362-1dec-11e3-b571-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




  
  12490
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">0de3a2aa-1dec-11e3-b571-080027bcf912</link>


  		




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


  		




  
  12492
  
    
                          <link type="object" struct-name="GrtObject" key="owner">0de3b22c-1dec-11e3-b571-080027bcf912</link>


  		




  
  12493
  
    
                        </value>


  		




  
  12494
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  12500
  
    
                      <value type="string" key="indexType">PRIMARY</value>


  		




  
  12501
  
    
                      <value type="int" key="isPrimary">1</value>


  		




  
  12502
  
    
                      <value type="string" key="name">PRIMARY</value>


  		




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


  		




  
  12504
  
    
                      <value type="string" key="oldName">PRIMARY</value>


  		




  
  12505
  
    
                      <link type="object" struct-name="GrtObject" key="owner">0de39e86-1dec-11e3-b571-080027bcf912</link>


  		




  
  12506
  
    
                    </value>


  		




  
  12507
  
    
                    <value type="object" struct-name="db.mysql.Index" id="0de3b510-1dec-11e3-b571-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




  
  12509
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="0de3b61e-1dec-11e3-b571-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




  
  12513
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">0de3a61a-1dec-11e3-b571-080027bcf912</link>


  		




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


  		




  
  12515
  
    
                          <link type="object" struct-name="GrtObject" key="owner">0de3b510-1dec-11e3-b571-080027bcf912</link>


  		




  
  12516
  
    
                        </value>


  		




  
  12517
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="0de3b880-1dec-11e3-b571-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




  
  12521
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">0de3ab06-1dec-11e3-b571-080027bcf912</link>


  		




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


  		




  
  12523
  
    
                          <link type="object" struct-name="GrtObject" key="owner">0de3b510-1dec-11e3-b571-080027bcf912</link>


  		




  
  12524
  
    
                        </value>


  		




  
  12525
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  12531
  
    
                      <value type="string" key="indexType">UNIQUE</value>


  		




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


  		




  
  12533
  
    
                      <value type="string" key="name">record_unique</value>


  		




  
  12534
  
    
                      <value type="int" key="unique">1</value>


  		




  
  12535
  
    
                      <value type="string" key="oldName">record_unique</value>


  		




  
  12536
  
    
                      <link type="object" struct-name="GrtObject" key="owner">0de39e86-1dec-11e3-b571-080027bcf912</link>


  		




  
  12537
  
    
                    </value>


  		




  
  12538
  
    
                    <value type="object" struct-name="db.mysql.Index" id="0de3ba38-1dec-11e3-b571-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




  
  12540
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="0de3bb64-1dec-11e3-b571-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




  
  12544
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">0de3a61a-1dec-11e3-b571-080027bcf912</link>


  		




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


  		




  
  12546
  
    
                          <link type="object" struct-name="GrtObject" key="owner">0de3ba38-1dec-11e3-b571-080027bcf912</link>


  		




  
  12547
  
    
                        </value>


  		




  
  12548
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  12556
  
    
                      <value type="string" key="name">fk_record_source1_idx</value>


  		




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


  		




  
  12558
  
    
                      <value type="string" key="oldName">fk_record_source1_idx</value>


  		




  
  12559
  
    
                      <link type="object" struct-name="GrtObject" key="owner">0de39e86-1dec-11e3-b571-080027bcf912</link>


  		




  
  12560
  
    
                    </value>


  		




  
  12561
  
    
                  </value>


  		




  
  12562
  
    
                  <value type="string" key="maxRows"></value>


  		




  
  12563
  
    
                  <value type="string" key="mergeInsert"></value>


  		




  
  12564
  
    
                  <value type="string" key="mergeUnion"></value>


  		




  
  12565
  
    
                  <value type="string" key="minRows"></value>


  		




  
  12566
  
    
                  <value type="string" key="nextAutoInc"></value>


  		




  
  12567
  
    
                  <value type="string" key="packKeys"></value>


  		




  
  12568
  
    
                  <value type="int" key="partitionCount">0</value>


  		




  
  12569
  
    
                  <value _ptr_="0xbb3c170" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>


  		




  
  12570
  
    
                  <value type="string" key="partitionExpression"></value>


  		




  
  12571
  
    
                  <value type="string" key="partitionType"></value>


  		




  
  12572
  
    
                  <value type="string" key="password"></value>


  		




  
  12573
  
    
                  <link type="object" struct-name="db.mysql.Index" key="primaryKey">0de3b22c-1dec-11e3-b571-080027bcf912</link>


  		




  
  12574
  
    
                  <value type="string" key="raidChunkSize"></value>


  		




  
  12575
  
    
                  <value type="string" key="raidChunks"></value>


  		




  
  12576
  
    
                  <value type="string" key="raidType"></value>


  		




  
  12577
  
    
                  <value type="string" key="rowFormat"></value>


  		




  
  12578
  
    
                  <value type="int" key="subpartitionCount">0</value>


  		




  
  12579
  
    
                  <value type="string" key="subpartitionExpression"></value>


  		




  
  12580
  
    
                  <value type="string" key="subpartitionType"></value>


  		




  
  12581
  
    
                  <value type="string" key="tableDataDir"></value>


  		




  
  12582
  
    
                  <value type="string" key="tableEngine">InnoDB</value>


  		




  
  12583
  
    
                  <value type="string" key="tableIndexDir"></value>


  		




  
  12584
  
    
                  <value _ptr_="0xc634ea0" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>


  		




  
  12585
  
    
                  <value type="int" key="isStub">0</value>


  		




  
  12586
  
    
                  <value type="int" key="isSystem">0</value>


  		




  
  12587
  
    
                  <value type="int" key="isTemporary">0</value>


  		




  
  12588
  
    
                  <value type="string" key="temporaryScope"></value>


  		




  
  12589
  
    
                  <value type="int" key="commentedOut">0</value>


  		




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


  		




  
  12591
  
    
                  <value _ptr_="0xbd24880" type="dict" key="customData"/>


  		




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


  		




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


  		




  
  12594
  
    
                  <value type="string" key="name">record</value>


  		




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


  		




  
  12596
  
    
                  <value type="string" key="temp_sql"></value>


  		




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


  		




  
  12598
  
    
                  <value type="string" key="oldName">record</value>


  		




  
  12599
  
    
                </value>


  		




  12706
  12600
  
    
              </value>


  		




  12707
  12601
  
    
              <value _ptr_="0xafa88f8" type="list" content-type="object" content-struct-name="db.mysql.View" key="views"/>


  		




  12708
  12602
  
    
              <value type="string" key="defaultCharacterSetName">utf8</value>


  		




  ......




  13157
  13051
  
    
                <value type="int" key="visible">1</value>


  		




  13158
  13052
  
    
                <value type="string" key="name"></value>


  		




  13159
  13053
  
    
              </value>


  		




  13160
  
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="c17f391a-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x9baebc92">


  		




  13161
  
  
    
                <value type="string" key="caption">fk_relationship_record1</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  13170
  
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">be8cf9fe-a6e0-11e2-95e9-080027bcf912</link>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  13176
  
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">AAC8BC14-38FA-4821-A3DD-6F5D0F1F69DE</link>


  		




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


  		




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


  		




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


  		




  13180
  
  
    
              </value>


  		




  13181
  
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="c17f547c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x9baebc92">


  		




  13182
  
  
    
                <value type="string" key="caption">fk_relationship_record1</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  13191
  
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">be8cfb66-a6e0-11e2-95e9-080027bcf912</link>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  13197
  
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">AAC8BC14-38FA-4821-A3DD-6F5D0F1F69DE</link>


  		




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


  		




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


  		




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


  		




  13201
  
  
    
              </value>


  		




  13202
  
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="c17f6f7a-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x9baebc92">


  		




  13203
  
  
    
                <value type="string" key="caption">fk_relationship_related_record</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  13212
  
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">be8cfcb0-a6e0-11e2-95e9-080027bcf912</link>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  13218
  
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">AAC8BC14-38FA-4821-A3DD-6F5D0F1F69DE</link>


  		




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


  		




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


  		




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


  		




  13222
  
  
    
              </value>


  		




  13223
  13054
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="5045c4c6-a6ea-11e2-98a6-080027bcf912" struct-checksum="0x9baebc92">


  		




  13224
  13055
  
    
                <value type="string" key="caption">fk_example_record10</value>


  		




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


  		




  ......




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


  		




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


  		




  15574
  15405
  
    
              </value>


  		




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


  		




  
  15407
  
    
                <value type="string" key="caption">fk_record_source10</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  15416
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">0de3afc0-1dec-11e3-b571-080027bcf912</link>


  		




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


  		




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


  		




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


  		




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


  		




  
  15421
  
    
                <link type="object" struct-name="model.Figure" key="endFigure">39C6F66E-A650-49AE-8EDD-9D8A567EFBEA</link>


  		




  
  15422
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">0de3d5b8-1dec-11e3-b571-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  
  15426
  
    
              </value>


  		




  
  15427
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="8e2c8058-1dec-11e3-b571-080027bcf912" struct-checksum="0x9baebc92">


  		




  
  15428
  
    
                <value type="string" key="caption">fk_record_source2</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  15437
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">8e2b8e78-1dec-11e3-b571-080027bcf912</link>


  		




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


  		




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


  		




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


  		




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


  		




  
  15442
  
    
                <link type="object" struct-name="model.Figure" key="endFigure">39C6F66E-A650-49AE-8EDD-9D8A567EFBEA</link>


  		




  
  15443
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">0de3d5b8-1dec-11e3-b571-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  
  15447
  
    
              </value>


  		




  15575
  15448
  
    
            </value>


  		




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


  		




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


  		




  ......




  15619
  15492
  
    
                <value type="int" key="triggersExpanded">0</value>


  		




  15620
  15493
  
    
                <value type="string" key="color">#99ccff</value>


  		




  15621
  15494
  
    
                <value type="int" key="expanded">1</value>


  		




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


  		




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


  		




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


  		




  15624
  15497
  
    
                <value type="real" key="left">1.46e+02</value>


  		




  15625
  15498
  
    
                <value type="int" key="locked">0</value>


  		




  15626
  15499
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15627
  15500
  
    
                <value type="real" key="top">5.14e+02</value>


  		




  15628
  
  
    
                <value type="real" key="width">1.06e+02</value>


  		




  
  15501
  
    
                <value type="real" key="width">1.02e+02</value>


  		




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


  		




  15630
  15503
  
    
                <value type="int" key="visible">1</value>


  		




  15631
  
  
    
                <value type="string" key="name">record</value>


  		




  
  15504
  
    
                <value type="string" key="name">traceable</value>


  		




  15632
  15505
  
    
              </value>


  		




  15633
  15506
  
    
              <value type="object" struct-name="workbench.physical.TableFigure" id="2EDCE9EA-B246-4F71-9D67-BD04855202B6" struct-checksum="0x3b14eccb">


  		




  15634
  15507
  
    
                <value type="int" key="columnsExpanded">1</value>


  		




  ......




  16130
  16003
  
    
                <value type="int" key="visible">1</value>


  		




  16131
  16004
  
    
                <value type="string" key="name">collection</value>


  		




  16132
  16005
  
    
              </value>


  		




  16133
  
  
    
              <value type="object" struct-name="workbench.physical.TableFigure" id="AAC8BC14-38FA-4821-A3DD-6F5D0F1F69DE" struct-checksum="0x3b14eccb">


  		




  16134
  
  
    
                <value type="int" key="columnsExpanded">1</value>


  		




  16135
  
  
    
                <value type="int" key="foreignKeysExpanded">0</value>


  		




  16136
  
  
    
                <value type="int" key="indicesExpanded">0</value>


  		




  16137
  
  
    
                <value type="int" key="summarizeDisplay">-1</value>


  		




  16138
  
  
    
                <link type="object" struct-name="db.Table" key="table">be8ce932-a6e0-11e2-95e9-080027bcf912</link>


  		




  16139
  
  
    
                <value type="int" key="triggersExpanded">0</value>


  		




  16140
  
  
    
                <value type="string" key="color">#99ccff</value>


  		




  16141
  
  
    
                <value type="int" key="expanded">1</value>


  		




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


  		




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


  		




  16144
  
  
    
                <value type="real" key="left">1.27e+02</value>


  		




  16145
  
  
    
                <value type="int" key="locked">0</value>


  		




  16146
  
  
    
                <value type="int" key="manualSizing">0</value>


  		




  16147
  
  
    
                <value type="real" key="top">7.21e+02</value>


  		




  16148
  
  
    
                <value type="real" key="width">1.18e+02</value>


  		




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


  		




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


  		




  16151
  
  
    
                <value type="string" key="name">relationship</value>


  		




  16152
  
  
    
              </value>


  		




  16153
  16006
  
    
              <value type="object" struct-name="workbench.physical.TableFigure" id="EE4765B7-0391-4132-8813-84A6E788C01D" struct-checksum="0x3b14eccb">


  		




  16154
  16007
  
    
                <value type="int" key="columnsExpanded">1</value>


  		




  16155
  16008
  
    
                <value type="int" key="foreignKeysExpanded">0</value>


  		




  ......




  17151
  17004
  
    
                <value type="int" key="visible">1</value>


  		




  17152
  17005
  
    
                <value type="string" key="name">taxon_occurrence</value>


  		




  17153
  17006
  
    
              </value>


  		




  
  17007
  
    
              <value type="object" struct-name="workbench.physical.TableFigure" id="0de3d5b8-1dec-11e3-b571-080027bcf912" struct-checksum="0x3b14eccb">


  		




  
  17008
  
    
                <value type="int" key="columnsExpanded">1</value>


  		




  
  17009
  
    
                <value type="int" key="foreignKeysExpanded">0</value>


  		




  
  17010
  
    
                <value type="int" key="indicesExpanded">0</value>


  		




  
  17011
  
    
                <value type="int" key="summarizeDisplay">-1</value>


  		




  
  17012
  
    
                <link type="object" struct-name="db.Table" key="table">0de39e86-1dec-11e3-b571-080027bcf912</link>


  		




  
  17013
  
    
                <value type="int" key="triggersExpanded">0</value>


  		




  
  17014
  
    
                <value type="string" key="color">#99ccff</value>


  		




  
  17015
  
    
                <value type="int" key="expanded">1</value>


  		




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


  		




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


  		




  
  17018
  
    
                <value type="real" key="left">1.46e+02</value>


  		




  
  17019
  
    
                <value type="int" key="locked">0</value>


  		




  
  17020
  
    
                <value type="int" key="manualSizing">0</value>


  		




  
  17021
  
    
                <value type="real" key="top">6.16e+02</value>


  		




  
  17022
  
    
                <value type="real" key="width">1.06e+02</value>


  		




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


  		




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


  		




  
  17025
  
    
                <value type="string" key="name">record</value>


  		




  
  17026
  
    
              </value>


  		




  17154
  17027
  
    
            </value>


  		




  17155
  17028
  
    
            <value type="real" key="height">1.2865e+03</value>


  		




  17156
  17029
  
    
            <value _ptr_="0xb052668" type="list" content-type="object" content-struct-name="model.Layer" key="layers">


  		




  ......




  17237
  17110
  
    
                <link type="object">E5EA8009-4F69-4EEE-B07A-5AC286CAA852</link>


  		




  17238
  17111
  
    
                <link type="object">627FF2A4-9311-4DBE-9DB0-1355360AACEA</link>


  		




  17239
  17112
  
    
                <link type="object">CC059D8C-291E-4748-A685-7668D0CFA36C</link>


  		




  17240
  
  
    
                <link type="object">AAC8BC14-38FA-4821-A3DD-6F5D0F1F69DE</link>


  		




  17241
  17113
  
    
                <link type="object">EE4765B7-0391-4132-8813-84A6E788C01D</link>


  		




  17242
  17114
  
    
                <link type="object">b9526b8a-a10a-11e2-a666-080027bcf912</link>


  		




  17243
  17115
  
    
                <link type="object">a8441070-a527-11e2-9e2d-080027bcf912</link>


  		




  ......




  17279
  17151
  
    
                <link type="object">f1574d28-011f-11e3-9f3a-080027bcf912</link>


  		




  17280
  17152
  
    
                <link type="object">d1d0a2b8-0130-11e3-8d80-080027bcf912</link>


  		




  17281
  17153
  
    
                <link type="object">f9d27532-1dc5-11e3-838b-410b6ef2c3ca</link>


  		




  
  17154
  
    
                <link type="object">0de3d5b8-1dec-11e3-b571-080027bcf912</link>


  		




  17282
  17155
  
    
              </value>


  		




  17283
  17156
  
    
              <value _ptr_="0xb09f730" type="list" content-type="object" content-struct-name="model.Group" key="groups"/>


  		




  17284
  17157
  
    
              <value type="real" key="height">1.2865e+03</value>


  		




  ......




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


  		




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


  		




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


  		




  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">


  		




  
  17182
  
    
          <value type="object" struct-name="db.mgmt.SyncProfile" id="22ae8c30-1ded-11e3-b571-080027bcf912" struct-checksum="0xc64972c2" key="">


  		




  
  17183
  
    
            <value _ptr_="0xae06388" type="dict" key="lastKnownDBNames">


  		




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


  		




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


  		




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


  		




  ......




  17333
  17206
  
    
              <value type="string" key="0ab99376-a7a1-11e2-b667-080027bcf912">fk_individual_observation_individual1_idx</value>


  		




  17334
  17207
  
    
              <value type="string" key="0ab99696-a7a1-11e2-b667-080027bcf912">fk_individual_observation_taxon_occurrence1</value>


  		




  17335
  17208
  
    
              <value type="string" key="0ab99812-a7a1-11e2-b667-080027bcf912">fk_individual_observation_individual1</value>


  		




  
  17209
  
    
              <value type="string" key="0de39e86-1dec-11e3-b571-080027bcf912">record</value>


  		




  
  17210
  
    
              <value type="string" key="0de3a2aa-1dec-11e3-b571-080027bcf912">id</value>


  		




  
  17211
  
    
              <value type="string" key="0de3a61a-1dec-11e3-b571-080027bcf912">source</value>


  		




  
  17212
  
    
              <value type="string" key="0de3ab06-1dec-11e3-b571-080027bcf912">source_record_id</value>


  		




  
  17213
  
    
              <value type="string" key="0de3afc0-1dec-11e3-b571-080027bcf912">fk_record_source10</value>


  		




  
  17214
  
    
              <value type="string" key="0de3b22c-1dec-11e3-b571-080027bcf912">PRIMARY</value>


  		




  
  17215
  
    
              <value type="string" key="0de3b510-1dec-11e3-b571-080027bcf912">record_unique</value>


  		




  
  17216
  
    
              <value type="string" key="0de3ba38-1dec-11e3-b571-080027bcf912">fk_record_source1_idx</value>


  		




  17336
  17217
  
    
              <value type="string" key="10b01930-1dcb-11e3-b98c-080027bcf912">fk_taxon_occurrence_taxon_determination3_idx</value>


  		




  17337
  17218
  
    
              <value type="string" key="110c72d2-a73f-11e2-9fbf-080027bcf912">stem_observation_unique</value>


  		




  17338
  17219
  
    
              <value type="string" key="11b487b4-f97f-11e2-8a2e-080027bcf912">fk_taxon_name_taxon_path1</value>


  		




  ......




  17441
  17322
  
    
              <value type="string" key="42405474-a783-11e2-afd5-080027bcf912">annotations</value>


  		




  17442
  17323
  
    
              <value type="string" key="426f5d76-1dcd-11e3-b98c-080027bcf912">fk_individual_count_taxon_presence1</value>


  		




  17443
  17324
  
    
              <value type="string" key="43cfb7dc-a790-11e2-84c3-080027bcf912">lat_long_domain_valid</value>


  		




  17444
  
  
    
              <value type="string" key="43f62c16-ad1a-11e2-9d85-080027bcf912">info</value>


  		




  17445
  17325
  
    
              <value type="string" key="43f70d90-f679-11e2-9716-080027bcf912">sort_order</value>


  		




  17446
  17326
  
    
              <value type="string" key="44e36b2c-a7b4-11e2-97d7-080027bcf912">fk_specimen_observation_specimen1</value>


  		




  17447
  17327
  
    
              <value type="string" key="44e36d02-a7b4-11e2-97d7-080027bcf912">specimen</value>


  		




  ......




  17570
  17450
  
    
              <value type="string" key="8535e982-006c-11e3-895c-080027bcf912">PRIMARY</value>


  		




  17571
  17451
  
    
              <value type="string" key="8542fbb8-a793-11e2-84c3-080027bcf912">info</value>


  		




  17572
  17452
  
    
              <value type="string" key="8b8a694e-a792-11e2-84c3-080027bcf912">name</value>


  		




  
  17453
  
    
              <value type="string" key="8e2b8e78-1dec-11e3-b571-080027bcf912">fk_record_source2</value>


  		




  17573
  17454
  
    
              <value type="string" key="8ed70288-ad14-11e2-9617-080027bcf912">PRIMARY</value>


  		




  17574
  17455
  
    
              <value type="string" key="8f0c3678-f978-11e2-9f36-080027bcf912">rank</value>


  		




  17575
  17456
  
    
              <value type="string" key="913a6e06-008a-11e3-9629-080027bcf912">fk_soil_observation_record1</value>


  		




  17576
  17457
  
    
              <value type="string" key="92fc2776-1be6-11e3-af49-080027bcf912">defining_data</value>


  		




  17577
  17458
  
    
              <value type="string" key="94ad6c18-f6c7-11e2-a35e-080027bcf912">dimensions</value>


  		




  17578
  
  
    
              <value type="string" key="95e0feca-a793-11e2-84c3-080027bcf912">info</value>


  		




  17579
  17459
  
    
              <value type="string" key="98e532e4-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1</value>


  		




  17580
  17460
  
    
              <value type="string" key="98e534d8-008a-11e3-9629-080027bcf912">place_observation</value>


  		




  17581
  17461
  
    
              <value type="string" key="98e5491e-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1_idx</value>


  		




  ......




  17596
  17476
  
    
              <value type="string" key="a01e269e-a741-11e2-9fbf-080027bcf912">string</value>


  		




  17597
  17477
  
    
              <value type="string" key="a01e47fa-a741-11e2-9fbf-080027bcf912">fk_taxon_assertion_taxon_string1_idx</value>


  		




  17598
  17478
  
    
              <value type="string" key="a0266c92-a92a-11e2-93c8-080027bcf912">latitude_deg</value>


  		




  17599
  
  
    
              <value type="string" key="a09e45d4-a79d-11e2-a346-080027bcf912">source_record_id</value>


  		




  17600
  17479
  
    
              <value type="string" key="a2fe2068-a790-11e2-84c3-080027bcf912">name</value>


  		




  17601
  17480
  
    
              <value type="string" key="a3e070f8-a77c-11e2-afd5-080027bcf912">fk_parsed_taxon_assertion_taxon_name1</value>


  		




  17602
  17481
  
    
              <value type="string" key="a45bf56a-f980-11e2-8a2e-080027bcf912">fk_subplot_place2</value>


  		




  ......




  17637
  17516
  
    
              <value type="string" key="be8cc75e-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  17638
  17517
  
    
              <value type="string" key="be8ccb14-a6e0-11e2-95e9-080027bcf912">fk_source1_idx</value>


  		




  17639
  17518
  
    
              <value type="string" key="be8cce5c-a6e0-11e2-95e9-080027bcf912">fk_source1</value>


  		




  17640
  
  
    
              <value type="string" key="be8cd56e-a6e0-11e2-95e9-080027bcf912">record</value>


  		




  
  17519
  
    
              <value type="string" key="be8cd56e-a6e0-11e2-95e9-080027bcf912">traceable</value>


  		




  17641
  17520
  
    
              <value type="string" key="be8cd7b2-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  17642
  17521
  
    
              <value type="string" key="be8cd956-a6e0-11e2-95e9-080027bcf912">source</value>


  		




  17643
  17522
  
    
              <value type="string" key="be8cdac8-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  17644
  17523
  
    
              <value type="string" key="be8cddca-a6e0-11e2-95e9-080027bcf912">fk_record_source1_idx</value>


  		




  17645
  17524
  
    
              <value type="string" key="be8ce0b8-a6e0-11e2-95e9-080027bcf912">fk_record_source1</value>


  		




  17646
  
  
    
              <value type="string" key="be8ce932-a6e0-11e2-95e9-080027bcf912">relationship</value>


  		




  17647
  
  
    
              <value type="string" key="be8cebb2-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  17648
  
  
    
              <value type="string" key="be8ced88-a6e0-11e2-95e9-080027bcf912">record</value>


  		




  17649
  
  
    
              <value type="string" key="be8cef2c-a6e0-11e2-95e9-080027bcf912">related_record</value>


  		




  17650
  
  
    
              <value type="string" key="be8cf0d0-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  17651
  
  
    
              <value type="string" key="be8cf42c-a6e0-11e2-95e9-080027bcf912">fk_relationship_record1_idx</value>


  		




  17652
  
  
    
              <value type="string" key="be8cf71a-a6e0-11e2-95e9-080027bcf912">fk_relationship_related_record_idx</value>


  		




  17653
  
  
    
              <value type="string" key="be8cf9fe-a6e0-11e2-95e9-080027bcf912">fk_relationship_record1</value>


  		




  17654
  
  
    
              <value type="string" key="be8cfb66-a6e0-11e2-95e9-080027bcf912">fk_relationship_record2</value>


  		




  17655
  
  
    
              <value type="string" key="be8cfcb0-a6e0-11e2-95e9-080027bcf912">fk_relationship_related_record</value>


  		




  17656
  17525
  
    
              <value type="string" key="be8d17d6-a6e0-11e2-95e9-080027bcf912">taxon_assertion</value>


  		




  17657
  17526
  
    
              <value type="string" key="be8d1ac4-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  17658
  17527
  
    
              <value type="string" key="be8d1de4-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  ......




  17812
  17681
  
    
              <value type="string" key="e5502346-f676-11e2-9716-080027bcf912">organization</value>


  		




  17813
  17682
  
    
              <value type="string" key="e550389a-f676-11e2-9716-080027bcf912">fk_party_organization1_idx</value>


  		




  17814
  17683
  
    
              <value type="string" key="e5d27f54-a792-11e2-84c3-080027bcf912">info</value>


  		




  17815
  
  
    
              <value type="string" key="ea3bec44-acef-11e2-bdae-080027bcf912">source_id_scope</value>


  		




  
  17684
  
    
              <value type="string" key="e95a1e48-1de9-11e3-b571-080027bcf912">fk_party_list_entry_record1</value>


  		




  17816
  17685
  
    
              <value type="string" key="eb778868-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1</value>


  		




  17817
  17686
  
    
              <value type="string" key="eb778aac-ad01-11e2-b309-080027bcf912">collection_event</value>


  		




  17818
  17687
  
    
              <value type="string" key="eb77b1da-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1_idx</value>


  		




  ......




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		












  

    
      schemas/VegCore/VegCore.my.sql
    
  





  84
  84
  
    
  UNIQUE KEY `collection_unique` (`institution`,`name`),


  		




  85
  85
  
    
  KEY `fk_collection_organization1_idx` (`institution`),


  		




  86
  86
  
    
  KEY `fk_collection_source1_idx` (`id`),


  		




  87
  
  
    
  CONSTRAINT `fk_collection_organization1` FOREIGN KEY (`institution`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  88
  
  
    
  CONSTRAINT `fk_collection_source1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  87
  
    
  CONSTRAINT `fk_collection_source1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  88
  
    
  CONSTRAINT `fk_collection_organization1` FOREIGN KEY (`institution`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  89
  89
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"the collection within the institution where a specimen is held" ("Brad Boyle":https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/collectionCode)';


  		




  90
  90
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  91
  91
  
    

  		




  ......




  107
  107
  
    
  `name` varbinary(767) NOT NULL,


  		




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


  		




  109
  109
  
    
  PRIMARY KEY (`id`),


  		




  110
  
  
    
  CONSTRAINT `fk_community_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  110
  
    
  CONSTRAINT `fk_community_record1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  111
  111
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A community type is an abstract grouping of organisms that tend to co-occur on the landscape due to shared ecological requirements or preferences. May be designated by syntaxon or physiognomic types." ([[VegCore#VegX|VegX]])';


  		




  112
  112
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  113
  113
  
    

  		




  ......




  155
  155
  
    
  KEY `fk_event_place1_idx` (`place`),


  		




  156
  156
  
    
  KEY `fk_event1_idx` (`parent`),


  		




  157
  157
  
    
  KEY `fk_event_party_list1_idx` (`participants`),


  		




  
  158
  
    
  CONSTRAINT `fk_event_party_list1` FOREIGN KEY (`participants`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  159
  
    
  CONSTRAINT `fk_event_record1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  158
  160
  
    
  CONSTRAINT `fk_event1` FOREIGN KEY (`parent`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  159
  
  
    
  CONSTRAINT `fk_event_party_list1` FOREIGN KEY (`participants`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  160
  
  
    
  CONSTRAINT `fk_event_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  161
  
  
    
  CONSTRAINT `fk_event_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  161
  
    
  CONSTRAINT `fk_event_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  162
  162
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"an action that occurs at a place and during a period of time" ("DwC":http://rs.tdwg.org/dwc/terms/#Event)';


  		




  163
  163
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  164
  164
  
    

  		




  ......




  180
  180
  
    
  `name` varbinary(767) NOT NULL,


  		




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


  		




  182
  182
  
    
  PRIMARY KEY (`id`),


  		




  183
  
  
    
  CONSTRAINT `fk_geological_context_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  183
  
    
  CONSTRAINT `fk_geological_context_record1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  184
  184
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"information pertaining to a location within a geological context, such as stratigraphy" ("DwC":http://rs.tdwg.org/dwc/terms/#GeologicalContext)';


  		




  185
  185
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  186
  186
  
    

  		




  ......




  256
  256
  
    
  KEY `fk_georef_place1_idx` (`input_place`),


  		




  257
  257
  
    
  KEY `fk_georeferencing_party_list1_idx` (`georeferenced_by`),


  		




  258
  258
  
    
  KEY `fk_georeferencing_geoplace1_idx` (`geoplace`),


  		




  
  259
  
    
  CONSTRAINT `fk_geovalidation_record100` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  259
  260
  
    
  CONSTRAINT `fk_georeferencing_geoplace1` FOREIGN KEY (`geoplace`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  260
  261
  
    
  CONSTRAINT `fk_georeferencing_party_list1` FOREIGN KEY (`georeferenced_by`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  261
  
  
    
  CONSTRAINT `fk_georef_place1` FOREIGN KEY (`input_place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  262
  
  
    
  CONSTRAINT `fk_geovalidation_record100` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  262
  
    
  CONSTRAINT `fk_georef_place1` FOREIGN KEY (`input_place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  263
  263
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='also stored GNRS results';


  		




  264
  264
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  265
  265
  
    

  		




  ......




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


  		




  440
  440
  
    
  PRIMARY KEY (`id`),


  		




  441
  441
  
    
  KEY `fk_method_method1_idx` (`parent`),


  		




  442
  
  
    
  CONSTRAINT `fk_method_method1` FOREIGN KEY (`parent`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  443
  
  
    
  CONSTRAINT `fk_method_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  442
  
    
  CONSTRAINT `fk_method_record1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  443
  
    
  CONSTRAINT `fk_method_method1` FOREIGN KEY (`parent`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  444
  444
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A specific method definition followed in the creation of the dataset. Each method links to a protocol and literature citation reference. A protocol may have many method or steps." ("VegX":http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/methods/method)';


  		




  445
  445
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  446
  446
  
    

  		




  ......




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


  		




  485
  485
  
    
  PRIMARY KEY (`id`),


  		




  486
  486
  
    
  KEY `fk_party_organization1_idx` (`organization`),


  		




  487
  
  
    
  CONSTRAINT `fk_collection_source10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




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


  		




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


  		




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


  		




  489
  489
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


  		




  490
  490
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  491
  491
  
    

  		




  ......




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


  		




  507
  507
  
    
  `count` int(11) NOT NULL,


  		




  508
  508
  
    
  PRIMARY KEY (`id`),


  		




  509
  
  
    
  CONSTRAINT `fk_collection_source100` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  509
  
    
  CONSTRAINT `fk_collection_source100` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  510
  510
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


  		




  511
  511
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  512
  512
  
    

  		




  ......




  532
  532
  
    
  PRIMARY KEY (`id`),


  		




  533
  533
  
    
  KEY `fk_party_list_has_party_party1_idx` (`party`),


  		




  534
  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,


  		




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


  		




  536
  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


  		




  
  537
  
    
  CONSTRAINT `fk_party_list_entry_record1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




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


  		




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


  		




  540
  540
  
    

  		




  ......




  562
  562
  
    
  PRIMARY KEY (`id`),


  		




  563
  563
  
    
  KEY `fk_place1_idx` (`parent`),


  		




  564
  564
  
    
  KEY `fk_place_geopath1_idx` (`geopath`),


  		




  
  565
  
    
  CONSTRAINT `fk_place_record1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  565
  566
  
    
  CONSTRAINT `fk_place1` FOREIGN KEY (`parent`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  566
  
  
    
  CONSTRAINT `fk_place_geopath1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  567
  
  
    
  CONSTRAINT `fk_place_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  567
  
    
  CONSTRAINT `fk_place_geopath1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  568
  568
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A spatial region" ("DwC":http://rs.tdwg.org/dwc/terms/#dcterms:Location) or point';


  		




  569
  569
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  570
  570
  
    

  		




  ......




  667
  667
  
    
CREATE TABLE `record` (


  		




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


  		




  669
  669
  
    
  `source` varbinary(767) NOT NULL,


  		




  670
  
  
    
  `source_id_scope` varbinary(767) DEFAULT NULL,


  		




  671
  670
  
    
  `source_record_id` varbinary(767) DEFAULT NULL,


  		




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


  		




  673
  671
  
    
  PRIMARY KEY (`id`),


  		




  674
  
  
    
  UNIQUE KEY `record_unique` (`source`,`source_id_scope`,`source_record_id`),


  		




  
  672
  
    
  UNIQUE KEY `record_unique` (`source`,`source_record_id`),


  		




  675
  673
  
    
  KEY `fk_record_source1_idx` (`source`),


  		




  676
  
  
    
  CONSTRAINT `fk_record_source1` FOREIGN KEY (`source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  674
  
    
  CONSTRAINT `fk_record_source10` FOREIGN KEY (`source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  675
  
    
  CONSTRAINT `fk_record_source2` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  677
  676
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


  		




  678
  677
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  679
  678
  
    

  		




  ......




  693
  692
  
    
CREATE TABLE `referenced_class` (


  		




  694
  693
  
    
  `id` varbinary(767) NOT NULL,


  		




  695
  694
  
    
  PRIMARY KEY (`id`),


  		




  696
  
  
    
  CONSTRAINT `fk_example_record10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  695
  
    
  CONSTRAINT `fk_example_record10` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  697
  696
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


  		




  698
  697
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  699
  698
  
    

  		




  ......




  705
  704
  
    
/*!40000 ALTER TABLE `referenced_class` ENABLE KEYS */;


  		




  706
  705
  
    

  		




  707
  706
  
    
--


  		




  708
  
  
    
-- Table structure for table `relationship`


  		




  709
  
  
    
--


  		




  710
  
  
    

  		




  711
  
  
    
/*!40101 SET @saved_cs_client     = @@character_set_client */;


  		




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


  		




  713
  
  
    
CREATE TABLE `relationship` (


  		




  714
  
  
    
  `id` varbinary(767) NOT NULL,


  		




  715
  
  
    
  `record` varbinary(767) NOT NULL,


  		




  716
  
  
    
  `related_record` varbinary(767) NOT NULL,


  		




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


  		




  718
  
  
    
  PRIMARY KEY (`id`),


  		




  719
  
  
    
  KEY `fk_relationship_record1_idx` (`record`),


  		




  720
  
  
    
  KEY `fk_relationship_related_record_idx` (`related_record`),


  		




  721
  
  
    
  CONSTRAINT `fk_relationship_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  722
  
  
    
  CONSTRAINT `fk_relationship_record2` FOREIGN KEY (`record`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  723
  
  
    
  CONSTRAINT `fk_relationship_related_record` FOREIGN KEY (`related_record`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  724
  
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"information pertaining to relationships between resources (instances of data records, such as Occurrences, Taxa, Locations, Events)" ("DwC":http://rs.tdwg.org/dwc/terms/#ResourceRelationship)';


  		




  725
  
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  726
  
  
    

  		




  727
  
  
    
--


  		




  728
  
  
    
-- Dumping data for table `relationship`


  		




  729
  
  
    
--


  		




  730
  
  
    

  		




  731
  
  
    
/*!40000 ALTER TABLE `relationship` DISABLE KEYS */;


  		




  732
  
  
    
/*!40000 ALTER TABLE `relationship` ENABLE KEYS */;


  		




  733
  
  
    

  		




  734
  
  
    
--


  		




  735
  707
  
    
-- Table structure for table `reobservable`


  		




  736
  708
  
    
--


  		




  737
  709
  
    

  		




  ......




  815
  787
  
    
  PRIMARY KEY (`id`),


  		




  816
  788
  
    
  KEY `fk_soil_observation_place_observation1_idx` (`place_observation`),


  		




  817
  789
  
    
  KEY `fk_soil_observation_subplace1_idx` (`measurement_spot`),


  		




  818
  
  
    
  CONSTRAINT `fk_soil_observation_place_observation1` FOREIGN KEY (`place_observation`) REFERENCES `place_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  819
  
  
    
  CONSTRAINT `fk_soil_observation_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  820
  
  
    
  CONSTRAINT `fk_soil_observation_subplace1` FOREIGN KEY (`measurement_spot`) REFERENCES `subplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  790
  
    
  CONSTRAINT `fk_soil_observation_subplace1` FOREIGN KEY (`measurement_spot`) REFERENCES `subplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  791
  
    
  CONSTRAINT `fk_soil_observation_record1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  792
  
    
  CONSTRAINT `fk_soil_observation_place_observation1` FOREIGN KEY (`place_observation`) REFERENCES `place_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  821
  793
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]''s soil';


  		




  822
  794
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  823
  795
  
    

  		




  ......




  1146
  1118
  
    
  PRIMARY KEY (`id`),


  		




  1147
  1119
  
    
  KEY `fk_taxon_assertion_taxon_string1_idx` (`string`),


  		




  1148
  1120
  
    
  KEY `fk_taxon_assertion_taxon_name1_idx` (`taxon`),


  		




  1149
  
  
    
  CONSTRAINT `fk_qualified_taxon_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  1150
  
  
    
  CONSTRAINT `fk_taxon_assertion_taxon_name1` FOREIGN KEY (`taxon`) REFERENCES `taxon_name` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  1151
  
  
    
  CONSTRAINT `fk_taxon_assertion_taxon_string1` FOREIGN KEY (`string`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  1121
  
    
  CONSTRAINT `fk_qualified_taxon_record1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  1122
  
    
  CONSTRAINT `fk_taxon_assertion_taxon_string1` FOREIGN KEY (`string`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  1123
  
    
  CONSTRAINT `fk_taxon_assertion_taxon_name1` FOREIGN KEY (`taxon`) REFERENCES `taxon_name` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  1152
  1124
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


  		




  1153
  1125
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  1154
  1126
  
    

  		




  ......




  1235
  1207
  
    
  PRIMARY KEY (`id`),


  		




  1236
  1208
  
    
  KEY `fk_taxon_concept_taxon_string10_idx` (`unique_name`),


  		




  1237
  1209
  
    
  KEY `fk_taxon_name_taxon_path1_idx` (`taxon_path`),


  		




  
  1210
  
    
  CONSTRAINT `fk_taxon_record10` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  1238
  1211
  
    
  CONSTRAINT `fk_taxon_concept_taxon_string10` FOREIGN KEY (`unique_name`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  1239
  
  
    
  CONSTRAINT `fk_taxon_name_taxon_path1` FOREIGN KEY (`taxon_path`) REFERENCES `taxon_path` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  1240
  
  
    
  CONSTRAINT `fk_taxon_record10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  1212
  
    
  CONSTRAINT `fk_taxon_name_taxon_path1` FOREIGN KEY (`taxon_path`) REFERENCES `taxon_path` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  1241
  1213
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


  		




  1242
  1214
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  1243
  1215
  
    

  		




  ......




  1297
  1269
  
    
  PRIMARY KEY (`id`),


  		




  1298
  1270
  
    
  KEY `fk_taxon_occurrence_taxon_determination3_idx` (`current_observation`),


  		




  1299
  1271
  
    
  KEY `fk_taxon_occurrence_place1_idx` (`within_place`),


  		




  1300
  
  
    
  CONSTRAINT `fk_taxon_occurrence_place1` FOREIGN KEY (`within_place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  1301
  
  
    
  CONSTRAINT `fk_taxon_occurrence_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  1302
  
  
    
  CONSTRAINT `fk_taxon_occurrence_taxon_determination3` FOREIGN KEY (`current_observation`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  1272
  
    
  CONSTRAINT `fk_taxon_occurrence_taxon_determination3` FOREIGN KEY (`current_observation`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  1273
  
    
  CONSTRAINT `fk_taxon_occurrence_record1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  1274
  
    
  CONSTRAINT `fk_taxon_occurrence_place1` FOREIGN KEY (`within_place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  1303
  1275
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


  		




  1304
  1276
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  1305
  1277
  
    

  		




  ......




  1372
  1344
  
    
  KEY `fk_parsed_taxon_assertion_taxon_name1_idx` (`matched_taxon_concept`),


  		




  1373
  1345
  
    
  KEY `fk_taxon_scrub_taxon_assertion1_idx` (`parsed_taxon_assertion`),


  		




  1374
  1346
  
    
  KEY `fk_taxon_scrub_taxon_string1_idx` (`input_string`),


  		




  
  1347
  
    
  CONSTRAINT `fk_taxon_scrub_record1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  1375
  1348
  
    
  CONSTRAINT `fk_parsed_taxon_assertion_taxon_name1` FOREIGN KEY (`matched_taxon_concept`) REFERENCES `taxon_concept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  1376
  
  
    
  CONSTRAINT `fk_taxon_scrub_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  1377
  1349
  
    
  CONSTRAINT `fk_taxon_scrub_taxon_assertion1` FOREIGN KEY (`parsed_taxon_assertion`) REFERENCES `taxon_assertion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  1378
  1350
  
    
  CONSTRAINT `fk_taxon_scrub_taxon_string1` FOREIGN KEY (`input_string`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  1379
  1351
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


  		




  ......




  1404
  1376
  
    

  		




  1405
  1377
  
    
/*!40000 ALTER TABLE `taxon_string` DISABLE KEYS */;


  		




  1406
  1378
  
    
/*!40000 ALTER TABLE `taxon_string` ENABLE KEYS */;


  		




  
  1379
  
    

  		




  
  1380
  
    
--


  		




  
  1381
  
    
-- Table structure for table `traceable`


  		




  
  1382
  
    
--


  		




  
  1383
  
    

  		




  
  1384
  
    
/*!40101 SET @saved_cs_client     = @@character_set_client */;


  		




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


  		




  
  1386
  
    
CREATE TABLE `traceable` (


  		




  
  1387
  
    
  `id` varbinary(767) NOT NULL,


  		




  
  1388
  
    
  `source` varbinary(767) DEFAULT NULL,


  		




  
  1389
  
    
  PRIMARY KEY (`id`),


  		




  
  1390
  
    
  UNIQUE KEY `record_unique` (`source`),


  		




  
  1391
  
    
  KEY `fk_record_source1_idx` (`source`),


  		




  
  1392
  
    
  CONSTRAINT `fk_record_source1` FOREIGN KEY (`source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  1393
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


  		




  
  1394
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  
  1395
  
    

  		




  
  1396
  
    
--


  		




  
  1397
  
    
-- Dumping data for table `traceable`


  		




  
  1398
  
    
--


  		




  
  1399
  
    

  		




  
  1400
  
    
/*!40000 ALTER TABLE `traceable` DISABLE KEYS */;


  		




  
  1401
  
    
/*!40000 ALTER TABLE `traceable` ENABLE KEYS */;


  		




  1407
  1402
  
    
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;


  		




  1408
  1403
  
    

  		




  1409
  1404
  
    
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;


  		












Also available in:  Unified diff