Here is a nice db structure shared by Dale Mead on the IA-CMS list (a new Yahoo group that just started up recently):
Another approach to Logical Data Model for a thesaurus could look something like this:
term_id (primary key)
(values: broader_narrower, related)
More CMS vendors need to provide support for thesauri management and integration (the database structure above is based on what is used in Documentum). Don’t take my word for it. Listen to Lou:
Content management system vendors take note: your bloody products might actually provide value if 1) you enabled manual indexing by integrating thesaurus management capabilities; and 2) that manual indexing stuff is “real work” too, so start figuring out how to better integrate it within your work flow support.