Revision 11194
Added by Aaron Marcuse-Kubitza about 11 years ago
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
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)