hey@ronlinet, thanks for the discussion thread.

I see a lot of value in the junction table. Since the thread can query all of the messages with the same id andmessages know whichthread they belong to, the junction table seems unnecessary. Does it have an extra benefit that I'm missing?

We originally had foreign keys on the tables, but it introduced a lot of issues in some applications. Since you can override any of the models in the config, and the models could have different table names, this introduced conflicts. We decided to drop FK handling in the package directly and leave that up to the individual application to add or not.

Hi@cmgmyr

Thank you for considering the use case.

After reviewing the things I do agree that a junction may be in this case an overkill.

There is still an advantage of ON DELETE CASCADE option where MySql takes care of associated messages deletion without requiring you guys writing any single line of PHP.

Sure things do work well in both cases :) .

Feel free to close the issue.

Thank you for your time.