-- MySQL dump 10.13 Distrib 8.0.19, for Win64 (x86_64) -- -- Host: localhost Database: src_compliance -- ------------------------------------------------------ -- Server version 8.0.19 /*!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 */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `category` -- DROP TABLE IF EXISTS `category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `category` ( `category_id` bigint NOT NULL AUTO_INCREMENT, `category_name` varchar(50) NOT NULL, `description` varchar(300) DEFAULT NULL, `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `status` smallint DEFAULT '1', `created_by` bigint NOT NULL, PRIMARY KEY (`category_id`), KEY `category_fk1` (`created_by`), CONSTRAINT `category_fk1` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `category` -- LOCK TABLES `category` WRITE; /*!40000 ALTER TABLE `category` DISABLE KEYS */; INSERT INTO `category` VALUES (1,'State Corporation',NULL,'2021-04-28 18:12:12','2021-04-28 15:12:12',1,4),(2,'County Governments','County Governments including the Executives and Assemblies','2021-04-28 18:12:40','2021-05-01 12:03:15',1,4),(3,'Ministries & State Departments',NULL,'2021-04-28 18:13:00','2021-04-28 15:13:00',1,4),(4,'Public Universities & Research & TVETs',NULL,'2021-04-28 18:13:25','2021-04-28 15:15:20',1,4),(5,'CCIOs',NULL,'2021-04-28 18:14:06','2021-04-28 15:14:06',1,4),(6,'Disciplined Services',NULL,'2021-04-28 18:14:29','2021-04-28 15:14:29',1,4); /*!40000 ALTER TABLE `category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `constituency` -- DROP TABLE IF EXISTS `constituency`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `constituency` ( `constituency_id` bigint NOT NULL AUTO_INCREMENT, `county_id` bigint NOT NULL, `constituency_name` varchar(30) NOT NULL, `constituency_code` varchar(30) NOT NULL, `status` smallint DEFAULT '1', `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created_by` bigint NOT NULL, PRIMARY KEY (`constituency_id`), KEY `constituency_fk1` (`county_id`), KEY `constituency_fk2` (`created_by`), CONSTRAINT `constituency_fk1` FOREIGN KEY (`county_id`) REFERENCES `county` (`county_id`), CONSTRAINT `constituency_fk2` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `constituency` -- LOCK TABLES `constituency` WRITE; /*!40000 ALTER TABLE `constituency` DISABLE KEYS */; INSERT INTO `constituency` VALUES (1,5,'Maragua','023002',1,'2021-04-28 20:24:35','2021-04-28 17:24:35',4),(2,5,'Kiharu','023004',1,'2021-04-28 20:25:34','2021-04-28 17:28:16',4); /*!40000 ALTER TABLE `constituency` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `control_figure` -- DROP TABLE IF EXISTS `control_figure`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `control_figure` ( `control_figure_id` bigint NOT NULL AUTO_INCREMENT, `questionnaire_id` bigint NOT NULL, `sub_questionnaire_id` bigint DEFAULT NULL, `control_figure_name` varchar(50) NOT NULL, `value` int NOT NULL, `questionnaire_table_id` bigint DEFAULT NULL, `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `status` smallint DEFAULT '1', `created_by` bigint NOT NULL, PRIMARY KEY (`control_figure_id`), KEY `control_figure_fk1` (`created_by`), KEY `control_figure_fk2` (`questionnaire_id`), KEY `control_figure_fk3` (`sub_questionnaire_id`), KEY `control_figure_fk4` (`questionnaire_table_id`), CONSTRAINT `control_figure_fk1` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`), CONSTRAINT `control_figure_fk2` FOREIGN KEY (`questionnaire_id`) REFERENCES `questionnaire` (`questionnaire_id`), CONSTRAINT `control_figure_fk3` FOREIGN KEY (`sub_questionnaire_id`) REFERENCES `sub_questionnaire` (`sub_questionnaire_id`), CONSTRAINT `control_figure_fk4` FOREIGN KEY (`questionnaire_table_id`) REFERENCES `questionnaire_table` (`questionnaire_table_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `control_figure` -- LOCK TABLES `control_figure` WRITE; /*!40000 ALTER TABLE `control_figure` DISABLE KEYS */; /*!40000 ALTER TABLE `control_figure` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `county` -- DROP TABLE IF EXISTS `county`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `county` ( `county_id` bigint NOT NULL AUTO_INCREMENT, `county_name` varchar(30) NOT NULL, `county_code` varchar(30) NOT NULL, `status` smallint DEFAULT '1', `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created_by` bigint NOT NULL, PRIMARY KEY (`county_id`), KEY `county_fk1` (`created_by`), CONSTRAINT `county_fk1` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `county` -- LOCK TABLES `county` WRITE; /*!40000 ALTER TABLE `county` DISABLE KEYS */; INSERT INTO `county` VALUES (1,'Nairobi','047',1,'2021-04-28 14:08:25','2021-04-28 13:42:36',4),(4,'Mombasa','001',1,'2021-04-28 16:53:45','2021-04-28 13:53:45',4),(5,'Murang\'a','021',1,'2021-04-28 16:53:57','2021-04-28 13:53:57',4); /*!40000 ALTER TABLE `county` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `county_assembly` -- DROP TABLE IF EXISTS `county_assembly`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `county_assembly` ( `county_assembly_id` bigint NOT NULL AUTO_INCREMENT, `county_id` bigint NOT NULL, `county_assembly_name` varchar(50) NOT NULL, `county_assembly_code` varchar(30) NOT NULL, `status` smallint DEFAULT '1', `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created_by` bigint NOT NULL, PRIMARY KEY (`county_assembly_id`), KEY `county_assembly_fk1` (`county_id`), KEY `county_assembly_fk2` (`created_by`), CONSTRAINT `county_assembly_fk1` FOREIGN KEY (`county_id`) REFERENCES `county` (`county_id`), CONSTRAINT `county_assembly_fk2` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `county_assembly` -- LOCK TABLES `county_assembly` WRITE; /*!40000 ALTER TABLE `county_assembly` DISABLE KEYS */; INSERT INTO `county_assembly` VALUES (2,5,'Murang\'a County Assembly','021001',1,'2021-04-28 21:18:10','2021-04-28 18:23:12',4); /*!40000 ALTER TABLE `county_assembly` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `failed_jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `financial_year` -- DROP TABLE IF EXISTS `financial_year`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `financial_year` ( `financial_year_id` bigint NOT NULL AUTO_INCREMENT, `financial_year_name` varchar(20) NOT NULL, `status` smallint DEFAULT '1', `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created_by` bigint NOT NULL, PRIMARY KEY (`financial_year_id`), KEY `financial_year_fk1` (`created_by`), CONSTRAINT `financial_year_fk1` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `financial_year` -- LOCK TABLES `financial_year` WRITE; /*!40000 ALTER TABLE `financial_year` DISABLE KEYS */; INSERT INTO `financial_year` VALUES (1,'2017/2018',1,'2021-04-28 22:38:19','2021-04-28 19:38:19',4),(2,'2018/2019',1,'2021-04-28 22:38:29','2021-04-28 19:38:29',4),(3,'2019/2020',1,'2021-04-28 22:38:37','2021-04-28 19:38:37',4),(4,'2020/2021',1,'2021-04-28 22:38:44','2021-04-28 19:38:44',4); /*!40000 ALTER TABLE `financial_year` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `institution` -- DROP TABLE IF EXISTS `institution`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `institution` ( `institution_id` bigint NOT NULL AUTO_INCREMENT, `sub_category_id` bigint NOT NULL, `institution_name` varchar(50) NOT NULL, `description` varchar(300) DEFAULT NULL, `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `status` smallint DEFAULT '1', `created_by` bigint NOT NULL, PRIMARY KEY (`institution_id`), KEY `institution_fk1` (`created_by`), KEY `institution_fk2` (`sub_category_id`), CONSTRAINT `institution_fk1` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`), CONSTRAINT `institution_fk2` FOREIGN KEY (`sub_category_id`) REFERENCES `sub_category` (`sub_category_id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `institution` -- LOCK TABLES `institution` WRITE; /*!40000 ALTER TABLE `institution` DISABLE KEYS */; INSERT INTO `institution` VALUES (1,8,'Bumbe Institute of Technology','Technical College','2021-04-28 22:11:35','2021-04-28 19:14:57',1,4),(4,8,'Sigalagala Technical Training Institute','Technical Training Institute','2021-04-28 22:16:39','2021-04-28 19:16:39',1,4),(5,1,'Rift Valley Water Services Board','Rift Valley Water Services Board','2021-05-02 15:20:59','2021-05-02 12:20:59',1,4),(6,2,'School Equipment Production Unit','School Equipment Production Unit','2021-05-02 15:23:57','2021-05-02 12:23:57',1,4),(7,2,'Simlaw Seeds Company Limited','Simlaw Seeds Company Limited','2021-05-02 15:24:23','2021-05-02 12:24:23',1,4),(8,2,'South Nyanza Sugar Company','South Nyanza Sugar Company','2021-05-02 15:24:45','2021-05-02 12:24:45',1,4),(9,4,'Baringo County Government','Baringo County Government','2021-05-02 15:26:19','2021-05-02 12:26:19',1,4),(10,4,'Bomet County Government','Bomet County Government','2021-05-02 15:26:40','2021-05-02 12:26:40',1,4),(11,4,'Bungoma County Government','Bungoma County Government','2021-05-02 15:27:00','2021-05-02 12:27:00',1,4); /*!40000 ALTER TABLE `institution` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `migrations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `password_resets_email_index` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `questionnaire` -- DROP TABLE IF EXISTS `questionnaire`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `questionnaire` ( `questionnaire_id` bigint NOT NULL AUTO_INCREMENT, `category_id` bigint DEFAULT NULL, `sub_category_id` bigint DEFAULT NULL, `questionnaire_part_id` bigint DEFAULT NULL, `questionnaire_section_id` bigint DEFAULT NULL, `question` text NOT NULL, `question_no` int NOT NULL, `feedback_area` tinyint(1) DEFAULT '0', `needs_upload` tinyint DEFAULT '0', `checkbox_options` varchar(200) DEFAULT NULL, `dropdown_options` varchar(200) DEFAULT NULL, `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `status` smallint DEFAULT '1', `created_by` bigint NOT NULL, PRIMARY KEY (`questionnaire_id`), KEY `questionnaire_fk1` (`created_by`), KEY `questionnaire_fk2` (`category_id`), KEY `questionnaire_fk3` (`sub_category_id`), KEY `questionnaire_fk4` (`questionnaire_part_id`), KEY `questionnaire_fk5` (`questionnaire_section_id`), CONSTRAINT `questionnaire_fk1` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`), CONSTRAINT `questionnaire_fk2` FOREIGN KEY (`category_id`) REFERENCES `category` (`category_id`), CONSTRAINT `questionnaire_fk3` FOREIGN KEY (`sub_category_id`) REFERENCES `sub_category` (`sub_category_id`), CONSTRAINT `questionnaire_fk4` FOREIGN KEY (`questionnaire_part_id`) REFERENCES `questionnaire_part` (`questionnaire_part_id`), CONSTRAINT `questionnaire_fk5` FOREIGN KEY (`questionnaire_section_id`) REFERENCES `questionnaire_section` (`questionnaire_section_id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `questionnaire` -- LOCK TABLES `questionnaire` WRITE; /*!40000 ALTER TABLE `questionnaire` DISABLE KEYS */; INSERT INTO `questionnaire` VALUES (1,NULL,NULL,2,1,'

Does your institution have a document outlining HR Policies and Procedures on recruitment, promotion, performance management, and training? 

',1,0,0,'Yes,No',NULL,'2021-04-29 21:38:07','2021-04-29 18:38:07',1,4),(2,NULL,NULL,2,1,'

Does your institution have Scheme(s) of Service and/or Career Progression Guidelines?

',2,0,0,'Yes,No',NULL,'2021-04-30 12:00:43','2021-04-30 09:00:43',1,4),(3,NULL,NULL,2,1,'

Does your institution have a Performance Management System?

',3,0,0,'Yes,No',NULL,'2021-04-30 12:41:19','2021-04-30 09:41:19',1,4),(4,NULL,NULL,2,1,'

Does your institution have an automated Human Resource Management Information System?

',4,0,0,'Yes,No',NULL,'2021-04-30 13:01:05','2021-04-30 10:01:05',1,4),(6,NULL,NULL,2,3,'

Does your institution have an approved staff establishment?

',5,0,0,'Yes,No',NULL,'2021-04-30 17:08:14','2021-04-30 14:08:14',1,4),(7,NULL,NULL,2,3,'

How many employees in your institution are serving (or had served) in different terms of employment?

',6,0,0,NULL,NULL,'2021-04-30 19:34:03','2021-04-30 16:34:03',1,4),(9,NULL,NULL,2,3,'

How many employees are there in your institution by mode of recruitment, and what is the total wage bill for each category? 

',7,0,0,NULL,NULL,'2021-04-30 19:50:03','2021-04-30 16:50:03',1,4),(10,NULL,NULL,2,3,'

How many employees are there in your institution by mode of recruitment, and what is the total wage bill for each category?

',8,0,0,NULL,NULL,'2021-04-30 20:08:03','2021-04-30 17:08:03',1,4),(11,NULL,NULL,2,3,'

How many State Officers do you have and what is the cost of their remuneration and benefits?

',9,0,0,NULL,NULL,'2021-04-30 20:16:37','2021-04-30 17:16:37',1,4),(12,NULL,NULL,2,3,'

How many Advisors do you have and what is the cost of their remuneration and benefits? 

',10,0,0,NULL,NULL,'2021-04-30 20:26:18','2021-04-30 17:26:18',1,4),(13,NULL,NULL,2,3,'

How many Board Members/Commissioners do you have and what is the cost of their remuneration and benefits? (Including Municipal and City Boards)

',11,0,0,NULL,NULL,'2021-04-30 20:29:44','2021-04-30 17:29:44',1,4),(14,NULL,NULL,2,3,'

How much is your total wage bill (i.e. salaries, wages) and pension/gratuity contribution/payments for the period 2012/13 to 2019/20 FYs?

',12,0,0,NULL,NULL,'2021-04-30 20:34:33','2021-04-30 17:34:33',1,4),(15,NULL,NULL,2,3,'

How much of the total compensation was paid as:

',13,0,0,NULL,NULL,'2021-04-30 20:48:36','2021-04-30 17:48:36',1,4),(16,NULL,NULL,2,3,'

What other allowances are paid in your institution to both State and Public Officers in the format below?

',14,0,0,NULL,NULL,'2021-04-30 21:09:01','2021-04-30 18:09:01',1,4),(17,NULL,NULL,2,3,'

Has the county formed any County Corporations? If Yes, kindly provide the salary structure for staff for each Corporation.

',15,1,0,NULL,NULL,'2021-04-30 21:10:29','2021-04-30 18:10:29',1,4); /*!40000 ALTER TABLE `questionnaire` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `questionnaire_answer` -- DROP TABLE IF EXISTS `questionnaire_answer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `questionnaire_answer` ( `questionnaire_answer_id` bigint NOT NULL AUTO_INCREMENT, `questionnaire_id` bigint NOT NULL, `sub_questionnaire_id` bigint DEFAULT NULL, `institution_id` bigint NOT NULL, `answered_by` bigint NOT NULL, `in_progress` tinyint(1) DEFAULT NULL, `submitted_for_review` tinyint(1) DEFAULT '0', `returned_for_review` tinyint(1) DEFAULT '0', `review_comments` text, `approved_by` bigint NOT NULL, `questionnaire_year` varchar(5) NOT NULL, `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created_by` bigint NOT NULL, PRIMARY KEY (`questionnaire_answer_id`), KEY `questionnaire_answer_fk1` (`questionnaire_id`), KEY `questionnaire_answer_fk2` (`answered_by`), KEY `questionnaire_answer_fk3` (`approved_by`), KEY `questionnaire_answer_fk4` (`created_by`), CONSTRAINT `questionnaire_answer_fk1` FOREIGN KEY (`questionnaire_id`) REFERENCES `questionnaire` (`questionnaire_id`), CONSTRAINT `questionnaire_answer_fk2` FOREIGN KEY (`answered_by`) REFERENCES `user` (`user_id`), CONSTRAINT `questionnaire_answer_fk3` FOREIGN KEY (`approved_by`) REFERENCES `user` (`user_id`), CONSTRAINT `questionnaire_answer_fk4` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `questionnaire_answer` -- LOCK TABLES `questionnaire_answer` WRITE; /*!40000 ALTER TABLE `questionnaire_answer` DISABLE KEYS */; /*!40000 ALTER TABLE `questionnaire_answer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `questionnaire_answer_detail` -- DROP TABLE IF EXISTS `questionnaire_answer_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `questionnaire_answer_detail` ( `questionnaire_answer_detail_id` bigint NOT NULL AUTO_INCREMENT, `questionnaire_answer_id` bigint NOT NULL, `answer_checkbox_options` varchar(100) DEFAULT NULL, `answer_dropdown_option` varchar(50) DEFAULT NULL, `answer_text` text, `answer_upload` varchar(200) DEFAULT NULL, `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created_by` bigint NOT NULL, PRIMARY KEY (`questionnaire_answer_detail_id`), KEY `questionnaire_answer_detail_fk1` (`questionnaire_answer_id`), KEY `questionnaire_answer_detail_fk4` (`created_by`), CONSTRAINT `questionnaire_answer_detail_fk1` FOREIGN KEY (`questionnaire_answer_id`) REFERENCES `questionnaire_answer` (`questionnaire_answer_id`), CONSTRAINT `questionnaire_answer_detail_fk4` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `questionnaire_answer_detail` -- LOCK TABLES `questionnaire_answer_detail` WRITE; /*!40000 ALTER TABLE `questionnaire_answer_detail` DISABLE KEYS */; /*!40000 ALTER TABLE `questionnaire_answer_detail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `questionnaire_part` -- DROP TABLE IF EXISTS `questionnaire_part`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `questionnaire_part` ( `questionnaire_part_id` bigint NOT NULL AUTO_INCREMENT, `part_name` varchar(200) DEFAULT NULL, `status` tinyint(1) DEFAULT '0', `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created_by` bigint NOT NULL, PRIMARY KEY (`questionnaire_part_id`), KEY `questionnaire_part_fk1` (`created_by`), CONSTRAINT `questionnaire_part_fk1` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `questionnaire_part` -- LOCK TABLES `questionnaire_part` WRITE; /*!40000 ALTER TABLE `questionnaire_part` DISABLE KEYS */; INSERT INTO `questionnaire_part` VALUES (1,'PART 1: GENERAL INFORMATION',NULL,'2021-04-29 03:23:36','2021-04-29 01:03:24',4),(2,'PART 2: TECHNICAL QUESTIONS',NULL,'2021-04-29 03:23:45','2021-04-29 01:04:04',4),(3,'PART 3: DISCUSSION',NULL,'2021-04-29 03:23:52','2021-04-29 01:04:36',4); /*!40000 ALTER TABLE `questionnaire_part` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `questionnaire_section` -- DROP TABLE IF EXISTS `questionnaire_section`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `questionnaire_section` ( `questionnaire_section_id` bigint NOT NULL AUTO_INCREMENT, `questionnaire_part_id` bigint NOT NULL, `section_name` varchar(200) DEFAULT NULL, `status` tinyint(1) DEFAULT '0', `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created_by` bigint NOT NULL, PRIMARY KEY (`questionnaire_section_id`), KEY `questionnaire_section_fk1` (`created_by`), KEY `questionnaire_section_fk2` (`questionnaire_part_id`), CONSTRAINT `questionnaire_section_fk1` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`), CONSTRAINT `questionnaire_section_fk2` FOREIGN KEY (`questionnaire_part_id`) REFERENCES `questionnaire_part` (`questionnaire_part_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `questionnaire_section` -- LOCK TABLES `questionnaire_section` WRITE; /*!40000 ALTER TABLE `questionnaire_section` DISABLE KEYS */; INSERT INTO `questionnaire_section` VALUES (1,2,'SECTION A: HUMAN RESOURCES POLICIES AND PRACTICES',0,'2021-04-29 04:06:07','2021-04-29 01:09:25',4),(3,2,'SECTION B: EMPLOYEES NUMBERS, SALARIES, WAGES AND ALLOWANCES',0,'2021-04-29 04:10:28','2021-04-29 01:10:28',4),(4,2,'SECTION C: PAYROLL MANAGEMENT',0,'2021-04-29 04:11:20','2021-04-29 01:11:20',4); /*!40000 ALTER TABLE `questionnaire_section` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `questionnaire_table` -- DROP TABLE IF EXISTS `questionnaire_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `questionnaire_table` ( `questionnaire_table_id` bigint NOT NULL AUTO_INCREMENT, `questionnaire_id` bigint DEFAULT NULL, `sub_questionnaire_id` bigint DEFAULT NULL, `table_no` int NOT NULL, `table_title` varchar(200) NOT NULL, `table_html` text NOT NULL, `table_js` text, `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `status` smallint DEFAULT '1', `created_by` bigint NOT NULL, PRIMARY KEY (`questionnaire_table_id`), KEY `questionnaire_table_fk1` (`created_by`), CONSTRAINT `questionnaire_table_fk1` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `questionnaire_table` -- LOCK TABLES `questionnaire_table` WRITE; /*!40000 ALTER TABLE `questionnaire_table` DISABLE KEYS */; INSERT INTO `questionnaire_table` VALUES (1,6,NULL,1,'Table 1: Approved Staff Establishment','\r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
DesignationInternal GradeCivil Service EquivalentNumber (As At....) \r\n \r\n \r\n \r\n
\r\n\r\n
\r\n','','2021-04-30 17:08:14','2021-04-30 14:41:06',1,4),(2,7,NULL,2,'Table 2: Number of employees','\r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
FYNumber of Public officers
PermanentContractualCasualTemporaryInternsSecondments inSecondments outTotal\r\n \r\n \r\n \r\n
\r\n \r\n
\r\n\r\n
\r\n','','2021-04-30 19:34:03','2021-04-30 16:38:06',1,4),(3,9,NULL,3,'Table 3: Category of Employees (Public Officers including Board Members and Advisors)','\r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
FYStaff Recruited by CPSBStaff Recruited by CASBStaff Devolved from National GovernmentStaff Inherited from Defunct Local Authorities\r\n Others (casuals and other temporary employees)\r\n \r\n \r\n \r\n
Total NumberTotal Wage BillTotal NumberTotal Wage BillTotal NumberTotal Wage BillTotal NumberTotal Wage BillTotal NumberTotal Wage Bill
\r\n \r\n
\r\n\r\n
\r\n','','2021-04-30 19:50:03','2021-04-30 16:57:49',1,4),(4,10,NULL,4,'Table 4: Category of Employees (Public Officers including Board Members and Advisors)','\r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
FYPermanent and PensionableContract\r\n Others(casuals and other temporary employees)\r\n \r\n \r\n \r\n
Total NumberTotal Wage BillTotal NumberTotal Wage BillTotal NumberTotal Wage Bill
\r\n \r\n
\r\n\r\n
\r\n','','2021-04-30 20:08:03','2021-04-30 17:17:42',1,4),(5,11,NULL,5,'Table 5: Total Wage Bill Expenditure for State Officers','\r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
FYState officers (no)\r\n Total Wage Bill Expenditure (Kshs)\r\n \r\n \r\n \r\n
RemunerationBenefits
\r\n \r\n
\r\n\r\n
\r\n','','2021-04-30 20:16:37','2021-04-30 17:16:37',1,4),(6,12,NULL,6,'Table 6: Total Wage Bill Expenditures for Advisors','\r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
FYAdvisors (No)\r\n Total Wage Bill Expenditure (Kshs)\r\n \r\n \r\n \r\n
RemunerationBenefits
\r\n \r\n
\r\n\r\n
\r\n','','2021-04-30 20:26:19','2021-04-30 17:26:19',1,4),(7,13,NULL,7,'Table 7: Total Wage Bill Expenditures for Board Members','\r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
FYBoard Members/Commisioners (No)\r\n Total Wage Bill Expenditure (Kshs)\r\n \r\n \r\n \r\n
RemunerationBenefits
\r\n \r\n
\r\n\r\n
\r\n','','2021-04-30 20:29:44','2021-04-30 17:29:44',1,4),(8,14,NULL,8,'Table 8: Total Wage Bill Expenditure including pension for the institution','\r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
FYWage Bill ExpenditurePension\r\n Total Expenditure\r\n \r\n \r\n \r\n
\r\n \r\n
\r\n\r\n
\r\n','','2021-04-30 20:34:33','2021-04-30 17:34:33',1,4),(9,15,NULL,9,'Table 9: Total Compensation','\r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Category\r\n Period\r\n \r\n \r\n \r\n
2012/20132013/20142014/20152015/20162016/20172017/20182018/20192019 Dec
Basic Salary
Other Allowances e.g. DSA, Sitting allowances
Wages to Casuals
Pension
Medical Cover
Group Life Cover
Group Personal Accident
Gratuity
Bonus
Arrears
Top-up Salary
Others (specify)
\r\n\r\n
\r\n','','2021-04-30 20:48:36','2021-04-30 17:48:36',1,4),(10,16,NULL,10,'Table 10: Allowances Payable','\r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Name of AllowanceSource of Circular (e.g. SRC, PSC, etc)Eligibile Staff by GradeRate of Payment/ amount(KShs)Mode of payment (e.g. payroll, cash or voucher)\r\n Frequency of Payment (e.g. Monthly, annually, etc)\r\n \r\n \r\n \r\n
\r\n\r\n
\r\n','','2021-04-30 21:09:01','2021-04-30 18:09:01',1,4); /*!40000 ALTER TABLE `questionnaire_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `questionnaire_table_answer` -- DROP TABLE IF EXISTS `questionnaire_table_answer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `questionnaire_table_answer` ( `questionnaire_table_answer_id` bigint NOT NULL AUTO_INCREMENT, `questionnaire_answer_id` bigint NOT NULL, `questionnaire_table_id` bigint NOT NULL, `table_answerhtml` text NOT NULL, `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `status` smallint DEFAULT '1', `created_by` bigint NOT NULL, PRIMARY KEY (`questionnaire_table_answer_id`), KEY `questionnaire_table_fk1` (`created_by`), KEY `questionnaire_table_answer_fk2` (`questionnaire_answer_id`), KEY `questionnaire_table_answer_fk3` (`questionnaire_table_id`), CONSTRAINT `questionnaire_table_answer_fk1` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`), CONSTRAINT `questionnaire_table_answer_fk2` FOREIGN KEY (`questionnaire_answer_id`) REFERENCES `questionnaire_answer` (`questionnaire_answer_id`), CONSTRAINT `questionnaire_table_answer_fk3` FOREIGN KEY (`questionnaire_table_id`) REFERENCES `questionnaire_table` (`questionnaire_table_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `questionnaire_table_answer` -- LOCK TABLES `questionnaire_table_answer` WRITE; /*!40000 ALTER TABLE `questionnaire_table_answer` DISABLE KEYS */; /*!40000 ALTER TABLE `questionnaire_table_answer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `src_circular` -- DROP TABLE IF EXISTS `src_circular`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `src_circular` ( `src_circular_id` bigint NOT NULL AUTO_INCREMENT, `subject` varchar(300) NOT NULL, `ref_no` varchar(50) DEFAULT NULL, `date_issued` datetime DEFAULT NULL, `status` smallint DEFAULT '1', `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created_by` bigint NOT NULL, PRIMARY KEY (`src_circular_id`), KEY `src_circular_fk1` (`created_by`), CONSTRAINT `src_circular_fk1` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `src_circular` -- LOCK TABLES `src_circular` WRITE; /*!40000 ALTER TABLE `src_circular` DISABLE KEYS */; INSERT INTO `src_circular` VALUES (1,'Salary survey for 2021-2025','SRC/ADM/CIR/1/13 Vol. IV (39)','2020-08-14 00:00:00',1,'2021-04-30 23:57:23','2021-04-30 21:07:12',4),(2,'Housing benefits for Governors','SRC/ADM/CIR/1/13 Vol. IV (39)','2020-08-14 00:00:00',1,'2021-05-01 00:05:32','2021-04-30 21:11:00',4); /*!40000 ALTER TABLE `src_circular` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sub_category` -- DROP TABLE IF EXISTS `sub_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sub_category` ( `sub_category_id` bigint NOT NULL AUTO_INCREMENT, `category_id` bigint NOT NULL, `sub_category_name` varchar(50) NOT NULL, `description` varchar(300) DEFAULT NULL, `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `status` smallint DEFAULT '1', `created_by` bigint NOT NULL, PRIMARY KEY (`sub_category_id`), KEY `sub_category_fk1` (`created_by`), KEY `sub_category_fk2` (`category_id`), CONSTRAINT `sub_category_fk1` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`), CONSTRAINT `sub_category_fk2` FOREIGN KEY (`category_id`) REFERENCES `category` (`category_id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sub_category` -- LOCK TABLES `sub_category` WRITE; /*!40000 ALTER TABLE `sub_category` DISABLE KEYS */; INSERT INTO `sub_category` VALUES (1,1,'Service and Regulatory',NULL,'2021-04-28 19:27:51','2021-04-28 16:27:51',1,4),(2,1,'Commercial and Strategic','Commercial and Strategic Sub Category','2021-04-28 19:44:11','2021-04-28 16:54:14',1,4),(3,1,'Service and Regulatory',NULL,'2021-04-28 19:44:37','2021-04-28 16:44:37',1,4),(4,2,'County Governments - Executive',NULL,'2021-04-28 19:45:32','2021-04-28 16:45:32',1,4),(5,2,'County Governments - Legislature',NULL,'2021-04-28 19:46:04','2021-04-28 16:46:04',1,4),(6,2,'County Governments - Public Service Board',NULL,'2021-04-28 19:46:11','2021-04-28 16:46:11',1,4),(8,4,'TVET Institution','Technical Vocational','2021-04-28 22:03:35','2021-04-28 19:03:35',1,4); /*!40000 ALTER TABLE `sub_category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sub_questionnaire` -- DROP TABLE IF EXISTS `sub_questionnaire`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sub_questionnaire` ( `sub_questionnaire_id` bigint NOT NULL AUTO_INCREMENT, `questionnaire_id` bigint DEFAULT NULL, `parent_sub_questionnaire_id` bigint DEFAULT NULL, `sub_question` text NOT NULL, `feedback_area` tinyint(1) DEFAULT NULL, `sub_question_no` int NOT NULL, `needs_upload` tinyint DEFAULT '0', `checkbox_options` varchar(200) DEFAULT NULL, `dropdown_options` varchar(200) DEFAULT NULL, `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `status` smallint DEFAULT '1', `created_by` bigint NOT NULL, PRIMARY KEY (`sub_questionnaire_id`), KEY `sub_questionnaire_fk1` (`created_by`), KEY `sub_questionnaire_fk2` (`questionnaire_id`), KEY `sub_questionnaire_id_fk3` (`parent_sub_questionnaire_id`), CONSTRAINT `sub_questionnaire_fk1` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`), CONSTRAINT `sub_questionnaire_fk2` FOREIGN KEY (`questionnaire_id`) REFERENCES `questionnaire` (`questionnaire_id`), CONSTRAINT `sub_questionnaire_id_fk3` FOREIGN KEY (`parent_sub_questionnaire_id`) REFERENCES `sub_questionnaire` (`sub_questionnaire_id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sub_questionnaire` -- LOCK TABLES `sub_questionnaire` WRITE; /*!40000 ALTER TABLE `sub_questionnaire` DISABLE KEYS */; INSERT INTO `sub_questionnaire` VALUES (1,1,NULL,'

If Yes, please specify the documents and provide copies of the documents.

',NULL,1,1,NULL,NULL,'2021-04-30 01:05:09','2021-04-29 22:05:09',1,4),(2,1,NULL,'

If No, what guides your HR practices?

',1,2,NULL,NULL,NULL,'2021-04-30 01:07:50','2021-04-29 22:07:50',1,4),(3,2,NULL,'

If Yes, please provide a copy. 

',0,1,1,NULL,NULL,'2021-04-30 12:01:30','2021-04-30 09:01:30',1,4),(4,2,NULL,'

If No, how is career progression managed in your institution? 

',1,2,NULL,NULL,NULL,'2021-04-30 12:02:10','2021-04-30 09:02:10',1,4),(5,3,NULL,'

If Yes, 

',0,1,0,NULL,NULL,'2021-04-30 12:42:27','2021-04-30 09:42:27',1,4),(6,NULL,5,'

Specify the system used to manage performance in your institution.

',1,1,0,NULL,NULL,'2021-04-30 12:46:49','2021-04-30 09:53:30',1,4),(7,NULL,5,'

How is the system applied in managing performance in your institution? 

',1,2,0,NULL,NULL,'2021-04-30 12:48:04','2021-04-30 09:53:30',1,4),(8,NULL,5,'

What type of rewards are administered? 

',1,3,0,NULL,NULL,'2021-04-30 12:48:42','2021-04-30 09:53:30',1,4),(9,NULL,5,'

What type of Sanctions are used for none performers?

',1,4,0,NULL,NULL,'2021-04-30 12:49:20','2021-04-30 09:53:30',1,4),(10,3,NULL,'

If No,

',0,2,0,NULL,NULL,'2021-04-30 12:56:10','2021-04-30 09:56:10',1,4),(11,NULL,10,'

How do you manage performance?

',1,1,0,NULL,NULL,'2021-04-30 12:56:53','2021-04-30 09:58:24',1,4),(12,NULL,10,'

Are you in the process of developing a Performance Management System?

',1,2,0,NULL,NULL,'2021-04-30 12:57:24','2021-04-30 09:58:24',1,4),(13,4,NULL,'

If Yes, please specify. (Does it include personal file management, performance appraisal, attendance monitoring, etc)?

',1,1,0,NULL,NULL,'2021-04-30 13:02:39','2021-04-30 10:02:39',1,4),(14,4,NULL,'

If No, state what is in use?

',1,2,0,NULL,NULL,'2021-04-30 13:03:08','2021-04-30 10:03:08',1,4),(15,6,NULL,'

Is the establishment adhered to during recruitments?

',1,1,0,NULL,NULL,'2021-04-30 17:43:59','2021-04-30 14:43:59',1,4),(16,6,NULL,'

If No, how does the county control recruitment?

',1,2,0,NULL,NULL,'2021-04-30 17:44:54','2021-04-30 14:44:54',1,4); /*!40000 ALTER TABLE `sub_questionnaire` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user` -- DROP TABLE IF EXISTS `user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user` ( `user_id` bigint NOT NULL AUTO_INCREMENT, `user_role_id` bigint NOT NULL, `msisdn` varchar(150) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `name` varchar(60) DEFAULT NULL, `institution_id` int DEFAULT NULL, `created` datetime DEFAULT CURRENT_TIMESTAMP, `status` smallint DEFAULT '0', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created_by` int DEFAULT NULL, `password` varchar(300) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `email_verified_at` datetime DEFAULT NULL, `approved_by` int DEFAULT NULL, PRIMARY KEY (`user_id`), UNIQUE KEY `email` (`email`), KEY `user_role_fk1` (`user_role_id`), CONSTRAINT `user_role_fk1` FOREIGN KEY (`user_role_id`) REFERENCES `user_role` (`user_role_id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user` -- LOCK TABLES `user` WRITE; /*!40000 ALTER TABLE `user` DISABLE KEYS */; INSERT INTO `user` VALUES (4,1,'0726498976','antony@issverify.com','Antony Njoroge Thiong\'o',NULL,'2021-04-28 13:58:37',0,'2021-04-28 22:25:11',NULL,'$2y$10$YOlqi8Uxcsbwl6uo4P4roerCF2Z/u/op2ZIADF2zLvJzsf9/sOV9q',NULL,NULL,NULL),(6,3,'0734626724','felix@ktda.or.ke','Felix Mugambi',4,'2021-04-29 01:09:01',0,'2021-04-28 23:11:37',4,'$2y$10$0cNiINgcDf5LJyss/Z0gS.WwegSloqmamlWg2msfeMZIPCMpngIEa',NULL,NULL,4),(7,2,'073456272','josephine@knh.go.ke','Josephine Kabiru',1,'2021-04-29 01:13:21',1,'2021-04-28 22:13:21',4,'$2y$10$RUvjtL.nv0qNv7H/I2cc/.u98zrjnnzRJNQA1TK7mtRlYH8ENKzdC',NULL,NULL,4); /*!40000 ALTER TABLE `user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_role` -- DROP TABLE IF EXISTS `user_role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_role` ( `user_role_id` bigint NOT NULL AUTO_INCREMENT, `role` varchar(50) NOT NULL, `created` datetime DEFAULT CURRENT_TIMESTAMP, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `status` smallint DEFAULT '1', `created_by` int DEFAULT NULL, PRIMARY KEY (`user_role_id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_role` -- LOCK TABLES `user_role` WRITE; /*!40000 ALTER TABLE `user_role` DISABLE KEYS */; INSERT INTO `user_role` VALUES (1,'SRC Employee','2021-04-28 13:26:41','2021-04-28 10:26:41',1,1),(2,'Government Institution Clerk','2021-04-28 13:26:58','2021-04-28 10:26:58',1,1),(3,'Government Institution Management','2021-04-28 13:27:04','2021-04-28 10:27:04',1,1),(8,'SRC Management','2021-05-02 03:24:14','2021-05-02 00:24:14',1,4); /*!40000 ALTER TABLE `user_role` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_session` -- DROP TABLE IF EXISTS `user_session`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_session` ( `user_session_id` bigint NOT NULL AUTO_INCREMENT, `user_id` bigint NOT NULL, `user_name` varchar(50) NOT NULL, `login_time` datetime NOT NULL, `logout_time` datetime DEFAULT NULL, `created` datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`user_session_id`), KEY `user_session_fk1` (`user_id`), CONSTRAINT `user_session_fk1` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_session` -- LOCK TABLES `user_session` WRITE; /*!40000 ALTER TABLE `user_session` DISABLE KEYS */; /*!40000 ALTER TABLE `user_session` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2021-05-03 8:23:29