--
-- Host: localhost    Database: EmployeeDB
-- ------------------------------------------------------


--
-- Current Database: `EmployeeDB`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `EmployeeDB` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;

USE `EmployeeDB`;

--
-- Table structure for table `EMPLOYEE_DETAILS_LOG`
--

CREATE TABLE `EMPLOYEE_DETAILS_LOG` (
  `LOG_ID` int(11) NOT NULL AUTO_INCREMENT,
  `USER_NAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DATETIME` datetime DEFAULT NULL,
  `OPERATION_TYPE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `EMP_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`LOG_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `EMPLOYEE_DETAILS_LOG`
--

INSERT INTO `EMPLOYEE_DETAILS_LOG` VALUES (6,'admin','2021-09-06 08:14:52','Create',13),(7,'admin','2021-09-06 08:15:01','Update',13),(8,'admin','2021-09-06 08:15:07','Delete',13);

--
-- Table structure for table `VACATION`
--

CREATE TABLE `VACATION` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `START_DATE` date DEFAULT NULL,
  `END_DATE` date DEFAULT NULL,
  `EMP_ID` int(11) NOT NULL,
  `TENANT_ID` int(11) DEFAULT NULL,
  `STATUS` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TYPE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_VACATION_TO_EMPLOYEE_a38mB` (`EMP_ID`),
  CONSTRAINT `FK_VACATION_TO_EMPLOYEE_a38mB` FOREIGN KEY (`EMP_ID`) REFERENCES `EMPLOYEE` (`EMP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `VACATION`
--


--
-- Dumping routines for database 'EmployeeDB'
--


