Revision 10521
Added by Aaron Marcuse-Kubitza almost 11 years ago
| VegCore.pg.sql | ||
|---|---|---|
| 296 | 296 |
/*!40101 SET character_set_client = utf8 */; |
| 297 | 297 |
CREATE TABLE "individual" ( |
| 298 | 298 |
"id" text NOT NULL, |
| 299 |
"plot_position" text DEFAULT NULL,
|
|
| 299 |
"place" text NOT NULL,
|
|
| 300 | 300 |
"tag" text DEFAULT NULL, |
| 301 | 301 |
"tag_history" hstore DEFAULT NULL, |
| 302 | 302 |
PRIMARY KEY ("id"),
|
| 303 |
/*KEY "fk_individual_plot_element1_idx" ("plot_position")*/CHECK (true),
|
|
| 304 |
/*CONSTRAINT "fk_individual_plot_element1" FOREIGN KEY ("plot_position") REFERENCES "plot_element" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 303 |
/*KEY "fk_individual_rel_place1_idx" ("place")*/CHECK (true),
|
|
| 304 |
/*CONSTRAINT "fk_individual_rel_place1" FOREIGN KEY ("place") REFERENCES "rel_place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 305 | 305 |
/*CONSTRAINT "fk_individual_record1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
| 306 | 306 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A distinct biological organism'*/; |
| 307 | 307 |
/*!40101 SET character_set_client = @saved_cs_client */; |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: individual: require it to have a place (which may be a rel_place within another place). do not require the place to be a plot_element, because individuals can be located in places other than uniformly-shaped plots.