Project

General

Profile

« Previous | Next » 

Revision 11058

schemas/VegCore/ERD/VegCore.ERD.mwb: traceable.table_fragment: renamed to id_within_source, since this can also identify e.g. a dataset within the source that it came from

View differences:

schemas/VegCore/ERD/document.mwb.xml
1333 1333
                      <value type="int" key="precision">-1</value>
1334 1334
                      <value type="int" key="scale">-1</value>
1335 1335
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
1336
                      <value type="string" key="comment">the portion of the source that this traceable refers to. when specified, this must *uniquely identify* the traceable within the source. denormalized source data often contains data for many VegCore tables in the same row, and the traceables for each of these table entries must be distinguished *from each other* since they share the same source. this is usually just the VegCore table name, sometimes with a distinguishing prefix (e.g. collector.party/identified_by.party; current_observation.taxon_determination/orig_observation.taxon_determination).</value>
1337
                      <value type="string" key="name">table_fragment</value>
1338
                      <value type="string" key="oldName">table_fragment</value>
1336
                      <value type="string" key="comment">the portion of the source that this traceable refers to. when specified, this must *uniquely identify* the traceable within the source. denormalized source data often contains data for many VegCore tables in the same row, and the traceables for each of these table entries must be distinguished *from each other* since they share the same source. this is usually just the VegCore table name, sometimes with a distinguishing prefix (e.g. collector.party/identified_by.party; current_observation.taxon_determination/orig_observation.taxon_determination). this can also identify e.g. a dataset within the source that it came from.</value>
1337
                      <value type="string" key="name">id_within_source</value>
1338
                      <value type="string" key="oldName">id_within_source</value>
1339 1339
                      <link type="object" struct-name="GrtObject" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
1340 1340
                    </value>
1341 1341
                  </value>
......
1451 1451
                  <value type="int" key="commentedOut">0</value>
1452 1452
                  <value type="string" key="createDate">2013-04-16 14:58</value>
1453 1453
                  <value _ptr_="0xb403d48" type="dict" key="customData"/>
1454
                  <value type="string" key="lastChangeDate">2013-09-22 06:21</value>
1454
                  <value type="string" key="lastChangeDate">2013-09-22 07:06</value>
1455 1455
                  <value type="int" key="modelOnly">0</value>
1456 1456
                  <value type="string" key="name">traceable</value>
1457 1457
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
16043 16043
                <value type="int" key="locked">0</value>
16044 16044
                <value type="int" key="manualSizing">0</value>
16045 16045
                <value type="real" key="top">5.2e+02</value>
16046
                <value type="real" key="width">1.02e+02</value>
16046
                <value type="real" key="width">1.03e+02</value>
16047 16047
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16048 16048
                <value type="int" key="visible">1</value>
16049 16049
                <value type="string" key="name">traceable</value>
......
17745 17745
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17746 17746
        <value _ptr_="0xbbde3b8" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17747 17747
        <value _ptr_="0xa949130" type="dict" key="syncProfiles">
17748
          <value type="object" struct-name="db.mgmt.SyncProfile" id="5be8da46-238d-11e3-a6f3-080027bcf912" struct-checksum="0xc64972c2" key="">
17749
            <value _ptr_="0xd3ea100" type="dict" key="lastKnownDBNames">
17748
          <value type="object" struct-name="db.mgmt.SyncProfile" id="d836d830-238f-11e3-a6f3-080027bcf912" struct-checksum="0xc64972c2" key="">
17749
            <value _ptr_="0xd86fa08" type="dict" key="lastKnownDBNames">
17750 17750
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17751 17751
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
17752 17752
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
18293 18293
              <value type="string" key="f9d23e32-1dc5-11e3-838b-410b6ef2c3ca">taxon_occurrence</value>
18294 18294
              <value type="string" key="f9d241ca-1dc5-11e3-838b-410b6ef2c3ca">id</value>
18295 18295
              <value type="string" key="f9d255c0-1dc5-11e3-838b-410b6ef2c3ca">PRIMARY</value>
18296
              <value type="string" key="f9d963a4-2326-11e3-a5a2-080027bcf912">table_fragment</value>
