Lookup tables are simple in nature, tend to have a small number of fields and contain static (rarely updated) values and never contain foreign keys.
- Prefix lookup tables with “lk_” as in “lk_countries”.
Reason: This makes lookup tables easy to find when assigning tables to lookup or dropdown controls.
- If useful, include a field named "Inactive" as a logical field. Set this to True to hide record in lists.