[GeneX-dev] Controlled Vocabs in DB

[Todd P. <tf...@nc...>]

Having a separate table for each control vocabulary is extremely =
tedious. I propose the following table structure:

table:=20
    ControlVocabulary
attributes:
    vocabulary_name varchar(80) NOT NULL
    term_string varchar(48) NOT NULL
    description text

Advantages: less tables which all have the same structure. less =
maintenance. generic. code simplification.
Disadvantages: code changes in DB2XML, XML2DB, control bundle generator. =
GeneXML should NOT change.

I realize this is probably something for redesign but wanted to get =
thoughts churning.