Multiple schemas per table

[tiziano]

Hello, can you give me some indications for when it is advisable to use multiple schemas for the same table in Ecto?

In the Ecto.Schema documentation it is stated that “An Ecto schema is used to map any data source into an Elixir struct. One of such use cases is to map data coming from a repository, usually a table, into Elixir structs.”

In general, should I always map an sql table to a schema, or there are nice examples where multiple schemas pointing to the same table is a more logical choice?

Thank you

[kokolegorille]

It might be advisable to use multiple schemas when dealing with cross boundaries associations.

Instead of crossing contexts, use 2 schemas of the same table, but with different responsabilities.

I have an example where I use 2 User schemas for the same table here…

Question about Contexts and Pivot tables

Another way is to have 2 User schemas, one in Account, one in Server. Account User would be read/write, Server User would be read only, and used into link to Server context.

[tiziano]

Thank you, really helpful!