Project

General

Profile

« Previous | Next » 

Revision 11065

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: dataset.parent: updated comment to refer to data_source, not traceable.source (which is now used for a different purpose)

View differences:

schemas/VegCore/ERD/document.mwb.xml
306 306 
                      <value type="int" key="precision">-1</value>
307 307 
                      <value type="int" key="scale">-1</value>
308 308 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
309 
                      <value type="string" key="comment">this provides a containment relationship, which differs from the attribution relationship provided by source (inherited from traceable). e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the source).</value>
309 
                      <value type="string" key="comment">this provides a containment relationship, which differs from the attribution relationship provided by data_source. e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the data_source).</value>
310 310 
                      <value type="string" key="name">parent</value>
311 311 
                      <value type="string" key="oldName">parent</value>
312 312 
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
......
709 709 
                  <value type="int" key="commentedOut">0</value>
710 710 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
711 711 
                  <value _ptr_="0xb034dc0" type="dict" key="customData"/>
712 
                  <value type="string" key="lastChangeDate">2013-09-22 08:23</value>
712 
                  <value type="string" key="lastChangeDate">2013-09-22 08:58</value>
713 713 
                  <value type="int" key="modelOnly">0</value>
714 714 
                  <value type="string" key="name">dataset</value>
715 715 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
17527 17527 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17528 17528 
        <value _ptr_="0xba3c650" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17529 17529 
        <value _ptr_="0xb030e28" type="dict" key="syncProfiles">
17530 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="eceaf9a6-239d-11e3-ab7c-080027bcf912" struct-checksum="0xc64972c2" key="">
17531 
            <value _ptr_="0xd40dc40" type="dict" key="lastKnownDBNames">
17530 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="59792a84-239e-11e3-ab7c-080027bcf912" struct-checksum="0xc64972c2" key="">
17531 
            <value _ptr_="0xc9239f0" type="dict" key="lastKnownDBNames">
17532 17532 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17533 17533 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
17534 17534 
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
18154 18154 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18155 18155 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18156 18156 
      <value type="string" key="caption">New Model</value>
18157 
      <value type="string" key="dateChanged">2013-09-22 08:47</value>
18157 
      <value type="string" key="dateChanged">2013-09-22 08:58</value>
18158 18158 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18159 18159 
      <value type="string" key="description"></value>
18160 18160 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
125 125 
/*!40101 SET character_set_client = utf8 */;
126 126 
CREATE TABLE `dataset` (
127 127 
  `id` varbinary(767) NOT NULL,
128 
  `parent` varbinary(767) DEFAULT NULL COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by source (inherited from traceable). e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the source).',
128 
  `parent` varbinary(767) DEFAULT NULL COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by data_source. e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the data_source).',
129 129 
  `data_source` varbinary(767) DEFAULT NULL COMMENT 'where the data in the dataset came from (as opposed to where the metadata *about* the dataset came from, which is in source, inherited from traceable)',
130 130 
  `first_publisher` varbinary(767) DEFAULT NULL,
131 131 
  `data_owners` varbinary(767) DEFAULT NULL COMMENT 'parties who must be given attribution, such as copyrightholders',
......
136 136 
  KEY `fk_source_party1_idx` (`contacts`),
137 137 
  KEY `fk_dataset_source2_idx` (`data_source`),
138 138 
  KEY `fk_dataset_dataset1_idx` (`parent`),
139 
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
139 
  CONSTRAINT `fk_dataset_source2` FOREIGN KEY (`data_source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
140 140 
  CONSTRAINT `fk_dataset_dataset1` FOREIGN KEY (`parent`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
141 141 
  CONSTRAINT `fk_dataset_source1` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
142 
  CONSTRAINT `fk_dataset_source2` FOREIGN KEY (`data_source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
143 142 
  CONSTRAINT `fk_dataset_traceable1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
143 
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
144 144 
  CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
145 145 
  CONSTRAINT `fk_source_party_list1` FOREIGN KEY (`data_owners`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
146 146 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements';
schemas/VegCore/VegCore.pg.sql
127 127 
/*!40101 SET character_set_client = utf8 */;
128 128 
CREATE TABLE "dataset" (
129 129 
  "id" text NOT NULL,
130 
  "parent" text DEFAULT NULL /*COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by source (inherited from traceable). e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the source).'*/,
130 
  "parent" text DEFAULT NULL /*COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by data_source. e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the data_source).'*/,
131 131 
  "data_source" text DEFAULT NULL /*COMMENT 'where the data in the dataset came from (as opposed to where the metadata *about* the dataset came from, which is in source, inherited from traceable)'*/,
132 132 
  "first_publisher" text DEFAULT NULL,
133 133 
  "data_owners" text DEFAULT NULL /*COMMENT 'parties who must be given attribution, such as copyrightholders'*/,
......
138 138 
  /*KEY "fk_source_party1_idx" ("contacts")*/CHECK (true),
139 139 
  /*KEY "fk_dataset_source2_idx" ("data_source")*/CHECK (true),
140 140 
  /*KEY "fk_dataset_dataset1_idx" ("parent")*/CHECK (true),
141 
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
141 
  /*CONSTRAINT "fk_dataset_source2" FOREIGN KEY ("data_source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
142 142 
  /*CONSTRAINT "fk_dataset_dataset1" FOREIGN KEY ("parent") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
143 143 
  /*CONSTRAINT "fk_dataset_source1" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
144 
  /*CONSTRAINT "fk_dataset_source2" FOREIGN KEY ("data_source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
145 144 
  /*CONSTRAINT "fk_dataset_traceable1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
145 
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
146 146 
  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
147 147 
  /*CONSTRAINT "fk_source_party_list1" FOREIGN KEY ("data_owners") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
148 148 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements'*/;

Also available in: Unified diff