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@myemma.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