text: 'use strict';
  
  module.exports = {
    up: (queryInterface, Sequelize) => {
      var tableDefinition = {
        "id": {
          "type": Sequelize.INTEGER,
          "primaryKey": true,
          "autoIncrement": true
  
        },
        "IndicadoresId": {
          "type": Sequelize.INTEGER,
          "references": {
              "model": "Indicadores",
              "key": "id"
          },
          "onUpdate": "cascade",
          "onDelete": "cascade"
        },
        "ObjetivosId": {
          "type": Sequelize.INTEGER,
          "references": {
              "model": "ObjetivosCalidad",
              "key": "id"
          },
          "onUpdate": "cascade",
          "onDelete": "cascade"
        },
        "CreatorId": {
            "type": Sequelize.INTEGER,
            "references": {
                "model": "Usuario",
                "key": "id"
            },
            "onUpdate": "cascade",
            "onDelete": "cascade"
  
        },
        "createdAt": {
            "type": Sequelize.DATE
        },
        "updatedAt": {
            "type": Sequelize.DATE
        },
        "deletedAt": {
            "type": Sequelize.DATE
        }
    };
    return queryInterface
        .createTable({name: "IndicadoresObjetivos", tableName: "IndicadoresObjetivos", schema: "noconformidades"}, tableDefinition);
    },
  
    down: (queryInterface, Sequelize) => {
      /*
        Add reverting commands here.
        Return a promise to correctly handle asynchronicity.
  
        Example:
        return queryInterface.dropTable('users');
      */
    }
  };
  