Project

General

Profile

« Previous | Next » 

Revision 11123

schemas/VegCore/ERD/VegCore.ERD.mwb: taxon_observation.observation_in_parent_place: merged with inherited parent field, documenting that for this table, this contains the observation of the same taxon_occurrence in the parent sampling_event

View differences:

schemas/VegCore/ERD/document.mwb.xml
3110 3110
                      <value type="string" key="oldName">all_collectors</value>
3111 3111
                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
3112 3112
                    </value>
3113
                    <value type="object" struct-name="db.mysql.Column" id="aecb1a5e-1de2-11e3-b950-080027bcf912" struct-checksum="0x783b5183">
3114
                      <value type="int" key="autoIncrement">0</value>
3115
                      <value type="string" key="characterSetName"></value>
3116
                      <value _ptr_="0xb6dbc00" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
3117
                      <value type="string" key="collationName"></value>
3118
                      <value type="string" key="datatypeExplicitParams"></value>
3119
                      <value type="string" key="defaultValue"></value>
3120
                      <value type="int" key="defaultValueIsNull">1</value>
3121
                      <value _ptr_="0xb6dbf80" type="list" content-type="string" key="flags"/>
3122
                      <value type="int" key="isNotNull">0</value>
3123
                      <value type="int" key="length">767</value>
3124
                      <value type="int" key="precision">-1</value>
3125
                      <value type="int" key="scale">-1</value>
3126
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
3127
                      <value type="string" key="comment">points to the observation of the same taxon/individual in the parent event; = VegBank.vegpath.org?taxonImportance.taxonObservation_ID</value>
3128
                      <value type="string" key="name">observation_in_parent_event</value>
3129
                      <value type="string" key="oldName">observation_in_parent_event</value>
3130
                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
3131
                    </value>
3132 3113
                    <value type="object" struct-name="db.mysql.Column" id="16538808-a7a7-11e2-8ba6-080027bcf912" struct-checksum="0x783b5183">
3133 3114
                      <value type="int" key="autoIncrement">0</value>
3134 3115
                      <value type="string" key="characterSetName"></value>
......
3192 3173
                  <value type="string" key="defaultCollationName">utf8_bin</value>
3193 3174
                  <value type="int" key="delayKeyWrite">0</value>
3194 3175
                  <value _ptr_="0xb6d9cc0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
3195
                    <value type="object" struct-name="db.mysql.ForeignKey" id="aecb187e-1de2-11e3-b950-080027bcf912" struct-checksum="0x70a8fc40">
3196
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
3197
                      <value _ptr_="0xb6dcf68" type="list" content-type="object" content-struct-name="db.Column" key="columns">
3198
                        <link type="object">aecb1a5e-1de2-11e3-b950-080027bcf912</link>
3199
                      </value>
3200
                      <value type="int" key="deferability">0</value>
3201
                      <value type="string" key="deleteRule">CASCADE</value>
3202
                      <link type="object" struct-name="db.Index" key="index">aecb3a34-1de2-11e3-b950-080027bcf912</link>
3203
                      <value type="int" key="mandatory">1</value>
3204
                      <value type="int" key="many">1</value>
3205
                      <value type="int" key="modelOnly">0</value>
3206
                      <link type="object" struct-name="db.Table" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
3207
                      <value _ptr_="0xb6dd2d0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
3208
                        <link type="object">16537d54-a7a7-11e2-8ba6-080027bcf912</link>
3209
                      </value>
3210
                      <value type="int" key="referencedMandatory">0</value>
3211
                      <value type="string" key="updateRule">CASCADE</value>
3212
                      <value type="string" key="comment"></value>
3213
                      <value type="string" key="name">fk_taxon_observation_taxon_observation1</value>
3214
                      <value type="string" key="oldName">fk_taxon_observation_taxon_observation1</value>
3215
                    </value>
3216 3176
                    <value type="object" struct-name="db.mysql.ForeignKey" id="713ff706-2998-11e3-a80d-080027bcf912" struct-checksum="0x70a8fc40">
3217 3177
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
3218 3178
                      <value _ptr_="0xb6dd340" type="list" content-type="object" content-struct-name="db.Column" key="columns">
......
3388 3348
                      <value type="string" key="oldName">fk_taxon_observation_taxa_sampling_event1_idx</value>
