Revision 10496
Added by Aaron Marcuse-Kubitza almost 11 years ago
| VegCore.my.sql | ||
|---|---|---|
| 1041 | 1041 |
`author` varbinary(767) DEFAULT NULL, |
| 1042 | 1042 |
`common_name` varbinary(767) DEFAULT NULL, |
| 1043 | 1043 |
`rank` varbinary(767) DEFAULT NULL, |
| 1044 |
`taxon_path` varbinary(767) DEFAULT NULL, |
|
| 1044 | 1045 |
PRIMARY KEY (`id`), |
| 1045 | 1046 |
KEY `fk_taxon_concept_taxon_string10_idx` (`unique_name`), |
| 1047 |
KEY `fk_taxon_name_taxon_path1_idx` (`taxon_path`), |
|
| 1046 | 1048 |
CONSTRAINT `fk_taxon_record10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 1047 |
CONSTRAINT `fk_taxon_concept_taxon_string10` FOREIGN KEY (`unique_name`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 1049 |
CONSTRAINT `fk_taxon_concept_taxon_string10` FOREIGN KEY (`unique_name`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 1050 |
CONSTRAINT `fk_taxon_name_taxon_path1` FOREIGN KEY (`taxon_path`) REFERENCES `taxon_path` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 1048 | 1051 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 1049 | 1052 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1050 | 1053 |
|
| ... | ... | |
| 1097 | 1100 |
`genus` varbinary(767) DEFAULT NULL, |
| 1098 | 1101 |
`specific_epithet` varbinary(767) DEFAULT NULL, |
| 1099 | 1102 |
`ranks` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| 1100 |
PRIMARY KEY (`id`), |
|
| 1101 |
CONSTRAINT `fk_taxon_path_taxon_name1` FOREIGN KEY (`id`) REFERENCES `taxon_name` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 1103 |
PRIMARY KEY (`id`) |
|
| 1102 | 1104 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"a group of one (or more) populations of organism(s), which a taxonomist adjudges to be a unit" ("Wikipedia":http://en.wikipedia.org/wiki/Taxon)';
|
| 1103 | 1105 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1104 | 1106 |
|
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: taxon_path: converted to an auxiliary table of taxon_name instead of a subclass of it (like geopath for the place table). this causes distinct taxon_paths to be stored only once, instead of repeatedly for each taxon_name.