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.147 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.146 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.145 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.144 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.143 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.142 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.141 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.140 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.139 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.138 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.137 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.136 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.135 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.134 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.133 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.132 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.131 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.130 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.129 db/migrate/20170917185426_add_indexes_to_diary_slots.rb
renalware-core-2.0.128 db/migrate/20170917185426_add_indexes_to_diary_slots.rb