class CreateNutrientMeasurements < ActiveRecord::Migration[8.0]
  def change
    create_table :nutrient_measurements do |t|
      t.date :measured_on
      t.float :nno3
      t.float :p
      t.float :k
      t.float :ca
      t.float :mg
      t.float :s
      t.float :na
      t.float :cl
      t.float :si
      t.float :fe
      t.float :zn
      t.float :b
      t.float :mn
      t.float :cu
      t.float :mo
      t.float :nnh4

      t.timestamps
    end

    add_index :nutrient_measurements, :measured_on, unique: true
  end
end