MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `employees` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255),
  `address` varchar(255),
  `phone_number` varchar(255),
  `gender` enum('male','female'),
  `created_at` timestamp,
  `updated_at` timestamp,
  PRIMARY KEY (`id`)
);

CREATE TABLE `kelompok_kriterias` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `nama_kelompok_kriteria` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `kriterias` (
  `id` bigint unsigned AUTO_INCREMENT,
  `kode_kriteria` varchar(255),
  `nama_kriteria` varchar(255),
  `bobot` int NOT NULL,
  `kelompok_kriteria_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `kriterias_kelompok_kriteria_id_kode_kriteria_unique` (`kelompok_kriteria_id`,`kode_kriteria`),
  CONSTRAINT `kriterias_kelompok_kriteria_id_foreign` FOREIGN KEY (`kelompok_kriteria_id`) REFERENCES `kelompok_kriterias` (`id`)
);
CREATE TABLE `rel_employee_kriterias` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint unsigned NOT NULL,
  `kode_kriteria` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kelompok_kriteria_id` bigint unsigned NOT NULL,
  `nilai` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `rel_employee_kriterias_employee_id_kode_kriteria_unique` (`employee_id`,`kode_kriteria`),
  CONSTRAINT `rel_employee_kriterias_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  CONSTRAINT `rel_employee_kriterias_kode_kriteria_foreign` FOREIGN KEY (`kelompok_kriteria_id`, `kode_kriteria`) REFERENCES `kriterias` (`kelompok_kriteria_id`, `kode_kriteria`)
);

Referencing column 'kode_kriteria' and referenced column 'kode_kriteria' in foreign key constraint 'rel_employee_kriterias_kode_kriteria_foreign' are incompatible.


CREATE TABLE `rel_employee_kriterias` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint unsigned NOT NULL,
  `kode_kriteria` varchar(255) NOT NULL,
  `kelompok_kriteria_id` bigint unsigned NOT NULL,
  `nilai` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `rel_employee_kriterias_employee_id_kode_kriteria_unique` (`employee_id`,`kode_kriteria`),
  CONSTRAINT `rel_employee_kriterias_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  CONSTRAINT `rel_employee_kriterias_kode_kriteria_foreign` FOREIGN KEY (`kelompok_kriteria_id`, `kode_kriteria`) REFERENCES `kriterias` (`kelompok_kriteria_id`, `kode_kriteria`)
);