group.ex

defmodule Test.Group do
  use Test.Web, :model

  @primary_key {:ID, :id, autogenerate: true}
  schema "TEST_GROUPS" do
    field :NAME, :string

    belongs_to :TENANT, Test.Tenant, foreign_key: :TENANT_ID, references: :ID

    has_many :PERMISSIONS, Test.Permission, foreign_key: :GROUP_ID, references: :ID

    many_to_many :USERS, Test.User, join_through: "TEST_GROUPS_USERS", join_keys: [GROUP_ID: :ID, USER_ID: :ID]
  end

end