-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: May 05, 2026 at 04:35 AM
-- Server version: 10.11.16-MariaDB-ubu2404
-- PHP Version: 8.4.20

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `edunesiaserver_siakad_staging`
--

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

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

CREATE TABLE `kelas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `mata_kuliah_id` bigint(20) UNSIGNED NOT NULL,
  `dosen_id` bigint(20) UNSIGNED NOT NULL,
  `dosen_id_lainnya` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `tahun_akademik_id` bigint(20) UNSIGNED NOT NULL,
  `kampus_id` bigint(20) UNSIGNED NOT NULL,
  `prodi_id` bigint(20) UNSIGNED DEFAULT NULL,
  `nama_kelas` varchar(255) NOT NULL,
  `semester` int(11) NOT NULL,
  `number_of_meetings` int(11) NOT NULL DEFAULT 16,
  `kapasitas` int(11) DEFAULT NULL,
  `tanggal_mulai_efektif` date DEFAULT NULL,
  `tanggal_akhir_efektif` date DEFAULT NULL,
  `lingkup` tinyint(4) DEFAULT NULL,
  `mode` char(1) DEFAULT NULL,
  `tipe_ajar` enum('solo','campuran') NOT NULL DEFAULT 'solo',
  `pembagian_ajar` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `mahasiswa_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Array of mahasiswa IDs dalam format JSON',
  `jadwal` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Jadwal pertemuan dalam format JSON',
  `modul` varchar(255) DEFAULT NULL,
  `rps` varchar(255) DEFAULT NULL,
  `bobot` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `bobot_diatur` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_validated` tinyint(1) DEFAULT 0,
  `validated_at` datetime DEFAULT NULL,
  `validated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `neofeeder_validated` tinyint(1) DEFAULT 0,
  `neofeeder_validated_at` datetime DEFAULT NULL,
  `neofeeder_validated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `neofeeder_status` enum('pending','validated','synced','error') DEFAULT 'pending',
  `neofeeder_error_message` text DEFAULT NULL,
  `neofeeder_synced_at` datetime DEFAULT NULL,
  `neofeeder_id` varchar(50) DEFAULT NULL
) ;

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

INSERT INTO `kelas` (`id`, `mata_kuliah_id`, `dosen_id`, `dosen_id_lainnya`, `tahun_akademik_id`, `kampus_id`, `prodi_id`, `nama_kelas`, `semester`, `number_of_meetings`, `kapasitas`, `tanggal_mulai_efektif`, `tanggal_akhir_efektif`, `lingkup`, `mode`, `tipe_ajar`, `pembagian_ajar`, `mahasiswa_ids`, `jadwal`, `modul`, `rps`, `bobot`, `bobot_diatur`, `created_at`, `updated_at`, `deleted_at`, `is_validated`, `validated_at`, `validated_by`, `neofeeder_validated`, `neofeeder_validated_at`, `neofeeder_validated_by`, `neofeeder_status`, `neofeeder_error_message`, `neofeeder_synced_at`, `neofeeder_id`) VALUES
(22, 62, 29, '[\"30\"]', 12, 57, 48, 'A', 1, 16, 2, '2026-02-10', '2026-02-12', 1, 'O', 'campuran', '[{\"id\": 1770113892601.2969, \"dosen_id\": \"29\", \"pembagian\": \"sebelum_uts\"}, {\"id\": 1770113894255.2085, \"dosen_id\": \"30\", \"pembagian\": \"sesudah_uts\"}]', '[]', NULL, NULL, NULL, '[{\"tipe\": \"Absensi\", \"persentase\": 10}, {\"tipe\": \"Tugas\", \"persentase\": 20}, {\"tipe\": \"UTS\", \"persentase\": 30}, {\"tipe\": \"UAS\", \"persentase\": 40}]', 1, '2026-02-03 00:04:33', '2026-02-09 20:19:30', NULL, 1, '2026-02-09 09:35:23', 135, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(23, 62, 29, '[\"30\"]', 12, 57, 48, 'A', 1, 16, 19, '2026-02-03', '2026-02-12', 1, 'O', 'campuran', '[{\"id\": 1770117855291, \"dosen_id\": \"29\", \"pembagian\": \"sebelum_uts\"}, {\"id\": 1770117857044, \"dosen_id\": \"30\", \"pembagian\": \"sesudah_uts\"}]', '[870019, 870023]', NULL, NULL, NULL, '[{\"tipe\": \"Absensi\", \"isDefault\": true, \"customTipe\": \"s\", \"persentase\": 10}, {\"tipe\": \"Tugas\", \"persentase\": 20}, {\"tipe\": \"UTS\", \"persentase\": 30}, {\"tipe\": \"UAS\", \"persentase\": 40}]', 1, '2026-02-03 04:27:54', '2026-02-09 20:21:25', NULL, 1, '2026-02-09 09:35:30', 135, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(24, 67, 31, '[]', 19, 68, 53, 'A', 1, 16, 3, '2026-02-05', '2026-02-21', 2, 'O', 'solo', '[]', '[870046]', '[{\"hari\": \"Senin\", \"ruangan\": null, \"jam_mulai\": \"08:00\", \"keterangan\": null, \"jam_selesai\": \"10:00\", \"link_meeting\": null, \"mode_pertemuan\": \"offline\"}]', NULL, NULL, '[{\"tipe\": \"Aktivitas Partisipatif\", \"persentase\": 10}, {\"tipe\": \"Quiz\", \"persentase\": 10}, {\"tipe\": \"Hasil Proyek\", \"persentase\": 10}, {\"tipe\": \"Tugas\", \"persentase\": 20}, {\"tipe\": \"Ujian Tengah Semester\", \"persentase\": 25}, {\"tipe\": \"Ujian Akhir Semester\", \"persentase\": 25}]', 0, '2026-02-04 21:41:18', '2026-02-13 07:58:30', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(25, 69, 0, '[]', 19, 68, 53, 'A', 1, 16, 2, '2026-02-05', '2026-02-28', 1, 'F', 'solo', '[]', '[870046]', '[{\"hari\": \"Senin\", \"ruangan\": \"R300\", \"jam_mulai\": \"12:00\", \"keterangan\": null, \"jam_selesai\": \"14:00\", \"link_meeting\": null, \"mode_pertemuan\": \"hybrid\"}]', NULL, NULL, '[{\"tipe\": \"Absensi\", \"persentase\": 10}, {\"tipe\": \"Tugas\", \"persentase\": 20}, {\"tipe\": \"UTS\", \"persentase\": 30}, {\"tipe\": \"UAS\", \"persentase\": 40}]', 0, '2026-02-04 21:43:09', '2026-02-09 23:15:39', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(26, 70, 31, '[]', 18, 68, 53, 'A', 2, 16, 3, '2026-02-05', '2026-02-28', 1, 'O', 'solo', '[]', '[870046]', NULL, NULL, 'rps_perkuliahan/MANAJEMENLANJUTAN_RPS_1770864553.pdf', '[{\"tipe\": \"Absensi\", \"persentase\": 10}, {\"tipe\": \"Tugas\", \"persentase\": 20}, {\"tipe\": \"UTS\", \"persentase\": 30}, {\"tipe\": \"UAS\", \"persentase\": 40}]', 0, '2026-02-04 21:44:26', '2026-02-12 02:49:13', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(27, 71, 33, '[]', 18, 68, 53, 'A', 2, 16, 2, '2026-02-05', '2026-02-28', 1, 'F', 'solo', '[]', '[870046]', NULL, NULL, NULL, '[{\"tipe\": \"Absensi\", \"persentase\": 10}, {\"tipe\": \"Tugas\", \"persentase\": 20}, {\"tipe\": \"UTS\", \"persentase\": 30}, {\"tipe\": \"UAS\", \"persentase\": 40}]', 0, '2026-02-04 21:45:13', '2026-02-09 20:53:56', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(28, 67, 31, '[]', 17, 68, 53, 'A', 1, 16, 4, '2026-02-06', '2026-02-28', 1, 'F', 'solo', '[]', '[]', NULL, NULL, NULL, '[{\"tipe\": \"Aktivitas Partisipatif\", \"persentase\": 10}, {\"tipe\": \"Tugas\", \"persentase\": 20}, {\"tipe\": \"Ujian Tengah Semester\", \"persentase\": 30}, {\"tipe\": \"Ujian Akhir Semester\", \"persentase\": 30}, {\"id\": 1770886394873.3362, \"tipe\": \"Quiz\", \"persentase\": 10}]', 1, '2026-02-04 21:47:56', '2026-02-12 08:53:31', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(29, 72, 31, '[]', 17, 68, 53, 'B', 3, 16, 6, '2026-02-10', '2026-02-28', 1, 'F', 'solo', '[]', '[]', '[{\"hari\": \"Senin\", \"ruangan\": null, \"jam_mulai\": \"08:00\", \"keterangan\": null, \"jam_selesai\": \"11:00\", \"link_meeting\": null, \"mode_pertemuan\": \"offline\"}]', NULL, NULL, '[{\"tipe\": \"Aktivitas Partisipatif\", \"persentase\": 10}, {\"tipe\": \"Quiz\", \"persentase\": 10}, {\"tipe\": \"Hasil Proyek\", \"persentase\": 10}, {\"tipe\": \"Tugas\", \"persentase\": 20}, {\"tipe\": \"Ujian Tengah Semester\", \"persentase\": 25}, {\"tipe\": \"Ujian Akhir Semester\", \"persentase\": 25}]', 0, '2026-02-04 21:49:06', '2026-02-12 09:22:55', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(30, 74, 35, '[]', 20, 67, 52, 'A', 1, 16, 2, '2026-02-05', '2026-02-28', 1, 'O', 'solo', '[]', '[]', NULL, NULL, NULL, '[{\"tipe\": \"Absensi\", \"persentase\": 10}, {\"tipe\": \"Tugas\", \"persentase\": 20}, {\"tipe\": \"UTS\", \"persentase\": 30}, {\"tipe\": \"UAS\", \"persentase\": 40}]', 0, '2026-02-05 02:54:05', '2026-02-05 02:54:05', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(31, 75, 34, '[]', 20, 67, 52, 'A', 1, 16, 2, '2026-02-05', '2026-02-28', 1, 'O', 'solo', '[]', '[]', NULL, NULL, NULL, '[{\"tipe\": \"Absensi\", \"persentase\": 10}, {\"tipe\": \"Tugas\", \"persentase\": 20}, {\"tipe\": \"UTS\", \"persentase\": 30}, {\"tipe\": \"UAS\", \"persentase\": 40}]', 0, '2026-02-05 02:56:08', '2026-02-05 02:56:08', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(32, 76, 36, '[]', 21, 67, 52, 'A', 2, 16, 2, '2026-02-05', '2026-02-28', 1, 'O', 'solo', '[]', '[]', NULL, NULL, NULL, '[{\"tipe\": \"Absensi\", \"persentase\": 10}, {\"tipe\": \"Tugas\", \"persentase\": 20}, {\"tipe\": \"UTS\", \"persentase\": 30}, {\"tipe\": \"UAS\", \"persentase\": 40}]', 0, '2026-02-05 02:56:55', '2026-02-05 02:56:55', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(33, 77, 35, '[]', 21, 67, 52, 'B', 2, 16, 4, '2026-02-05', '2026-02-28', 1, 'O', 'solo', '[]', '[]', NULL, NULL, NULL, '[{\"tipe\": \"Absensi\", \"persentase\": 10}, {\"tipe\": \"Tugas\", \"persentase\": 20}, {\"tipe\": \"UTS\", \"persentase\": 30}, {\"tipe\": \"UAS\", \"persentase\": 40}]', 0, '2026-02-05 02:58:04', '2026-02-05 02:58:04', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(34, 78, 34, '[]', 22, 67, 52, 'A', 3, 16, 2, '2026-02-05', '2026-02-28', 1, 'O', 'solo', '[]', '[]', NULL, NULL, NULL, '[{\"tipe\": \"Absensi\", \"persentase\": 10}, {\"tipe\": \"Tugas\", \"persentase\": 20}, {\"tipe\": \"UTS\", \"persentase\": 30}, {\"tipe\": \"UAS\", \"persentase\": 40}]', 0, '2026-02-05 02:58:50', '2026-02-05 02:58:50', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(35, 79, 35, '[\"36\"]', 22, 67, 52, 'A', 3, 16, 2, '2026-02-05', '2026-02-28', 1, 'O', 'campuran', '[{\"id\": 1770285562199, \"dosen_id\": \"35\", \"pembagian\": \"sebelum_uts\"}, {\"id\": 1770285564800, \"dosen_id\": \"36\", \"pembagian\": \"sesudah_uts\"}]', '[]', '[{\"hari\": \"Senin\", \"ruangan\": null, \"jam_mulai\": \"08:00\", \"keterangan\": null, \"jam_selesai\": \"10:00\", \"link_meeting\": null, \"mode_pertemuan\": \"offline\"}]', NULL, NULL, '[{\"tipe\": \"Absensi\", \"persentase\": 10}, {\"tipe\": \"Tugas\", \"persentase\": 20}, {\"tipe\": \"UTS\", \"persentase\": 30}, {\"tipe\": \"UAS\", \"persentase\": 20}, {\"id\": 1770785811609.5625, \"tipe\": \"Praktikum\", \"isDefault\": false, \"persentase\": 20}]', 1, '2026-02-05 02:59:59', '2026-02-10 21:57:11', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(38, 67, 31, '[]', 17, 68, 53, 'C', 1, 16, 22, '2026-02-12', '2026-02-21', 1, 'O', 'solo', '[]', '[]', NULL, NULL, NULL, '[{\"tipe\": \"Aktivitas Partisipatif\", \"persentase\": 10}, {\"tipe\": \"Quiz\", \"persentase\": 10}, {\"tipe\": \"Hasil Proyek\", \"persentase\": 10}, {\"tipe\": \"Tugas\", \"persentase\": 20}, {\"tipe\": \"Ujian Tengah Semester\", \"persentase\": 25}, {\"tipe\": \"Ujian Akhir Semester\", \"persentase\": 20}, {\"id\": 1770889687648.8118, \"tipe\": \"Praktikum\", \"persentase\": 5}]', 1, '2026-02-12 09:48:59', '2026-02-12 09:48:59', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(39, 80, 37, '[]', 23, 69, 57, 'NFD09', 1, 16, 40, '2026-02-14', '2026-02-27', 1, 'F', 'solo', '[]', '[870075]', NULL, NULL, NULL, '[{\"tipe\": \"Aktivitas Partisipatif\", \"persentase\": 10}, {\"tipe\": \"Quiz\", \"persentase\": 10}, {\"tipe\": \"Hasil Proyek\", \"persentase\": 10}, {\"tipe\": \"Tugas\", \"persentase\": 20}, {\"tipe\": \"Ujian Tengah Semester\", \"persentase\": 25}, {\"tipe\": \"Ujian Akhir Semester\", \"persentase\": 25}]', 0, '2026-02-14 08:53:15', '2026-02-23 07:31:02', NULL, 1, '2026-02-14 16:57:06', 318, 1, '2026-02-14 16:57:10', 318, 'error', 'Gagal autentikasi ke Neofeeder', NULL, 'b3130c2a-c9e3-49fe-a112-e51954851a57'),
(43, 70, 31, '[]', 17, 68, 53, 'A', 2, 16, NULL, NULL, NULL, NULL, NULL, 'solo', '[]', '[]', NULL, NULL, NULL, '[{\"tipe\":\"Aktivitas Partisipatif\",\"persentase\":10},{\"tipe\":\"Quiz\",\"persentase\":10},{\"tipe\":\"Hasil Proyek\",\"persentase\":10},{\"tipe\":\"Tugas\",\"persentase\":20},{\"tipe\":\"Ujian Tengah Semester\",\"persentase\":25},{\"tipe\":\"Ujian Akhir Semester\",\"persentase\":25}]', 0, '2026-03-11 10:14:53', '2026-03-11 10:14:53', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(53, 139, 39, NULL, 29, 70, 58, 'AUTO-BD. 101-S1-TA29', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(54, 140, 39, NULL, 29, 70, 58, 'AUTO-BD. 102-S1-TA29', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(55, 141, 39, NULL, 29, 70, 58, 'AUTO-BD. 201-S1-TA29', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(56, 142, 39, NULL, 29, 70, 58, 'AUTO-BD. 203-S1-TA29', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(57, 143, 39, NULL, 29, 70, 58, 'AUTO-BD. 401-S1-TA29', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(58, 144, 39, NULL, 29, 70, 58, 'AUTO-BD. 501-S1-TA29', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(59, 145, 39, NULL, 29, 70, 58, 'AUTO-BD. 103-S1-TA29', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(60, 146, 39, NULL, 29, 70, 58, 'AUTO-BD. 202-S2-TA29', 2, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(61, 147, 39, NULL, 29, 70, 58, 'AUTO-BD. 204-S2-TA29', 2, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(62, 148, 39, NULL, 29, 70, 58, 'AUTO-BD. 301-S2-TA29', 2, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(63, 149, 39, NULL, 29, 70, 58, 'AUTO-BD. 402-S2-TA29', 2, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(64, 150, 39, NULL, 29, 70, 58, 'AUTO-BD. 403-S2-TA29', 2, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(65, 151, 39, NULL, 29, 70, 58, 'AUTO-AIHC 1402-S2-TA29', 2, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(66, 152, 39, NULL, 29, 70, 58, 'AUTO-AIHC 1403-S2-TA29', 2, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(67, 153, 39, NULL, 29, 70, 58, 'AUTO-BD. 302-S3-TA29', 3, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(68, 154, 39, NULL, 29, 70, 58, 'AUTO-BD. 303-S3-TA29', 3, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(69, 155, 39, NULL, 29, 70, 58, 'AUTO-BD. 304-S3-TA29', 3, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(70, 156, 39, NULL, 29, 70, 58, 'AUTO-BD. 205-S3-TA29', 3, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(71, 157, 39, NULL, 29, 70, 58, 'AUTO-BD. 307-S3-TA29', 3, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(72, 158, 39, NULL, 29, 70, 58, 'AUTO-BD. 305-S4-TA29', 4, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(73, 159, 39, NULL, 29, 70, 58, 'AUTO-BD. 306-S4-TA29', 4, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(74, 160, 39, NULL, 29, 70, 58, 'AUTO-BD. 308-S4-TA29', 4, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(75, 161, 39, NULL, 29, 70, 58, 'AUTO-AIHC 1404-S4-TA29', 4, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(76, 162, 39, NULL, 29, 70, 58, 'AUTO-AIHC 1405-S4-TA29', 4, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(77, 163, 39, NULL, 29, 70, 58, 'AUTO-BD. 404-S5-TA29', 5, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(78, 164, 39, NULL, 29, 70, 58, 'AUTO-AIHC 140-S5-TA29', 5, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(79, 165, 39, NULL, 29, 70, 58, 'AUTO-BD. 502-S5-TA29', 5, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(80, 166, 39, NULL, 29, 70, 58, 'AUTO-AIHC 1406-S5-TA29', 5, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(81, 167, 39, NULL, 29, 70, 58, 'AUTO-AIHC 1407-S5-TA29', 5, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(82, 168, 39, NULL, 29, 70, 58, 'AUTO-AIHC 1408-S5-TA29', 5, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870165,870166,870167,870168,870169,870170,870171,870172,870173,870174,870175,870176,870177,870178,870179,870180,870181,870182]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(83, 103, 39, NULL, 28, 70, 58, 'AUTO-BDU. 101-S1-TA28', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870138,870139,870140,870141,870142,870143,870144,870145,870146,870147,870148,870149,870150,870151,870152,870153,870154,870155,870156,870157,870158,870159,870160,870161,870162,870163,870164]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(84, 106, 39, NULL, 28, 70, 58, 'AUTO-BDP. 101-S1-TA28', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870138,870139,870140,870141,870142,870143,870144,870145,870146,870147,870148,870149,870150,870151,870152,870153,870154,870155,870156,870157,870158,870159,870160,870161,870162,870163,870164]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(85, 107, 39, NULL, 28, 70, 58, 'AUTO-BDP. 102-S1-TA28', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870138,870139,870140,870141,870142,870143,870144,870145,870146,870147,870148,870149,870150,870151,870152,870153,870154,870155,870156,870157,870158,870159,870160,870161,870162,870163,870164]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(86, 108, 39, NULL, 28, 70, 58, 'AUTO-BDP. 103-S1-TA28', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870138,870139,870140,870141,870142,870143,870144,870145,870146,870147,870148,870149,870150,870151,870152,870153,870154,870155,870156,870157,870158,870159,870160,870161,870162,870163,870164]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(87, 109, 39, NULL, 28, 70, 58, 'AUTO-BDP. 104-S1-TA28', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870138,870139,870140,870141,870142,870143,870144,870145,870146,870147,870148,870149,870150,870151,870152,870153,870154,870155,870156,870157,870158,870159,870160,870161,870162,870163,870164]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(88, 110, 39, NULL, 28, 70, 58, 'AUTO-BDM. 101-S1-TA28', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870138,870139,870140,870141,870142,870143,870144,870145,870146,870147,870148,870149,870150,870151,870152,870153,870154,870155,870156,870157,870158,870159,870160,870161,870162,870163,870164]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(89, 111, 39, NULL, 28, 70, 58, 'AUTO-BDU. 102-S1-TA28', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870138,870139,870140,870141,870142,870143,870144,870145,870146,870147,870148,870149,870150,870151,870152,870153,870154,870155,870156,870157,870158,870159,870160,870161,870162,870163,870164]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(90, 112, 39, NULL, 28, 70, 58, 'AUTO-BDM.102-S1-TA28', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870138,870139,870140,870141,870142,870143,870144,870145,870146,870147,870148,870149,870150,870151,870152,870153,870154,870155,870156,870157,870158,870159,870160,870161,870162,870163,870164]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(91, 103, 39, NULL, 26, 70, 58, 'AUTO-BDU. 101-S1-TA26', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(92, 106, 39, NULL, 26, 70, 58, 'AUTO-BDP. 101-S1-TA26', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(93, 107, 39, NULL, 26, 70, 58, 'AUTO-BDP. 102-S1-TA26', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(94, 108, 39, NULL, 26, 70, 58, 'AUTO-BDP. 103-S1-TA26', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(95, 109, 39, NULL, 26, 70, 58, 'AUTO-BDP. 104-S1-TA26', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(96, 110, 39, NULL, 26, 70, 58, 'AUTO-BDM. 101-S1-TA26', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(97, 111, 39, NULL, 26, 70, 58, 'AUTO-BDU. 102-S1-TA26', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(98, 112, 39, NULL, 26, 70, 58, 'AUTO-BDM.102-S1-TA26', 1, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(99, 113, 39, NULL, 26, 70, 58, 'AUTO-BDU. 201-S2-TA26', 2, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(100, 114, 39, NULL, 26, 70, 58, 'AUTO-BDM. 201-S2-TA26', 2, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(101, 115, 39, NULL, 26, 70, 58, 'AUTO-BDP. 201-S2-TA26', 2, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(102, 116, 39, NULL, 26, 70, 58, 'AUTO-BDP. 202-S2-TA26', 2, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(103, 117, 39, NULL, 26, 70, 58, 'AUTO-BDP. 203-S2-TA26', 2, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(104, 118, 39, NULL, 26, 70, 58, 'AUTO-BDM. 202-S2-TA26', 2, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(105, 119, 39, NULL, 26, 70, 58, 'AUTO-BDP. 204-S2-TA26', 2, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(106, 120, 39, NULL, 26, 70, 58, 'AUTO-BDP. 205-S2-TA26', 2, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(107, 121, 39, NULL, 26, 70, 58, 'AUTO-BDP. 301-S3-TA26', 3, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(108, 122, 39, NULL, 26, 70, 58, 'AUTO-BDP. 302-S3-TA26', 3, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(109, 123, 39, NULL, 26, 70, 58, 'AUTO-BDP. 303-S3-TA26', 3, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(110, 124, 39, NULL, 26, 70, 58, 'AUTO-BDP. 304-S3-TA26', 3, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(111, 125, 39, NULL, 26, 70, 58, 'AUTO-BDP. 305-S3-TA26', 3, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL),
(112, 126, 39, NULL, 26, 70, 58, 'AUTO-BDU. 306-S3-TA26', 3, 16, NULL, NULL, NULL, NULL, NULL, 'solo', NULL, '[870100,870101,870102,870103,870104,870105,870106,870107,870108,870109,870110,870111,870112,870113,870114,870115,870116,870118,870119,870120,870122,870123,870125,870127,870128,870130,870131,870132,870133,870134]', NULL, NULL, NULL, NULL, 0, '2026-03-12 03:40:19', '2026-03-12 03:40:19', NULL, 0, NULL, NULL, 0, NULL, NULL, 'pending', NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `kelas`
--
ALTER TABLE `kelas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `kelas_mata_kuliah_id_foreign` (`mata_kuliah_id`),
  ADD KEY `kelas_dosen_id_foreign` (`dosen_id`),
  ADD KEY `fk_kelas_validated_by` (`validated_by`),
  ADD KEY `fk_kelas_neofeeder_validated_by` (`neofeeder_validated_by`),
  ADD KEY `idx_kelas_is_validated` (`is_validated`),
  ADD KEY `idx_kelas_neofeeder_status` (`neofeeder_status`),
  ADD KEY `idx_kelas_neofeeder_id` (`neofeeder_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `kelas`
--
ALTER TABLE `kelas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `kelas`
--
ALTER TABLE `kelas`
  ADD CONSTRAINT `fk_kelas_neofeeder_validated_by` FOREIGN KEY (`neofeeder_validated_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `fk_kelas_validated_by` FOREIGN KEY (`validated_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `kelas_mata_kuliah_id_foreign` FOREIGN KEY (`mata_kuliah_id`) REFERENCES `mata_kuliah` (`id`) ON DELETE CASCADE;
COMMIT;

/*!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 */;
