Re: Using meta-data for foreign key?

On Apr 17, 2008, at 10:23 AM, Mike Blackwell wrote:
> 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?

You're going to have to be *much* more specific about what you're
trying to do/talk about. A complete example would be best.

Erik Jones

DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com