Project

General

Profile

« Previous | Next » 

Revision 10975

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: source: split into source and dataset tables, since many of the source fields (first_publisher, data_owners, contacts) were only applicable to datasets. note that a dataset is specifically something requiring attribution, while a source just indicates where something came from. non-dataset sources are useful e.g. as the taxon_concept.according_to.

View differences:

schemas/VegCore/VegCore.pg.sql
38 38 
  "traits" hstore DEFAULT NULL,
39 39 
  PRIMARY KEY ("id"),
40 40 
  /*KEY "fk_aggregate_observation_taxa_sampling_event1_idx" ("sampling_event")*/CHECK (true),
41 
  /*CONSTRAINT "fk_aggregate_observation_taxa_sampling_event1" FOREIGN KEY ("sampling_event") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
42 
  /*CONSTRAINT "fk_taxon_presence_taxon_determination10" FOREIGN KEY ("id") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
41 
  /*CONSTRAINT "fk_taxon_presence_taxon_determination10" FOREIGN KEY ("id") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
42 
  /*CONSTRAINT "fk_aggregate_observation_taxa_sampling_event1" FOREIGN KEY ("sampling_event") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
43 43 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
44 44 
/*!40101 SET character_set_client = @saved_cs_client */;
45 45 

  		




  ......




  121
  121
  
    
/*!40000 ALTER TABLE "community" ENABLE KEYS */;


  		




  122
  122
  
    

  		




  123
  123
  
    
--


  		




  
  124
  
    
-- Table structure for table "dataset"


  		




  
  125
  
    
--


  		




  
  126
  
    

  		




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


  		




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


  		




  
  129
  
    
CREATE TABLE "dataset" (


  		




  
  130
  
    
  "id" text NOT NULL,


  		




  
  131
  
    
  "first_publisher" text DEFAULT NULL,


  		




  
  132
  
    
  "data_owners" text DEFAULT NULL /*COMMENT 'parties who must be given attribution, such as copyrightholders'*/,


  		




  
  133
  
    
  "contacts" text DEFAULT NULL,


  		




  
  134
  
    
  "info" hstore DEFAULT NULL,


  		




  
  135
  
    
  PRIMARY KEY ("id"),


  		




  
  136
  
    
  /*KEY "fk_source_party2_idx" ("first_publisher")*/CHECK (true),


  		




  
  137
  
    
  /*KEY "fk_source_party_list1_idx" ("data_owners")*/CHECK (true),


  		




  
  138
  
    
  /*KEY "fk_source_party1_idx" ("contacts")*/CHECK (true),


  		




  
  139
  
    
  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  140
  
    
  /*CONSTRAINT "fk_source_party_list1" FOREIGN KEY ("data_owners") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  141
  
    
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




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


  		




  
  143
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='something requiring attribution'*/;


  		




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


  		




  
  145
  
    

  		




  
  146
  
    
--


  		




  
  147
  
    
-- Dumping data for table "dataset"


  		




  
  148
  
    
--


  		




  
  149
  
    

  		




  
  150
  
    
/*!40000 ALTER TABLE "dataset" DISABLE KEYS */;


  		




  
  151
  
    
/*!40000 ALTER TABLE "dataset" ENABLE KEYS */;


  		




  
  152
  
    

  		




  
  153
  
    
--


  		




  124
  154
  
    
-- Table structure for table "derived_class"


  		




  125
  155
  
    
--


  		




  126
  156
  
    

  		




  ......




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


  		




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


  		




  160
  190
  
    
  /*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),


  		




  162
  191
  
    
  /*CONSTRAINT "fk_event1" FOREIGN KEY ("parent") REFERENCES "event" ("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)


  		




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


  		




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


  		




  164
  194
  
    
) /*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
  195
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  166
  196
  
    

  		




  ......




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


  		




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


  		




  260
  290
  
    
  /*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),


  		




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


  		




  263
  292
  
    
  /*CONSTRAINT "fk_georeferencing_party_list1" FOREIGN KEY ("georeferenced_by") REFERENCES "party_list" ("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)


  		




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


  		




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


  		




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


  		




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


  		




  267
  297
  
    

  		




  ......




  283
  313
  
    
  "parent_geoplace" text NOT NULL,


  		




  284
  314
  
    
  PRIMARY KEY ("id"),


  		




  285
  315
  
    
  /*KEY "fk_geovalidatable_place_geoplace1_idx" ("parent_geoplace")*/CHECK (true),


  		




  286
  
  
    
  /*CONSTRAINT "fk_geovalidatable_place_geoplace1" FOREIGN KEY ("parent_geoplace") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  287
  
  
    
  /*CONSTRAINT "fk_nested_geoplace_geoplace1" FOREIGN KEY ("id") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  316
  
    
  /*CONSTRAINT "fk_nested_geoplace_geoplace1" FOREIGN KEY ("id") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  317
  
    
  /*CONSTRAINT "fk_geovalidatable_place_geoplace1" FOREIGN KEY ("parent_geoplace") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  288
  318
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores only scrubbed geoplaces (GADM places, and distinct point coordinates that GNRS says should be located within them)'*/;


  		




  289
  319
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  290
  320
  
    

  		




  ......




  364
  394
  
    
  PRIMARY KEY ("id"),


  		




  365
  395
  
    
  /*KEY "fk_aggregate_observation_taxon_presence1_idx" ("taxon")*/CHECK (true),


  		




  366
  396
  
    
  /*KEY "fk_aggregate_observation_size_class1_idx" ("size_class")*/CHECK (true),


  		




  367
  
  
    
  /*CONSTRAINT "fk_individual_count_taxon_presence1" FOREIGN KEY ("id") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  368
  397
  
    
  /*CONSTRAINT "fk_aggregate_observation_size_class1" FOREIGN KEY ("size_class") REFERENCES "size_class" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  369
  
  
    
  /*CONSTRAINT "fk_aggregate_observation_taxon_presence1" FOREIGN KEY ("taxon") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  398
  
    
  /*CONSTRAINT "fk_aggregate_observation_taxon_presence1" FOREIGN KEY ("taxon") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  399
  
    
  /*CONSTRAINT "fk_individual_count_taxon_presence1" FOREIGN KEY ("id") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  370
  400
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= stemCount.VegBank.vegpath.org'*/;


  		




  371
  401
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  372
  402
  
    

  		




  ......




  441
  471
  
    
  "info" hstore DEFAULT NULL,


  		




  442
  472
  
    
  PRIMARY KEY ("id"),


  		




  443
  473
  
    
  /*KEY "fk_method_method1_idx" ("parent")*/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)


  		




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


  		




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


  		




  446
  476
  
    
) /*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
  477
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  448
  478
  
    

  		




  ......




  564
  594
  
    
  PRIMARY KEY ("id"),


  		




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


  		




  566
  596
  
    
  /*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),


  		




  568
  597
  
    
  /*CONSTRAINT "fk_place1" FOREIGN KEY ("parent") REFERENCES "place" ("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)


  		




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


  		




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


  		




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


  		




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


  		




  572
  602
  
    

  		




  ......




  596
  626
  
    
  /*KEY "fk_place_observation_place1_idx" ("place")*/CHECK (true),


  		




  597
  627
  
    
  /*KEY "fk_place_observation_geological_context1_idx" ("geological_context")*/CHECK (true),


  		




  598
  628
  
    
  /*KEY "fk_place_observation_community1_idx" ("community")*/CHECK (true),


  		




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


  		




  
  630
  
    
  /*CONSTRAINT "fk_place_observation_geological_context1" FOREIGN KEY ("geological_context") REFERENCES "geological_context" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  599
  631
  
    
  /*CONSTRAINT "fk_place_observation_community1" FOREIGN KEY ("community") REFERENCES "community" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  600
  
  
    
  /*CONSTRAINT "fk_place_observation_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  601
  
  
    
  /*CONSTRAINT "fk_place_observation_geological_context1" FOREIGN KEY ("geological_context") REFERENCES "geological_context" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




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


  		




  
  632
  
    
  /*CONSTRAINT "fk_place_observation_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




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


  		




  604
  634
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  605
  635
  
    

  		




  ......




  668
  698
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  669
  699
  
    
CREATE TABLE "record" (


  		




  670
  700
  
    
  "id" text NOT NULL,


  		




  671
  
  
    
  "source" text NOT NULL,


  		




  672
  
  
    
  "source_record_id" text DEFAULT NULL,


  		




  
  701
  
    
  "dataset" text NOT NULL,


  		




  
  702
  
    
  "dataset_record_id" text NOT NULL,


  		




  673
  703
  
    
  PRIMARY KEY ("id"),


  		




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


  		




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


  		




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


  		




  
  704
  
    
  /*CONSTRAINT "record_unique" */UNIQUE ("dataset","dataset_record_id"),


  		




  
  705
  
    
  /*KEY "fk_record_source1_idx" ("dataset")*/CHECK (true),


  		




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


  		




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


  		




  678
  708
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='the record in the *source* data'*/;


  		




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


  		




  ......




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


  		




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


  		




  792
  822
  
    
  /*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
  
    
  /*CONSTRAINT "fk_soil_observation_place_observation1" FOREIGN KEY ("place_observation") REFERENCES "place_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




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


  		




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


  		




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


  		




  797
  827
  
    

  		




  ......




  811
  841
  
    
CREATE TABLE "source" (


  		




  812
  842
  
    
  "id" text NOT NULL,


  		




  813
  843
  
    
  "parent" text DEFAULT NULL,


  		




  814
  
  
    
  "name" text NOT NULL,


  		




  815
  
  
    
  "first_publisher" text DEFAULT NULL,


  		




  816
  
  
    
  "data_owners" text DEFAULT NULL /*COMMENT 'parties who must be given attribution, such as copyrightholders'*/,


  		




  817
  
  
    
  "contacts" text DEFAULT NULL,


  		




  
  844
  
    
  "name" text DEFAULT NULL,


  		




  818
  845
  
    
  "info" hstore DEFAULT NULL,


  		




  819
  846
  
    
  PRIMARY KEY ("id"),


  		




  820
  847
  
    
  /*CONSTRAINT "source_unique" */UNIQUE ("parent","name"),


  		




  821
  848
  
    
  /*KEY "fk_source1_idx" ("parent")*/CHECK (true),


  		




  822
  
  
    
  /*KEY "fk_source_party2_idx" ("first_publisher")*/CHECK (true),


  		




  823
  
  
    
  /*KEY "fk_source_party_list1_idx" ("data_owners")*/CHECK (true),


  		




  824
  
  
    
  /*KEY "fk_source_party1_idx" ("contacts")*/CHECK (true),


  		




  825
  
  
    
  /*CONSTRAINT "fk_source_party_list1" FOREIGN KEY ("data_owners") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  826
  
  
    
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  827
  
  
    
  /*CONSTRAINT "fk_source1" FOREIGN KEY ("parent") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  828
  
  
    
  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  829
  
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a "reference [...] cited within the database" ("VegBank":http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=reference&entity=dba_tabledescription&where=where_tablename)'*/;


  		




  
  849
  
    
  /*CONSTRAINT "fk_source10" FOREIGN KEY ("parent") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  850
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='where something came from; a "reference [...] cited within the database" ("VegBank":http://reference.VegBank.vegpath.org); = reference.VegBank.vegpath.org'*/;


  		




  830
  851
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  831
  852
  
    

  		




  832
  853
  
    
