Revision 10450
Added by Aaron Marcuse-Kubitza almost 11 years ago
| VegCore.my.sql | ||
|---|---|---|
| 260 | 260 |
CREATE TABLE `individual` ( |
| 261 | 261 |
`id` varbinary(767) NOT NULL, |
| 262 | 262 |
`tag` varbinary(767) DEFAULT NULL, |
| 263 |
`tag_history` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
|
| 263 | 264 |
PRIMARY KEY (`id`), |
| 264 | 265 |
CONSTRAINT `fk_individual_record1` FOREIGN KEY (`id`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 265 | 266 |
) 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