OwlCyberSecurity - MANAGER
Edit File: leave.mjs
// models/leave.mjs import { DataTypes } from 'sequelize'; import sequelize from '../config/database.mjs'; const Leave = sequelize.define('Leave', { LeaveID: { type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true }, LeaveDate: { type: DataTypes.DATEONLY, allowNull: false, }, EmployeeName: DataTypes.STRING, EmpNo: DataTypes.STRING, EmpStatus: DataTypes.STRING, Department: DataTypes.STRING, Designation: DataTypes.STRING, LeaveType: DataTypes.STRING, LeavePurpose: DataTypes.TEXT, NoOfDaysRequired: DataTypes.STRING, ImmediateOfficer: DataTypes.STRING, GeneralManager: DataTypes.STRING, LeaveStatus: { type: DataTypes.ENUM('pending', 'approve', 'reject'), defaultValue: 'pending', } }, { timestamps: false, }); export default Leave;