class CreateApiKeys < ActiveRecord::Migration[6.1]
  def change
    create_table :api_keys, id: :uuid do |t|
      t.references :account,
        type:        :uuid,
        null:        false,
        index:       true,
        foreign_key: true

      t.string :key_id,        null: false, index: { unique: true }
      t.string :authenticator, null: false, index: { unique: true }

      t.datetime :last_used_at, null: false

      t.timestamps null: false, index: true

      t.index %i[account_id last_used_at]
    end
  end
end