-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               10.4.16-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win64
-- HeidiSQL Version:             11.3.0.6295
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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 */;

-- Dumping structure for table peoplei_300_people_dev.employee_trainings
CREATE TABLE IF NOT EXISTS `pm_employee_trainings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `emp_id` bigint(20) unsigned DEFAULT NULL,
  `appraisal_id` bigint(20) unsigned DEFAULT NULL,
  `client_id` bigint(20) unsigned DEFAULT NULL,
  `status` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



-- Dumping structure for table peoplei_300_people_dev.pm_individual_calculation
CREATE TABLE IF NOT EXISTS `pm_individual_calculation` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `pm_role_based_calculation_id` int(10) DEFAULT NULL,
  `client_id` int(9) unsigned DEFAULT NULL,
  `country_id` int(11) unsigned DEFAULT 154,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `role_id` int(11) DEFAULT NULL,
  `role_status` tinyint(1) NOT NULL DEFAULT 0,
  `role_comments` varchar(255) DEFAULT NULL,
  `role_date` timestamp NULL DEFAULT NULL,
  `emp_id` int(9) unsigned DEFAULT NULL,
  `what's_average_rating` varchar(255) DEFAULT NULL,
  `what's_weightage_rating` varchar(255) DEFAULT NULL,
  `how's_weightage_rating` varchar(255) DEFAULT NULL,
  `how's_average_rating` varchar(255) DEFAULT NULL,
  `how's_total_rating` varchar(255) DEFAULT NULL,
  `what's_total_rating` varchar(255) DEFAULT NULL,
  `final_rating` varchar(255) DEFAULT NULL,
  `group_id` int(9) unsigned DEFAULT NULL,
  `created_by` int(9) unsigned DEFAULT NULL,
  `updated_by` int(9) unsigned DEFAULT NULL,
  `deleted_by` int(9) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pm_role_wise_calculation_detail_group_id_foreign` (`group_id`),
  KEY `pm_role_wise_calculation_detail_role_id_foreign` (`role_id`),
  KEY `pm_role_wise_calculation_detail_client_id_foreign` (`client_id`),
  KEY `pm_role_wise_calculation_detail_country_id_foreign` (`country_id`),
  KEY `pm_role_wise_calculation_detail_foreign` (`pm_role_based_calculation_id`),
  KEY `pm_role_wise_calculation_detail_created_by_foreign` (`created_by`),
  KEY `pm_role_wise_calculation_detail_updated_by_foreign` (`updated_by`),
  KEY `pm_role_wise_calculation_detail_deleted_by_foreign` (`deleted_by`),
  KEY `pm_role_wise_calculation_detail_emp_id_foreign` (`emp_id`),
  CONSTRAINT `pm_role_wise_calculation_detail_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `proll_client` (`id`),
  CONSTRAINT `pm_role_wise_calculation_detail_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`country_id`),
  CONSTRAINT `pm_role_wise_calculation_detail_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `proll_employee` (`id`),
  CONSTRAINT `pm_role_wise_calculation_detail_deleted_by_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `proll_employee` (`id`),
  CONSTRAINT `pm_role_wise_calculation_detail_emp_id_foreign` FOREIGN KEY (`emp_id`) REFERENCES `proll_employee` (`id`),
  CONSTRAINT `pm_role_wise_calculation_detail_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`group_id`),
  CONSTRAINT `pm_role_wise_calculation_detail_id_foreign` FOREIGN KEY (`pm_role_based_calculation_id`) REFERENCES `pm_role_wise_calculation` (`id`),
  CONSTRAINT `pm_role_wise_calculation_detail_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
  CONSTRAINT `pm_role_wise_calculation_detail_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `proll_employee` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;



-- Dumping structure for table peoplei_300_people_dev.pm_key_accountability_areas
CREATE TABLE IF NOT EXISTS `pm_key_accountability_areas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kaa_title` varchar(200) DEFAULT NULL,
  `weightage` int(3) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` int(9) unsigned DEFAULT NULL,
  `updated_by` int(9) unsigned DEFAULT NULL,
  `deleted_by` int(9) unsigned DEFAULT NULL,
  `client_id` int(9) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `Foregin_key_kaa_created_by` (`created_by`),
  KEY `Foregin_key_kaa_updated_by` (`updated_by`),
  KEY `Foregin_key_kaa_deleted_by` (`deleted_by`),
  KEY `Foregin_key_kaa_client_id` (`client_id`),
  CONSTRAINT `Foregin_key_kaa_client_id` FOREIGN KEY (`client_id`) REFERENCES `proll_client` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `Foregin_key_kaa_created_by` FOREIGN KEY (`created_by`) REFERENCES `proll_employee` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `Foregin_key_kaa_deleted_by` FOREIGN KEY (`deleted_by`) REFERENCES `proll_employee` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `Foregin_key_kaa_updated_by` FOREIGN KEY (`updated_by`) REFERENCES `proll_employee` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=262 DEFAULT CHARSET=latin1;



-- Dumping structure for table peoplei_300_people_dev.pm_key_perfomance_indicator
CREATE TABLE IF NOT EXISTS `pm_key_perfomance_indicator` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` int(9) unsigned DEFAULT NULL,
  `updated_by` int(9) unsigned DEFAULT NULL,
  `deleted_by` int(9) unsigned DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `kpi_title` varchar(255) DEFAULT NULL,
  `kaa_id` int(11) DEFAULT NULL,
  `goal_id` int(11) DEFAULT NULL,
  `client_id` int(9) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `Foregin_key_aag_created_by` (`created_by`),
  KEY `Foregin_key_aag_updated_by` (`updated_by`),
  KEY `Foregin_key_aag_deleted_by` (`deleted_by`),
  KEY `Foregin_key_kaa_id` (`kaa_id`),
  KEY `Foregin_key_goal_id` (`goal_id`),
  KEY `Foregin_key_aas_client_id` (`client_id`),
  CONSTRAINT `Foregin_key_aag_created_by` FOREIGN KEY (`created_by`) REFERENCES `proll_employee` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `Foregin_key_aag_deleted_by` FOREIGN KEY (`deleted_by`) REFERENCES `proll_employee` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `Foregin_key_aag_updated_by` FOREIGN KEY (`updated_by`) REFERENCES `proll_employee` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `Foregin_key_aas_client_id` FOREIGN KEY (`client_id`) REFERENCES `proll_client` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `Foregin_key_goal_id` FOREIGN KEY (`goal_id`) REFERENCES `pm_goals` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `Foregin_key_kaa_id` FOREIGN KEY (`kaa_id`) REFERENCES `pm_key_accountability_areas` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=214 DEFAULT CHARSET=latin1;



