[BioSQL-l] NOT NULL on seqfeature_qualifier_value.value

[Peter Cock]

On Sat, Aug 20, 2011 at 2:06 AM, Hilmar Lapp <hlapp at drycafe.net> wrote:
> There is a NOT NULL constraint on seqfeature_qualifier_value.value, which prevents simple ontology term associations to seqfeatures. The only other metadata association table in BioSQL that does this is location_qualifier_value. In the latter case there is arguably some sense to that (at least originally for locations the purpose of that table was pretty much to store the fuzzy location start/end properties), but for seqfeatures this looks like a bug to me.
>
> Any objections to or concerns with removing the NOT NULL constraint on that column?
>
> -hilmar

How are things like /psuedo and /trans_splicing from
GenBank files currently stored in BioSQL? i.e. GenBank
or EMBL feature table entries with no values. Would they
also benefit from allowing a null value?

Peter