3389 3349
                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
3390 3350
                    </value>
3391
                    <value type="object" struct-name="db.mysql.Index" id="aecb3a34-1de2-11e3-b950-080027bcf912" struct-checksum="0x309b847a">
3392
                      <value _ptr_="0xb6df8d8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
3393
                        <value type="object" struct-name="db.mysql.IndexColumn" id="aecb3e94-1de2-11e3-b950-080027bcf912" struct-checksum="0x62630b3c">
3394
                          <value type="int" key="columnLength">0</value>
3395
                          <value type="string" key="comment"></value>
3396
                          <value type="int" key="descend">0</value>
3397
                          <link type="object" struct-name="db.Column" key="referencedColumn">aecb1a5e-1de2-11e3-b950-080027bcf912</link>
3398
                          <value type="string" key="name"></value>
3399
                          <link type="object" struct-name="GrtObject" key="owner">aecb3a34-1de2-11e3-b950-080027bcf912</link>
3400
                        </value>
3401
                      </value>
3402
                      <value type="string" key="indexKind"></value>
3403
                      <value type="int" key="keyBlockSize">0</value>
3404
                      <value type="string" key="withParser"></value>
3405
                      <value type="string" key="comment"></value>
3406
                      <value type="int" key="deferability">0</value>
3407
                      <value type="string" key="indexType">INDEX</value>
3408
                      <value type="int" key="isPrimary">0</value>
3409
                      <value type="string" key="name">fk_taxon_observation_taxon_observation1_idx</value>
3410
                      <value type="int" key="unique">0</value>
3411
                      <value type="string" key="oldName">fk_taxon_observation_taxon_observation1_idx</value>
3412
                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
3413
                    </value>
3414 3351
                    <value type="object" struct-name="db.mysql.Index" id="714100ce-2998-11e3-a80d-080027bcf912" struct-checksum="0x309b847a">
3415 3352
                      <value _ptr_="0xb6dffb8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
3416 3353
                        <value type="object" struct-name="db.mysql.IndexColumn" id="71413ae4-2998-11e3-a80d-080027bcf912" struct-checksum="0x62630b3c">
......
3532 3469
                  <value type="string" key="name">taxon_observation</value>
3533 3470
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
3534 3471
                  <value type="string" key="temp_sql"></value>
3535
                  <value type="string" key="comment">= DwC.vegpath.org?Occurrence (which actually represents an *observation* of an occurrence)</value>
3472
                  <value type="string" key="comment">= DwC.vegpath.org?Occurrence (which actually represents an *observation* of an occurrence); inherited fields: parent: contains the observation of the same taxon_occurrence in the parent sampling_event</value>
3536 3473
                  <value type="string" key="oldName">taxon_observation</value>
3537 3474
                </value>
3538 3475
                <value type="object" struct-name="db.mysql.Table" id="be8f1784-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">
......
13891 13828
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13892 13829
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13893 13830
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">be8e8fe4-a6e0-11e2-95e9-080027bcf912</link>
13894
                <value type="real" key="middleSegmentOffset">4.715454256184551695696427486836910247802734375e+01</value>
13831
                <value type="real" key="middleSegmentOffset">6.007780790614521038150996901094913482666015625e+01</value>
13895 13832
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13896 13833
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13897 13834
                <value type="int" key="drawSplit">0</value>
......
13933 13870
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13934 13871
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13935 13872
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">f62bfaf6-a797-11e2-8681-080027bcf912</link>
13936
                <value type="real" key="middleSegmentOffset">5.7000641529401292473266948945820331573486328125e+01</value>
13873
                <value type="real" key="middleSegmentOffset">6.8693153443453610407232190482318401336669921875e+01</value>
13937 13874
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13938 13875
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13939 13876
                <value type="int" key="drawSplit">0</value>
......
15424 15361
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15425 15362
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15426 15363
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">07e2f24c-1dde-11e3-bd5f-080027bcf912</link>
15427
                <value type="real" key="middleSegmentOffset">-6.069062987439656353672035038471221923828125e+01</value>
15364
                <value type="real" key="middleSegmentOffset">-4.061325955806017873328528366982936859130859375e+01</value>
15428 15365
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15429 15366
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15430 15367
                <value type="int" key="drawSplit">0</value>
