Revision 11125
Added by Aaron Marcuse-Kubitza about 11 years ago
schemas/VegCore/ERD/document.mwb.xml | ||
---|---|---|
11187 | 11187 |
<value type="int" key="precision">-1</value> |
11188 | 11188 |
<value type="int" key="scale">-1</value> |
11189 | 11189 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
11190 |
<value type="string" key="comment"></value> |
|
11191 |
<value type="string" key="name">parent_event</value>
|
|
11190 |
<value type="string" key="comment">the parent sampling_event</value>
|
|
11191 |
<value type="string" key="name">parent</value> |
|
11192 | 11192 |
<value type="string" key="oldName">parent_event</value> |
11193 | 11193 |
<link type="object" struct-name="GrtObject" key="owner">8535dbc2-006c-11e3-895c-080027bcf912</link> |
11194 | 11194 |
</value> |
... | ... | |
11381 | 11381 |
<value type="int" key="commentedOut">0</value> |
11382 | 11382 |
<value type="string" key="createDate">2013-04-16 14:58</value> |
11383 | 11383 |
<value _ptr_="0xa9aba70" type="dict" key="customData"/> |
11384 |
<value type="string" key="lastChangeDate">2013-09-22 02:04</value>
|
|
11384 |
<value type="string" key="lastChangeDate">2013-09-30 02:04</value>
|
|
11385 | 11385 |
<value type="int" key="modelOnly">0</value> |
11386 | 11386 |
<value type="string" key="name">stratum_event</value> |
11387 | 11387 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
... | ... | |
17618 | 17618 |
<value type="string" key="name"></value> |
17619 | 17619 |
</value> |
17620 | 17620 |
<value _ptr_="0xa9c9950" type="list" content-type="object" content-struct-name="model.Object" key="selection"> |
17621 |
<link type="object">5600079C-23BA-4A27-BDB6-87D19B80AF56</link>
|
|
17621 |
<link type="object">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
|
|
17622 | 17622 |
</value> |
17623 | 17623 |
<value type="int" key="updateBlocked">0</value> |
17624 | 17624 |
<value type="real" key="width">1.6215e+03</value> |
... | ... | |
17632 | 17632 |
<link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link> |
17633 | 17633 |
<value _ptr_="0xa91b830" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/> |
17634 | 17634 |
<value _ptr_="0x9de1448" type="dict" key="syncProfiles"> |
17635 |
<value type="object" struct-name="db.mgmt.SyncProfile" id="27c1bb1c-29ae-11e3-a980-080027bcf912" struct-checksum="0xc64972c2" key="">
|
|
17636 |
<value _ptr_="0xbefce70" type="dict" key="lastKnownDBNames">
|
|
17635 |
<value type="object" struct-name="db.mgmt.SyncProfile" id="5328e8de-29ae-11e3-a980-080027bcf912" struct-checksum="0xc64972c2" key="">
|
|
17636 |
<value _ptr_="0xbd0a748" type="dict" key="lastKnownDBNames">
|
|
17637 | 17637 |
<value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value> |
17638 | 17638 |
<value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value> |
17639 | 17639 |
<value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value> |
... | ... | |
18261 | 18261 |
<value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info"> |
18262 | 18262 |
<value type="string" key="author">Aaron Marcuse-Kubitza</value> |
18263 | 18263 |
<value type="string" key="caption">New Model</value> |
18264 |
<value type="string" key="dateChanged">2013-09-30 01:57</value>
|
|
18264 |
<value type="string" key="dateChanged">2013-09-30 02:04</value>
|
|
18265 | 18265 |
<value type="string" key="dateCreated">2012-01-19 14:06</value> |
18266 | 18266 |
<value type="string" key="description"></value> |
18267 | 18267 |
<value type="string" key="project">Name of the project</value> |
schemas/VegCore/VegCore.my.sql | ||
---|---|---|
1028 | 1028 |
/*!40101 SET character_set_client = utf8 */; |
1029 | 1029 |
CREATE TABLE `stratum_event` ( |
1030 | 1030 |
`id` varbinary(767) NOT NULL, |
1031 |
`parent_event` varbinary(767) NOT NULL,
|
|
1031 |
`parent` varbinary(767) NOT NULL COMMENT 'the parent sampling_event',
|
|
1032 | 1032 |
`stratum` varbinary(767) NOT NULL, |
1033 | 1033 |
PRIMARY KEY (`id`), |
1034 | 1034 |
KEY `fk_stratum_event_stratum1_idx` (`stratum`), |
1035 |
KEY `fk_stratum_event_sampling_event2_idx` (`parent_event`),
|
|
1036 |
CONSTRAINT `fk_stratum_event_stratum1` FOREIGN KEY (`stratum`) REFERENCES `stratum` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
1035 |
KEY `fk_stratum_event_sampling_event2_idx` (`parent`), |
|
1036 |
CONSTRAINT `fk_stratum_event_sampling_event2` FOREIGN KEY (`parent`) REFERENCES `taxa_sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
1037 | 1037 |
CONSTRAINT `fk_stratum_event_sampling_event1` FOREIGN KEY (`id`) REFERENCES `taxa_sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
1038 |
CONSTRAINT `fk_stratum_event_sampling_event2` FOREIGN KEY (`parent_event`) REFERENCES `taxa_sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
1038 |
CONSTRAINT `fk_stratum_event_stratum1` FOREIGN KEY (`stratum`) REFERENCES `stratum` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
1039 | 1039 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= VegX.vegpath.org?stratumObservation, VegBank.vegpath.org?stratum (which was confusingly named)'; |
1040 | 1040 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1041 | 1041 |
|
schemas/VegCore/VegCore.pg.sql | ||
---|---|---|
1030 | 1030 |
/*!40101 SET character_set_client = utf8 */; |
1031 | 1031 |
CREATE TABLE "stratum_event" ( |
1032 | 1032 |
"id" text NOT NULL, |
1033 |
"parent_event" text NOT NULL,
|
|
1033 |
"parent" text NOT NULL /*COMMENT 'the parent sampling_event'*/,
|
|
1034 | 1034 |
"stratum" text NOT NULL, |
1035 | 1035 |
PRIMARY KEY ("id"), |
1036 | 1036 |
/*KEY "fk_stratum_event_stratum1_idx" ("stratum")*/CHECK (true), |
1037 |
/*KEY "fk_stratum_event_sampling_event2_idx" ("parent_event")*/CHECK (true),
|
|
1038 |
/*CONSTRAINT "fk_stratum_event_stratum1" FOREIGN KEY ("stratum") REFERENCES "stratum" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
1037 |
/*KEY "fk_stratum_event_sampling_event2_idx" ("parent")*/CHECK (true), |
|
1038 |
/*CONSTRAINT "fk_stratum_event_sampling_event2" FOREIGN KEY ("parent") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
1039 | 1039 |
/*CONSTRAINT "fk_stratum_event_sampling_event1" FOREIGN KEY ("id") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
1040 |
/*CONSTRAINT "fk_stratum_event_sampling_event2" FOREIGN KEY ("parent_event") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
1040 |
/*CONSTRAINT "fk_stratum_event_stratum1" FOREIGN KEY ("stratum") REFERENCES "stratum" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
1041 | 1041 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= VegX.vegpath.org?stratumObservation, VegBank.vegpath.org?stratum (which was confusingly named)'*/; |
1042 | 1042 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1043 | 1043 |
|
Also available in: Unified diff
schemas/VegCore/ERD/VegCore.ERD.mwb: stratum_event.parent_event: renamed to parent so it will merge with the inherited parent field