CREATE TABLE `fit_ind_exemption` ( `id` int(11) NOT NULL AUTO_INCREMENT, `individual_id` int(11) NOT NULL, `company_id` int(11) NOT NULL, `fit_test_id` int(11) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `forced` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `company_test_individual_uniq` (`individual_id`,`company_id`,`fit_test_id`), KEY `fit_test_id` (`fit_test_id`), KEY `FK_fit_ind_exemption_company` (`company_id`), CONSTRAINT `FK_fit_ind_exemption_company` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`), CONSTRAINT `fit_ind_exemption_ibfk_1` FOREIGN KEY (`individual_id`) REFERENCES `individual` (`id`), CONSTRAINT `fit_ind_exemption_ibfk_2` FOREIGN KEY (`fit_test_id`) REFERENCES `fit_test` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17051 DEFAULT CHARSET=utf8mb4 CREATE TABLE `fit_cat_rule` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fit_rule_id` int(11) DEFAULT NULL, `individual_id` int(11) NOT NULL, `company_id` int(11) NOT NULL, `fsp_cluster_id` int(11) NOT NULL, `fht_id` int(11) DEFAULT NULL, `cat` varchar(8) NOT NULL, `cat_off` int(11) NOT NULL, `fit_cat_id` int(11) NOT NULL, `fit_capacity_id` int(11) NOT NULL, `fit_service_id` int(11) NOT NULL, `fit_cob_id` int(11) NOT NULL, `dofa` date NOT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `exec_only` tinyint(4) DEFAULT NULL, `cms_date` date DEFAULT NULL, `cms_status_id_` int(11) DEFAULT 0, `cms_exempt` tinyint(4) DEFAULT 0, `cms_extension` date DEFAULT NULL, `cms_disregard` tinyint(4) DEFAULT 0, `cob_req_id` int(11) DEFAULT 0, `cob_id` int(11) DEFAULT 0, `cob_disregard` tinyint(4) DEFAULT 0, `cob_forced` tinyint(4) DEFAULT 0, `cob_deem` int(11) DEFAULT 0, `cob_status_id_` int(11) DEFAULT 0, `cob_end_date` date DEFAULT NULL, `cob_first` date DEFAULT NULL, `cob_deem_date` date DEFAULT NULL, `cob_exempt` tinyint(4) DEFAULT 0, `cob_extension` date DEFAULT NULL, `cob_date` date DEFAULT NULL, `cpd_required` int(11) DEFAULT 0, `cpd_6year` date DEFAULT NULL, `cpd_beg` date DEFAULT NULL, `cpd_status_id_` int(11) DEFAULT 0, `cpd_forced` tinyint(4) DEFAULT 0, `cpd_pre_req_hrs` decimal(10,1) DEFAULT 0.0, `cpd_pre_hours` decimal(10,1) DEFAULT 0.0, `cpd_pre_shortfall` decimal(10,1) DEFAULT 0.0, `cpd_cur_req_hrs` decimal(10,1) DEFAULT 0.0, `cpd_cur_hours` decimal(10,1) DEFAULT 0.0, `cpd_cur_shortfall` decimal(10,1) DEFAULT 0.0, `cpd_exempt` tinyint(4) DEFAULT 0, `cpd_extension` date DEFAULT NULL, `cpd_disregard` int(11) DEFAULT 0, `debarment` enum('Not Declared','Debarred','Not Debarred') DEFAULT 'Not Declared', `debar_status_id_` int(11) DEFAULT 0, `debar_exempt` tinyint(4) DEFAULT 0, `debar_extension` date DEFAULT NULL, `moral_disregard` int(11) DEFAULT 0, `fpe_status_id_` int(11) DEFAULT 0, `fpe_months` int(11) DEFAULT 0, `fpe_end` date DEFAULT NULL, `fpe_exempt` tinyint(4) DEFAULT 0, `fpe_extension` date DEFAULT NULL, `fpe_disregard` tinyint(4) DEFAULT 0, `fpe_forced` tinyint(4) DEFAULT 0, `good_standing` enum('Not Declared','No','Yes') DEFAULT 'Not Declared', `good_status_id_` int(11) DEFAULT 0, `good_exempt` tinyint(4) DEFAULT 0, `good_extension` date DEFAULT NULL, `honesty_integrity` enum('Not Declared','No','Yes') DEFAULT 'Not Declared', `honest_status_id_` int(11) DEFAULT 0, `honest_exempt` tinyint(4) DEFAULT 0, `honest_extension` date DEFAULT NULL, `meq_req_qual_id` int(11) DEFAULT 0, `meq_deem_qual_id` int(11) DEFAULT 0, `meq_status_id_` int(11) DEFAULT 0, `meq_date` date DEFAULT NULL, `meq_fsca_cat_id` int(11) DEFAULT 0, `meq_req_level_id` int(11) DEFAULT 0, `meq_deem_2010` int(11) DEFAULT 0, `meq_deem_level_id` int(11) DEFAULT 0, `meq_deem_credits` int(11) DEFAULT 0, `meq_exempt` tinyint(4) DEFAULT 0, `meq_extension` date DEFAULT NULL, `meq_disregard` int(11) DEFAULT 0, `meq_forced` tinyint(4) DEFAULT 0, `mo_date` date DEFAULT NULL, `mo_status_id_` int(11) DEFAULT 11, `mo_exempt` tinyint(4) DEFAULT 0, `mo_extension` date DEFAULT NULL, `mo_disregard` tinyint(4) DEFAULT 0, `pst_required` int(11) DEFAULT 0, `pst_status_id_` int(11) DEFAULT 0, `pst_exempt` tinyint(4) DEFAULT 0, `pst_disregard` int(11) DEFAULT 0, `q_req_qual_id` int(11) DEFAULT 0, `q_deem_qual_id` int(11) DEFAULT 0, `q_status_id_` int(11) DEFAULT 0, `q_date` date DEFAULT NULL, `q_end_date` date DEFAULT NULL, `q_fsca_cat_id` int(11) DEFAULT 0, `q_req_level_id` int(11) DEFAULT 0, `q_deem_2010` tinyint(4) DEFAULT 0, `q_deem_level_id` int(11) DEFAULT 0, `q_deem_credits` int(11) DEFAULT 0, `q_6years` tinyint(4) DEFAULT 0, `q_exempt` tinyint(4) DEFAULT 0, `q_extension` date DEFAULT NULL, `q_disregard` tinyint(4) DEFAULT 0, `q_forced` tinyint(4) DEFAULT 0, `re_req_code` int(11) DEFAULT 0, `re_miss_code` int(11) DEFAULT 0, `re_min_dofa` date DEFAULT NULL, `re_date` date DEFAULT NULL, `re_end_date` date DEFAULT NULL, `re_status_id_` int(11) DEFAULT 0, `re_2019` int(11) DEFAULT 0, `re_exempt` tinyint(4) DEFAULT 0, `re_extension` date DEFAULT NULL, `re_disregard` tinyint(4) DEFAULT 0, `re_forced` tinyint(4) DEFAULT 0, `re_neosad` date DEFAULT NULL, `supervisor_id` int(11) DEFAULT NULL, `sup_beg` date DEFAULT NULL, `sup_end` date DEFAULT NULL, `plansup_beg` date DEFAULT NULL, `plansup_end` date DEFAULT NULL, `plan_supervisor_id` int(11) DEFAULT NULL, `updated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `fcr_ind_fsp_cat_cap_service_UK` (`individual_id`,`company_id`,`fit_cat_id`,`fit_capacity_id`,`fit_service_id`), KEY `fit_cat_rule_individual_id_IDX` (`individual_id`) USING BTREE, KEY `fit_cat_rule_company_id_IDX` (`company_id`) USING BTREE, KEY `fit_cat_rule_supervisor_id_IDX` (`supervisor_id`) USING BTREE, KEY `fit_cat_rule_ind_cat_cap_serv_id_IDX` (`individual_id`,`fit_cat_id`,`fit_capacity_id`,`fit_service_id`) USING BTREE, KEY `fit_cat_rule_ind_cpy_cat_cap_serv_id_IDX` (`individual_id`,`company_id`,`fit_cat_id`,`fit_capacity_id`,`fit_service_id`) USING BTREE, KEY `fit_cat_rule_individual_id_fit_cob_id_IDX` (`individual_id`,`fit_cob_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=131079 DEFAULT CHARSET=utf8mb4