Sha256: b9d5b80d48ba312480fce53b57086f72dfdf56a850660fe1caf22ccbed5e70a6
Contents?: true
Size: 937 Bytes
Versions: 68
Compression:
Stored size: 937 Bytes
Contents
class CreatePhqAssessments < ActiveRecord::Migration
def change
create_table :phq_assessments do |t|
t.date :release_date, null: false
t.integer :q1
t.integer :q2
t.integer :q3
t.integer :q4
t.integer :q5
t.integer :q6
t.integer :q7
t.integer :q8
t.integer :q9
t.references :participant, index: true, null: false
t.timestamps
end
add_index :phq_assessments, [:participant_id, :release_date], unique: true
reversible do |dir|
dir.up do
execute <<-SQL
ALTER TABLE phq_assessments
ADD CONSTRAINT fk_phq_assessments_participants
FOREIGN KEY (participant_id)
REFERENCES participants(id)
SQL
end
dir.down do
execute <<-SQL
ALTER TABLE phq_assessments
DROP CONSTRAINT fk_phq_assessments_participants
SQL
end
end
end
end
Version data entries
68 entries across 68 versions & 1 rubygems