• 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

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)

Create permalinking page¶

see vegbiendev .

• 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 (and fix capitalization using the VegCore vocabulary)