class CreateWorkflowStepAssignees < ActiveRecord::Migration[6.1]
  def change
    create_table :workflow_step_assignees do |t|
      t.bigint :workflow_step_id, null: false
      t.string :assignee_type, null: false  # 'user', 'role_group', 'department'
      t.integer :assignee_id, null: false   # user_id, role_group_id, or department_id
      t.timestamps
    end

    add_index :workflow_step_assignees, :workflow_step_id
    add_index :workflow_step_assignees, [:assignee_type, :assignee_id]
    add_foreign_key :workflow_step_assignees, :workflow_steps
  end
end