Revision 11192
Added by Aaron Marcuse-Kubitza about 11 years ago
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 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>
|
|
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>
|
|
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:09</value>
|
|
649 |
<value type="string" key="lastChangeDate">2013-10-09 11:19</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> |
... | ... | |
17500 | 17500 |
<link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link> |
17501 | 17501 |
<value _ptr_="0xba53b00" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/> |
17502 | 17502 |
<value _ptr_="0xb0204c8" type="dict" key="syncProfiles"> |
17503 |
<value type="object" struct-name="db.mgmt.SyncProfile" id="261c5266-310d-11e3-ab47-080027bcf912" struct-checksum="0xc64972c2" key="">
|
|
17504 |
<value _ptr_="0xd233de8" type="dict" key="lastKnownDBNames">
|
|
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">
|
|
17505 | 17505 |
<value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value> |
17506 | 17506 |
<value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value> |
17507 | 17507 |
<value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value> |
... | ... | |
18126 | 18126 |
<value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info"> |
18127 | 18127 |
<value type="string" key="author">Aaron Marcuse-Kubitza</value> |
18128 | 18128 |
<value type="string" key="caption">New Model</value> |
18129 |
<value type="string" key="dateChanged">2013-10-09 11:09</value>
|
|
18129 |
<value type="string" key="dateChanged">2013-10-09 11:19</value>
|
|
18130 | 18130 |
<value type="string" key="dateCreated">2012-01-19 14:06</value> |
18131 | 18131 |
<value type="string" key="description"></value> |
18132 | 18132 |
<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 data_source. e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the data_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 the GBIF dataset (the parent), but was obtained from ARIZ (the dataset_source).',
|
|
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 |
CONSTRAINT `fk_dataset_dataset1` FOREIGN KEY (`parent`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
138 | 141 |
CONSTRAINT `fk_dataset_traceable1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
139 | 142 |
CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
140 |
CONSTRAINT `fk_dataset_dataset1` FOREIGN KEY (`parent`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
141 | 143 |
CONSTRAINT `fk_dataset_source1` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
142 |
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 |
|
144 |
CONSTRAINT `fk_dataset_source2` FOREIGN KEY (`dataset_source`) REFERENCES `source` (`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 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 |
"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).'*/,
|
|
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 |
/*CONSTRAINT "fk_dataset_dataset1" FOREIGN KEY ("parent") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
140 | 143 |
/*CONSTRAINT "fk_dataset_traceable1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
141 | 144 |
/*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
142 |
/*CONSTRAINT "fk_dataset_dataset1" FOREIGN KEY ("parent") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
143 | 145 |
/*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 ("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) |
|
146 |
/*CONSTRAINT "fk_dataset_source2" FOREIGN KEY ("dataset_source") REFERENCES "source" ("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: renamed data_source to dataset_source for clarity