From: <jws...@ra...> - 2004-02-17 17:37:44
|
>> Note that from the standpoint of the cust_account object, these are all >> one-to-one relations. >if the relations are strict one-to-one, then why data is divided into >separate tables? They are actually many-to-one, but from this side of the join it looks like a one-to-one. This customer account has that one buyer. From the buyer side of the join, that one buyer has many potential customer accounts. >perhaps relationships may be optional, e.g. some customers are buyers, >and others are not? if this is the case, then you may consider using >SQLObject inheritance patch by Daniel Savard. No, customers = accounts and buyers = people. Inheritance is one way of looking at it, though. I will investigate that. |