The product 9 is a hard drive, so it's inserted in the hard drive table, but
as it inherits product, I see it in product table too.
Why do i Have this message ? Can you help me ?
Thank you
David
Working as designed; foreign keys and unique indexes are only valid for the
explicit table they point to.
You can try making "hard drive" have a one-to-one relationship with
"product" instead of inheriting from it. Either give "hard drive" its own
PK and add a "Product PK" to the table or have the "hard drive" and
"product" tables both use the same primary key (product PK) with a FK
between them.
David J.