I have table structure (pseudo):
Order(
order_id int PK identity(1,1),
order_date datetime
)
GiftOrder(
order_id int Primary KEY FK Order(order_id),
ReceiverAddress nvarchar(200),
Wrapped bit
)
GiftOrder isA Order, but when I make the foreign key from GiftOrder to Order, its make a two-way arrow relationship (I think strongly 1-1), and I can't insert record in Order or OrderRecord at all
You can change your
GiftOrder
table structure to be like below having only the required field withISA
relationship entity.