--


  		




  ......




  869
  890
  
    
  /*KEY "fk_specimen_party_list1_idx" ("specimenholder_institutions")*/CHECK (true),


  		




  870
  891
  
    
  /*KEY "fk_specimen_individual_observation1_idx" ("individual_observation")*/CHECK (true),


  		




  871
  892
  
    
  /*CONSTRAINT "fk_specimen_collection1" FOREIGN KEY ("orig_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  893
  
    
  /*CONSTRAINT "fk_specimen_individual_observation1" FOREIGN KEY ("individual_observation") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  872
  894
  
    
  /*CONSTRAINT "fk_specimen_collection2" FOREIGN KEY ("current_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  895
  
    
  /*CONSTRAINT "fk_specimen_party_list1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  896
  
    
  /*CONSTRAINT "fk_specimen_organization3" FOREIGN KEY ("owner_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  873
  897
  
    
  /*CONSTRAINT "fk_specimen_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  874
  
  
    
  /*CONSTRAINT "fk_specimen_individual_observation1" FOREIGN KEY ("individual_observation") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  875
  
  
    
  /*CONSTRAINT "fk_specimen_organization3" FOREIGN KEY ("owner_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  876
  
  
    
  /*CONSTRAINT "fk_specimen_party_list1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  877
  
  
    
  /*CONSTRAINT "fk_specimen_taxon_observation1" FOREIGN KEY ("collection_event") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  878
  
  
    
  /*CONSTRAINT "fk_specimen_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  898
  
    
  /*CONSTRAINT "fk_specimen_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  899
  
    
  /*CONSTRAINT "fk_specimen_taxon_observation1" FOREIGN KEY ("collection_event") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  879
  900
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='something collected from a plant. this can be a physical "part of a plant" ("Wikipedia":http://en.wikipedia.org/wiki/Specimen), or a picture or description of the plant. when there are multiple specimen replicates (copies) of a specimen, each gets its own specimen_observation pointing to the same specimen.'*/;


  		




  880
  901
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  881
  902
  
    

  		




  ......




  899
  920
  
    
  "traits" hstore DEFAULT NULL,


  		




  900
  921
  
    
  PRIMARY KEY ("id"),


  		




  901
  922
  
    
  /*KEY "fk_specimen_observation_specimen1_idx" ("specimen")*/CHECK (true),


  		




  902
  
  
    
  /*CONSTRAINT "fk_specimen_observation_specimen1" FOREIGN KEY ("specimen") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  903
  
  
    
  /*CONSTRAINT "fk_specimen_taxon_occurrence10" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  923
  
    
  /*CONSTRAINT "fk_specimen_taxon_occurrence10" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  924
  
    
  /*CONSTRAINT "fk_specimen_observation_specimen1" FOREIGN KEY ("specimen") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




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


  		




  905
  926
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  906
  927
  
    

  		




  ......




  949
  970
  
    
  /*CONSTRAINT "stem_observation_unique" */UNIQUE ("individual_observation","stem"),


  		




  950
  971
  
    
  /*KEY "fk_stem_observation_individual_observation1_idx" ("individual_observation")*/CHECK (true),


  		




  951
  972
  
    
  /*KEY "fk_stem_observation_stem1_idx" ("stem")*/CHECK (true),


  		




  
  973
  
    
  /*CONSTRAINT "fk_stem_observation_stem1" FOREIGN KEY ("stem") REFERENCES "stem" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  952
  974
  
    
  /*CONSTRAINT "fk_stem_observation_individual_observation1" FOREIGN KEY ("individual_observation") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  953
  
  
    
  /*CONSTRAINT "fk_stem_observation_individual_observation2" FOREIGN KEY ("id") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  954
  
  
    
  /*CONSTRAINT "fk_stem_observation_stem1" FOREIGN KEY ("stem") REFERENCES "stem" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  975
  
    
  /*CONSTRAINT "fk_stem_observation_individual_observation2" FOREIGN KEY ("id") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  955
  976
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of a [[VegCore#Stem|Stem]]'*/;


  		




  956
  977
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  957
  978
  
    

  		




  ......




  996
  1017
  
    
  PRIMARY KEY ("id"),


  		




  997
  1018
  
    
  /*KEY "fk_stratum_event_stratum1_idx" ("stratum")*/CHECK (true),


  		




  998
  1019
  
    
  /*KEY "fk_stratum_event_sampling_event2_idx" ("parent_event")*/CHECK (true),


  		




  
  1020
  
    
  /*CONSTRAINT "fk_stratum_event_stratum1" FOREIGN KEY ("stratum") REFERENCES "stratum" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  999
  1021
  
    
  /*CONSTRAINT "fk_stratum_event_sampling_event1" FOREIGN KEY ("id") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1000
  
  
    
  /*CONSTRAINT "fk_stratum_event_sampling_event2" FOREIGN KEY ("parent_event") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1001
  
  
    
  /*CONSTRAINT "fk_stratum_event_stratum1" FOREIGN KEY ("stratum") REFERENCES "stratum" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  1022
  
    
  /*CONSTRAINT "fk_stratum_event_sampling_event2" FOREIGN KEY ("parent_event") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  1002
  1023
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= stratum.VegBank.vegpath.org (which was confusingly named)'*/;


  		




  1003
  1024
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  1004
  1025
  
    

  		




  ......




  1023
  1044
  
    
  "coords" hstore DEFAULT NULL,


  		




  1024
  1045
  
    
  PRIMARY KEY ("id"),


  		




  1025
  1046
  
    
  /*KEY "fk_rel_place_place1_idx" ("parent")*/CHECK (true),


  		




  1026
  
  
    
  /*CONSTRAINT "fk_rel_place_place1" FOREIGN KEY ("parent") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




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


  		




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


  		




  
  1048
  
    
  /*CONSTRAINT "fk_rel_place_place1" FOREIGN KEY ("parent") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  1028
  1049
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores plot elements such as subplots ("subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot))'*/;


  		




  1029
  1050
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  1030
  1051
  
    

  		




  ......




  1076
  1097
  
    
  /*KEY "fk_taxa_sampling_event_project1_idx" ("project")*/CHECK (true),


  		




  1077
  1098
  
    
  /*CONSTRAINT "fk_taxa_sampling_event_project1" FOREIGN KEY ("project") REFERENCES "project" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1078
  1099
  
    
  /*CONSTRAINT "fk_project_event10" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1079
  
  
    
  /*CONSTRAINT "fk_sampling_event_method1" FOREIGN KEY ("method") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




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


  		




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


  		




  
  1101
  
    
  /*CONSTRAINT "fk_sampling_event_method1" FOREIGN KEY ("method") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  1081
  1102
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='for plots and aggregate_observations within them'*/;


  		




  1082
  1103
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  1083
  1104
  
    

  		




  ......




  1152
  1173
  
    
  /*KEY "fk_taxon_taxon1_idx" ("parent")*/CHECK (true),


  		




  1153
  1174
  
    
  /*KEY "fk_taxon_concept_source1_idx" ("according_to")*/CHECK (true),


  		




  1154
  1175
  
    
  /*KEY "fk_taxon_concept_taxon_concept1_idx" ("accepted_taxon_concept")*/CHECK (true),


  		




  1155
  
  
    
  /*CONSTRAINT "fk_taxon_concept_source1" FOREIGN KEY ("according_to") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  1176
  
    
  /*CONSTRAINT "fk_taxon_taxon1" FOREIGN KEY ("parent") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  1177
  
    
  /*CONSTRAINT "fk_taxon_concept_source1" FOREIGN KEY ("according_to") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1156
  1178
  
    
  /*CONSTRAINT "fk_taxon_concept_taxon_concept1" FOREIGN KEY ("accepted_taxon_concept") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1157
  
  
    
  /*CONSTRAINT "fk_taxon_concept_taxon_name1" FOREIGN KEY ("id") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1158
  
  
    
  /*CONSTRAINT "fk_taxon_taxon1" FOREIGN KEY ("parent") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  1179
  
    
  /*CONSTRAINT "fk_taxon_concept_taxon_name1" FOREIGN KEY ("id") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  1159
  1180
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A [[VegCore#Taxon|Taxon]] described by a specific [[VegCore#Reference|Reference]]'*/;


  		




  1160
  1181
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  1161
  1182
  
    

  		




  ......




  1181
  1202
  
    
  /*CONSTRAINT "taxon_determination_unique" */UNIQUE ("taxon_assertion","identified_by"),


  		




  1182
  1203
  
    
  /*KEY "fk_taxon_occurrence_has_qualified_taxon1_idx" ("taxon_assertion")*/CHECK (true),


  		




  1183
  1204
  
    
  /*KEY "fk_taxon_determination_party_list1_idx" ("identified_by")*/CHECK (true),


  		




  
  1205
  
    
  /*CONSTRAINT "fk_taxon_occurrence_has_qualified_taxon1" FOREIGN KEY ("taxon_assertion") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1184
  1206
  
    
  /*CONSTRAINT "fk_taxon_determination_party_list1" FOREIGN KEY ("identified_by") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1185
  
  
    
  /*CONSTRAINT "fk_taxon_determination_taxon_observation1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1186
  
  
    
  /*CONSTRAINT "fk_taxon_occurrence_has_qualified_taxon1" FOREIGN KEY ("taxon_assertion") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  1207
  
    
  /*CONSTRAINT "fk_taxon_determination_taxon_observation1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  1187
  1208
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]'*/;


  		




  1188
  1209
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  1189
  1210
  
    

  		




  ......




  1349
  1370
  
    
  /*KEY "fk_parsed_taxon_assertion_taxon_name1_idx" ("matched_taxon_concept")*/CHECK (true),


  		




  1350
  1371
  
    
  /*KEY "fk_taxon_scrub_taxon_assertion1_idx" ("parsed_taxon_assertion")*/CHECK (true),


  		




  1351
  1372
  
    
  /*KEY "fk_taxon_scrub_taxon_string1_idx" ("input_string")*/CHECK (true),


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  1357
  1378
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  1358
  1379
  
    

  		




  ......




  1393
  1414
  
    
  "source" text DEFAULT NULL,


  		




  1394
  1415
  
    
  PRIMARY KEY ("id"),


  		




  1395
  1416
  
    
  /*CONSTRAINT "record_unique" */UNIQUE ("source"),


  		




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


  		




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


  		




  1398
  1418
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a row that can have associated source information'*/;


  		




  1399
  1419
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		












  

    
      schemas/VegCore/document.mwb.xml
    
  





  2
  2
  
    
