-- MySQL / MariaDB
CREATE TABLE IF NOT EXISTS Master_Employee (
  id INT AUTO_INCREMENT PRIMARY KEY,
  Emp_id VARCHAR(100) NULL,
  Full_Name VARCHAR(255) NULL,
  First_name VARCHAR(120) NULL,
  last_name VARCHAR(120) NULL,
  Marital_Status ENUM('Single','Married','Widowed','Divorced') NULL,
  Probation_End_date DATE NULL,
  DOB DATE NULL,
  Date_Of_Joining DATE NULL,
  Labour_Card_Expiry DATE NULL,
  Visa_Exp_Date DATE NULL,
  Passport_No VARCHAR(100) NULL,
  Passport_Expiry DATE NULL,
  Emirates_Id_Number VARCHAR(100) NULL,
  Visa_Designation VARCHAR(150) NULL,
  Branch VARCHAR(150) NULL,
  Entity VARCHAR(100) NULL,
  Department VARCHAR(100) NULL,
  Gender ENUM('Male','Female','Other') NULL,
  Nationality VARCHAR(120) NULL,
  Town_City_Country VARCHAR(200) NULL,
  Mobile_No VARCHAR(50) NULL,
  Personal_Emails VARCHAR(255) NULL,
  Company_Email VARCHAR(255) NULL,
  Address TEXT NULL,
  Emergency1_Name_UAE VARCHAR(150) NULL,
  Emergency1_Relation_UAE VARCHAR(100) NULL,
  Emergency1_Contact_UAE VARCHAR(50) NULL,
  Emergency2_Name_Homeland VARCHAR(150) NULL,
  Emergency2_Relation_Homeland VARCHAR(100) NULL,
  Emergency2_Contact_Homeland VARCHAR(50) NULL,
  Attested_Educational_Certificate VARCHAR(10) NULL,
  Password_Hash VARCHAR(255) NULL,
  role VARCHAR(100) NULL,
  status ENUM('active','non active') DEFAULT 'active',
  create_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;