Revision 8551
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 339 | 339 |
PRIMARY KEY (`id`) , |
| 340 | 340 |
INDEX `fk_voucher_taxon_occurrence1` (`taxon_occurrence` ASC) , |
| 341 | 341 |
INDEX `fk_voucher_specimen1` (`specimen` ASC) , |
| 342 |
UNIQUE INDEX `voucher_unique` (`taxon_occurrence` ASC, `specimen` ASC) , |
|
| 342 | 343 |
CONSTRAINT `fk_voucher_record1` |
| 343 | 344 |
FOREIGN KEY (`id` ) |
| 344 | 345 |
REFERENCES `record` (`id` ) |
| ... | ... | |
| 431 | 432 |
PRIMARY KEY (`id`) , |
| 432 | 433 |
INDEX `fk_stem_observation_individual_observation1` (`individual_observation` ASC) , |
| 433 | 434 |
INDEX `fk_stem_observation_stem1` (`stem` ASC) , |
| 435 |
UNIQUE INDEX `stem_observation_unique` (`individual_observation` ASC, `stem` ASC) , |
|
| 434 | 436 |
CONSTRAINT `fk_stem_observation_record1` |
| 435 | 437 |
FOREIGN KEY (`id` ) |
| 436 | 438 |
REFERENCES `record` (`id` ) |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: added unique indexes on identifying columns where possible. unique indexes differ from primary keys in that they are generally on multiple columns, while pkeys are on a text field which is the concatenation of the identifying columns.