Sha256: 147e145acd50ece77fb14959279ae0b0d86a4b514b0ba5215d48c2ee12720d75

Contents?: true

Size: 1.01 KB

Versions: 177

Compression:

Stored size: 1.01 KB

Contents

class CreateHDProfiles < ActiveRecord::Migration[4.2]
  def change
    create_table :hd_profiles do |t|
      t.belongs_to :patient, index: true, foreign_key: true
      t.belongs_to :hospital_unit, index: true, foreign_key: true

      t.string :schedule
      t.string :other_schedule
      t.integer :prescribed_time
      t.date :prescribed_on

      t.belongs_to :created_by, index: true, null: false
      t.belongs_to :updated_by, index: true, null: false

      t.jsonb :document

      t.timestamps null: false
    end

    add_index :hd_profiles, :document, using: :gin

    add_reference :hd_profiles, :prescriber, references: :users, index: true
    add_foreign_key :hd_profiles, :users, column: :prescriber_id

    add_reference :hd_profiles, :named_nurse, references: :users, index: true
    add_foreign_key :hd_profiles, :users, column: :named_nurse_id

    add_reference :hd_profiles, :transport_decider, references: :users, index: true
    add_foreign_key :hd_profiles, :users, column: :transport_decider_id
  end
end

Version data entries

177 entries across 177 versions & 1 rubygems

Version Path
renalware-core-2.0.127 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.126 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.125 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.124 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.123 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.121 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.120 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.119 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.118 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.117 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.116 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.115 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.113 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.112 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.111 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.110 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.109 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.108 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.106 db/migrate/20160202152252_create_hd_profiles.rb
renalware-core-2.0.105 db/migrate/20160202152252_create_hd_profiles.rb