Revision 10450
Added by Aaron Marcuse-Kubitza almost 11 years ago
| VegCore.pg.sql | ||
|---|---|---|
| 262 | 262 |
CREATE TABLE "individual" ( |
| 263 | 263 |
"id" text NOT NULL, |
| 264 | 264 |
"tag" text DEFAULT NULL, |
| 265 |
"tag_history" hstore DEFAULT NULL, |
|
| 265 | 266 |
PRIMARY KEY ("id"),
|
| 266 | 267 |
/*CONSTRAINT "fk_individual_record1" FOREIGN KEY ("id") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
| 267 | 268 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A distinct biological organism'*/; |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: individual: added tag_history hstore to store custom identity attributes