delimiter $$

CREATE TABLE `employee_address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `permanent_address` varchar(100) DEFAULT NULL,
  `present_address` varchar(100) DEFAULT NULL,
  `contact_1` varchar(45) DEFAULT NULL,
  `contact_2` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8$$




CREATE TABLE `employee_master` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_name` varchar(60) DEFAULT NULL,
  `employee_shortname` varchar(45) DEFAULT NULL,
  `catagory` varchar(45) DEFAULT NULL,
  `marital_status` varchar(45) DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `gender` varchar(45) DEFAULT NULL,
  `nationality` varchar(45) DEFAULT NULL,
  `hire_date` date DEFAULT NULL,
  `employee_father_name` varchar(60) DEFAULT NULL,
  `address` int(11) DEFAULT NULL,
  `open_balance` decimal(10,0) DEFAULT NULL,
  `lock` varchar(45) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `updated_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_idx` (`address`),
  CONSTRAINT `fk` FOREIGN KEY (`address`) REFERENCES `employee_address` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8$$