......
15434 15371
                <value type="int" key="visible">1</value>
15435 15372
                <value type="string" key="name"></value>
15436 15373
              </value>
15437
              <value type="object" struct-name="workbench.physical.Connection" id="aecb459c-1de2-11e3-b950-080027bcf912" struct-checksum="0x9baebc92">
15438
                <value type="string" key="caption">fk_taxon_observation_taxon_observation1</value>
15439
                <value type="real" key="captionXOffs">0.e+00</value>
15440
                <value type="real" key="captionYOffs">0.e+00</value>
15441
                <value type="string" key="comment"></value>
15442
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15443
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15444
                <value type="string" key="extraCaption"></value>
15445
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15446
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15447
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">aecb187e-1de2-11e3-b950-080027bcf912</link>
15448
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15449
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15450
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15451
                <value type="int" key="drawSplit">0</value>
15452
                <link type="object" struct-name="model.Figure" key="endFigure">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
15453
                <link type="object" struct-name="model.Figure" key="startFigure">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
15454
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15455
                <value type="int" key="visible">1</value>
15456
                <value type="string" key="name"></value>
15457
              </value>
15458 15374
              <value type="object" struct-name="workbench.physical.Connection" id="813e8be6-1de9-11e3-b571-080027bcf912" struct-checksum="0x9baebc92">
15459 15375
                <value type="string" key="caption">fk_party_list_entry_party_list1</value>
15460 15376
                <value type="real" key="captionXOffs">0.e+00</value>
......
16889 16805
                <value type="int" key="triggersExpanded">0</value>
16890 16806
                <value type="string" key="color">#FFFF00</value>
16891 16807
                <value type="int" key="expanded">1</value>
16892
                <value type="real" key="height">2.61e+02</value>
16808
                <value type="real" key="height">2.38e+02</value>
16893 16809
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16894
                <value type="real" key="left">8.42e+02</value>
16810
                <value type="real" key="left">8.47e+02</value>
16895 16811
                <value type="int" key="locked">0</value>
16896 16812
                <value type="int" key="manualSizing">0</value>
16897
                <value type="real" key="top">1.76e+02</value>
16898
                <value type="real" key="width">1.63e+02</value>
16813
                <value type="real" key="top">1.59e+02</value>
16814
                <value type="real" key="width">1.56e+02</value>
16899 16815
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16900 16816
                <value type="int" key="visible">1</value>
16901 16817
                <value type="string" key="name">taxon_observation</value>
......
17754 17670
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
17755 17671
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
17756 17672
      <value type="string" key="caption">New Model</value>
17757
      <value type="string" key="dateChanged">2013-09-30 01:32</value>
17673
      <value type="string" key="dateChanged">2013-09-30 01:36</value>
17758 17674
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
17759 17675
      <value type="string" key="description"></value>
17760 17676
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
1272 1272
  `primary_collector` varbinary(767) DEFAULT NULL,
1273 1273
  `collector_number` varbinary(767) DEFAULT NULL,
1274 1274
  `all_collectors` varbinary(767) DEFAULT NULL,
1275
  `observation_in_parent_event` varbinary(767) DEFAULT NULL COMMENT 'points to the observation of the same taxon/individual in the parent event; = VegBank.vegpath.org?taxonImportance.taxonObservation_ID',
1276 1275
  `growth_form` varbinary(767) DEFAULT NULL,
1277 1276
  `cultivated` tinyint(1) DEFAULT NULL,
