/var/www/verywell.gr/server/delivery/models
Edit: /var/www/verywell.gr/server/delivery/models/accountHistory.js (1267B)
module.exports = (sequelize, Sequelize) => {
const AccountHistory = sequelize.define(
'accountHistory',
{
id: {
type: Sequelize.BIGINT,
autoIncrement: true,
allowNull: false,
primaryKey: true
},
uid: {
type: Sequelize.UUID,
defaultValue: Sequelize.UUIDV4
},
accountId: {
type: Sequelize.BIGINT,
allowNull: false,
},
event: {
allowNull: true,
type: Sequelize.ENUM(
'create',
'delete',
'put',
'transfer',
'withdraw'
)
},
summ: {
type: Sequelize.DECIMAL(10, 2),
allowNull: false,
defaultValue: 0
},
balanceBefore: {
type: Sequelize.DECIMAL(10, 2),
allowNull: false,
defaultValue: 0
},
balanceAfter: {
type: Sequelize.DECIMAL(10, 2),
allowNull: false,
defaultValue: 0
},
createdId: {
type: Sequelize.BIGINT
},
createdAt: {
allowNull: false,
type: Sequelize.DATE
},
updatedAt: {
allowNull: false,
type: Sequelize.DATE
}
},
{
timestamps: true,
paranoid: true,
tableName: 'accounts_history'
}
)
return AccountHistory
}