Code Tables

Code tables are what programmers might refer to as "editable enums" and DBAs might call "look-up tables" – but what’s in a name? To Infinity, a code table is just a simple table with ID and Description columns that encapsulate one aspect of an entity – like a list of states for an address table or a constituency type for an individual.

For our example, let's create a parking zone color code table for our parking pass.