# frozen_string_literal: true

# Crea las transacciones
class CreateTransactions < ActiveRecord::Migration[6.1]
  def change
    enable_extension :pgcrypto

    create_table :transactions, id: :uuid do |t|
      t.timestamps
      t.uuid :raspberry_id, index: true
      t.datetime :timestamp
      t.string :error_code
      t.jsonb :coordinates
      t.string :battery_status
      t.string :sample
      t.string :storage
      t.string :signature
    end
  end
end