saperx/db/migrations/20230725203505_avaliacao-basica.js

exports.up = function(knex, Promise) {
  return knex.schema.createTable('avaliacao_basica', t => {
      t.increments('Id')
      t.integer('Pesquisa').unsigned().references('Id').inTable('pesquisa').onDelete('CASCADE').index().notNullable()
      t.string('Cliente').notNullable()
      t.integer('Nota').notNullable()
      t.timestamp('DataCadastro').notNullable().defaultTo(knex.raw('CURRENT_TIMESTAMP'))
  })
};

exports.down = function(knex, Promise) {
  return knex.schema.dropTable('avaliacao_basica')
};