20 lines
667 B
Ruby
20 lines
667 B
Ruby
class CreateDeviceJobs < ActiveRecord::Migration[6.1]
|
|
def change
|
|
create_table :device_jobs, id: false do |t|
|
|
# t.references :job_id, references: :job, foreign_key: true # the owner
|
|
# t.references :device_id, references: :device, foreign_key: true # the invitee
|
|
t.integer :device_id
|
|
t.integer :job_id
|
|
t.string :status
|
|
|
|
t.timestamps
|
|
end
|
|
add_index :device_jobs, :job_id
|
|
add_foreign_key :device_jobs, :jobs, column: :job_id
|
|
add_index :device_jobs, :device_id
|
|
add_foreign_key :device_jobs, :devices, column: :device_id
|
|
# execute "ALTER TABLE device_jobs ADD PRIMARY KEY (device_id, jobs_id);"
|
|
end
|
|
end
|
|
|