CREATE TABLE `scheduled_employee_create_request` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `office_id` int(11) NOT NULL,
  `employee_office_id` varchar(100) DEFAULT NULL,
  `name` varchar(100) NOT NULL DEFAULT '',
  `email` longtext NOT NULL,
  `password` longtext NOT NULL,
  `report_position` int(11) NOT NULL,
  `rfid` longtext,
  `primary_text` varchar(10) NOT NULL DEFAULT '',
  `secondary_text` varchar(10) NOT NULL DEFAULT '',
  `workplace_id` int(11) DEFAULT NULL,
  `date_of_join` bigint(20) DEFAULT NULL,
  `date_of_resignation` bigint(20) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `request_time` bigint(20) DEFAULT NULL,
  `update_time` bigint(20) DEFAULT NULL,
  `requested_by` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;