Task #560
Updated by Aaron Marcuse-Kubitza over 11 years ago
* term details go in column comments, with Redmine formatting translated to HTML * each synonym becomes a parameter to a function with the same name as the term, which COALESCEs the synonyms together term h3. Modify phpPgAdmin to render HTML in column comments * don't strip HTML tags * wrap comment in a @pre@ tag (but with normal font) instead of using a plain text->HTML translator * replace @[[term]]@ with a permalink to the term * display schema comment on schema's main page (tables list) h3. Create permalinking page * permalinks can be made by linking to a shortened URL (e.g. from bit.ly), which points to a Javascript page that redirects to the appropriate phpPgAdmin page depending on the URL fragment (the fragment because URL shorteners don't pass along other parts of the URL) ** to ensure that permalinks are always valid, the Javascript page should translate synonyms using the "VegCore thesaurus":https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/mappings/VegCore.thesaurus.csv (and fix capitalization using the "VegCore vocabulary":https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/mappings/VegCore.vocab.csv)