Contents

class CreateSsnValidatorDeathMasterFiles < ActiveRecord::Migration

  def change
    create_table :death_master_files do |t|
      t.string :social_security_number
      t.string :last_name
      t.string :name_suffix
      t.string :first_name
      t.string :middle_name
      t.string :verify_proof_code
      t.date :date_of_death
      t.date :date_of_birth
      t.string :state_of_residence
      t.string :last_known_zip_residence
      t.string :last_known_zip_payment
      t.timestamps
      t.date :as_of
    end
    add_index :death_master_files, :social_security_number, unique: true, name: 'idx_ssn'
    add_index :death_master_files, :as_of, name: 'idx_as_of'
  end

end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
ssn_validator-1.1.0	db/migrate/20130914201438_create_ssn_validator_death_master_files.rb