Many-to-many / join tables

[EmileSpecs]

Hi

It is not clear to me how to approach many-to-many / join tables in Dove (v5).

I can create a service for each, but that doesn't seem optimal since I'll never really directly use the service as those tables will just be used to resolve relational data.

But if I don't have those services and just use migrations to add the tables, there's no schema etc for these tables.
Or is it just best practice to create a service for all tables (and then restrict external calls to the service)?

Is there any advice on how to approach this? I haven't found anything on this anywhere I searched...

Thanks!

[indatawetrust]

Creating a relation service and tracking the relationships through it seems like the best option. For example, let's assume there are two services named post and category. You can proceed by creating a service called post-category-relation and keeping the post and category id information there. If necessary, you can access this service through the schemas of the post and category services.