Project

General

Profile

« Previous | Next » 

Revision 11193

fix: schemas/VegCore/ERD/VegCore.ERD.mwb: dataset.parent: fixed example to indicate that the GBIF.ARIZ dataset is contained within a specific GBIF dataset (the parent), but was obtained from the GBIF organization (the dataset_source). ARIZ is then the first_publisher, not the dataset_source.

View differences:

schemas/VegCore/ERD/document.mwb.xml
231 231
                      <value type="int" key="precision">-1</value>
232 232
                      <value type="int" key="scale">-1</value>
233 233
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
234
                      <value type="string" key="comment">this provides a containment relationship, which differs from the attribution relationship provided by dataset_source. e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the dataset_source).</value>
234
                      <value type="string" key="comment">this provides a containment relationship, which differs from the attribution relationship provided by dataset_source. e.g. the GBIF.ARIZ dataset is contained within a specific GBIF *dataset* (the parent), but was obtained from the GBIF *organization* (the dataset_source). ARIZ is then the first_publisher.</value>
235 235
                      <value type="string" key="name">parent</value>
236 236
                      <value type="string" key="oldName">parent</value>
237 237
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
......
646 646
                  <value type="int" key="commentedOut">0</value>
647 647
                  <value type="string" key="createDate">2013-04-16 14:58</value>
648 648
                  <value _ptr_="0xba4cf98" type="dict" key="customData"/>
649
                  <value type="string" key="lastChangeDate">2013-10-09 11:19</value>
649
                  <value type="string" key="lastChangeDate">2013-10-09 11:29</value>
650 650
                  <value type="int" key="modelOnly">0</value>
651 651
                  <value type="string" key="name">dataset</value>
652 652
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
17485 17485
              <value type="int" key="visible">1</value>
17486 17486
              <value type="string" key="name"></value>
17487 17487
            </value>
17488
            <value _ptr_="0xbb01748" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17489
              <link type="object">39C6F66E-A650-49AE-8EDD-9D8A567EFBEA</link>
17490
            </value>
17488
            <value _ptr_="0xbb01748" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17491 17489
            <value type="int" key="updateBlocked">0</value>
17492 17490
            <value type="real" key="width">1.6215e+03</value>
17493 17491
            <value type="real" key="x">0.e+00</value>
......
17500 17498
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17501 17499
        <value _ptr_="0xba53b00" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17502 17500
        <value _ptr_="0xb0204c8" type="dict" key="syncProfiles">
17503
          <value type="object" struct-name="db.mgmt.SyncProfile" id="07822cb2-310e-11e3-ab47-080027bcf912" struct-checksum="0xc64972c2" key="">
17504
            <value _ptr_="0xcd50588" type="dict" key="lastKnownDBNames">
17501
          <value type="object" struct-name="db.mgmt.SyncProfile" id="65fc2d8c-310f-11e3-ab47-080027bcf912" struct-checksum="0xc64972c2" key="">
17502
            <value _ptr_="0xd2a7748" type="dict" key="lastKnownDBNames">
17505 17503
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17506 17504
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17507 17505
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
18126 18124
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18127 18125
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18128 18126
      <value type="string" key="caption">New Model</value>
18129
      <value type="string" key="dateChanged">2013-10-09 11:19</value>
18127
      <value type="string" key="dateChanged">2013-10-09 11:29</value>
18130 18128
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18131 18129
      <value type="string" key="description"></value>
18132 18130
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
124 124
  `id` varbinary(767) NOT NULL,
125 125
  `name` varbinary(767) NOT NULL,
126 126
  `contacts` varbinary(767) NOT NULL COMMENT 'contact person(s) to ask about attribution questions. there should always be at least one contact person. if unknown, the person loading the data should set this to themselves.',
127
  `parent` varbinary(767) DEFAULT NULL COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by dataset_source. e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the dataset_source).',
127
  `parent` varbinary(767) DEFAULT NULL COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by dataset_source. e.g. the GBIF.ARIZ dataset is contained within a specific GBIF *dataset* (the parent), but was obtained from the GBIF *organization* (the dataset_source). ARIZ is then the first_publisher.',
