Class: AddNppesTable

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
lib/generators/active_record/add_nppes_table.rb

Class Method Summary collapse

Class Method Details

.down ⇒ Object 



29
30
31
32
 
# File 'lib/generators/active_record/add_nppes_table.rb', line 29

def self.down
  #remove_index :np_identifiers, :name => 'np_identifiers_npi'
  drop_table :np_identifiers
end

.up ⇒ Object 



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
 
# File 'lib/generators/active_record/add_nppes_table.rb', line 2

def self.up
  create_table :np_identifiers do |t|
    t.integer  :npi
    t.integer  :owner_id
    t.string   :owner_type

    t.string   :npi_deactivation_reason_code,           :limit => 2
    t.date     :npi_deactivation_date
    t.date     :npi_reactivation_date

    t.string   :first_name,                            :limit => 50
    t.string   :middle_name,                           :limit => 50
    t.string   :last_name,                             :limit => 50
    t.string   :prefix,                                :limit => 5
    t.string   :suffix,                                :limit => 5

    t.string   :gender_code,                           :limit => 1
    t.string   :entity_type_code,                      :limit => 1

    t.date     :last_update_date

    t.timestamps
  end

  add_index(:np_identifiers, [:npi], {:name => 'np_identifiers_npi'})
end