That sounds too me like a basic normalized datamodel. http://www.mschopman.demon.nl/diagram.gif uses a similair approach. It is just way to keep things in hand when handling data with alot of dependencies and modelling for future enhancements.
________________________________ From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Mon 5/9/2005 6:24 PM To: CF-Talk Subject: odd data model Hey All, I always join my tables directly like so: TableA.PK_Field joins to FK TableB.PK_Field_fromTableA Like with products and categories..the product records have an FK back to categories table via cat_id Now I've been handed with a data model that joins all tables associated with lets say products via a central table that contains the PKs from all child tables. So the central table would have prod_id, cat_id, color_id, etc Some relationships between the child tables are one to many..some are many to many...all are held in this central table instead of actual relationships between tables Has anyone ever seen data setup this way? I never have.... TIA Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206105 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
