Sha256: 28943bebd8a0f894e1296eeb35b0cf8b5642a85bd7c6f74001429f10f05bc683

Contents?: true

Size: 970 Bytes

Versions: 177

Compression:

Stored size: 970 Bytes

Contents

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

      t.date :formed_on, null: false
      t.date :planned_on
      t.date :started_on
      t.date :terminated_on
      t.references :type, null: false
      t.references :site, null: false
      t.references :plan
      t.string :side, null: false
      t.text :notes

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

      t.timestamps null: false
    end

    add_reference :access_profiles, :decided_by, references: :users, index: true
    add_foreign_key :access_profiles, :users, column: :decided_by_id

    add_foreign_key :access_profiles, :access_types, column: :type_id
    add_foreign_key :access_profiles, :access_sites, column: :site_id
    add_foreign_key :access_profiles, :access_plans, column: :plan_id
  end
end

Version data entries

177 entries across 177 versions & 1 rubygems

Version Path
renalware-core-2.0.147 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.146 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.145 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.144 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.143 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.142 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.141 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.140 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.139 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.138 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.137 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.136 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.135 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.134 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.133 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.132 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.131 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.130 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.129 db/migrate/20160120203755_create_access_profiles.rb
renalware-core-2.0.128 db/migrate/20160120203755_create_access_profiles.rb