I have an existing table in an app, along the lines of:
CREATE TABLE foo (
name text,
address text,
some_numeric_info integer,
<a bunch of additional fields here>
);
I now need to be able to associate additional information (e.g. printing
order) with each field. Is it a bad idea to use the (fully qualified)
field name as a foreign key to link back to the table meta-data? Is
there a better way?