db/migrate/20250820175742_create_nutrient_measurements.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27

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