OwlCyberSecurity - MANAGER
Edit File: database.sqlite
SQLite format 3 @ .r� � � G�� � � \ �i##�tableYearlyLeaveYearlyLeaveCREATE TABLE `YearlyLeave` (`yearlyLeaveID` VARCHAR(255) PRIMARY KEY, `EmployeeId` VARCHAR(255), `LeaveID` VARCHAR(255), `periodOfDuty` VARCHAR(255) NOT NULL, `leaveAtCredit` INTEGER NOT NULL, `leaveAvailed` INTEGER NOT NULL, `startDate` DATE NOT NULL, `endDate` DATE NOT NULL, `balanceLeave` INTEGER NOT NULL, `remarks` TEXT)5I# indexsqlite_autoindex_YearlyLeave_1YearlyLeave��ctableLeavesLeavesCREATE TABLE `Leaves` (`LeaveID` VARCHAR(10) NOT NULL PRIMARY KEY, `EmployeeId` VARCHAR(10), `EmpNo` VARCHAR(10), `EmpStatus` TEXT, `EmployeeName` VARCHAR(100), `Designation` VARCHAR(100), `Department` VARCHAR(100), `LeaveType` TEXT, `NoOfDaysRequired` INTEGER, `DateOfLeaveFrom` DATE, `DateOfLeaveTo` DATE, `LeavePurpose` TEXT, `DateOfApplied` DATE, `LeaveRecommended` VARCHAR(100), `AvailedLeaveML` INTEGER DEFAULT 0, `AvailedLeaveCL` INTEGER DEFAULT 0, `AvailedBalancedOfML` INTEGER DEFAULT 0, `AvailedBalancedOfCL` INTEGER DEFAULT 0, `LeaveStatus` TEXT DEFAULT 'Pending', `createdAt` DATETIME, `updatedAt` DATETIME)+? indexsqlite_autoindex_Leaves_1Leaves�L �ktableEmployeeEmployeeCREATE TABLE `Employee` (`EmployeeId` VARCHAR(255) PRIMARY KEY, `EmployeeName` VARCHAR(255) NOT NULL, `Email` VARCHAR(255) NOT NULL UNIQUE, `Designation` VARCHAR(255) NOT NULL, `Department` VARCHAR(255) NOT NULL, `JoiningDate` DATE NOT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL)/C indexsqlite_autoindex_Employee_2Employee/C indexsqlite_autoindex_Employee_1Employee � C� �4 !!#!)II02E01ContractAroosaIntern ITCasual2025-06-112025-06-12Urgent work2025-06-11IT specialist Pending2025-06-12 05:27:49.682 +00:002025-06-12 05:27:49.684 +00:00�: !!+! II01EMP123RegularJohn DoeDeveloperITCasual2025-06-142025-06-15Personal errand2025-06-09Team Lead Pending2025-06-12 05:02:24.813 +00:002025-06-12 05:02:24.822 +00:00 � �� 02 01