0
I am deploying a table to save the messages, in this table I have source users (sender) and destination user(recipient) from the same table: user.
When trying to add the constraints to the message table, I have the following error: The restriction introduction FOREIGN KEY
FK_MOVMSGCHT_IDCUSRDST
on the table MOVMSGCHT
can cause cycles or multiple cascading paths. Specify ON DELETE NO ACTION
or ON UPDATE NO ACTION
, or modify other restrictions FOREIGN KEY
.
Is there any way to use DELETE CASCADE
in this case?