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
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)