class CreateEdfiStudentIndicatorValues < ActiveRecord::Migration[6.0]
  def change
    create_table :EdFi_StudentIndicatorValues, primary_key: :SIVID do |t|
      t.integer :SchoolID, null: false
      t.integer :StudentID, null: false
      t.bigint :StudentIndicatorID, null: false
      t.bigint :IndicatorID, null: false

      t.index [:SchoolID, :StudentID]
    end

    add_foreign_key :EdFi_StudentIndicatorValues, :Schools, column: :SchoolID,
      primary_key: :SchoolID

    add_foreign_key :EdFi_StudentIndicatorValues, :Students, column: :StudentID,
      primary_key: :StudentID

    add_foreign_key :EdFi_StudentIndicatorValues, :EdFi_StudentIndicators,
      column: :StudentIndicatorID, primary_key: :StudentIndicatorID
  end
end