class CreateRoleGroupMembers < ActiveRecord::Migration[6.1]
  def change
    create_table :role_group_members do |t|
      t.bigint :role_group_id, null: false
      t.integer :user_id, null: false
      t.text :note
      t.timestamps
    end

    add_index :role_group_members, :role_group_id
    add_index :role_group_members, :user_id
    add_index :role_group_members, [:role_group_id, :user_id], unique: true
    add_foreign_key :role_group_members, :role_groups
    add_foreign_key :role_group_members, :users
  end
end