Revision 10809
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/VegCore/VegCore.pg.sql | ||
|---|---|---|
| 387 | 387 |
CREATE TABLE "individual_observation" ( |
| 388 | 388 |
"id" text NOT NULL, |
| 389 | 389 |
"place_observed_at" text DEFAULT NULL, |
| 390 |
"individual" text DEFAULT NULL, |
|
| 390 |
"individual" text DEFAULT NULL /*COMMENT 'optional because an individual_observation cannot have an associated individual unless the individual is traceable to a specific plant'*/,
|
|
| 391 | 391 |
"code" text DEFAULT NULL, |
| 392 | 392 |
"traits" hstore DEFAULT NULL, |
| 393 | 393 |
PRIMARY KEY ("id"),
|
| schemas/VegCore/document.mwb.xml | ||
|---|---|---|
| 7386 | 7386 |
<value type="int" key="precision">-1</value> |
| 7387 | 7387 |
<value type="int" key="scale">-1</value> |
| 7388 | 7388 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
| 7389 |
<value type="string" key="comment"></value> |
|
| 7389 |
<value type="string" key="comment">optional because an individual_observation cannot have an associated individual unless the individual is traceable to a specific plant</value>
|
|
| 7390 | 7390 |
<value type="string" key="name">individual</value> |
| 7391 | 7391 |
<value type="string" key="oldName">individual</value> |
| 7392 | 7392 |
<link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link> |
| ... | ... | |
| 7600 | 7600 |
<value type="int" key="commentedOut">0</value> |
| 7601 | 7601 |
<value type="string" key="createDate">2013-04-17 13:54</value> |
| 7602 | 7602 |
<value _ptr_="0xada6590" type="dict" key="customData"/> |
| 7603 |
<value type="string" key="lastChangeDate">2013-08-30 05:03</value>
|
|
| 7603 |
<value type="string" key="lastChangeDate">2013-08-30 05:09</value>
|
|
| 7604 | 7604 |
<value type="int" key="modelOnly">0</value> |
| 7605 | 7605 |
<value type="string" key="name">individual_observation</value> |
| 7606 | 7606 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
| ... | ... | |
| 17341 | 17341 |
<value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info"> |
| 17342 | 17342 |
<value type="string" key="author">Aaron Marcuse-Kubitza</value> |
| 17343 | 17343 |
<value type="string" key="caption">New Model</value> |
| 17344 |
<value type="string" key="dateChanged">2013-08-30 05:06</value>
|
|
| 17344 |
<value type="string" key="dateChanged">2013-08-30 05:09</value>
|
|
| 17345 | 17345 |
<value type="string" key="dateCreated">2012-01-19 14:06</value> |
| 17346 | 17346 |
<value type="string" key="description"></value> |
| 17347 | 17347 |
<value type="string" key="project">Name of the project</value> |
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 385 | 385 |
CREATE TABLE `individual_observation` ( |
| 386 | 386 |
`id` varbinary(767) NOT NULL, |
| 387 | 387 |
`place_observed_at` varbinary(767) DEFAULT NULL, |
| 388 |
`individual` varbinary(767) DEFAULT NULL, |
|
| 388 |
`individual` varbinary(767) DEFAULT NULL COMMENT 'optional because an individual_observation cannot have an associated individual unless the individual is traceable to a specific plant',
|
|
| 389 | 389 |
`code` varbinary(767) DEFAULT NULL, |
| 390 | 390 |
`traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| 391 | 391 |
PRIMARY KEY (`id`), |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: individual_observation.individual: documented that it is optional because an individual_observation cannot have an associated individual unless the individual is traceable to a specific plant