|Subject||RE: [IB-Architect] Table Inheritance|
>for the purpose of discussion, pick one and explain why.Fine, make things simple. ;-]
>Natural primary keys are a real problem in the unified semantic model --*ponderponder* It would be the responsability of the developer to define a
>a single primary index that implements primary keys for all tables
>in a type hierarchy is flat impossible. About the only way out that
>I can think of is an artificial unique field in the root table. Any
primary key that is valid for all tables in the hierarchy. That key must
then be unique across the tables. For example if I had a master table
Customers, 3 descendant tables Customers1, Customers2, Customers3, and
Customers defined a primary key of CUSTID, then a record in Customers1 could
not have the same CUSTID as a record in Customers3.
Segue Technologies, Inc.