Re: How to build database to support user-specified entities and attributes?
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 22 Mar 2005 06:57:04 -0800
Message-ID: <1111503424.141750.32790_at_z14g2000cwz.googlegroups.com>
Date: 22 Mar 2005 06:57:04 -0800
Message-ID: <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 Tue Mar 22 2005 - 15:57:04 CET