[BioSQL-l] NOT NULL on seqfeature_qualifier_value.value

[Hilmar Lapp]

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

Sent with a tap.