File: /var/www/api.javaapp.co.uk_old/src/models/notification_list.model.js
import Sequelize from "sequelize";
import sequelize from "../config/database.config.js";
import sequelizePaginate from "sequelize-paginate";
const NotificationList = sequelize.define(
"notifications",
{
id: {
type: Sequelize.BIGINT,
primaryKey: true,
autoIncrement: true,
allowNull: false,
},
sender_id: {
type: Sequelize.BIGINT,
defaultValue: 0,
},
receiver_id: {
type: Sequelize.BIGINT,
defaultValue: 0,
},
reference_id: {
type: Sequelize.BIGINT
},
notification_type: {
type: Sequelize.TINYINT,
defaultValue: 0,
comment: "1 = new order (cafe admin) 2 = group coffee run"
},
is_read: {
type: Sequelize.TINYINT,
defaultValue: 0,
comment: "1 = read, 0 = unread"
},
deleted_at: {
type: Sequelize.INTEGER,
defaultValue: 0,
},
created_at: {
type: Sequelize.INTEGER,
defaultValue: 0,
},
updated_at: {
type: Sequelize.INTEGER,
defaultValue: 0,
},
},
{
tableName: 'notifications',
timestamps: false,
}
);
sequelizePaginate.paginate(NotificationList);
export default NotificationList;