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;