File: //var/www/javago_test/src/models/users.model.js
import Sequelize from "sequelize";
import sequelize from "../config/database.config.js";
import sequelizePaginate from "sequelize-paginate";
const User = sequelize.define(
"users",
{
id: {
type: Sequelize.BIGINT,
primaryKey: true,
autoIncrement: true,
allowNull: false,
},
name: {
type: Sequelize.STRING,
},
email: {
type: Sequelize.STRING,
unique: true
},
password: {
type: Sequelize.STRING,
},
remember_token: {
type: Sequelize.STRING,
},
device_id: {
type: Sequelize.STRING,
defaultValue: "",
},
device_type: {
type: Sequelize.TINYINT,
defaultValue: 0,
comment: "0 Default 1 Android 2 iOS"
},
fcm_token: {
type: Sequelize.TEXT,
defaultValue: "",
},
otp: {
type: Sequelize.INTEGER,
defaultValue: 0,
},
profile_picture: {
type: Sequelize.STRING,
},
address: {
type: Sequelize.STRING,
},
notification_status: {
type: Sequelize.TINYINT,
defaultValue: 0,
comment: "1 = On 2 = Off"
},
is_active: {
type: Sequelize.TINYINT,
defaultValue: 0,
comment: "0 = active, 1 = inactive"
},
is_verified: {
type: Sequelize.TINYINT,
defaultValue: 0,
comment: "0 = No, 1 = Yes"
},
is_deleted: {
type: Sequelize.TINYINT,
defaultValue: 0,
comment: "1 = deleted, 0 = not deleted"
},
delete_reason: {
type: Sequelize.TEXT,
defaultValue: "",
comment: "Reason for delete account"
},
created_at: {
type: Sequelize.INTEGER,
defaultValue: 0,
},
updated_at: {
type: Sequelize.INTEGER,
defaultValue: 0,
},
},
{
tableName: 'users',
timestamps: false,
}
);
sequelizePaginate.paginate(User);
export default User;