Re: Generic schema design

The definition of the dictionary table(s) would depend on how fancy of a query tool you were going to provide the end users. But at the very least you would need a mapping of the physical table columns and rows to user columns and rows. Some of the Oracle table rows are user logical table X and other are user logical talbe Y and user tables X and Y would have different columns.

It is possible that you might be able to query all the real table columns every time and then in code filter out the columns not needed for display based on your input screens or report definitions. So you could have a mapping table and a report table and the physical table. But it will all depend on exactly what you need to do with the data.

The rest is going to be up to your team
HTH -- Mark D Powell -- Received on Tue Feb 14 2006 - 09:44:48 CST