Sha256: e56c862ed7c03fde8561c3485da74132c78a67a1de4fab74fde0a42ba9130127

Contents?: true

Size: 989 Bytes

Versions: 177

Compression:

Stored size: 989 Bytes

Contents

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

      t.date :performed_on, null: false
      t.time :start_time, null: false
      t.time :end_time
      t.integer :duration
      t.text :notes

      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_sessions, :document, using: :gin

    add_reference :hd_sessions, :signed_on_by, references: :users, index: true
    add_foreign_key :hd_sessions, :users, column: :signed_on_by_id

    add_reference :hd_sessions, :signed_off_by, references: :users, index: true
    add_foreign_key :hd_sessions, :users, column: :signed_off_by_id
  end
end

Version data entries

177 entries across 177 versions & 1 rubygems

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