How to create a messaging system for three independent user groups?

Question

Database design

I'm poking around in a project where there are three user groups - Buyers, Staff, Couriers. It is quite logical that each group should be separate. It's not kosher to create three independent message tables with a bunch of related tables. I came up with the idea of ​​dividing id by digits 1 - ..., 1001 - ..., 10001 -... Now I can’t figure out how to build queries for writing and selecting from tables and whether it is worth making linked tables for all entities or somehow it is possible to dump everything in one message_user? Let me know if anyone has experienced something similar.

Answer 1

roles
role_user Laravel
notification, the table is already there.
As a bonus, other entities can now also not be divided because users are divided.