class AddFieldsToStudentDetails < ActiveRecord::Migration[6.0]
  def change
    add_column :StudentDetails, :BirthCity, :string, after: :EnteredUS, limit: 30
    add_column :StudentDetails, :BirthStateID, :bigint, after: :BirthCity
    add_column :StudentDetails, :BirthCountryID, :bigint, after: :BirthStateID

    add_foreign_key :StudentDetails, :us_states, column: :BirthStateID
    add_foreign_key :StudentDetails, :iso_countries, column: :BirthCountryID
  end
end