What’s a good approach for referencing lookup/reference data (static)
one has loaded in a reference table. Say for example “tax codes”, which
pretty much have just the database ID and then a description field.
options that come to mind:
1 - By ID - however this makes an assumption that the data always loads
a database and gets the same IDs (i.e. when you’re loading your static
2 - Search by description to identify the record - but obviously if one
changes the description this isn’t very good.
3 - Perhaps create a specific identify/key as a new column that you use,
is not the database Rails ID? How’s this sound?