Re: How to build database to support user-specified entities and attributes?

Hi,

I think of what you are looking for as a User-Extendible Facility.

Here's a Data Model that might provide some illuminating insights :- http://www.databaseanswers.org/data_models/user_extendable_datadictionary/index.htm

And here's an example of how it looks in practice :- http://www.databaseanswers.org/data_models/user_extendable_database/uedb_tables.asp

You will find you are logged in as johnd and can create tables and extend tables that belong to johnd.

HTH B.Dimple
Senior DBA

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:<1111503424.141750.32790_at_z14g2000cwz.googlegroups.com>...
> One way to support user defined attributes would be to add some extra
> variable character columns to the rows. You would add these columns to
> your screens and also add label variables to your screens for these
> columns.
>
> The screens would then select the label variable string values from a
> metadata table to match the row data for these columns. Rows without
> data in these columns would just display blanks with either no label or
> a default label such as UNUSED.
>
> In your case since you want to allow each club to define their own
> column descriptions you would need the club ID to be part of the
> metadata table.
>
> HTH -- Mark D Powell --
Received on Wed Apr 13 2005 - 23:50:15 CEST