1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / innfinityandaman /
Filename : employee.sql
back
-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Mar 27, 2023 at 07:35 AM
-- Server version: 8.0.32-0ubuntu0.20.04.2
-- PHP Version: 7.4.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `projects_ilium`
--

-- --------------------------------------------------------

--
-- Table structure for table `employee`
--

CREATE TABLE `employee` (
  `employee_id` int NOT NULL,
  `company_id` int DEFAULT NULL,
  `emp_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `employeename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `contract_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `employee_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `department` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `designation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `emergency_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `gender` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `employedDate` date DEFAULT NULL,
  `resignedDate` date DEFAULT NULL,
  `address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `spousename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `passport_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `passport_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `passport_issue_date` date DEFAULT NULL,
  `passport_expiry_date` date DEFAULT NULL,
  `passport_issue_place` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `passport_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rp_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rp_issue_date` date DEFAULT NULL,
  `rp_expiry_date` date DEFAULT NULL,
  `rp_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `crp_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `crp_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `crp_issue_date` date DEFAULT NULL,
  `crp_expiry_date` date DEFAULT NULL,
  `bank_account_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_iban` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_swift_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `basic_salary` decimal(10,2) DEFAULT NULL,
  `other_allowance` decimal(10,2) DEFAULT NULL,
  `sio` decimal(10,2) DEFAULT NULL,
  `lmra_fee` decimal(10,2) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employee`
--

INSERT INTO `employee` (`employee_id`, `company_id`, `emp_id`, `employeename`, `contract_type`, `employee_status`, `department`, `designation`, `mobile`, `emergency_number`, `email`, `birthdate`, `gender`, `employedDate`, `resignedDate`, `address`, `spousename`, `image`, `passport_name`, `passport_number`, `passport_issue_date`, `passport_expiry_date`, `passport_issue_place`, `passport_file`, `rp_number`, `rp_issue_date`, `rp_expiry_date`, `rp_file`, `crp_name`, `crp_number`, `crp_issue_date`, `crp_expiry_date`, `bank_account_name`, `bank_iban`, `bank_swift_code`, `basic_salary`, `other_allowance`, `sio`, `lmra_fee`, `status`, `created_by`, `created_at`, `updated_by`, `updated_at`) VALUES
(1, NULL, '01', 'Luma Majed Aljishi', '\nPartTime', 'Local', 'MG', '\nManagement', '012452412212', '0215424562', 'lumamajed@yahoo.com', '2023-03-19', 'M', '1970-01-01', '1970-01-01', 'Singapore', ' Aljishi', '9248084201679384524.png', 'Luma Majed', '01201202', '2023-03-01', '2023-07-29', 'Singapore\n', '9248084201679384524.jpg', '652425501', '2022-02-06', '2023-03-25', '92480842016793845241.jpg', 'Luma Majed Aljishi', '\n01201201', '2022-07-01', '2023-06-03', 'Luma Majed', '656565', '\nDFR445GG', '200000.00', '200.00', '20.00', '1000.00', 1, NULL, NULL, NULL, NULL),
(2, NULL, '2', 'Ramkumar', 'FulTime', 'Expat', 'MG', 'Management', '7708813913', '998877665544', 'ram4uever24@gmail.com', '2023-03-22', 'M', '2023-03-22', '1970-01-01', 'test', 'Test', '12856367561679384997.jpg', 'Ramkumar', '9872990090', '2023-03-21', '2023-03-25', 'Test', '128563675616793849971.jpg', '123', '2023-03-21', '2023-06-23', '128563675616793849972.jpg', 'Ramkumar', '1234455', '2023-03-06', '2023-05-11', 'Ramkumar', '15155665665', 'ttstst', '500.00', '60.00', '200.00', '50.00', 1, NULL, NULL, NULL, NULL),
(3, NULL, '03', 'Ramkumar', 'FulTime', 'Local', 'Production', 'Production Manager ', '7708813913', '123456789', 'ram4uever24@gmail.com', '2023-03-23', 'M', '2023-03-02', NULL, 'test', 'tesr', '21257082631679564258.jpg', 'Ramkumar Rm', '12345677', '2023-03-23', '2023-03-23', 'Chennai', '212570826316795642581.jpg', '12345677', '2023-03-22', '2023-04-22', '212570826316795642582.jpg', 'Ramkumar Rm', '122234', '2023-03-23', '2023-03-23', 'ramkumar', '12345677', 'q334', '1234.00', '1233.00', '1234.00', '123.00', 1, NULL, NULL, NULL, NULL),
(4, NULL, '03', 'Ramkumar', 'FulTime', 'Local', 'Production', 'Production Manager ', '7708813913', '123456789', 'ram4uever24@gmail.com', '2023-03-23', 'M', '2023-03-02', NULL, 'test', 'tesr', '3437826011679565314.jpg', 'Ramkumar Rm', '12345677', '2023-03-23', '2023-03-23', 'Chennai', '34378260116795653141.jpg', '12345677', '2023-03-22', '2023-04-22', '34378260116795653142.jpg', 'Ramkumar Rm', '122234', '2023-03-23', '2023-03-23', 'ramkumar', '12345677', 'q334', '1234.00', '1233.00', '1234.00', '123.00', 1, NULL, NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `employee`
--
ALTER TABLE `employee`
  ADD PRIMARY KEY (`employee_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `employee`
--
ALTER TABLE `employee`
  MODIFY `employee_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;