-- Dumping structure for table peoplei_300_people_dev.pm_rating
CREATE TABLE IF NOT EXISTS `pm_rating` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rating_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `application_individual_claculation_id` int(10) unsigned DEFAULT NULL,
  `competency_id` int(11) DEFAULT NULL,
  `kpi_id` int(11) DEFAULT NULL,
  `kaa_id` int(11) DEFAULT NULL,
  `goal_id` int(11) DEFAULT NULL,
  `rating_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_id` int(9) unsigned DEFAULT NULL,
  `group_id` int(9) unsigned DEFAULT NULL,
  `country_id` int(11) unsigned DEFAULT 154,
  `created_by` int(9) unsigned DEFAULT NULL,
  `updated_by` int(9) unsigned DEFAULT NULL,
  `deleted_by` int(9) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `pm_rating_group_id_foreign` (`group_id`) USING BTREE,
  KEY `pm_rating_country_id_foreign` (`country_id`) USING BTREE,
  KEY `pm_rating_client_id_foreign` (`client_id`) USING BTREE,
  KEY `ppm_rating_created_by_foreign` (`created_by`) USING BTREE,
  KEY `pm_rating_updated_by_foreign` (`updated_by`) USING BTREE,
  KEY `pm_rating_deleted_by_foreign` (`deleted_by`) USING BTREE,
  KEY `pm_rating_individual_calculation_foreign` (`application_individual_claculation_id`) USING BTREE,
  KEY `pm_rating_competency_by_foreign` (`competency_id`) USING BTREE,
  KEY `pm_rating_kpi_id_foreign` (`kpi_id`) USING BTREE,
  KEY `pm_rating_kaa_id_foreign` (`kaa_id`) USING BTREE,
  KEY `pm_rating_goal_id_foreign` (`goal_id`) USING BTREE,
  CONSTRAINT `pm_rating_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `proll_client` (`id`),
  CONSTRAINT `pm_rating_competency_id_by_foreign` FOREIGN KEY (`competency_id`) REFERENCES `pm_competency` (`id`),
  CONSTRAINT `pm_rating_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`country_id`),
  CONSTRAINT `pm_rating_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `proll_employee` (`id`),
  CONSTRAINT `pm_rating_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `proll_employee` (`id`),
  CONSTRAINT `pm_rating_goal_id_foreign` FOREIGN KEY (`goal_id`) REFERENCES `pm_goals` (`id`),
  CONSTRAINT `pm_rating_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`group_id`),
  CONSTRAINT `pm_rating_kaa_id_foreign` FOREIGN KEY (`kaa_id`) REFERENCES `pm_key_accountability_areas` (`id`),
  CONSTRAINT `pm_rating_kpi_id_foreign` FOREIGN KEY (`kpi_id`) REFERENCES `pm_key_perfomance_indicator` (`id`),
  CONSTRAINT `pm_rating_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `proll_employee` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4;





CREATE TABLE IF NOT EXISTS `pm_employee_trainings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `emp_id` bigint(20) unsigned DEFAULT NULL,
  `appraisal_id` bigint(20) unsigned DEFAULT NULL,
  `client_id` bigint(20) unsigned DEFAULT NULL,
  `status` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;








-- Dumping structure for table peoplei_300_people_dev.trainings
CREATE TABLE IF NOT EXISTS `pm_trainings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



-- Dumping structure for table peoplei_300_people_dev.training_categories
CREATE TABLE IF NOT EXISTS `pm_training_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `training_id` bigint(20) unsigned DEFAULT NULL,
  `department_group_heirarchy_id` bigint(20) unsigned DEFAULT NULL,
  `department_heirarchy_id` bigint(20) unsigned DEFAULT NULL,
  `employee_band_id` bigint(20) unsigned DEFAULT NULL,
  `KAA_id` bigint(20) unsigned DEFAULT NULL,
  `KPI_id` bigint(20) unsigned DEFAULT NULL,
  `goal_id` bigint(20) unsigned DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



-- Dumping structure for table peoplei_300_people_dev.training_requests
CREATE TABLE IF NOT EXISTS `pm_training_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `appraisal_id` bigint(20) unsigned DEFAULT NULL,
  `training_id` bigint(20) unsigned DEFAULT NULL,
  `emp_id` bigint(20) unsigned DEFAULT NULL,
  `role_id` bigint(20) unsigned DEFAULT NULL,
  `rating_id` bigint(20) unsigned DEFAULT NULL,
  `kaa_id` bigint(20) unsigned DEFAULT NULL,
  `kpi_id` bigint(20) unsigned DEFAULT NULL,
  `goal_id` bigint(20) unsigned DEFAULT NULL,
  `emp_training_id` bigint(20) unsigned DEFAULT NULL,
  `request_training` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `flag` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;