ModelSEED/Model-SEED-core — Issue #97: Database defaults
Author: samseaver
Created: 2011-11-14 19:43:38+00:00
State: open

Currently, there are some fields that are not set to the pre-supposed defaults. For example, there are NULL charges in the compound table. The default value for these should be "10000000" as set by the import_model code. These NULL charges throw errors when an attempt is made to compare the charge of a compound.

As far as I can understand, the schema for the creation of a database table should set these defaults, and should also state whether a field should be "NON-NULL" by default.

What I'm proposing here is a more refined fined-tuned schema and an update of the data so that it is compatible.