18296
              <value type="string" key="f9d963a4-2326-11e3-a5a2-080027bcf912">id_within_source</value>
18297 18297
              <value type="string" key="fbf69d1e-a79d-11e2-a346-080027bcf912">traceable_unique</value>
18298 18298
              <value type="string" key="fc6fbbae-f96e-11e2-9f36-080027bcf912">geoplace</value>
18299 18299
            </value>
......
18383 18383
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18384 18384
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18385 18385
      <value type="string" key="caption">New Model</value>
18386
      <value type="string" key="dateChanged">2013-09-22 06:46</value>
18386
      <value type="string" key="dateChanged">2013-09-22 07:06</value>
18387 18387
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18388 18388
      <value type="string" key="description"></value>
18389 18389
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
1420 1420
CREATE TABLE `traceable` (
1421 1421
  `id` varbinary(767) NOT NULL,
1422 1422
  `source` varbinary(767) NOT NULL,
1423
  `table_fragment` varbinary(767) DEFAULT NULL COMMENT 'the portion of the source that this traceable refers to. when specified, this must *uniquely identify* the traceable within the source. denormalized source data often contains data for many VegCore tables in the same row, and the traceables for each of these table entries must be distinguished *from each other* since they share the same source. this is usually just the VegCore table name, sometimes with a distinguishing prefix (e.g. collector.party/identified_by.party; current_observation.taxon_determination/orig_observation.taxon_determination).',
1423
  `id_within_source` varbinary(767) DEFAULT NULL COMMENT 'the portion of the source that this traceable refers to. when specified, this must *uniquely identify* the traceable within the source. denormalized source data often contains data for many VegCore tables in the same row, and the traceables for each of these table entries must be distinguished *from each other* since they share the same source. this is usually just the VegCore table name, sometimes with a distinguishing prefix (e.g. collector.party/identified_by.party; current_observation.taxon_determination/orig_observation.taxon_determination). this can also identify e.g. a dataset within the source that it came from.',
1424 1424
  PRIMARY KEY (`id`),
1425
  UNIQUE KEY `traceable_unique` (`source`,`table_fragment`),
1425
  UNIQUE KEY `traceable_unique` (`source`,`id_within_source`),
1426 1426
  CONSTRAINT `fk_record_source1` FOREIGN KEY (`source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1427 1427
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a row that can have associated source information';
1428 1428
/*!40101 SET character_set_client = @saved_cs_client */;
schemas/VegCore/VegCore.pg.sql
1422 1422
CREATE TABLE "traceable" (
1423 1423
  "id" text NOT NULL,
1424 1424
  "source" text NOT NULL,
1425
  "table_fragment" text DEFAULT NULL /*COMMENT 'the portion of the source that this traceable refers to. when specified, this must *uniquely identify* the traceable within the source. denormalized source data often contains data for many VegCore tables in the same row, and the traceables for each of these table entries must be distinguished *from each other* since they share the same source. this is usually just the VegCore table name, sometimes with a distinguishing prefix (e.g. collector.party/identified_by.party; current_observation.taxon_determination/orig_observation.taxon_determination).'*/,
1425
  "id_within_source" text DEFAULT NULL /*COMMENT 'the portion of the source that this traceable refers to. when specified, this must *uniquely identify* the traceable within the source. denormalized source data often contains data for many VegCore tables in the same row, and the traceables for each of these table entries must be distinguished *from each other* since they share the same source. this is usually just the VegCore table name, sometimes with a distinguishing prefix (e.g. collector.party/identified_by.party; current_observation.taxon_determination/orig_observation.taxon_determination). this can also identify e.g. a dataset within the source that it came from.'*/,
1426 1426
  PRIMARY KEY ("id"),
1427
  /*CONSTRAINT "traceable_unique" */UNIQUE ("source","table_fragment"),
1427
  /*CONSTRAINT "traceable_unique" */UNIQUE ("source","id_within_source"),
1428 1428
  /*CONSTRAINT "fk_record_source1" FOREIGN KEY ("source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1429 1429
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a row that can have associated source information'*/;
1430 1430
/*!40101 SET character_set_client = @saved_cs_client */;

Also available in: Unified diff