Project

General

Profile

« Previous | Next » 

Revision 11194

schemas/VegCore/ERD/VegCore.ERD.mwb: dataset.data_owners: documented that this includes all aggregators through which the data has passed, so that this is equivalent to Brad's data indexers (Brad.vegpath.org?attribution.data_indexer)

View differences:

schemas/VegCore/ERD/document.mwb.xml
288 288
                      <value type="int" key="precision">-1</value>
289 289
                      <value type="int" key="scale">-1</value>
290 290
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
291
                      <value type="string" key="comment">parties who must be given attribution, such as copyrightholders</value>
291
                      <value type="string" key="comment">parties who must be given attribution, such as copyrightholders. this includes all aggregators through which the data has passed. = Brad.vegpath.org?attribution.data_indexer</value>
292 292
                      <value type="string" key="name">data_owners</value>
293 293
                      <value type="string" key="oldName">data_owners</value>
294 294
                      <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:29</value>
649
                  <value type="string" key="lastChangeDate">2013-10-09 11:36</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>
......
17498 17498
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17499 17499
        <value _ptr_="0xba53b00" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17500 17500
        <value _ptr_="0xb0204c8" type="dict" key="syncProfiles">
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">
17501
          <value type="object" struct-name="db.mgmt.SyncProfile" id="ce7bb8fe-3110-11e3-ab47-080027bcf912" struct-checksum="0xc64972c2" key="">
17502
            <value _ptr_="0xd02fc08" type="dict" key="lastKnownDBNames">
17503 17503
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17504 17504
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17505 17505
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
18124 18124
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18125 18125
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18126 18126
      <value type="string" key="caption">New Model</value>
18127
      <value type="string" key="dateChanged">2013-10-09 11:29</value>
18127
      <value type="string" key="dateChanged">2013-10-09 11:36</value>
18128 18128
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18129 18129
      <value type="string" key="description"></value>
18130 18130
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
127 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
  `data_owners` varbinary(767) DEFAULT NULL COMMENT 'parties who must be given attribution, such as copyrightholders',
130
  `data_owners` varbinary(767) DEFAULT NULL COMMENT 'parties who must be given attribution, such as copyrightholders. this includes all aggregators through which the data has passed. = Brad.vegpath.org?attribution.data_indexer',
131 131
  PRIMARY KEY (`id`),
132 132
  UNIQUE KEY `dataset_unique` (`parent`,`name`),
133 133
  KEY `fk_source_party_list1_idx` (`data_owners`),
......
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
  CONSTRAINT `fk_dataset_traceable1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
138 141
  CONSTRAINT `fk_dataset_dataset1` FOREIGN KEY (`parent`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
139 142
  CONSTRAINT `fk_dataset_source1` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
140 143
  CONSTRAINT `fk_dataset_source2` FOREIGN KEY (`dataset_source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
141
  CONSTRAINT `fk_dataset_traceable1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
142
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`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
144
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) 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
129 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
  "data_owners" text DEFAULT NULL /*COMMENT 'parties who must be given attribution, such as copyrightholders'*/,
132
  "data_owners" text DEFAULT NULL /*COMMENT 'parties who must be given attribution, such as copyrightholders. this includes all aggregators through which the data has passed. = Brad.vegpath.org?attribution.data_indexer'*/,
133 133
  PRIMARY KEY ("id"),
134 134
  /*CONSTRAINT "dataset_unique" */UNIQUE ("parent","name"),
135 135
  /*KEY "fk_source_party_list1_idx" ("data_owners")*/CHECK (true),
......
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
  /*CONSTRAINT "fk_dataset_traceable1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
140 143
  /*CONSTRAINT "fk_dataset_dataset1" FOREIGN KEY ("parent") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
141 144
  /*CONSTRAINT "fk_dataset_source1" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
142 145
  /*CONSTRAINT "fk_dataset_source2" FOREIGN KEY ("dataset_source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
143
  /*CONSTRAINT "fk_dataset_traceable1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
144
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("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)
146
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") 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