Revision 11138
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/VegCore/ERD/document.mwb.xml | ||
|---|---|---|
| 6413 | 6413 |
<value type="int" key="precision">-1</value> |
| 6414 | 6414 |
<value type="int" key="scale">-1</value> |
| 6415 | 6415 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
| 6416 |
<value type="string" key="comment"></value> |
|
| 6417 |
<value type="string" key="name">parent_geoplace</value>
|
|
| 6416 |
<value type="string" key="comment">the parent geoplace</value>
|
|
| 6417 |
<value type="string" key="name">parent</value> |
|
| 6418 | 6418 |
<value type="string" key="oldName">parent_geoplace</value> |
| 6419 | 6419 |
<link type="object" struct-name="GrtObject" key="owner">be8f78aa-a6e0-11e2-95e9-080027bcf912</link> |
| 6420 | 6420 |
</value> |
| ... | ... | |
| 6544 | 6544 |
<value type="int" key="commentedOut">0</value> |
| 6545 | 6545 |
<value type="string" key="createDate">2013-04-16 14:58</value> |
| 6546 | 6546 |
<value _ptr_="0xad77b00" type="dict" key="customData"/> |
| 6547 |
<value type="string" key="lastChangeDate">2013-08-01 02:39</value>
|
|
| 6547 |
<value type="string" key="lastChangeDate">2013-09-30 03:57</value>
|
|
| 6548 | 6548 |
<value type="int" key="modelOnly">0</value> |
| 6549 | 6549 |
<value type="string" key="name">geovalidatable_place</value> |
| 6550 | 6550 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
| ... | ... | |
| 17463 | 17463 |
<value type="string" key="name"></value> |
| 17464 | 17464 |
</value> |
| 17465 | 17465 |
<value _ptr_="0xadd91a0" type="list" content-type="object" content-struct-name="model.Object" key="selection"> |
| 17466 |
<link type="object">7afee050-0075-11e3-906b-080027bcf912</link>
|
|
| 17466 |
<link type="object">988D9E58-7324-4913-A132-BF8CAD6050C8</link>
|
|
| 17467 | 17467 |
</value> |
| 17468 | 17468 |
<value type="int" key="updateBlocked">0</value> |
| 17469 | 17469 |
<value type="real" key="width">1.6215e+03</value> |
| ... | ... | |
| 18102 | 18102 |
<value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info"> |
| 18103 | 18103 |
<value type="string" key="author">Aaron Marcuse-Kubitza</value> |
| 18104 | 18104 |
<value type="string" key="caption">New Model</value> |
| 18105 |
<value type="string" key="dateChanged">2013-09-30 03:20</value>
|
|
| 18105 |
<value type="string" key="dateChanged">2013-09-30 03:57</value>
|
|
| 18106 | 18106 |
<value type="string" key="dateCreated">2012-01-19 14:06</value> |
| 18107 | 18107 |
<value type="string" key="description"></value> |
| 18108 | 18108 |
<value type="string" key="project">Name of the project</value> |
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 314 | 314 |
/*!40101 SET character_set_client = utf8 */; |
| 315 | 315 |
CREATE TABLE `geovalidatable_place` ( |
| 316 | 316 |
`id` varbinary(767) NOT NULL, |
| 317 |
`parent_geoplace` varbinary(767) NOT NULL,
|
|
| 317 |
`parent` varbinary(767) NOT NULL COMMENT 'the parent geoplace',
|
|
| 318 | 318 |
PRIMARY KEY (`id`), |
| 319 |
KEY `fk_geovalidatable_place_geoplace1_idx` (`parent_geoplace`),
|
|
| 320 |
CONSTRAINT `fk_nested_geoplace_geoplace1` FOREIGN KEY (`id`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 321 |
CONSTRAINT `fk_geovalidatable_place_geoplace1` FOREIGN KEY (`parent_geoplace`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 319 |
KEY `fk_geovalidatable_place_geoplace1_idx` (`parent`), |
|
| 320 |
CONSTRAINT `fk_geovalidatable_place_geoplace1` FOREIGN KEY (`parent`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 321 |
CONSTRAINT `fk_nested_geoplace_geoplace1` FOREIGN KEY (`id`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 322 | 322 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores only scrubbed geoplaces (GADM places, and distinct point coordinates that GNRS says should be located within them)'; |
| 323 | 323 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 324 | 324 |
|
| schemas/VegCore/VegCore.pg.sql | ||
|---|---|---|
| 316 | 316 |
/*!40101 SET character_set_client = utf8 */; |
| 317 | 317 |
CREATE TABLE "geovalidatable_place" ( |
| 318 | 318 |
"id" text NOT NULL, |
| 319 |
"parent_geoplace" text NOT NULL,
|
|
| 319 |
"parent" text NOT NULL /*COMMENT 'the parent geoplace'*/,
|
|
| 320 | 320 |
PRIMARY KEY ("id"),
|
| 321 |
/*KEY "fk_geovalidatable_place_geoplace1_idx" ("parent_geoplace")*/CHECK (true),
|
|
| 322 |
/*CONSTRAINT "fk_nested_geoplace_geoplace1" FOREIGN KEY ("id") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 323 |
/*CONSTRAINT "fk_geovalidatable_place_geoplace1" FOREIGN KEY ("parent_geoplace") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 321 |
/*KEY "fk_geovalidatable_place_geoplace1_idx" ("parent")*/CHECK (true),
|
|
| 322 |
/*CONSTRAINT "fk_geovalidatable_place_geoplace1" FOREIGN KEY ("parent") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 323 |
/*CONSTRAINT "fk_nested_geoplace_geoplace1" FOREIGN KEY ("id") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 324 | 324 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores only scrubbed geoplaces (GADM places, and distinct point coordinates that GNRS says should be located within them)'*/; |
| 325 | 325 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 326 | 326 |
|
Also available in: Unified diff
schemas/VegCore/ERD/VegCore.ERD.mwb: geovalidatable_place.parent_geoplace: renamed to parent so it will merge with the inherited parent field. this is the parent geoplace.