Revision 10449
Added by Aaron Marcuse-Kubitza almost 11 years ago
| VegCore.pg.sql | ||
|---|---|---|
| 380 | 380 |
"info" hstore DEFAULT NULL, |
| 381 | 381 |
PRIMARY KEY ("id"),
|
| 382 | 382 |
/*CONSTRAINT "fk_collection_source10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
| 383 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a\n\nb'*/;
|
|
| 383 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
|
| 384 | 384 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 385 | 385 |
|
| 386 | 386 |
-- |
| ... | ... | |
| 1065 | 1065 |
CREATE TABLE "taxon_string" ( |
| 1066 | 1066 |
"string" text NOT NULL, |
| 1067 | 1067 |
PRIMARY KEY ("string")
|
| 1068 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='to get the parsed_taxon_assertion (TNRS result) for a taxon_string, join using taxon_string.string<-taxon_assertion(string):parsed_taxon_assertion[source=''TNRS.version''] (see wiki.vegpath.org/SQL_dotpaths)'*/; |
|
| 1068 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='to get the parsed_taxon_assertion (TNRS result) for a taxon_string, join using taxon_string.string<-taxon_assertion(string)::parsed_taxon_assertion[source=''TNRS.version''] (see wiki.vegpath.org/SQL_dotpaths)'*/;
|
|
| 1069 | 1069 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1070 | 1070 |
|
| 1071 | 1071 |
-- |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: taxon_string: documented that to get the parsed_taxon_assertion (TNRS result) for a taxon_string, you would join using the SQL dotpath taxon_string.string<-taxon_assertion(string)::parsed_taxon_assertion[source='TNRS.version'] (see wiki.vegpath.org/SQL_dotpaths). important how-to comments such as this one are now included in the version-controlled MySQL schema file itself, not just the .mwb file and the staging copy on vegbiendev.