/var/www/greso.tech/server/nsm/models
Edit: /var/www/greso.tech/server/nsm/models/userLoginHistory.js (1396B)
module.exports = (sequelize, Sequelize) => {
const UserLoginHistory = sequelize.define(
'userLoginHistory',
{
id: {
type: Sequelize.UUID,
defaultValue: Sequelize.UUIDV4,
allowNull: false,
primaryKey: true
},
userAgent:{
type: Sequelize.STRING,
allowNull: true,
defaultValue: ''
},
ipAddress:{
type: Sequelize.STRING(32),
allowNull: true,
defaultValue: ''
},
app:{
type: Sequelize.ENUM('unknown', 'client', 'crm'),
allowNull: false,
defaultValue: 'unknown',
unique: false
},
deviceId:{
type: Sequelize.STRING(150),
allowNull: false,
defaultValue: ''
},
platform: {
type: Sequelize.ENUM('Unknown','Web', 'Android', 'iOS', 'Linux', 'MacOS', 'Windows', 'Fuchsia'),
allowNull: false,
defaultValue: 'Unknown',
unique: false
},
createdAt: {
allowNull: false,
type: Sequelize.DATE,
// defaultValue: new Date(),
},
updatedAt: {
allowNull: false,
type: Sequelize.DATE,
// defaultValue: new Date(),
},
},
{
timestamps: true,
paranoid: false,
tableName: 'user_login_history'
}
)
return UserLoginHistory
}