128 128
  `dataset_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); = Brad.vegpath.org?attribution.proximate_data_provider',
129 129
  `first_publisher` varbinary(767) DEFAULT NULL COMMENT '= Brad.vegpath.org?attribution.data_publisher, Brad.vegpath.org?data_provenance.primarydataprovider',
130 130
  `data_owners` varbinary(767) DEFAULT NULL COMMENT 'parties who must be given attribution, such as copyrightholders',
......
135 135
  KEY `fk_dataset_source2_idx` (`dataset_source`),
136 136
  KEY `fk_dataset_dataset1_idx` (`parent`),
137 137
  KEY `fk_source_party2_idx` (`first_publisher`),
138
  CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
139
  CONSTRAINT `fk_source_party_list1` FOREIGN KEY (`data_owners`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
140 138
  CONSTRAINT `fk_dataset_dataset1` FOREIGN KEY (`parent`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
139
  CONSTRAINT `fk_dataset_source1` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
140
  CONSTRAINT `fk_dataset_source2` FOREIGN KEY (`dataset_source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
141 141
  CONSTRAINT `fk_dataset_traceable1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
142 142
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
143
  CONSTRAINT `fk_dataset_source1` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
144
  CONSTRAINT `fk_dataset_source2` FOREIGN KEY (`dataset_source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
143
  CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
144
  CONSTRAINT `fk_source_party_list1` FOREIGN KEY (`data_owners`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
145 145
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements';
146 146
/*!40101 SET character_set_client = @saved_cs_client */;
147 147

  
schemas/VegCore/VegCore.pg.sql
126 126
  "id" text NOT NULL,
127 127
  "name" text NOT NULL,
128 128
  "contacts" text NOT NULL /*COMMENT 'contact person(s) to ask about attribution questions. there should always be at least one contact person. if unknown, the person loading the data should set this to themselves.'*/,
129
  "parent" text DEFAULT NULL /*COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by dataset_source. e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the dataset_source).'*/,
129
  "parent" text DEFAULT NULL /*COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by dataset_source. e.g. the GBIF.ARIZ dataset is contained within a specific GBIF *dataset* (the parent), but was obtained from the GBIF *organization* (the dataset_source). ARIZ is then the first_publisher.'*/,
130 130
  "dataset_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); = Brad.vegpath.org?attribution.proximate_data_provider'*/,
131 131
  "first_publisher" text DEFAULT NULL /*COMMENT '= Brad.vegpath.org?attribution.data_publisher, Brad.vegpath.org?data_provenance.primarydataprovider'*/,
132 132
  "data_owners" text DEFAULT NULL /*COMMENT 'parties who must be given attribution, such as copyrightholders'*/,
......
137 137
  /*KEY "fk_dataset_source2_idx" ("dataset_source")*/CHECK (true),
138 138
  /*KEY "fk_dataset_dataset1_idx" ("parent")*/CHECK (true),
139 139
  /*KEY "fk_source_party2_idx" ("first_publisher")*/CHECK (true),
140
  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
141
  /*CONSTRAINT "fk_source_party_list1" FOREIGN KEY ("data_owners") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
142 140
  /*CONSTRAINT "fk_dataset_dataset1" FOREIGN KEY ("parent") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
141
  /*CONSTRAINT "fk_dataset_source1" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
142
  /*CONSTRAINT "fk_dataset_source2" FOREIGN KEY ("dataset_source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
143 143
  /*CONSTRAINT "fk_dataset_traceable1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
144 144
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
145
  /*CONSTRAINT "fk_dataset_source1" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
146
  /*CONSTRAINT "fk_dataset_source2" FOREIGN KEY ("dataset_source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
145
  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
146
  /*CONSTRAINT "fk_source_party_list1" FOREIGN KEY ("data_owners") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
147 147
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements'*/;
148 148
/*!40101 SET character_set_client = @saved_cs_client */;
149 149

  

Also available in: Unified diff