[Gusdev-gusdev] Re: proposed modifications to GO Schema for GUS3.0

[Arnaud K. <ax...@sa...>]

Sharon Diskin wrote:

>
>> Also re. the GOTerm table, would it be possible to add a comment field ?
>
>
> I do not have a problem with this.  Does anyone else have an opinion 
> on this?  What type of information would you put in the comment field?

Matt,

Do you have an example of comment you want to store ?

I should mention than the GO database design allows to store several 
comments (one to many relationship), one comment field might be enough 
though and would keep the design simple.

cheers
Arnaud

>
> Cheers,
> Sharon
>
> p.s.  I will be out of town until Monday July 22nd.
>
>>
>> cheers
>> Arnaud
>>
>> Sharon Diskin wrote:
>>
>>> Hi Arnaud,
>>>
>>> I've attached the new GO schema and documentation that Jonathan 
>>> Schug and I have come up. We believe that this new schema addresses 
>>> your concern about the association date and also provides a better 
>>> way of tracking multiple instances/sources of the same association 
>>> (see description of GOAssociationInstance table).
>>>
>>>
>>> Regarding your other question concerning the 'DB:Ref' and 'from or 
>>> with', we see these being tracked using the generic Evidence 
>>> table.   The 'from or with' would be Evidence for the 
>>> GOAssocInstEvidCode entry as it is connected to a specific evidence 
>>> code that is assigned to the association.  The 'DB:Ref' (such as in 
>>> the PubMed example you mentioned) would be Evidence for the 
>>> GOAssociationInstance entry as it is _not_ connected to a specific 
>>> evidence code, but rather the association as a whole.  More details 
>>> can be found in the attached documentation.
>>>
>>>
>>> Any feedback is welcome.  Also, if any of this is unclear, just let 
>>> us know.
>>>
>>> Cheers,
>>> Sharon
>>>
>>>
>>
>