Project

General

Profile

Task #560

Updated by Aaron Marcuse-Kubitza about 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 

 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 Create permalinking page- 

 p((. _see "vegbiendev":http://vegbiendev.nceas.ucsb.edu/ ._ 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)

Back