Lookup Tables Best Practices: DB Tables… or Enumerations

Generally you should only use enumeration where there is a clear set of items that will not change, e.g. primary colours, or continent names. Otherwise lookup tables with appropriately implemented foreign keys are pretty much always the best option. There is a possible variation on the lookup table option where you potentially have a large … Read more