Revisit column defintions - Add NULL constraints and indexes #154
Labels
DB
Any requests related to changes/updates of the DB table structure or definitions
enhancement
New feature or request
Most of our column definitions don't have the null constraint.
For example - an instrument can be currently be added without a name.
This can be improved by adding
Second review while doing a swoop through the tables is to check for needed indexes.
From the above example, it would also be good to have an index on names since that is a very frequent query we will have
The text was updated successfully, but these errors were encountered: