Sha256: 2a5f79c6d4b45c9f7087a925f409ee1b6eeebff06f78bfc2e1d35a8c5a6aa36c
Contents?: true
Size: 1.63 KB
Versions: 28
Compression:
Stored size: 1.63 KB
Contents
class CreateMedicationDeliveryEvents < ActiveRecord::Migration[5.2]
def change
within_renalware_schema do
create_table :medication_delivery_events do |t|
t.references(
:homecare_form,
foreign_key: { to_table: :drug_homecare_forms },
index: true,
null: false
)
t.references(
:drug_type,
foreign_key: { to_table: :drug_types },
index: true,
null: false
)
t.references(:patient, index: true, null: false)
t.string :reference_number, null: true
t.integer :prescription_duration
t.boolean :printed, default: false, null: false
t.references :created_by, foreign_key: { to_table: :users }, index: true, null: false
t.references :updated_by, foreign_key: { to_table: :users }, index: true, null: false
t.datetime :deleted_at, index: true
t.timestamps null: false
end
# Create a sequence to generate home_delivery etc purchase order numbers.
# These aren't guaranteed to be contiguous because of the way we use them.
reversible do |direction|
direction.up do
connection.execute(<<-SQL.squish)
CREATE SEQUENCE renalware.medication_delivery_purchase_order_number_seq
AS integer
START WITH 100
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
SQL
end
direction.down do
connection.execute(
"drop sequence if exists renalware.medication_delivery_purchase_order_number_seq;"
)
end
end
end
end
end
Version data entries
28 entries across 28 versions & 1 rubygems