// P2P_Liquiloans_Inv_Transaction

module.exports = function (sequelize, DataTypes) {
    const liquiloansTransaction = sequelize.define('P2P_BI_Liquiloans_Inv_Transactions', {

        request_id: { type: DataTypes.INTEGER, allowNull: false, unique: true },
        investor_id: { type: DataTypes.INTEGER, allowNull: true },
        amount: { type: DataTypes.INTEGER, allowNull: true },
        transaction_type: { type: DataTypes.STRING, allowNull: true },
        transaction_sub_type: { type: DataTypes.STRING, allowNull: true },
        withdrawal_method: { type: DataTypes.STRING, allowNull: true },
        manual_parameters: { type: DataTypes.STRING, allowNull: true },
        old_investment_id: { type: DataTypes.STRING, allowNull: true },
        scheme_id: { type: DataTypes.INTEGER, allowNull: true },
        mode: { type: DataTypes.STRING, allowNull: true },
        transaction_id: { type: DataTypes.STRING, allowNull: true },
        order_id: { type: DataTypes.STRING, allowNull: true },
        settlement_utr: { type: DataTypes.STRING, allowNull: true },
        transaction_source: { type: DataTypes.STRING, allowNull: true },
        approval_status: { type: DataTypes.STRING, allowNull: true },
        transaction_status: { type: DataTypes.STRING, allowNull: true },
        created_at: { type: DataTypes.STRING, allowNull: true },
        authenticated_at: { type: DataTypes.STRING, allowNull: true },
        banking_date: { type: DataTypes.STRING, allowNull: true },
        execution_date: { type: DataTypes.STRING, allowNull: true },
        transaction_date: { type: DataTypes.STRING, allowNull: true },
        ext_transaction_date: { type: DataTypes.STRING, allowNull: true },
        source_payment: { type: DataTypes.STRING, allowNull: true },
        last_updatedAt: { type: DataTypes.STRING, allowNull: true },
    }, {
        timestamps: false,
    }
    );

    return liquiloansTransaction

}