Re: [Gusdev-gusdev] Relation between tables

[Steve F. <sfi...@pc...>]

thomas-

I don't know the answer to this.   I will ask around.

steve

Thomas Otto wrote:

> Hello,
>
> I am uploading some kegg data in the GUS system...
>
> So I looked which tables are existing, and which we are needing i.e. 
> for compound, reactions. Now I am not sure how is the convention to 
> relate the data.
>
> Example:
> The Enzymes are related to the compounds.
> (1) In EzymeClassAttribute I write the names of the compound related 
> to each enzyme. In CompoundClassAttribute I write also all EC-numbers, 
> related to it.
> (2) Other possibilty would be to utilize a thrid table 
> EnzymeCompoundRelation, where I put the primkeys of the relations.
>
> (1) would be faster, easier to query, but redundend.
> (2) Cleaner
>
> What are you thinking I should use?
>
> Thanks,
> Thomas
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev