Ian Skinner wrote: > Dave Watts wrote: >>> These tables are not a child-parent relationship. They are >>> basically the same data with some variations of fields as >>> time goes on. Is there an ER standard to express this type >>> of relationship? >>> >> No, because there is no relationship between them, as "relationships" are >> defined within a relational database. > Do you have a suggestion how one could document this type of data > model?
Just treat them as independent tables: that is what they are. If you want something better you should start with the data and put it in a better schema: your documentation follows your schema. This sounds like a job for table inheritance if your database supports it. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305254 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4