[BioSQL-l] One Datasource => One Comment?

[Marc Logghe]

> -----Original Message-----
> From: Raphael A. Bauer [mailto:raphael.bauer at informatik.hu-berlin.de]
> Sent: Monday, December 15, 2003 4:00 PM
> To: biosql-l at open-bio.org
> Subject: [BioSQL-l] One Datasource => One Comment?
> 
> 
> Hello BioSQL List,
> 
> When I parse Swissprot or Genbank or EMBL into a newly 
> generated biosql 
> schema - is it possible that there can be generated more than one 
> comment entries for a single bioentry?

Sure, that is possible. They even get an internal ranking so that when you fetch the bioentry from biosql and dump it as say, genbank, they end up in the same order as originally entered.

> I would think that more comments for a single bioentry can 
> only happen 
> if there is more than one datasource in the biosql-schema 
> (eg. Genbank 
> and Swissprot together).
> Am I right?
I don't follow you here. Every COMMENT field from the original genbank record becomes a separate entry in the comment table, which is linked to the bioentry via its FK (Bioentry ID)
HTH,
Marc