Project

General

Profile

« Previous | Next » 

Revision 11055

Added by Aaron Marcuse-Kubitza about 11 years ago

schemas/VegCore/ERD/VegCore.ERD.mwb: traceable.table_fragment: made this optional, since some traceables may have a source but are not uniquely identifiable within that source. the ID would in this case need to be populated by a subclass table, since traceable can't generate a unique ID without the fragment.

View differences:

schemas/VegCore/ERD/document.mwb.xml
1243 1243 
                      <value type="string" key="collationName"></value>
1244 1244 
                      <value type="string" key="datatypeExplicitParams"></value>
1245 1245 
                      <value type="string" key="defaultValue"></value>
1246 
                      <value type="int" key="defaultValueIsNull">0</value>
1246 
                      <value type="int" key="defaultValueIsNull">1</value>
1247 1247 
                      <value _ptr_="0xbbd9ac0" type="list" content-type="string" key="flags"/>
1248 
                      <value type="int" key="isNotNull">1</value>
1248 
                      <value type="int" key="isNotNull">0</value>
1249 1249 
                      <value type="int" key="length">767</value>
1250 1250 
                      <value type="int" key="precision">-1</value>
1251 1251 
                      <value type="int" key="scale">-1</value>
1252 1252 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
1253 
                      <value type="string" key="comment">the portion of the source record that this traceable refers to. 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>
1253 
                      <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>
1254 1254 
                      <value type="string" key="name">table_fragment</value>
1255 1255 
                      <value type="string" key="oldName">table_fragment</value>
1256 1256 
                      <link type="object" struct-name="GrtObject" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
......
1368 1368 
                  <value type="int" key="commentedOut">0</value>
1369 1369 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
1370 1370 
                  <value _ptr_="0xb403d48" type="dict" key="customData"/>
1371 
                  <value type="string" key="lastChangeDate">2013-09-21 18:56</value>
1371 
                  <value type="string" key="lastChangeDate">2013-09-22 06:21</value>
1372 1372 
                  <value type="int" key="modelOnly">0</value>
1373 1373 
                  <value type="string" key="name">traceable</value>
1374 1374 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
17620 17620 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17621 17621 
        <value _ptr_="0xbbde3b8" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17622 17622 
        <value _ptr_="0xa949130" type="dict" key="syncProfiles">
17623 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="a0df43b8-2376-11e3-a6f3-080027bcf912" struct-checksum="0xc64972c2" key="">
17624 
            <value _ptr_="0xca703a0" type="dict" key="lastKnownDBNames">
17623 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="eba55122-2389-11e3-a6f3-080027bcf912" struct-checksum="0xc64972c2" key="">
17624 
            <value _ptr_="0xcdb5c18" type="dict" key="lastKnownDBNames">
17625 17625 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17626 17626 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
17627 17627 
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
18254 18254 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18255 18255 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18256 18256 
      <value type="string" key="caption">New Model</value>
18257 
      <value type="string" key="dateChanged">2013-09-22 04:31</value>
18257 
      <value type="string" key="dateChanged">2013-09-22 06:21</value>
18258 18258 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18259 18259 
      <value type="string" key="description"></value>
18260 18260 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
1416 1416 
CREATE TABLE `traceable` (
1417 1417 
  `id` varbinary(767) NOT NULL,
1418 1418 
  `source` varbinary(767) NOT NULL,
1419 
  `table_fragment` varbinary(767) NOT NULL COMMENT 'the portion of the source record that this traceable refers to. 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).',
1419 
  `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).',
1420 1420 
  PRIMARY KEY (`id`),
1421 1421 
  UNIQUE KEY `traceable_unique` (`source`,`table_fragment`),
1422 1422 
  CONSTRAINT `fk_record_source1` FOREIGN KEY (`source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
schemas/VegCore/VegCore.pg.sql
1418 1418 
CREATE TABLE "traceable" (
1419 1419 
  "id" text NOT NULL,
1420 1420 
  "source" text NOT NULL,
1421 
  "table_fragment" text NOT NULL /*COMMENT 'the portion of the source record that this traceable refers to. 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).'*/,
1421 
  "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).'*/,
1422 1422 
  PRIMARY KEY ("id"),
1423 1423 
  /*CONSTRAINT "traceable_unique" */UNIQUE ("source","table_fragment"),
1424 1424 
  /*CONSTRAINT "fk_record_source1" FOREIGN KEY ("source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

Also available in: Unified diff