Re: [Gusdev-gusdev] Relation between tables

[Angel P. <an...@pc...>]

OK, I don't see where you are getting EnzymCompoundRelation & 
CompoundClassAttribute from. Our current version of GUS does not have 
these tables. The SRes.EnzymeClass table is also looking very wacky to 
me. Propose a nice structure for this and we can put it in the next 
release of GUS.

Angel

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