class CreateSummaryDocuments < ActiveRecord::Migration[7.0]
  def change
    create_table :summary_documents do |t|
      t.references :respondent_category, null: false, foreign_key: true
      t.string :name, null: false
      t.text :content_html
      t.references :last_edited_by, foreign_key: { to_table: :users }
      t.references :locked_by, foreign_key: { to_table: :users }
      t.datetime :locked_at
      t.integer :lock_version, default: 0, null: false
      t.timestamps
    end

    add_index :summary_documents, %i[respondent_category_id name]
  end
end