-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `appspk`
--

-- --------------------------------------------------------

--
-- Table structure for table `alternatif`
--

CREATE TABLE `alternatif` (
  `id` bigint UNSIGNED NOT NULL,
  `nis` bigint NOT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tgl_lahir` date NOT NULL,
  `gender` enum('Pria','Wanita') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kelas_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `alternatif`
--

INSERT INTO `alternatif` (`id`, `nis`, `nama`, `tgl_lahir`, `gender`, `kelas_id`, `created_at`, `updated_at`) VALUES
(1, 12345678, 'sahidin', '2025-01-24', 'Pria', 4, NULL, NULL),
(4, 11111111111, 'nurul', '2025-01-24', 'Wanita', 4, '2025-01-23 18:00:18', '2025-01-27 00:57:23'),
(5, 22222222222, 'Gustafo', '2025-01-25', 'Pria', 5, '2025-01-24 20:35:05', '2025-02-01 19:31:41'),
(6, 123123123, 'Aila', '2025-01-29', 'Wanita', 5, '2025-01-29 03:52:38', '2025-02-01 19:32:18'),
(7, 321321321, 'Siswa', '2025-01-29', 'Pria', 2, '2025-01-29 04:05:02', '2025-01-29 04:05:02'),
(8, 78956781213, 'Abenta', '2025-01-29', 'Pria', 5, '2025-01-29 04:20:29', '2025-02-01 19:16:13'),
(9, 11111111112, 'Alfian', '2025-02-02', 'Pria', 5, '2025-02-01 19:17:22', '2025-02-01 19:17:22'),
(10, 11111111113, 'Selfianan', '2025-02-02', 'Wanita', 5, '2025-02-01 19:17:54', '2025-02-01 19:33:44'),
(11, 11111111114, 'Dava', '2025-02-02', 'Pria', 5, '2025-02-01 19:18:13', '2025-02-01 19:18:13'),
(17, 11111111115, 'ADAM HARIZH P.', '2025-01-12', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(18, 11111111116, 'AIRA ALMASWAH', '2025-01-13', 'Wanita', 6, '2025-02-17 08:42:13', '2025-02-17 11:18:59'),
(19, 11111111117, 'AKHMAD ZULFIKRI', '2025-01-14', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(20, 11111111118, 'ALHAFIQIN ZAMI KURNIAWAN', '2025-01-15', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(21, 11111111119, 'ANGGA GUSNINO RAHMAN', '2025-01-16', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(22, 11111111120, 'ANISYA PUTRI PERTIWI', '2025-01-17', 'Wanita', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(23, 11111111121, 'ARJANTI NATHANIA AQILA SYARIF', '2025-01-18', 'Wanita', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(24, 11111111122, 'AUREL SAKINAH', '2025-01-19', 'Wanita', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(25, 11111111123, 'BAGUS RAMADHANI', '2025-01-20', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(26, 11111111124, 'BALQIS NURUL AMANAH', '2025-01-21', 'Wanita', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(27, 11111111125, 'DENISYAH HERLINO', '2025-01-22', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(28, 11111111126, 'DESYIFA ALYA BASHIRA', '2025-01-23', 'Wanita', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(29, 11111111127, 'DEWI ASRANDA', '2025-01-24', 'Wanita', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(30, 11111111128, 'DWI MURNI MAULIDA', '2025-01-25', 'Wanita', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(31, 11111111129, 'EKI FEBRIANSYAH', '2025-01-26', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(32, 11111111130, 'FAISAL ADRIANSYAH', '2025-01-27', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(33, 11111111131, 'HABIL RAHMA SHOLIHIN', '2025-01-28', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(34, 11111111132, 'ILHAM JULIAN FATHONY', '2025-01-29', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(35, 11111111133, 'INTAN PUTRI REMADANI', '2025-01-30', 'Wanita', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(36, 11111111134, 'JUNIOR RAHEL', '2025-01-31', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(37, 11111111135, 'KEYSHA NURAINI', '2025-02-01', 'Wanita', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(38, 11111111136, 'M. ADJIE ATH THAARIA ADHA', '2025-02-02', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(39, 11111111137, 'M. DAVA SETIADI', '2025-02-03', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(40, 11111111138, 'MARISA RAINA AURELIA', '2025-02-04', 'Wanita', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(41, 11111111139, 'MAULA FERDIANO SYAFAAT', '2025-02-05', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(42, 11111111140, 'MUHAMMAD YUSUF KHOIRY P.', '2025-02-06', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(43, 11111111141, 'NANDA ANINDITA', '2025-02-07', 'Wanita', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(44, 11111111142, 'NARITA MELFIANA AGATHA', '2025-02-08', 'Wanita', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(45, 11111111143, 'RAFFA HAZIRAH', '2025-02-09', 'Wanita', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(46, 11111111144, 'REZA ARDIANSYAH', '2025-02-10', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(47, 11111111145, 'RIZKY SAIFULLOH', '2025-02-11', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(48, 11111111146, 'SILVANA ROMADHAN', '2025-02-12', 'Wanita', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(49, 11111111147, 'SYARIF HIDAYAT THULOH', '2025-02-13', 'Pria', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(50, 11111111148, 'TIA ADITA', '2025-02-14', 'Wanita', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13'),
(51, 11111111149, 'ZENITA AULIA', '2025-02-15', 'Wanita', 6, '2025-02-17 08:42:13', '2025-02-17 08:42:13');

-- --------------------------------------------------------

--
-- Table structure for table `kelas`
--

CREATE TABLE `kelas` (
  `id` bigint UNSIGNED NOT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kelas`
--

INSERT INTO `kelas` (`id`, `nama`, `created_at`, `updated_at`) VALUES
(2, 'KELAS 7 A', '2025-01-22 18:42:00', '2025-01-23 19:25:03'),
(4, 'KELAS 7 B', '2025-01-23 17:04:27', '2025-01-23 19:25:09'),
(5, 'KELAS 7 C', '2025-01-23 19:24:44', '2025-01-23 19:24:44'),
(6, 'KELAS 9 C', '2025-02-17 08:39:44', '2025-02-17 08:39:44'),
(7, 'KELAS 9 A', '2025-07-02 20:50:43', '2025-07-02 20:50:43'),
(8, 'KELAS 9 B', '2025-07-03 20:58:57', '2025-07-03 20:59:21');

-- --------------------------------------------------------

--
-- Table structure for table `kriteria`
--

CREATE TABLE `kriteria` (
  `id` bigint UNSIGNED NOT NULL,
  `kode` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bobot` double NOT NULL,
  `tipe` enum('benefit','cost') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kriteria`
--

INSERT INTO `kriteria` (`id`, `kode`, `nama`, `bobot`, `tipe`, `created_at`, `updated_at`) VALUES
(1, 'C1', 'Nilai', 30, 'benefit', NULL, '2025-02-01 19:12:03'),
(3, 'C2', 'Absen', 25, 'cost', '2025-01-23 20:41:52', '2025-02-01 19:12:15'),
(4, 'C3', 'Prestasi', 20, 'benefit', '2025-01-27 07:22:19', '2025-02-01 19:12:24'),
(5, 'C4', 'Kedisiplinan', 15, 'benefit', '2025-01-27 08:18:36', '2025-04-04 21:30:41'),
(6, 'C5', 'Sikap', 10, 'benefit', '2025-01-27 08:18:48', '2025-02-01 19:12:39');

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_080605_create_kelas_table', 1),
(3, '2025_01_10_043501_create_alternatif_table', 1),
(4, '2025_01_10_043744_create_kriteria_table', 1),
(5, '2025_01_10_043826_create_nilai_alternatif_table', 1),
(6, '2025_01_12_060305_create_sub_kriteria_table', 1);

-- --------------------------------------------------------

--
-- Table structure for table `nilai_alternatif`
--

CREATE TABLE `nilai_alternatif` (
  `id` bigint UNSIGNED NOT NULL,
  `alternatif_id` bigint UNSIGNED NOT NULL,
  `kriteria_id` bigint UNSIGNED NOT NULL,
  `nilai` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `nilai_alternatif`
--

INSERT INTO `nilai_alternatif` (`id`, `alternatif_id`, `kriteria_id`, `nilai`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 5, NULL, '2025-01-27 08:15:22'),
(2, 1, 3, 5, NULL, '2025-01-28 03:18:42'),
(3, 4, 1, 4, NULL, '2025-01-28 03:14:47'),
(4, 4, 3, 4, NULL, '2025-01-28 03:18:50'),
(5, 5, 1, 5, NULL, '2025-02-01 19:34:42'),
(6, 5, 3, 4, NULL, '2025-02-01 19:21:46'),
(7, 1, 4, 5, '2025-01-28 03:14:06', '2025-01-28 03:14:06'),
(8, 1, 5, 5, '2025-01-28 03:14:06', '2025-01-28 03:14:06'),
(9, 1, 6, 5, '2025-01-28 03:14:06', '2025-01-28 03:14:06'),
(10, 4, 4, 4, '2025-01-28 03:14:19', '2025-01-28 03:14:19'),
(11, 4, 5, 4, '2025-01-28 03:14:19', '2025-01-28 03:14:19'),
(12, 4, 6, 4, '2025-01-28 03:14:19', '2025-01-28 03:14:19'),
(13, 5, 4, 5, '2025-01-28 03:14:35', '2025-02-01 19:34:42'),
(14, 5, 5, 3, '2025-01-28 03:14:35', '2025-02-01 19:34:42'),
(15, 5, 6, 4, '2025-01-28 03:14:36', '2025-02-01 19:34:42'),
(16, 6, 1, 4, '2025-01-29 04:18:46', '2025-02-01 19:35:14'),
(17, 6, 3, 4, '2025-01-29 04:18:46', '2025-02-01 19:21:19'),
(18, 6, 4, 4, '2025-01-29 04:18:46', '2025-02-01 19:35:14'),
(19, 6, 5, 5, '2025-01-29 04:18:46', '2025-02-01 19:35:14'),
(20, 6, 6, 4, '2025-01-29 04:18:46', '2025-02-01 19:35:14'),
(21, 7, 1, 1, '2025-01-29 04:19:01', '2025-01-29 04:19:01'),
(22, 7, 3, 1, '2025-01-29 04:19:01', '2025-01-29 04:19:01'),
(23, 7, 4, 1, '2025-01-29 04:19:01', '2025-01-29 04:19:01'),
(24, 7, 5, 1, '2025-01-29 04:19:01', '2025-01-29 04:19:01'),
(25, 7, 6, 1, '2025-01-29 04:19:01', '2025-01-29 04:19:01'),
(26, 8, 1, 5, '2025-01-29 04:22:16', '2025-01-29 04:22:16'),
(27, 8, 3, 3, '2025-01-29 04:22:16', '2025-02-01 19:20:46'),
(28, 8, 4, 3, '2025-01-29 04:22:16', '2025-02-01 19:20:46'),
(29, 8, 5, 5, '2025-01-29 04:22:16', '2025-02-01 19:20:46'),
(30, 8, 6, 4, '2025-01-29 04:22:16', '2025-02-01 19:20:46'),
(31, 9, 1, 3, '2025-02-01 19:22:16', '2025-02-01 19:22:16'),
(32, 9, 3, 4, '2025-02-01 19:22:16', '2025-02-01 19:22:16'),
(33, 9, 4, 5, '2025-02-01 19:22:16', '2025-02-01 19:22:16'),
(34, 9, 5, 4, '2025-02-01 19:22:16', '2025-02-01 19:22:16'),
(35, 9, 6, 3, '2025-02-01 19:22:16', '2025-02-01 19:22:16'),
(36, 10, 1, 3, '2025-02-01 19:22:40', '2025-02-01 19:22:40'),
(37, 10, 3, 4, '2025-02-01 19:22:40', '2025-02-01 19:36:55'),
(38, 10, 4, 5, '2025-02-01 19:22:40', '2025-02-01 19:36:55'),
(39, 10, 5, 3, '2025-02-01 19:22:40', '2025-02-01 19:22:40'),
(40, 10, 6, 4, '2025-02-01 19:22:40', '2025-02-01 19:22:40'),
(41, 11, 1, 3, '2025-02-01 19:23:10', '2025-02-01 19:23:10'),
(42, 11, 3, 2, '2025-02-01 19:23:10', '2025-02-01 19:23:10'),
(43, 11, 4, 4, '2025-02-01 19:23:10', '2025-02-01 19:23:10'),
(44, 11, 5, 3, '2025-02-01 19:23:10', '2025-02-01 19:23:10'),
(45, 11, 6, 3, '2025-02-01 19:23:10', '2025-02-01 19:23:10'),
(46, 17, 1, 3, '2025-02-17 10:40:19', '2025-02-17 10:40:19'),
(47, 17, 3, 2, '2025-02-17 10:40:19', '2025-05-19 12:28:03'),
(48, 17, 4, 1, '2025-02-17 10:40:19', '2025-02-17 10:40:19'),
(49, 17, 5, 3, '2025-02-17 10:40:19', '2025-02-17 10:40:19'),
(50, 17, 6, 3, '2025-02-17 10:40:19', '2025-02-17 10:40:19'),
(51, 18, 1, 3, '2025-02-17 10:40:19', '2025-02-17 10:40:19'),
(52, 18, 3, 1, '2025-02-17 10:40:19', '2025-05-19 12:29:46'),
(53, 18, 4, 1, '2025-02-17 10:40:19', '2025-02-17 10:40:19'),
(54, 18, 5, 3, '2025-02-17 10:40:19', '2025-02-17 10:40:19'),
(55, 18, 6, 3, '2025-02-17 10:40:19', '2025-02-17 10:40:19'),
(56, 19, 1, 4, '2025-02-17 10:41:52', '2025-02-17 10:41:52'),
(57, 19, 3, 1, '2025-02-17 10:41:52', '2025-05-19 20:32:25'),
(58, 19, 4, 1, '2025-02-17 10:41:52', '2025-02-17 10:41:52'),
(59, 19, 5, 4, '2025-02-17 10:41:52', '2025-02-17 10:41:52'),
(60, 19, 6, 3, '2025-02-17 10:41:52', '2025-02-17 10:41:52'),
(221, 20, 1, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(222, 20, 3, 2, '2025-02-17 10:59:12', '2025-05-22 02:59:27'),
(223, 20, 4, 2, '2025-02-17 10:59:12', '2025-05-22 02:59:27'),
(224, 20, 5, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(225, 20, 6, 4, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(226, 21, 1, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(227, 21, 3, 2, '2025-02-17 10:59:12', '2025-05-19 20:32:59'),
(228, 21, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(229, 21, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(230, 21, 6, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(231, 22, 1, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(232, 22, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(233, 22, 4, 5, '2025-02-17 10:59:12', '2025-05-22 03:00:22'),
(234, 22, 5, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(235, 22, 6, 4, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(236, 23, 1, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(237, 23, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(238, 23, 4, 1, '2025-02-17 10:59:12', '2025-02-17 11:39:47'),
(239, 23, 5, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(240, 23, 6, 4, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(241, 24, 1, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(242, 24, 3, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(243, 24, 4, 1, '2025-02-17 10:59:12', '2025-02-17 11:30:11'),
(244, 24, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(245, 24, 6, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(246, 25, 1, 4, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(247, 25, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(248, 25, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(249, 25, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(250, 25, 6, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(251, 26, 1, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(252, 26, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(253, 26, 4, 3, '2025-02-17 10:59:12', '2025-05-22 03:01:11'),
(254, 26, 5, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(255, 26, 6, 4, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(256, 27, 1, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(257, 27, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(258, 27, 4, 2, '2025-02-17 10:59:12', '2025-05-22 03:01:56'),
(259, 27, 5, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(260, 27, 6, 4, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(261, 28, 1, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(262, 28, 3, 2, '2025-02-17 10:59:12', '2025-05-22 03:02:36'),
(263, 28, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(264, 28, 5, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(265, 28, 6, 4, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(266, 29, 1, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(267, 29, 3, 2, '2025-02-17 10:59:12', '2025-05-22 03:03:29'),
(268, 29, 4, 3, '2025-02-17 10:59:12', '2025-05-22 03:03:30'),
(269, 29, 5, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(270, 29, 6, 4, '2025-02-17 10:59:12', '2025-02-17 11:33:41'),
(271, 30, 1, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(272, 30, 3, 3, '2025-02-17 10:59:12', '2025-05-22 03:04:13'),
(273, 30, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(274, 30, 5, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(275, 30, 6, 4, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(276, 31, 1, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(277, 31, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(278, 31, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(279, 31, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(280, 31, 6, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(281, 32, 1, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(282, 32, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(283, 32, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(284, 32, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(285, 32, 6, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(286, 33, 1, 4, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(287, 33, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(288, 33, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(289, 33, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(290, 33, 6, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(291, 34, 1, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(292, 34, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(293, 34, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(294, 34, 5, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(295, 34, 6, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(296, 35, 1, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(297, 35, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(298, 35, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(299, 35, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(300, 35, 6, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(301, 36, 1, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(302, 36, 3, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(303, 36, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(304, 36, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(305, 36, 6, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(306, 37, 1, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(307, 37, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(308, 37, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(309, 37, 5, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(310, 37, 6, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(311, 38, 1, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(312, 38, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(313, 38, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(314, 38, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(315, 38, 6, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(316, 39, 1, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(317, 39, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(318, 39, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(319, 39, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(320, 39, 6, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(321, 40, 1, 4, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(322, 40, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(323, 40, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(324, 40, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(325, 40, 6, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(326, 41, 1, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(327, 41, 3, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(328, 41, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(329, 41, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(330, 41, 6, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(331, 42, 1, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(332, 42, 3, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(333, 42, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(334, 42, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(335, 42, 6, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(336, 43, 1, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(337, 43, 3, 2, '2025-02-17 10:59:12', '2025-05-21 03:47:35'),
(338, 43, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(339, 43, 5, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(340, 43, 6, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(341, 44, 1, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(342, 44, 3, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(343, 44, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(344, 44, 5, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(345, 44, 6, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(346, 45, 1, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(347, 45, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(348, 45, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(349, 45, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(350, 45, 6, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(351, 46, 1, 4, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(352, 46, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(353, 46, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(354, 46, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(355, 46, 6, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(356, 47, 1, 4, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(357, 47, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(358, 47, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(359, 47, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(360, 47, 6, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(361, 48, 1, 4, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(362, 48, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(363, 48, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(364, 48, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(365, 48, 6, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(366, 49, 1, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(367, 49, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(368, 49, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(369, 49, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(370, 49, 6, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(371, 50, 1, 4, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(372, 50, 3, 2, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(373, 50, 4, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(374, 50, 5, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(375, 50, 6, 3, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(376, 51, 1, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(377, 51, 3, 1, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(378, 51, 4, 4, '2025-02-17 10:59:12', '2025-05-22 03:08:49'),
(379, 51, 5, 5, '2025-02-17 10:59:12', '2025-02-17 10:59:12'),
(380, 51, 6, 4, '2025-02-17 10:59:12', '2025-02-17 11:40:43');

-- --------------------------------------------------------

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('GTwnmIuQwoC95mistpE6NSIoA3br3P2FmWVINyjF', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoib1h4NjJsdmxUbHB4V2k0elRjY0FEeTN1UjM4OEVpSEs2QnZFTHlvNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly9hcHAtc3BrLnRlc3Q6ODA4MC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6MzoidXJsIjthOjE6e3M6ODoiaW50ZW5kZWQiO3M6MjQ6Imh0dHA6Ly9hcHAtc3BrLnRlc3Q6ODA4MCI7fX0=', 1751689443);

-- --------------------------------------------------------

--
-- Table structure for table `sub_kriteria`
--

CREATE TABLE `sub_kriteria` (
  `id` bigint UNSIGNED NOT NULL,
  `kriteria_id` bigint UNSIGNED NOT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bobot` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sub_kriteria`
--

INSERT INTO `sub_kriteria` (`id`, `kriteria_id`, `nama`, `bobot`, `created_at`, `updated_at`) VALUES
(1, 1, '100 - 81', 5, NULL, '2025-01-27 08:12:08'),
(2, 1, '80 - 61', 4, '2025-01-24 20:28:13', '2025-01-27 08:12:26'),
(4, 3, 'Tidak Pernah Izin', 1, '2025-01-24 20:33:07', '2025-05-19 12:26:48'),
(5, 1, '60 - 41', 3, '2025-01-27 08:12:53', '2025-01-27 08:12:53'),
(6, 1, '40 - 21', 2, '2025-01-27 08:13:15', '2025-01-27 08:13:35'),
(7, 1, '20 - 0', 1, '2025-01-27 08:13:55', '2025-01-27 08:13:55'),
(8, 4, 'Tingkat Nasional', 5, '2025-01-28 03:09:39', '2025-01-28 03:09:39'),
(9, 4, 'Tingkat Provinsi', 4, '2025-01-28 03:10:04', '2025-01-28 03:10:04'),
(10, 4, 'Tingkat Kota', 3, '2025-01-28 03:10:25', '2025-01-28 03:10:25'),
(11, 4, 'Tingkat Sekolah', 2, '2025-01-28 03:10:47', '2025-01-28 03:10:47'),
(12, 4, 'Tidak', 1, '2025-01-28 03:10:55', '2025-01-28 03:10:55'),
(13, 5, 'Sangat Baik', 5, '2025-01-28 03:11:25', '2025-01-28 03:11:25'),
(14, 5, 'Baik', 4, '2025-01-28 03:11:37', '2025-01-28 03:11:37'),
(15, 5, 'Cukup', 3, '2025-01-28 03:11:46', '2025-01-28 03:11:46'),
(16, 5, 'Kurang', 2, '2025-01-28 03:11:55', '2025-01-28 03:11:55'),
(17, 5, 'Sangat Kurang', 1, '2025-01-28 03:12:04', '2025-01-28 03:12:04'),
(18, 6, 'Sangat Baik', 5, '2025-01-28 03:12:51', '2025-01-28 03:12:51'),
(19, 6, 'Baik', 4, '2025-01-28 03:13:01', '2025-01-28 03:13:01'),
(20, 6, 'Cukup', 3, '2025-01-28 03:13:09', '2025-01-28 03:13:09'),
(21, 6, 'Kurang', 2, '2025-01-28 03:13:17', '2025-01-28 03:13:17'),
(22, 6, 'Sangat Kurang', 1, '2025-01-28 03:13:26', '2025-01-28 03:13:26'),
(23, 3, 'Sakit < 3', 2, '2025-01-28 03:17:08', '2025-05-19 12:27:08'),
(24, 3, 'Izin < 4', 3, '2025-01-28 03:17:18', '2025-01-28 03:18:19'),
(25, 3, 'Alpa > 5', 4, '2025-01-28 03:17:46', '2025-05-19 12:27:15'),
(26, 3, 'Bolos > 5', 5, '2025-01-28 03:18:03', '2025-05-19 12:27:01');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `alternatif`
--
ALTER TABLE `alternatif`
  ADD PRIMARY KEY (`id`),
  ADD KEY `alternatif_kelas_id_foreign` (`kelas_id`);

--
-- Indexes for table `kelas`
--
ALTER TABLE `kelas`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kriteria`
--
ALTER TABLE `kriteria`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `nilai_alternatif`
--
ALTER TABLE `nilai_alternatif`
  ADD PRIMARY KEY (`id`),
  ADD KEY `nilai_alternatif_alternatif_id_foreign` (`alternatif_id`),
  ADD KEY `nilai_alternatif_kriteria_id_foreign` (`kriteria_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `sub_kriteria`
--
ALTER TABLE `sub_kriteria`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sub_kriteria_kriteria_id_foreign` (`kriteria_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `alternatif`
--
ALTER TABLE `alternatif`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75;

--
-- AUTO_INCREMENT for table `kelas`
--
ALTER TABLE `kelas`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `kriteria`
--
ALTER TABLE `kriteria`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `nilai_alternatif`
--
ALTER TABLE `nilai_alternatif`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=381;

--
-- AUTO_INCREMENT for table `sub_kriteria`
--
ALTER TABLE `sub_kriteria`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `alternatif`
--
ALTER TABLE `alternatif`
  ADD CONSTRAINT `alternatif_kelas_id_foreign` FOREIGN KEY (`kelas_id`) REFERENCES `kelas` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `nilai_alternatif`
--
ALTER TABLE `nilai_alternatif`
  ADD CONSTRAINT `nilai_alternatif_alternatif_id_foreign` FOREIGN KEY (`alternatif_id`) REFERENCES `alternatif` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `nilai_alternatif_kriteria_id_foreign` FOREIGN KEY (`kriteria_id`) REFERENCES `kriteria` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sub_kriteria`
--
ALTER TABLE `sub_kriteria`
  ADD CONSTRAINT `sub_kriteria_kriteria_id_foreign` FOREIGN KEY (`kriteria_id`) REFERENCES `kriteria` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

