OwlCyberSecurity - MANAGER

Edit File: employee.mjs

// models/employee.mjs
import { DataTypes } from 'sequelize';
import sequelize from '../config/database.mjs'; // shared sequelize instance

const Employee = sequelize.define('Employee', {
  EmployeeId: {
    type: DataTypes.INTEGER,
    autoIncrement: true,
    primaryKey: true,
  },
  EmpNo: {
    type: DataTypes.STRING,
    unique: true,
    allowNull: false,
  },
  EmployeeName: {
    type: DataTypes.STRING,
    allowNull: false,
  },
  password: {
    type: DataTypes.STRING,
    allowNull: false,
  },
  role: {
    type: DataTypes.STRING,
    defaultValue: 'view',
  },
  AvailedLeaveCL: {
    type: DataTypes.INTEGER,
    defaultValue: 0,
  },
  AvailedLeaveML: {
    type: DataTypes.INTEGER,
    defaultValue: 0,
  },
  AvailedBalancedOfCL: {
    type: DataTypes.INTEGER,
    defaultValue: 3,
  },
  AvailedBalancedOfML: {
    type: DataTypes.INTEGER,
    defaultValue: 30,
  },
  DateOfJoining: {
  type: DataTypes.DATEONLY,
  allowNull: false, // or true if optional
},
}, {
  tableName: 'employee',
  timestamps: false,
  id: false,
});

export default Employee;