Are there ready-made database architectures for multi-site IM?

Question

MySQL

Good afternoon.
Prompt existing database architectures for a multi-site online store.
In particular, architectures that store site directory structures in a single table.
I couldn’t come up with anything better than this architecture on my own.

Answer 1

Yes, either fields with the identifier of the site / project / store or a table are added there, depending on the type of connection. and the category classifier is just a multi-root tree.

Answer 2

1) for each site, build your own tree of categories
2) for each product, indicate which sites to display it on. (M2M)
ps actually, as I understand it, you drew it.