I've got dozens of "type" tables that are mostly identical and I would like to consolidate them all into a handful of tables. (i.e. a table of types)
For example, the tables Permit Type, Employee Type, Line Type, Vendor Type, etc. all have the same basic columns:
There are a few that might have an additional attribute column, but for the most part they're just an ID and a Name.
Does anyone have a link to an example of creating a table of types, or just advice in general?