Re: [GeneX-dev] Controlled Vocabs in DB

[Greg D. C. <gd...@nc...>]

I'm sure Jason would applaud this idea. He has been saying the same thing since 
6 months ago.

Greg

>From: "Todd Peterson" <tf...@nc...>
>To: <gen...@li...>
>MIME-Version: 1.0
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
>Subject: [GeneX-dev] Controlled Vocabs in DB
>Date: Wed, 31 Jan 2001 16:06:35 -0700
>
>Having a separate table for each control vocabulary is extremely tedious. I 
propose the following table structure:
>
>table: 
>    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.