<data grt_format="2.0" document_type="MySQL Workbench Model" version="1.4.4">


  		




  3
  3
  
    
  <value type="object" struct-name="workbench.Document" id="DD51DD12-152C-46FD-90D9-84EB5F9F500F" struct-checksum="0x7131bf99">


  		




  4
  4
  
    
    <value type="object" struct-name="workbench.logical.Model" id="9FB30CD5-3D20-4492-935C-7986A48D7820" struct-checksum="0xf4220370" key="logicalModel">


  		




  5
  
  
    
      <value _ptr_="0xb1fe250" type="list" content-type="object" content-struct-name="workbench.logical.Diagram" key="diagrams"/>


  		




  6
  
  
    
      <value _ptr_="0xb1f6e58" type="dict" key="customData"/>


  		




  7
  
  
    
      <value _ptr_="0xb1fe520" type="list" content-type="object" content-struct-name="model.Marker" key="markers"/>


  		




  8
  
  
    
      <value _ptr_="0xb1fad00" type="dict" key="options"/>


  		




  
  5
  
    
      <value _ptr_="0xb4804e0" type="list" content-type="object" content-struct-name="workbench.logical.Diagram" key="diagrams"/>


  		




  
  6
  
    
      <value _ptr_="0xb478be0" type="dict" key="customData"/>


  		




  
  7
  
    
      <value _ptr_="0xb4807b0" type="list" content-type="object" content-struct-name="model.Marker" key="markers"/>


  		




  
  8
  
    
      <value _ptr_="0xb47ce70" type="dict" key="options"/>


  		




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


  		




  10
  10
  
    
      <link type="object" struct-name="GrtObject" key="owner">DD51DD12-152C-46FD-90D9-84EB5F9F500F</link>


  		




  11
  11
  
    
    </value>


  		




  12
  
  
    
    <value _ptr_="0xa68ef50" type="list" content-type="object" content-struct-name="workbench.OverviewPanel" key="overviewPanels"/>


  		




  13
  
  
    
    <value _ptr_="0xb1fe1c8" type="list" content-type="object" content-struct-name="workbench.physical.Model" key="physicalModels">


  		




  
  12
  
    
    <value _ptr_="0xaa28d20" type="list" content-type="object" content-struct-name="workbench.OverviewPanel" key="overviewPanels"/>


  		




  
  13
  
    
    <value _ptr_="0xb480458" type="list" content-type="object" content-struct-name="workbench.physical.Model" key="physicalModels">


  		




  14
  14
  
    
      <value type="object" struct-name="workbench.physical.Model" id="257B05AA-CE39-49DE-9522-6B703F985F32" struct-checksum="0x5f896d18">


  		




  15
  15
  
    
        <value type="object" struct-name="db.mysql.Catalog" id="42266085-54CC-4441-8553-68BBE0286A05" struct-checksum="0x82ad3466" key="catalog">


  		




  16
  
  
    
          <value _ptr_="0xb1ff328" type="list" content-type="object" content-struct-name="db.mysql.LogFileGroup" key="logFileGroups"/>


  		




  17
  
  
    
          <value _ptr_="0xb1ff3a0" type="list" content-type="object" content-struct-name="db.mysql.Schema" key="schemata">


  		




  
  16
  
    
          <value _ptr_="0xb4815b8" type="list" content-type="object" content-struct-name="db.mysql.LogFileGroup" key="logFileGroups"/>


  		




  
  17
  
    
          <value _ptr_="0xb481630" type="list" content-type="object" content-struct-name="db.mysql.Schema" key="schemata">


  		




  18
  18
  
    
            <value type="object" struct-name="db.mysql.Schema" id="be8cb246-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x20b94c22">


  		




  19
  
  
    
              <value _ptr_="0xb1ff5c0" type="list" content-type="object" content-struct-name="db.mysql.RoutineGroup" key="routineGroups"/>


  		




  20
  
  
    
              <value _ptr_="0xb1ff9a8" type="list" content-type="object" content-struct-name="db.mysql.Routine" key="routines"/>


  		




  21
  
  
    
              <value _ptr_="0xb1ff9d8" type="list" content-type="object" content-struct-name="db.mysql.Sequence" key="sequences"/>


  		




  22
  
  
    
              <value _ptr_="0xb1ffa30" type="list" content-type="object" content-struct-name="db.mysql.StructuredDatatype" key="structuredTypes"/>


  		




  23
  
  
    
              <value _ptr_="0xb1ffa60" type="list" content-type="object" content-struct-name="db.mysql.Synonym" key="synonyms"/>


  		




  24
  
  
    
              <value _ptr_="0xb1ffa90" type="list" content-type="object" content-struct-name="db.mysql.Table" key="tables">


  		




  
  19
  
    
              <value _ptr_="0xb481850" type="list" content-type="object" content-struct-name="db.mysql.RoutineGroup" key="routineGroups"/>


  		




  
  20
  
    
              <value _ptr_="0xb481c38" type="list" content-type="object" content-struct-name="db.mysql.Routine" key="routines"/>


  		




  
  21
  
    
              <value _ptr_="0xb481c68" type="list" content-type="object" content-struct-name="db.mysql.Sequence" key="sequences"/>


  		




  
  22
  
    
              <value _ptr_="0xb481cc0" type="list" content-type="object" content-struct-name="db.mysql.StructuredDatatype" key="structuredTypes"/>


  		




  
  23
  
    
              <value _ptr_="0xb481cf0" type="list" content-type="object" content-struct-name="db.mysql.Synonym" key="synonyms"/>


  		




  
  24
  
    
              <value _ptr_="0xb481d20" type="list" content-type="object" content-struct-name="db.mysql.Table" key="tables">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  37
  
  
    
                      <value _ptr_="0xb2006c8" type="list" content-type="string" key="flags"/>


  		




  
  37
  
    
                      <value _ptr_="0xb482958" type="list" content-type="string" key="flags"/>


  		




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


  		




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


  		




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


  		




  ......




  48
  48
  
    
                    <value type="object" struct-name="db.mysql.Column" id="e5502346-f676-11e2-9716-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  56
  
  
    
                      <value _ptr_="0xb200b40" type="list" content-type="string" key="flags"/>


  		




  
  56
  
    
                      <value _ptr_="0xb482dd0" type="list" content-type="string" key="flags"/>


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  75
  
  
    
                      <value _ptr_="0xb200fb8" type="list" content-type="string" key="flags"/>


  		




  
  75
  
    
                      <value _ptr_="0xb483248" type="list" content-type="string" key="flags"/>


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




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


  		




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


  		




  92
  92
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="e550209e-f676-11e2-9716-080027bcf912" struct-checksum="0x70a8fc40">


  		




  93
  93
  
    
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">049df920-a91b-11e2-bdec-080027bcf912</link>


  		




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


  		




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


  		




  95
  95
  
    
                        <link type="object">e5502346-f676-11e2-9716-080027bcf912</link>


  		




  96
  96
  
    
                      </value>


  		




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


  		




  ......




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  106
  106
  
    
                      </value>


  		




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


  		




  ......




  112
  112
  
    
                    </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  117
  117
  
    
                      </value>


  		




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


  		




  ......




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  127
  127
  
    
                      </value>


  		




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


  		




  ......




  132
  132
  
    
                      <value type="string" key="oldName">fk_collection_source10</value>


  		




  133
  133
  
    
                    </value>


  		




  134
  134
  
    
                  </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  138
  138
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="c37e8388-ac44-11e2-820d-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




  ......




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


  		




  158
  158
  
    
                    </value>


  		




  159
  159
  
    
                    <value type="object" struct-name="db.mysql.Index" id="e550389a-f676-11e2-9716-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




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


  		




  161
  161
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="e5503a2a-f676-11e2-9716-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




  243
  243
  
    
                    </value>


  		




  244
  
  
    
                    <value type="object" struct-name="db.mysql.Column" id="be8cc59c-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_="0xb203008" 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">1</value>


  		




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


  		




  253
  
  
    
                      <value type="int" key="isNotNull">0</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">parent</value>


  		




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


  		




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


  		




  262
  
  
    
                    </value>


  		




  263
  
  
    
                    <value type="object" struct-name="db.mysql.Column" id="d9b5781e-a90b-11e2-8576-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




  266
  
  
    
                      <value _ptr_="0xb203480" 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_="0xb2037a8" 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">name</value>


  		




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


  		




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


  		




  281
  
  
    
                    </value>


  		




  282
  244
  
    
                    <value type="object" struct-name="db.mysql.Column" id="c7c1e862-a91b-11e2-bdec-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  289
  251
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  ......




  301
  263
  
    
                    <value type="object" struct-name="db.mysql.Column" id="c8552b14-a7bc-11e2-8af2-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  308
  270
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




  309
  
  
    
                      <value _ptr_="0xb204098" type="list" content-type="string" key="flags"/>


  		




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


  		




  310
  272
  
    
                      <value type="int" key="isNotNull">0</value>


  		




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


  		




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


  		




  ......




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


  		




  315
  277
  
    
                      <value type="string" key="comment">parties who must be given attribution, such as copyrightholders</value>


  		




  316
  278
  
    
                      <value type="string" key="name">data_owners</value>


  		




  317
  
  
    
                      <value type="string" key="oldName">owners</value>


  		




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


  		




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


  		




  319
  281
  
    
                    </value>


  		




  320
  282
  
    
                    <value type="object" struct-name="db.mysql.Column" id="873d473c-1df1-11e3-bbb6-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  325
  287
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




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


  		




  327
  289
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




  328
  
  
    
                      <value _ptr_="0xbcd30e0" type="list" content-type="string" key="flags"/>


  		




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


  		




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


  		




  330
  292
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




  ......




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


  		




  340
  302
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  341
  303
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  343
  305
  
    
                      <value type="string" key="collationName"></value>


  		




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


  		




  345
  307
  
    
                      <value type="string" key="defaultValue"></value>


  		




  346
  308
  
    
                      <value type="int" key="defaultValueIsNull">0</value>


  		




  347
  
  
    
                      <value _ptr_="0xb204510" type="list" content-type="string" key="flags"/>


  		




  
  309
  
    
                      <value _ptr_="0xb486328" type="list" content-type="string" key="flags"/>


  		




  348
  310
  
    
                      <value type="int" key="isNotNull">0</value>


  		




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


  		




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


  		




  ......




  360
  322
  
    
                  <value type="string" key="defaultCharacterSetName">utf8</value>


  		




  361
  323
  
    
                  <value type="string" key="defaultCollationName">utf8_bin</value>


  		




  362
  324
  
    
                  <value type="int" key="delayKeyWrite">0</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  368
  
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  378
  
  
    
                      </value>


  		




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


  		




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


  		




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


  		




  382
  
  
    
                      <value type="string" key="name">fk_source1</value>


  		




  383
  
  
    
                      <value type="string" key="oldName">fk_source1</value>


  		




  384
  
  
    
                    </value>


  		




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


  		




  385
  326
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="c7c1e6aa-a91b-11e2-bdec-080027bcf912" struct-checksum="0x70a8fc40">


  		




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


  		




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


  		




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


  		




  388
  329
  
    
                        <link type="object">c7c1e862-a91b-11e2-bdec-080027bcf912</link>


  		




  389
  330
  
    
                      </value>


  		




  390
  331
  
    
                      <value type="int" key="deferability">0</value>


  		




  ......




  394
  335
  
    
                      <value type="int" key="many">1</value>


  		




  395
  336
  
    
                      <value type="int" key="modelOnly">0</value>


  		




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


  		




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


  		




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


  		




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


  		




  399
  340
  
    
                      </value>


  		




  400
  341
  
    
                      <value type="int" key="referencedMandatory">0</value>


  		




  ......




  405
  346
  
    
                    </value>


  		




  406
  347
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="61c193a8-1dee-11e3-b571-080027bcf912" struct-checksum="0x70a8fc40">


  		




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


  		




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


  		




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


  		




  409
  350
  
    
                        <link type="object">c8552b14-a7bc-11e2-8af2-080027bcf912</link>


  		




  410
  351
  
    
                      </value>


  		




  411
  352
  
    
                      <value type="int" key="deferability">0</value>


  		




  ......




  415
  356
  
    
                      <value type="int" key="many">1</value>


  		




  416
  357
  
    
                      <value type="int" key="modelOnly">0</value>


  		




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


  		




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


  		




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


  		




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


  		




  420
  361
  
    
                      </value>


  		




  421
  362
  
    
                      <value type="int" key="referencedMandatory">0</value>


  		




  ......




  426
  367
  
    
                    </value>


  		




  427
  368
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="873d44bc-1df1-11e3-bbb6-080027bcf912" struct-checksum="0x70a8fc40">


  		




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


  		




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


  		




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


  		




  430
  371
  
    
                        <link type="object">873d473c-1df1-11e3-bbb6-080027bcf912</link>


  		




  431
  372
  
    
                      </value>


  		




  432
  373
  
    
                      <value type="int" key="deferability">0</value>


  		




  ......




  436
  377
  
    
                      <value type="int" key="many">1</value>


  		




  437
  378
  
    
                      <value type="int" key="modelOnly">0</value>


  		




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


  		




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


  		




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


  		




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


  		




  441
  382
  
    
                      </value>


  		




  442
  383
  
    
                      <value type="int" key="referencedMandatory">0</value>


  		




  ......




  445
  386
  
    
                      <value type="string" key="name">fk_source_party1</value>


  		




  446
  387
  
    
                      <value type="string" key="oldName">fk_source_party1</value>


  		




  447
  388
  
    
                    </value>


  		




  
  389
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="7e2aa84c-1dfb-11e3-bbb6-080027bcf912" struct-checksum="0x70a8fc40">


  		




  
  390
  
    
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">afc401d4-1df9-11e3-bbb6-080027bcf912</link>


  		




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


  		




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


  		




  
  393
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  401
  
    
                        <link type="object">afc4053a-1df9-11e3-bbb6-080027bcf912</link>


  		




  
  402
  
    
                      </value>


  		




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


  		




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


  		




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


  		




  
  406
  
    
                      <value type="string" key="name">fk_dataset_source1</value>


  		




  
  407
  
    
                      <value type="string" key="oldName">fk_dataset_source1</value>


  		




  
  408
  
    
                    </value>


  		




  448
  409
  
    
                  </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  453
  414
  
    
                          <value type="int" key="columnLength">0</value>


  		




  454
  415
  
    
                          <value type="string" key="comment"></value>


  		




  ......




  470
  431
  
    
                      <value type="string" key="oldName">PRIMARY</value>


  		




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


  		




  472
  433
  
    
                    </value>


  		




  473
  
  
    
                    <value type="object" struct-name="db.mysql.Index" id="11c10cc8-a90c-11e2-8576-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




  475
  
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="151fbf2c-a90c-11e2-8576-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  481
  
  
    
                          <link type="object" struct-name="GrtObject" key="owner">11c10cc8-a90c-11e2-8576-080027bcf912</link>


  		




  482
  
  
    
                        </value>


  		




  483
  
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="156de03a-a90c-11e2-8576-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




  487
  
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">d9b5781e-a90b-11e2-8576-080027bcf912</link>


  		




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


  		




  489
  
  
    
                          <link type="object" struct-name="GrtObject" key="owner">11c10cc8-a90c-11e2-8576-080027bcf912</link>


  		




  490
  
  
    
                        </value>


  		




  491
  
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  499
  
  
    
                      <value type="string" key="name">source_unique</value>


  		




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


  		




  501
  
  
    
                      <value type="string" key="oldName">source_unique</value>


  		




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


  		




  503
  
  
    
                    </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  513
  
  
    
                        </value>


  		




  514
  
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  522
  
  
    
                      <value type="string" key="name">fk_source1_idx</value>


  		




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


  		




  524
  
  
    
                      <value type="string" key="oldName">fk_source1_idx</value>


  		




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


  		




  526
  
  
    
                    </value>


  		




  527
  434
  
    
                    <value type="object" struct-name="db.mysql.Index" id="c7c2089c-a91b-11e2-bdec-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




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


  		




  529
  436
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="c7c20a4a-a91b-11e2-bdec-080027bcf912" struct-checksum="0x62630b3c">


  		




  530
  437
  
    
                          <value type="int" key="columnLength">0</value>


  		




  531
  438
  
    
                          <value type="string" key="comment"></value>


  		




  ......




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


  		




  549
  456
  
    
                    </value>


  		




  550
  457
  
    
                    <value type="object" struct-name="db.mysql.Index" id="61c1b04a-1dee-11e3-b571-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




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


  		




  552
  459
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="61c1e9d4-1dee-11e3-b571-080027bcf912" struct-checksum="0x62630b3c">


  		




  553
  460
  
    
                          <value type="int" key="columnLength">0</value>


  		




  554
  461
  
    
                          <value type="string" key="comment"></value>


  		




  ......




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


  		




  572
  479
  
    
                    </value>


  		




  573
  480
  
    
                    <value type="object" struct-name="db.mysql.Index" id="d2855d46-1df2-11e3-bbb6-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




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


  		




  575
  482
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="d2867b72-1df2-11e3-bbb6-080027bcf912" struct-checksum="0x62630b3c">


  		




  576
  483
  
    
                          <value type="int" key="columnLength">0</value>


  		




  577
  484
  
    
                          <value type="string" key="comment"></value>


  		




  ......




  601
  508
  
    
                  <value type="string" key="nextAutoInc"></value>


  		




  602
  509
  
    
                  <value type="string" key="packKeys"></value>


  		




  603
  510
  
    
                  <value type="int" key="partitionCount">0</value>


  		




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


  		




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


  		




  605
  512
  
    
                  <value type="string" key="partitionExpression"></value>


  		




  606
  513
  
    
                  <value type="string" key="partitionType"></value>


  		




  607
  514
  
    
                  <value type="string" key="password"></value>


  		




  ......




  616
  523
  
    
                  <value type="string" key="tableDataDir"></value>


  		




  617
  524
  
    
                  <value type="string" key="tableEngine">InnoDB</value>


  		




  618
  525
  
    
                  <value type="string" key="tableIndexDir"></value>


  		




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


  		




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


  		




  620
  527
  
    
                  <value type="int" key="isStub">0</value>


  		




  621
  528
  
    
                  <value type="int" key="isSystem">0</value>


  		




  622
  529
  
    
                  <value type="int" key="isTemporary">0</value>


  		




  623
  530
  
    
                  <value type="string" key="temporaryScope"></value>


  		




  624
  531
  
    
                  <value type="int" key="commentedOut">0</value>


  		




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


  		




  626
  
  
    
                  <value _ptr_="0xb1fbb70" type="dict" key="customData"/>


  		




  627
  
  
    
                  <value type="string" key="lastChangeDate">2013-09-15 03:47</value>


  		




  
  533
  
    
                  <value _ptr_="0xb47dce0" type="dict" key="customData"/>


  		




  
  534
  
    
                  <value type="string" key="lastChangeDate">2013-09-15 04:36</value>


  		




  628
  535
  
    
                  <value type="int" key="modelOnly">0</value>


  		




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


  		




  
  536
  
    
                  <value type="string" key="name">dataset</value>


  		




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


  		




  631
  538
  
    
                  <value type="string" key="temp_sql"></value>


  		




  632
  
  
    
                  <value type="string" key="comment">a "reference [...] cited within the database" ("VegBank":http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&amp;wparam=reference&amp;entity=dba_tabledescription&amp;where=where_tablename)</value>


  		




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


  		




  
  539
  
    
                  <value type="string" key="comment">something requiring attribution</value>


  		




  
  540
  
    
                  <value type="string" key="oldName">dataset</value>


  		




  634
  541
  
    
                </value>


  		




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


  		




  636
  543
  
    
                  <value type="string" key="avgRowLength"></value>


  		




  637
  544
  
    
                  <value type="int" key="checksum">0</value>


  		




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


  		




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


  		




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


  		




  640
  547
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  641
  548
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  643
  550
  
    
                      <value type="string" key="collationName"></value>


  		




  644
  551
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  645
  552
  
    
                      <value type="string" key="defaultValue"></value>


  		




  646
  553
  
    
                      <value type="int" key="defaultValueIsNull">0</value>


  		




  647
  
  
    
                      <value _ptr_="0xa6acd90" type="list" content-type="string" key="flags"/>


  		




  
  554
  
    
                      <value _ptr_="0xb489548" type="list" content-type="string" key="flags"/>


  		




  648
  555
  
    
                      <value type="int" key="isNotNull">1</value>


  		




  649
  556
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




  ......




  658
  565
  
    
                    <value type="object" struct-name="db.mysql.Column" id="ed1eb468-ad0e-11e2-b309-080027bcf912" struct-checksum="0x783b5183">


  		




  659
  566
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  660
  567
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  662
  569
  
    
                      <value type="string" key="collationName"></value>


  		




  663
  570
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  664
  571
  
    
                      <value type="string" key="defaultValue"></value>


  		




  665
  572
  
    
                      <value type="int" key="defaultValueIsNull">0</value>


  		




  666
  
  
    
                      <value _ptr_="0xb1f8e18" type="list" content-type="string" key="flags"/>


  		




  
  573
  
    
                      <value _ptr_="0xb4899c0" type="list" content-type="string" key="flags"/>


  		




  667
  574
  
    
                      <value type="int" key="isNotNull">1</value>


  		




  668
  575
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




  ......




  677
  584
  
    
                    <value type="object" struct-name="db.mysql.Column" id="45a3f404-ad0f-11e2-b309-080027bcf912" struct-checksum="0x783b5183">


  		




  678
  585
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  679
  586
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  681
  588
  
    
                      <value type="string" key="collationName"></value>


  		




  682
  589
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  683
  590
  
    
                      <value type="string" key="defaultValue"></value>


  		




  684
  591
  
    
                      <value type="int" key="defaultValueIsNull">0</value>


  		




  685
  
  
    
                      <value _ptr_="0xa6bc038" type="list" content-type="string" key="flags"/>


  		




  
  592
  
    
                      <value _ptr_="0xb489e38" type="list" content-type="string" key="flags"/>


  		




  686
  593
  
    
                      <value type="int" key="isNotNull">1</value>


  		




  687
  594
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




  ......




  698
  605
  
    
                  <value type="string" key="defaultCharacterSetName">utf8</value>


  		




  699
  606
  
    
                  <value type="string" key="defaultCollationName">utf8_bin</value>


  		




  700
  607
  
    
                  <value type="int" key="delayKeyWrite">0</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  705
  612
  
    
                        <link type="object">be8dfbf6-a6e0-11e2-95e9-080027bcf912</link>


  		




  706
  613
  
    
                      </value>


  		




  707
  614
  
    
                      <value type="int" key="deferability">0</value>


  		




  ......




  711
  618
  
    
                      <value type="int" key="many">0</value>


  		




  712
  619
  
    
                      <value type="int" key="modelOnly">0</value>


  		




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


  		




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


  		




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


  		




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


  		




  716
  623
  
    
                      </value>


  		




  717
  624
  
    
                      <value type="int" key="referencedMandatory">1</value>


  		




  ......




  722
  629
  
    
                    </value>


  		




  723
  630
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="ed1eb2a6-ad0e-11e2-b309-080027bcf912" struct-checksum="0x70a8fc40">


  		




  724
  631
  
    
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">049df920-a91b-11e2-bdec-080027bcf912</link>


  		




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


  		




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


  		




  726
  633
  
    
                        <link type="object">ed1eb468-ad0e-11e2-b309-080027bcf912</link>


  		




  727
  634
  
    
                      </value>


  		




  728
  635
  
    
                      <value type="int" key="deferability">0</value>


  		




  ......




  732
  639
  
    
                      <value type="int" key="many">1</value>


  		




  733
  640
  
    
                      <value type="int" key="modelOnly">0</value>


  		




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


  		




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


  		




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


  		




  736
  643
  
    
                        <link type="object">049dfc5e-a91b-11e2-bdec-080027bcf912</link>


  		




  737
  644
  
    
                      </value>


  		




  738
  645
  
    
                      <value type="int" key="referencedMandatory">1</value>


  		




  ......




  742
  649
  
    
                      <value type="string" key="oldName">fk_collection_organization1</value>


  		




  743
  650
  
    
                    </value>


  		




  744
  651
  
    
                  </value>


  		




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


  		




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


  		




  746
  653
  
    
                    <value type="object" struct-name="db.mysql.Index" id="ed1ec98a-ad0e-11e2-b309-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




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


  		




  748
  655
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="ed1ecb1a-ad0e-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">


  		




  749
  656
  
    
                          <value type="int" key="columnLength">0</value>


  		




  750
  657
  
    
                          <value type="string" key="comment"></value>


  		




  ......




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


  		




  768
  675
  
    
                    </value>


  		




  769
  676
  
    
                    <value type="object" struct-name="db.mysql.Index" id="6b54505e-ad0f-11e2-b309-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




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


  		




  771
  678
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="6dd2beb0-ad0f-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">


  		




  772
  679
  
    
                          <value type="int" key="columnLength">0</value>


  		




  773
  680
  
    
                          <value type="string" key="comment"></value>


  		




  ......




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


  		




  799
  706
  
    
                    </value>


  		




  800
  707
  
    
                    <value type="object" struct-name="db.mysql.Index" id="81937b1c-ad12-11e2-b309-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




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


  		




  802
  709
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="8194729c-ad12-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">


  		




  803
  710
  
    
                          <value type="int" key="columnLength">0</value>


  		




  804
  711
  
    
                          <value type="string" key="comment"></value>


  		




  ......




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


  		




  822
  729
  
    
                    </value>


  		




  823
  730
  
    
                    <value type="object" struct-name="db.mysql.Index" id="8ed70288-ad14-11e2-9617-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




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


  		




  825
  732
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="8ed7a80a-ad14-11e2-9617-080027bcf912" struct-checksum="0x62630b3c">


  		




  826
  733
  
    
                          <value type="int" key="columnLength">0</value>


  		




  827
  734
  
    
                          <value type="string" key="comment"></value>


  		




  ......




  851
  758
  
    
                  <value type="string" key="nextAutoInc"></value>


  		




  852
  759
  
    
                  <value type="string" key="packKeys"></value>


  		




  853
  760
  
    
                  <value type="int" key="partitionCount">0</value>


  		




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


  		




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


  		




  855
  762
  
    
                  <value type="string" key="partitionExpression"></value>


  		




  856
  763
  
    
                  <value type="string" key="partitionType"></value>


  		




  857
  764
  
    
                  <value type="string" key="password"></value>


  		




  ......




  866
  773
  
    
                  <value type="string" key="tableDataDir"></value>


  		




  867
  774
  
    
                  <value type="string" key="tableEngine">InnoDB</value>


  		




  868
  775
  
    
                  <value type="string" key="tableIndexDir"></value>


  		




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


  		




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


  		




  870
  777
  
    
                  <value type="int" key="isStub">0</value>


  		




  871
  778
  
    
                  <value type="int" key="isSystem">0</value>


  		




  872
  779
  
    
                  <value type="int" key="isTemporary">0</value>


  		




  873
  780
  
    
                  <value type="string" key="temporaryScope"></value>


  		




  874
  781
  
    
                  <value type="int" key="commentedOut">0</value>


  		




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


  		




  876
  
  
    
                  <value _ptr_="0xa6baf98" type="dict" key="customData"/>


  		




  
  783
  
    
                  <value _ptr_="0xb47a6e8" type="dict" key="customData"/>


  		




  877
  784
  
    
                  <value type="string" key="lastChangeDate">2013-04-24 14:34</value>


  		




  878
  785
  
    
                  <value type="int" key="modelOnly">0</value>


  		




  879
  786
  
    
                  <value type="string" key="name">collection</value>


  		




  ......




  885
  792
  
    
                <value type="object" struct-name="db.mysql.Table" id="687f12b8-a780-11e2-afd5-080027bcf912" struct-checksum="0x1a403946">


  		




  886
  793
  
    
                  <value type="string" key="avgRowLength"></value>


  		




  887
  794
  
    
                  <value type="int" key="checksum">0</value>


  		




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


  		




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


  		




  889
  796
  
    
                    <value type="object" struct-name="db.mysql.Column" id="687f1542-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">


  		




  890
  797
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  891
  798
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  893
  800
  
    
                      <value type="string" key="collationName"></value>


  		




  894
  801
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  895
  802
  
    
                      <value type="string" key="defaultValue"></value>


  		




  896
  803
  
    
                      <value type="int" key="defaultValueIsNull">0</value>


  		




  897
  
  
    
                      <value _ptr_="0xa6bb730" type="list" content-type="string" key="flags"/>


  		




  
  804
  
    
                      <value _ptr_="0xb48cc78" type="list" content-type="string" key="flags"/>


  		




  898
  805
  
    
                      <value type="int" key="isNotNull">1</value>


  		




  899
  806
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




  ......




  908
  815
  
    
                    <value type="object" struct-name="db.mysql.Column" id="687f1718-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">


  		




  909
  816
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  910
  817
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  912
  819
  
    
                      <value type="string" key="collationName"></value>


  		




  913
  820
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  914
  821
  
    
                      <value type="string" key="defaultValue"></value>


  		




  915
  822
  
    
                      <value type="int" key="defaultValueIsNull">0</value>


  		




  916
  
  
    
                      <value _ptr_="0xa6bbbe0" type="list" content-type="string" key="flags"/>


  		




  
  823
  
    
                      <value _ptr_="0xb48d0f0" type="list" content-type="string" key="flags"/>


  		




  917
  824
  
    
                      <value type="int" key="isNotNull">1</value>


  		




  918
  825
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




  ......




  927
  834
  
    
                    <value type="object" struct-name="db.mysql.Column" id="687f18b2-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">


  		




  928
  835
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  929
  836
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  931
  838
  
    
                      <value type="string" key="collationName"></value>


  		




  932
  839
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  933
  840
  
    
                      <value type="string" key="defaultValue"></value>


  		




  934
  841
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




  935
  
  
    
                      <value _ptr_="0xb1fd660" type="list" content-type="string" key="flags"/>


  		




  
  842
  
    
                      <value _ptr_="0xb48d568" type="list" content-type="string" key="flags"/>


  		




  936
  843
  
    
                      <value type="int" key="isNotNull">0</value>


  		




  937
  844
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




  ......




  946
  853
  
    
                    <value type="object" struct-name="db.mysql.Column" id="687f1a6a-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">


  		




  947
  854
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  948
  855
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  950
  857
  
    
                      <value type="string" key="collationName"></value>


  		




  951
  858
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  952
  859
  
    
                      <value type="string" key="defaultValue"></value>


  		




  953
  860
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




  954
  
  
    
                      <value _ptr_="0xb1fdb30" type="list" content-type="string" key="flags"/>


  		




  
  861
  
    
                      <value _ptr_="0xb48d9e0" type="list" content-type="string" key="flags"/>


  		




  955
  862
  
    
                      <value type="int" key="isNotNull">0</value>


  		




  956
  863
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




  ......




  965
  872
  
    
                    <value type="object" struct-name="db.mysql.Column" id="687f1c2c-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">


  		




  966
  873
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  967
  874
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  969
  876
  
    
                      <value type="string" key="collationName"></value>


  		




  970
  877
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  971
  878
  
    
                      <value type="string" key="defaultValue"></value>


  		




  972
  879
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




  973
  
  
    
                      <value _ptr_="0xb1f93a8" type="list" content-type="string" key="flags"/>


  		




  
  880
  
    
                      <value _ptr_="0xb48de58" type="list" content-type="string" key="flags"/>


  		




  974
  881
  
    
                      <value type="int" key="isNotNull">0</value>


  		




  975
  882
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




  ......




  984
  891
  
    
                    <value type="object" struct-name="db.mysql.Column" id="29c29602-a7a4-11e2-8ba6-080027bcf912" struct-checksum="0x783b5183">


  		




  985
  892
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  986
  893
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  988
  895
  
    
                      <value type="string" key="collationName"></value>


  		




  989
  896
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  990
  897
  
    
                      <value type="string" key="defaultValue"></value>


  		




  991
  898
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




  992
  
  
    
                      <value _ptr_="0xb1f9878" type="list" content-type="string" key="flags"/>


  		




  
  899
  
    
                      <value _ptr_="0xb48e2d0" type="list" content-type="string" key="flags"/>


  		




  993
  900
  
    
                      <value type="int" key="isNotNull">0</value>


  		




  994
  901
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




  ......




  1003
  910
  
    
                    <value type="object" struct-name="db.mysql.Column" id="687f1dda-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">


  		




  1004
  911
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  1005
  912
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  1007
  914
  
    
                      <value type="string" key="collationName"></value>


  		




  1008
  915
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  1009
  916
  
    
                      <value type="string" key="defaultValue"></value>


  		




  1010
  917
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




  1011
  
  
    
                      <value _ptr_="0xb1f9d48" type="list" content-type="string" key="flags"/>


  		




  
  918
  
    
                      <value _ptr_="0xb48e748" type="list" content-type="string" key="flags"/>


  		




  1012
  919
  
    
                      <value type="int" key="isNotNull">0</value>


  		




  1013
  920
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




  ......




  1022
  929
  
    
                    <value type="object" struct-name="db.mysql.Column" id="11b489bc-f97f-11e2-8a2e-080027bcf912" struct-checksum="0x783b5183">


  		




  1023
  930
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  1024
  931
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  1026
  933
  
    
                      <value type="string" key="collationName"></value>


  		




  1027
  934
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  1028
  935
  
    
                      <value type="string" key="defaultValue"></value>


  		




  1029
  936
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




  1030
  
  
    
                      <value _ptr_="0xb1fbe88" type="list" content-type="string" key="flags"/>


  		




  
  937
  
    
                      <value _ptr_="0xb48ebc0" type="list" content-type="string" key="flags"/>


  		




  1031
  938
  
    
                      <value type="int" key="isNotNull">0</value>


  		




  1032
  939
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




  ......




  1043
  950
  
    
                  <value type="string" key="defaultCharacterSetName">utf8</value>


  		




  1044
  951
  
    
                  <value type="string" key="defaultCollationName">utf8_bin</value>


  		




  1045
  952
  
    
                  <value type="int" key="delayKeyWrite">0</value>


  		




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


  		




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


  		




  1047
  954
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="687f25a0-a780-11e2-afd5-080027bcf912" struct-checksum="0x70a8fc40">


  		




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


  		




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


  		




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


  		




  1050
  957
  
    
                        <link type="object">687f1542-a780-11e2-afd5-080027bcf912</link>


  		




  1051
  958
  
    
                      </value>


  		




  1052
  959
  
    
                      <value type="int" key="deferability">0</value>


  		




  ......




  1056
  963
  
    
                      <value type="int" key="many">0</value>


  		




  1057
  964
  
    
                      <value type="int" key="modelOnly">0</value>


  		




  1058
  965
  
    
                      <link type="object" struct-name="db.Table" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  1061
  968
  
    
                      </value>


  		




  1062
  969
  
    
                      <value type="int" key="referencedMandatory">1</value>


  		




  ......




  1067
  974
  
    
                    </value>


  		




  1068
  975
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="687f26f4-a780-11e2-afd5-080027bcf912" struct-checksum="0x70a8fc40">


  		




  1069
  976
  
    
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4c3ffc96-a741-11e2-9fbf-080027bcf912</link>


  		




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


  		




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


  		




  1071
  978
  
    
                        <link type="object">687f1718-a780-11e2-afd5-080027bcf912</link>


  		




  1072
  979
  
    
                      </value>


  		




  1073
  980
  
    
                      <value type="int" key="deferability">0</value>


  		




  ......




  1077
  984
  
    
                      <value type="int" key="many">1</value>


  		




  1078
  985
  
    
                      <value type="int" key="modelOnly">0</value>


  		




  1079
  986
  
    
                      <link type="object" struct-name="db.Table" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>


  		




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


  		




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


  		




  1081
  988
  
    
                        <link type="object">4c40001a-a741-11e2-9fbf-080027bcf912</link>


  		




  1082
  989
  
    
                      </value>


  		




  1083
  990
  
    
                      <value type="int" key="referencedMandatory">1</value>


  		




  ......




  1088
  995
  
    
                    </value>


  		




  1089
  996
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="11b487b4-f97f-11e2-8a2e-080027bcf912" struct-checksum="0x70a8fc40">


  		




  1090
  997
  
    
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">687f2f28-a780-11e2-afd5-080027bcf912</link>


  		




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


  		




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


  		




  1092
  999
  
    
                        <link type="object">11b489bc-f97f-11e2-8a2e-080027bcf912</link>


  		




  1093
  1000
  
    
                      </value>


  		




  1094
  1001
  
    
                      <value type="int" key="deferability">0</value>


  		




  ......




  1098
  1005
  
    
                      <value type="int" key="many">1</value>


  		




  1099
  1006
  
    
                      <value type="int" key="modelOnly">0</value>


  		




  1100
  1007
  
    
                      <link type="object" struct-name="db.Table" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>


  		




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


  		




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


  		




  1102
  1009
  
    
                        <link type="object">687f31c6-a780-11e2-afd5-080027bcf912</link>


  		




  1103
  1010
  
    
                      </value>


  		




  1104
  1011
  
    
                      <value type="int" key="referencedMandatory">0</value>


  		




  ......




  1108
  1015
  
    
                      <value type="string" key="oldName">fk_taxon_name_taxon_path1</value>


  		




  1109
  1016
  
    
                    </value>


  		




  1110
  1017
  
    
                  </value>


  		




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


  		




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


  		




  1112
  1019
  
    
                    <value type="object" struct-name="db.mysql.Index" id="687f1f92-a780-11e2-afd5-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




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


  		




  1114
  1021
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="687f217c-a780-11e2-afd5-080027bcf912" struct-checksum="0x62630b3c">


  		




  1115
  1022
  
    
                          <value type="int" key="columnLength">0</value>


  		




  1116
  1023
  
    
                          <value type="string" key="comment"></value>


  		




  ......




  1133
  1040
  
    
                      <link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>


  		




  1134
  1041
  
    
                    </value>


  		




  1135
  1042
  
    
                    <value type="object" struct-name="db.mysql.Index" id="687f22b2-a780-11e2-afd5-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




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


  		




  1137
  1044
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="687f246a-a780-11e2-afd5-080027bcf912" struct-checksum="0x62630b3c">


  		




  1138
  1045
  
    
                          <value type="int" key="columnLength">0</value>


  		




  1139
  1046
  
    
                          <value type="string" key="comment"></value>


  		




  ......




  1156
  1063
  
    
                      <link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>


  		




  1157
  1064
  
    
                    </value>


  		




  1158
  1065
  
    
                    <value type="object" struct-name="db.mysql.Index" id="11b49e5c-f97f-11e2-8a2e-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




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


  		




  1160
  1067
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="11b4a000-f97f-11e2-8a2e-080027bcf912" struct-checksum="0x62630b3c">


  		




  1161
  1068
  
    
                          <value type="int" key="columnLength">0</value>


  		




  1162
  1069
  
    
                          <value type="string" key="comment"></value>


  		




  ......




  1186
  1093
  
    
                  <value type="string" key="nextAutoInc"></value>


  		




  1187
  1094
  
    
                  <value type="string" key="packKeys"></value>


  		




  1188
  1095
  
    
                  <value type="int" key="partitionCount">0</value>


  		




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


  		




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


  		




  1190
  1097
  
    
                  <value type="string" key="partitionExpression"></value>


  		




  1191
  1098
  
    
                  <value type="string" key="partitionType"></value>


  		




  1192
  1099
  
    
                  <value type="string" key="password"></value>


  		




  ......




  1201
  1108
  
    
                  <value type="string" key="tableDataDir"></value>


  		




  1202
  1109
  
    
                  <value type="string" key="tableEngine">InnoDB</value>


  		




  1203
  1110
  
    
                  <value type="string" key="tableIndexDir"></value>


  		




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


  		




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


  		




  1205
  1112
  
    
                  <value type="int" key="isStub">0</value>


  		




  1206
  1113
  
    
                  <value type="int" key="isSystem">0</value>


  		




  1207
  1114
  
    
                  <value type="int" key="isTemporary">0</value>


  		




  1208
  1115
  
    
                  <value type="string" key="temporaryScope"></value>


  		




  1209
  1116
  
    
                  <value type="int" key="commentedOut">0</value>


  		




  1210
  1117
  
    
                  <value type="string" key="createDate">2013-04-17 10:01</value>


  		




  1211
  
  
    
                  <value _ptr_="0xb1fb540" type="dict" key="customData"/>


  		




  
  1118
  
    
                  <value _ptr_="0xacb6f40" type="dict" key="customData"/>


  		




  1212
  1119
  
    
                  <value type="string" key="lastChangeDate">2013-07-30 18:20</value>


  		




  1213
  1120
  
    
                  <value type="int" key="modelOnly">0</value>


  		




  1214
  1121
  
    
                  <value type="string" key="name">taxon_name</value>


  		




  ......




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


  		




  1221
  1128
  
    
                  <value type="string" key="avgRowLength"></value>


  		




  1222
  1129
  
    
                  <value type="int" key="checksum">0</value>


  		




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


  		




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


  		




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


  		




  1225
  1132
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  1226
  1133
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  1228
  1135
  
    
                      <value type="string" key="collationName"></value>


  		




  1229
  1136
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  1230
  1137
  
    
                      <value type="string" key="defaultValue"></value>


  		




  1231
  1138
  
    
                      <value type="int" key="defaultValueIsNull">0</value>


  		




  1232
  
  
    
                      <value _ptr_="0xb1f7410" type="list" content-type="string" key="flags"/>


  		




  
  1139
  
    
                      <value _ptr_="0xb491450" type="list" content-type="string" key="flags"/>


  		




  1233
  1140
  
    
                      <value type="int" key="isNotNull">1</value>


  		




  1234
  1141
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




  ......




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


  		




  1244
  1151
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  1245
  1152
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  1247
  1154
  
    
                      <value type="string" key="collationName"></value>


  		




  1248
  1155
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  1249
  1156
  
    
                      <value type="string" key="defaultValue"></value>


  		




  1250
  1157
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




  1251
  
  
    
                      <value _ptr_="0xb1f78c0" type="list" content-type="string" key="flags"/>


  		




  
  1158
  
    
                      <value _ptr_="0xb4918c8" type="list" content-type="string" key="flags"/>


  		




  1252
  1159
  
    
                      <value type="int" key="isNotNull">0</value>


  		




  1253
  1160
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




  ......




  1264
  1171
  
    
                  <value type="string" key="defaultCharacterSetName">utf8</value>


  		




  1265
  1172
  
    
                  <value type="string" key="defaultCollationName">utf8_bin</value>


  		




  1266
  1173
  
    
                  <value type="int" key="delayKeyWrite">0</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  1176
  
    
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">afc401d4-1df9-11e3-bbb6-080027bcf912</link>


  		




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


  		




  1271
  1178
  
    
                        <link type="object">be8cd956-a6e0-11e2-95e9-080027bcf912</link>


  		




  1272
  1179
  
    
                      </value>


  		




  1273
  1180
  
    
                      <value type="int" key="deferability">0</value>


  		




  1274
  1181
  
    
                      <value type="string" key="deleteRule">CASCADE</value>


  		




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


  		




  1276
  1182
  
    
                      <value type="int" key="mandatory">1</value>


  		




  1277
  1183
  
    
                      <value type="int" key="many">1</value>


  		




  1278
  1184
  
    
                      <value type="int" key="modelOnly">0</value>


  		




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


  		




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


  		




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


  		




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


  		




  
  1187
  
    
                        <link type="object">afc4053a-1df9-11e3-bbb6-080027bcf912</link>


  		




  1282
  1188
  
    
                      </value>


  		




  1283
  1189
  
    
                      <value type="int" key="referencedMandatory">0</value>


  		




  1284
  1190
  
    
                      <value type="string" key="updateRule">CASCADE</value>


  		




  ......




  1287
  1193
  
    
                      <value type="string" key="oldName">fk_record_source1</value>


  		




  1288
  1194
  
    
                    </value>


  		




  1289
  1195
  
    
                  </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  1294
  1200
  
    
                          <value type="int" key="columnLength">0</value>


  		




  1295
  1201
  
    
                          <value type="string" key="comment"></value>


  		




  ......




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


  		




  1313
  1219
  
    
                    </value>


  		




  1314
  1220
  
    
                    <value type="object" struct-name="db.mysql.Index" id="fbf69d1e-a79d-11e2-a346-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




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


  		




  1316
  1222
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="fecdc3c8-a79d-11e2-a346-080027bcf912" struct-checksum="0x62630b3c">


  		




  1317
  1223
  
    
                          <value type="int" key="columnLength">0</value>


  		




  1318
  1224
  
    
                          <value type="string" key="comment"></value>


  		




  ......




  1334
  1240
  
    
                      <value type="string" key="oldName">record_unique</value>


  		




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


  		




  1336
  1242
  
    
                    </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  1346
  
  
    
                        </value>


  		




  1347
  
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  1359
  
  
    
                    </value>


  		




  1360
  1243
  
    
                  </value>


  		




  1361
  1244
  
    
                  <value type="string" key="maxRows"></value>


  		




  1362
  1245
  
    
                  <value type="string" key="mergeInsert"></value>


  		




  ......




  1365
  1248
  
    
                  <value type="string" key="nextAutoInc"></value>


  		




  1366
  1249
  
    
                  <value type="string" key="packKeys"></value>


  		




  1367
  1250
  
    
                  <value type="int" key="partitionCount">0</value>


  		




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


  		




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


  		




  1369
  1252
  
    
                  <value type="string" key="partitionExpression"></value>


  		




  1370
  1253
  
    
                  <value type="string" key="partitionType"></value>


  		




  1371
  1254
  
    
                  <value type="string" key="password"></value>


  		




  ......




  1380
  1263
  
    
                  <value type="string" key="tableDataDir"></value>


  		




  1381
  1264
  
    
                  <value type="string" key="tableEngine">InnoDB</value>


  		




  1382
  1265
  
    
                  <value type="string" key="tableIndexDir"></value>


  		




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


  		




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


  		




  1384
  1267
  
    
                  <value type="int" key="isStub">0</value>


  		




  1385
  1268
  
    
                  <value type="int" key="isSystem">0</value>


  		




  1386
  1269
  
    
                  <value type="int" key="isTemporary">0</value>


  		




  1387
  1270
  
    
                  <value type="string" key="temporaryScope"></value>


  		




  1388
  1271
  
    
                  <value type="int" key="commentedOut">0</value>


  		




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


  		




  1390
  
  
    
                  <value _ptr_="0xb1f67c8" type="dict" key="customData"/>


  		




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


  		




  
  1273
  
    
                  <value _ptr_="0xaa5abc0" type="dict" key="customData"/>


  		




  
  1274
  
    
                  <value type="string" key="lastChangeDate">2013-09-15 04:37</value>


  		




  1392
  1275
  
    
                  <value type="int" key="modelOnly">0</value>


  		




  1393
  1276
  
    
                  <value type="string" key="name">traceable</value>


  		




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


  		




  ......




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


  		




  1400
  1283
  
    
                  <value type="string" key="avgRowLength"></value>


  		




  1401
  1284
  
    
                  <value type="int" key="checksum">0</value>


  		




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


  		




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


  		




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


  		




  1404
  1287
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  1405
  1288
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  1407
  1290
  
    
                      <value type="string" key="collationName"></value>


  		




  1408
  1291
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  1409
  1292
  
    
                      <value type="string" key="defaultValue"></value>


  		




  1410
  1293
  
    
                      <value type="int" key="defaultValueIsNull">0</value>


  		




  1411
  
  
    
                      <value _ptr_="0xa6b86d8" type="list" content-type="string" key="flags"/>


  		




  
  1294
  
    
                      <value _ptr_="0xb493468" type="list" content-type="string" key="flags"/>


  		




  1412
  1295
  
    
                      <value type="int" key="isNotNull">1</value>


  		




  1413
  1296
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




  ......




  1422
  1305
  
    
                    <value type="object" struct-name="db.mysql.Column" id="2f07bade-0127-11e3-9f3a-080027bcf912" struct-checksum="0x783b5183">


  		




  1423
  1306
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  1424
  1307
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  1426
  1309
  
    
                      <value type="string" key="collationName"></value>


  		




  1427
  1310
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  1428
  1311
  
    
                      <value type="string" key="defaultValue"></value>


  		




  1429
  1312
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




  1430
  
  
    
                      <value _ptr_="0xa6b8b88" type="list" content-type="string" key="flags"/>


  		




  
  1313
  
    
                      <value _ptr_="0xb4938e0" type="list" content-type="string" key="flags"/>


  		




  1431
  1314
  
    
                      <value type="int" key="isNotNull">0</value>


  		




  1432
  1315
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




  ......




  1441
  1324
  
    
                    <value type="object" struct-name="db.mysql.Column" id="273737e8-a796-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">


  		




  1442
  1325
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  1443
  1326
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  1445
  1328
  
    
                      <value type="string" key="collationName"></value>


  		




  1446
  1329
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  1447
  1330
  
    
                      <value type="string" key="defaultValue"></value>


  		




  1448
  1331
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




  1449
  
  
    
                      <value _ptr_="0xa6b9058" type="list" content-type="string" key="flags"/>


  		




  
  1332
  
    
                      <value _ptr_="0xb493d58" type="list" content-type="string" key="flags"/>


  		




  1450
  1333
  
    
                      <value type="int" key="isNotNull">0</value>


  		




  1451
  1334
  
    
                      <value type="int" key="length">767</value>


  		




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


  		




  ......




  1460
  1343
  
    
                    <value type="object" struct-name="db.mysql.Column" id="d009232a-f671-11e2-9716-080027bcf912" struct-checksum="0x783b5183">


  		




  1461
  1344
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  1462
  1345
  
    
                      <value type="string" key="characterSetName"></value>


  		




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


  		




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


  		




  1464
  1347
  
    
                      <value type="string" key="collationName"></value>


  		




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


  		




  1466
  1349
  
    
                      <value type="string" key="defaultValue"></value>


  		




  1467
  1350
  
    
                      <value type="int" key="defaultValueIsNull">0</value>


  		




  1468
  
  
    
                      <value _ptr_="0xa6b9528" type="list" content-type="string" key="flags"/>


  		




  
  1351
  
    
                      <value _ptr_="0xb4941d0" type="list" content-type="string" key="flags"/>


  		




  1469
  1352
  
    
                      <value type="int" key="isNotNull">0</value>


  		




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


  		




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


  		




  ......




  1481
  1364
  
    
                  <value type="string" key="defaultCharacterSetName">utf8</value>


  		




  1482
  1365
  
    
                  <value type="string" key="defaultCollationName">utf8_bin</value>


  		




  1483
  1366
  
    
                  <value type="int" key="delayKeyWrite">0</value>


  		




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


  		




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


  		




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


  		




  1486
  1369
  
    
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">c672a8d8-a7a0-11e2-b667-080027bcf912</link>


  		




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


  		




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


  		




  1488
  1371
  
    
                        <link type="object">be8e4142-a6e0-11e2-95e9-080027bcf912</link>


  		




  1489
  1372
  
    
                      </value>


  		




  1490
  1373
  
    
                      <value type="int" key="deferability">0</value>


  		




  ......




  1494
  1377
  
    
                      <value type="int" key="many">0</value>


  		




  1495
  1378
  
    
                      <value type="int" key="modelOnly">0</value>


  		




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


  		




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


  		




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


  		




  1498
  1381
  
    
                        <link type="object">c672abda-a7a0-11e2-b667-080027bcf912</link>


  		




  1499
  1382
  
    
                      </value>


  		




  1500
  1383
  
    
                      <value type="int" key="referencedMandatory">1</value>


  		




  ......




  1505
  1388
  
    
                    </value>


  		




  1506
  1389
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="2f07b8cc-0127-11e3-9f3a-080027bcf912" struct-checksum="0x70a8fc40">


  		




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


  		




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


  		




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


  		




  1509
  1392
  
    
                        <link type="object">2f07bade-0127-11e3-9f3a-080027bcf912</link>


  		




  1510
  1393
  
    
                      </value>


  		




  1511
  1394
  
    
                      <value type="int" key="deferability">0</value>


  		




  ......




  1515
  1398
  
    
                      <value type="int" key="many">1</value>


  		




  1516
  1399
  
    
                      <value type="int" key="modelOnly">0</value>


  		




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


  		




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


  		




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


  		




  1519
  1402
  
    
                        <link type="object">be8f6a86-a6e0-11e2-95e9-080027bcf912</link>


  		




  1520
  1403
  
    
                      </value>


  		




  1521
  1404
  
    
                      <value type="int" key="referencedMandatory">0</value>


  		




  ......




  1525
  1408
  
    
                      <value type="string" key="oldName">fk_individual_subplace1</value>


  		




  1526
  1409
  
    
                    </value>


  		








... This diff was truncated because it exceeds the maximum size that can be displayed.



Also available in:  Unified diff