backend/db/migrations/20260715180000_create_atendimento_rag_index_table.cjs

exports.up = function (knex) {
  return knex.schema.createTable("atendimento_rag_index", (t) => {
    t.integer("AtendimentoId").unsigned().primary();
    t.bigInteger("UltimaMensagemId").unsigned().nullable(); 
    t.integer("ChunksCount").unsigned().nullable(); 
    t.string("EmbeddingModel", 100).nullable(); 
    t.timestamp("CreatedAt").notNullable().defaultTo(knex.fn.now());
    t.timestamp("UpdatedAt").notNullable().defaultTo(knex.fn.now());

    t.foreign("AtendimentoId").references("atendimentos.Id").onDelete("CASCADE");
  });
};

exports.down = function (knex) {
  return knex.schema.dropTable("atendimento_rag_index");
};