class CreateAnalysisReports < ActiveRecord::Migration[7.0]
  def change
    create_table :analysis_reports do |t|
      t.references :respondent_category, null: false, foreign_key: true
      t.boolean :requires_section_regeneration, default: false
      t.boolean :requires_insight_regeneration, default: false

      t.integer :respondent_ids, array: true, default: []
      t.integer :section_ids, array: true, default: []
      t.integer :question_ids, array: true, default: []

      t.string :name

      t.timestamps
    end
  end
end