Breaking News: Grepper is joining You.com. Read the official announcement!

Kindly help provide a migration file for this DirectDebitLog

Anxious Anaconda answered on September 7, 2023 Popularity 1/10 Helpfulness 1/10

answer Kindly help provide a migration file for this DirectDebitLog

Kindly help provide a migration file for this DirectDebitLog

Comment

'use strict';
module.exports = {
  up: async (queryInterface, DataTypes) => {
    await queryInterface.createTable('DirectDebitLogs', {
      id: {
        allowNull: false,
        autoIncrement: true,
        primaryKey: true,
        type: DataTypes.INTEGER
      },
      mandate_id: {
        type: DataTypes.INTEGER
      },
      description: {
        type: DataTypes.STRING
      },
      note: {
        type: DataTypes.STRING
      },
      account_number: {
        type: DataTypes.STRING
      },
      staff_id: {
        type: DataTypes.INTEGER
      },
      customer_id: {
        type: DataTypes.INTEGER
      },
      identifier: {
        type: DataTypes.INTEGER
      },
      date: {
        type: DataTypes.STRING
      },
      amount: {
        type: DataTypes.DOUBLE
      },
      minimum_amount: {
        type: DataTypes.DOUBLE
      },
      transaction_id: {
        type: DataTypes.INTEGER
      },
      reference_number: {
        type: DataTypes.STRING
      },
      createdAt: {
        allowNull: false,
        type: DataTypes.DATE
      },
      updatedAt: {
        allowNull: false,
        type: DataTypes.DATE
      }
    });
  },
  down: async (queryInterface, Sequelize) => {
    await queryInterface.dropTable('DirectDebitLogs');
  }
};

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: chat.openai.com

Tags: file javascript migration this

Link to this answer
Share Copy Link

Contributed on Sep 07 2023

Anxious Anaconda

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Kindly help provide a migration file for this DirectDebitLog

Contents

More Related Answers

Kindly help provide a migration file for this DirectDebitLog

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.