/var/www/greso.tech/server/nsm/models
Edit: /var/www/greso.tech/server/nsm/models/orderPayment.js (2117B)
module.exports = (sequelize, Sequelize) => {
const OrderPayment = sequelize.define(
'orderPayment',
{
id: {
type: Sequelize.UUID,
defaultValue: Sequelize.UUIDV4,
allowNull: false,
primaryKey: true
},
orderId: {
type: Sequelize.UUID,
},
userId: {
type: Sequelize.UUID,
},
payTypeId: {
type: Sequelize.UUID,
},
merchantId: {
type: Sequelize.UUID,
},
summ: {
type: Sequelize.DECIMAL(10, 2),
allowNull: false,
defaultValue: 0.0
},
cardType: {
type: Sequelize.STRING,
allowNull: true
},
maskedCardNumber: {
type: Sequelize.STRING,
allowNull: true
},
refNumber: {
type: Sequelize.STRING,
allowNull: true
},
token: {
type: Sequelize.STRING,
allowNull: true
},
status: {
type: Sequelize.STRING,
allowNull: true
},
orderStatus: {
type: Sequelize.STRING,
allowNull: true
},
error: {
type: Sequelize.STRING,
allowNull: true
},
errorCode: {
type: Sequelize.INTEGER,
allowNull: true
},
comment: {
type: Sequelize.STRING,
allowNull: true
},
response: {
type: Sequelize.TEXT('long'),
allowNull: true
},
transactionType: { //
type: Sequelize.STRING(15),
allowNull: true
},
ipAddress: {
type: Sequelize.STRING(32),
allowNull: true
},
confirmed: {
allowNull: false,
type: Sequelize.BOOLEAN,
defaultValue: false,
},
createdAt: {
allowNull: true,
type: Sequelize.DATE
},
updatedAt: {
allowNull: true,
type: Sequelize.DATE
}
},
{
timestamps: true,
paranoid: true,
tableName: 'orders_payments'
}
)
return OrderPayment
}