Re: [GeneX-dev] Controlled Vocabs in DB

[<ja...@op...>]

"Greg D. Colello" <gd...@nc...> writes:

> I'm sure Jason would applaud this idea. He has been saying the same thing since 
> 6 months ago.
> 
> >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

<applaud sound_volume="loud"/>

I would suggest we be liberal and make them varchar(128). I think we
agreed all varchars be 128 unless we have a reason to want them
short. 

jas.