File: /var/www/api.javaapp.co.uk_old/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.INTEGER,
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,
},
user_latitude: {
type: Sequelize.DECIMAL,
},
user_longitude: {
type: Sequelize.DECIMAL,
},
notification_status: {
type: Sequelize.TINYINT,
defaultValue: 0,
comment: "0 On 1 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,
},
},
{
timestamps: false,
}
);
sequelizePaginate.paginate(User);
export default User;