Re: Table design decision

From: Tarby777 <nick_williamson_at_mentorg.com>
Date: 13 Jan 2006 01:15:32 -0800
Message-ID: <1137143732.207358.169350@g44g2000cwa.googlegroups.com>

Well, I don't think the 50 existing tables are badly designed; there are 50 different kinds of objects that can be created in the app, and each one is sufficiently different from the others to merit having its own table so I don't think that that part of the schema needs to change. The bad design I was alluding to is that the user-defined properties for all these different kinds of objects are all stored in one table, which has 50 FKs. I imagine that when the app started out, there would have been substantially less than 50 object types, and it's probably just evolved into the current monster over time.

Anyway, after much typing, I now have the DDL for my 50-new-tables option. If anything earth-shattering comes out of my testing, I'll report back. Thanks again to all who posted.

Regards,
Tarby Received on Fri Jan 13 2006 - 03:15:32 CST