Sha256: 3fb33495f2c6028fabca953022f33ad200b9f698a3b6db93497f1ffcf89fcf5c

Contents?: true

Size: 1.1 KB

Versions: 87

Compression:

Stored size: 1.1 KB

Contents

class CreatePathologyCodeGroups < ActiveRecord::Migration[5.2]
  def change
    within_renalware_schema do
      create_table :pathology_code_groups do |t|
        t.string :name, null: false, index: { unique: true }
        t.text :description
        t.timestamps null: false
      end

      create_table :pathology_code_group_memberships do |t|
        t.references :code_group, null: false, foreign_key: { to_table: :pathology_code_groups }
        t.references :observation_description,
                     null: false,
                     foreign_key: { to_table: :pathology_observation_descriptions },
                     index: { name: :pathology_code_group_membership_obx }
        t.integer :subgroup, null: false, default: 1
        t.integer :position_within_subgroup, null: false, default: 1
        t.timestamps null: false
      end

      # Prevent the code appearing > once in any group
      add_index(
        :pathology_code_group_memberships,
        %i(code_group_id observation_description_id),
        unique: true,
        name: :index_pathology_code_group_memberships_uniq
      )
    end
  end
end

Version data entries

87 entries across 87 versions & 1 rubygems

Version Path
renalware-core-2.1.1 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.1.0 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.167 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.166 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.165 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.164 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.163 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.162 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.161 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.160 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.159 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.158 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.157 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.156 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.155 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.153 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.152 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.151 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.149 db/migrate/20190513135312_create_pathology_code_groups.rb
renalware-core-2.0.148 db/migrate/20190513135312_create_pathology_code_groups.rb