Sha256: 67b69f01a2dc0c7b8ecddf3928d595ee95d05beda01e48fcdda0d02193e0fd12

Contents?: true

Size: 707 Bytes

Versions: 171

Compression:

Stored size: 707 Bytes

Contents

class AddIndexesToDiarySlots < ActiveRecord::Migration[5.1]
  def change
    # This unique index ensures that, for a diary (weekly or master), the same patient can
    # only be added to one station in any period (am pm etc) on any day of the week
    add_index :hd_diary_slots,
              [
                :diary_id,
                :diurnal_period_code_id,
                :day_of_week,
                :patient_id
              ],
              unique: true,
              name: "idx_unique_diaryslot_patients"

    add_column :hd_diary_slots, :archived, :boolean, null: false, default: false
    add_index :hd_diary_slots, :archived
    add_column :hd_diary_slots, :archived_at, :datetime
  end
end

Version data entries

171 entries across 171 versions & 1 rubygems

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