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.