1278 1277
  `traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,
1279 1278
  PRIMARY KEY (`id`),
1280 1279
  KEY `fk_taxon_observation_taxon_occurrence1_idx` (`taxon_occurrence`),
1281 1280
  KEY `fk_taxon_observation_taxa_sampling_event1_idx` (`sampling_event`),
1282
  KEY `fk_taxon_observation_taxon_observation1_idx` (`observation_in_parent_event`),
1283 1281
  KEY `taxon_observation_id_fkey1_idx` (`primary_collector`),
1284 1282
  KEY `fk_taxon_observation_party_list1_idx` (`all_collectors`),
1285 1283
  KEY `taxon_observation__unique` (`sampling_event`,`primary_collector`,`collector_number`),
1284
  CONSTRAINT `taxon_observation_id_fkey1` FOREIGN KEY (`primary_collector`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1286 1285
  CONSTRAINT `fk_taxon_observation_taxa_sampling_event1` FOREIGN KEY (`sampling_event`) REFERENCES `taxa_sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1287 1286
  CONSTRAINT `fk_taxon_observation_party_list1` FOREIGN KEY (`all_collectors`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1288 1287
  CONSTRAINT `fk_taxon_observation_sampling_event1` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1289
  CONSTRAINT `fk_taxon_observation_taxon_observation1` FOREIGN KEY (`observation_in_parent_event`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1290
  CONSTRAINT `fk_taxon_observation_taxon_occurrence1` FOREIGN KEY (`taxon_occurrence`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1291
  CONSTRAINT `taxon_observation_id_fkey1` FOREIGN KEY (`primary_collector`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1292
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= DwC.vegpath.org?Occurrence (which actually represents an *observation* of an occurrence)';
1288
  CONSTRAINT `fk_taxon_observation_taxon_occurrence1` FOREIGN KEY (`taxon_occurrence`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1289
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= DwC.vegpath.org?Occurrence (which actually represents an *observation* of an occurrence); inherited fields: parent: contains the observation of the same taxon_occurrence in the parent sampling_event';
1293 1290
/*!40101 SET character_set_client = @saved_cs_client */;
1294 1291

  
1295 1292
--
schemas/VegCore/VegCore.pg.sql
1274 1274
  "primary_collector" text DEFAULT NULL,
1275 1275
  "collector_number" text DEFAULT NULL,
1276 1276
  "all_collectors" text DEFAULT NULL,
1277
  "observation_in_parent_event" text DEFAULT NULL /*COMMENT 'points to the observation of the same taxon/individual in the parent event; = VegBank.vegpath.org?taxonImportance.taxonObservation_ID'*/,
1278 1277
  "growth_form" text DEFAULT NULL,
1279 1278
  "cultivated" integer DEFAULT NULL,
1280 1279
  "traits" hstore DEFAULT NULL,
1281 1280
  PRIMARY KEY ("id"),
1282 1281
  /*KEY "fk_taxon_observation_taxon_occurrence1_idx" ("taxon_occurrence")*/CHECK (true),
1283 1282
  /*KEY "fk_taxon_observation_taxa_sampling_event1_idx" ("sampling_event")*/CHECK (true),
1284
  /*KEY "fk_taxon_observation_taxon_observation1_idx" ("observation_in_parent_event")*/CHECK (true),
1285 1283
  /*KEY "taxon_observation_id_fkey1_idx" ("primary_collector")*/CHECK (true),
1286 1284
  /*KEY "fk_taxon_observation_party_list1_idx" ("all_collectors")*/CHECK (true),
1287 1285
  /*KEY "taxon_observation__unique" ("sampling_event","primary_collector","collector_number")*/CHECK (true),
1286
  /*CONSTRAINT "taxon_observation_id_fkey1" FOREIGN KEY ("primary_collector") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1288 1287
  /*CONSTRAINT "fk_taxon_observation_taxa_sampling_event1" FOREIGN KEY ("sampling_event") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1289 1288
  /*CONSTRAINT "fk_taxon_observation_party_list1" FOREIGN KEY ("all_collectors") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1290 1289
  /*CONSTRAINT "fk_taxon_observation_sampling_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1291
  /*CONSTRAINT "fk_taxon_observation_taxon_observation1" FOREIGN KEY ("observation_in_parent_event") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1292
  /*CONSTRAINT "fk_taxon_observation_taxon_occurrence1" FOREIGN KEY ("taxon_occurrence") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1293
  /*CONSTRAINT "taxon_observation_id_fkey1" FOREIGN KEY ("primary_collector") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1294
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= DwC.vegpath.org?Occurrence (which actually represents an *observation* of an occurrence)'*/;
1290
  /*CONSTRAINT "fk_taxon_observation_taxon_occurrence1" FOREIGN KEY ("taxon_occurrence") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1291
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= DwC.vegpath.org?Occurrence (which actually represents an *observation* of an occurrence); inherited fields: parent: contains the observation of the same taxon_occurrence in the parent sampling_event'*/;
1295 1292
/*!40101 SET character_set_client = @saved_cs_client */;
1296 1293

  
1297 1294
--

Also available in: Unified diff