Revision 10496
Added by Aaron Marcuse-Kubitza almost 11 years ago
| VegCore.pg.sql | ||
|---|---|---|
| 1043 | 1043 |
"author" text DEFAULT NULL, |
| 1044 | 1044 |
"common_name" text DEFAULT NULL, |
| 1045 | 1045 |
"rank" text DEFAULT NULL, |
| 1046 |
"taxon_path" text DEFAULT NULL, |
|
| 1046 | 1047 |
PRIMARY KEY ("id"),
|
| 1047 | 1048 |
/*KEY "fk_taxon_concept_taxon_string10_idx" ("unique_name")*/CHECK (true),
|
| 1049 |
/*KEY "fk_taxon_name_taxon_path1_idx" ("taxon_path")*/CHECK (true),
|
|
| 1048 | 1050 |
/*CONSTRAINT "fk_taxon_record10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 1049 |
/*CONSTRAINT "fk_taxon_concept_taxon_string10" FOREIGN KEY ("unique_name") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 1051 |
/*CONSTRAINT "fk_taxon_concept_taxon_string10" FOREIGN KEY ("unique_name") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 1052 |
/*CONSTRAINT "fk_taxon_name_taxon_path1" FOREIGN KEY ("taxon_path") REFERENCES "taxon_path" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 1050 | 1053 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
| 1051 | 1054 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1052 | 1055 |
|
| ... | ... | |
| 1099 | 1102 |
"genus" text DEFAULT NULL, |
| 1100 | 1103 |
"specific_epithet" text DEFAULT NULL, |
| 1101 | 1104 |
"ranks" hstore DEFAULT NULL, |
| 1102 |
PRIMARY KEY ("id"),
|
|
| 1103 |
/*CONSTRAINT "fk_taxon_path_taxon_name1" FOREIGN KEY ("id") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 1105 |
PRIMARY KEY ("id")
|
|
| 1104 | 1106 |
) /*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)'*/;
|
| 1105 | 1107 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1106 | 1108 |
|
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.