[Gusdev-gusdev] Relation between tables

[Thomas O. <ot...@fi...>]

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