--
-- Host: localhost    Database: spp_single
-- ------------------------------------------------------


--
-- Current Database: `spp_single`
--

/*!40000 DROP DATABASE IF EXISTS `spp_single`*/;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `spp_single` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;

USE `spp_single`;

--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `school_id` bigint(20) unsigned DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `user_nama` varchar(255) DEFAULT NULL,
  `aksi` varchar(255) NOT NULL,
  `objek` varchar(255) NOT NULL,
  `deskripsi` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_logs_school_id_index` (`school_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_logs`
--

INSERT INTO `activity_logs` VALUES (1,1,1,'Administrator','dibuat','Siswa','Uji Runtime (9001)','2026-07-09 10:10:33','2026-07-09 10:10:33');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_batches`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


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

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2026_01_01_000010_create_schools_table',1),(5,'2026_01_01_000020_create_students_table',1),(6,'2026_01_01_000030_create_payments_table',1),(7,'2026_01_01_000040_create_payment_items_table',1),(8,'2026_01_01_000070_add_wa_sekolah_to_schools',1),(9,'2026_01_01_000080_add_qris_and_payment_confirmations',1),(10,'2026_01_01_000090_create_activity_logs_table',1);

--
-- Table structure for table `payment_confirmations`
--

CREATE TABLE `payment_confirmations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `school_id` bigint(20) unsigned NOT NULL,
  `student_id` bigint(20) unsigned NOT NULL,
  `nama_pengirim` varchar(255) NOT NULL,
  `jumlah` bigint(20) unsigned NOT NULL,
  `metode` varchar(255) NOT NULL DEFAULT 'qris',
  `bukti` varchar(255) DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `catatan_admin` text DEFAULT NULL,
  `handled_by` bigint(20) unsigned DEFAULT NULL,
  `handled_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payment_confirmations_school_id_index` (`school_id`),
  KEY `payment_confirmations_student_id_index` (`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_confirmations`
--


--
-- Table structure for table `payment_items`
--

CREATE TABLE `payment_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `school_id` bigint(20) unsigned NOT NULL,
  `payment_id` bigint(20) unsigned NOT NULL,
  `jenis` varchar(255) NOT NULL,
  `bulan` varchar(255) DEFAULT NULL,
  `slot` tinyint(3) unsigned DEFAULT NULL,
  `nama_jenis` varchar(255) NOT NULL,
  `jumlah` bigint(20) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payment_items_school_id_foreign` (`school_id`),
  KEY `payment_items_payment_id_foreign` (`payment_id`),
  KEY `payment_items_jenis_bulan_index` (`jenis`,`bulan`),
  KEY `payment_items_slot_index` (`slot`),
  CONSTRAINT `payment_items_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `payment_items_school_id_foreign` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_items`
--

INSERT INTO `payment_items` VALUES (1,1,1,'spp','Juli',NULL,'SPP Juli',150000,'2026-07-09 10:07:03','2026-07-09 10:07:03'),(2,1,1,'spp','Agustus',NULL,'SPP Agustus',150000,'2026-07-09 10:07:03','2026-07-09 10:07:03'),(3,1,1,'tunggakan',NULL,NULL,'Angsuran Tunggakan',50000,'2026-07-09 10:07:03','2026-07-09 10:07:03');

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `school_id` bigint(20) unsigned NOT NULL,
  `no_transaksi` varchar(255) NOT NULL,
  `student_id` bigint(20) unsigned NOT NULL,
  `tanggal` date NOT NULL,
  `tahun_pelajaran` varchar(255) DEFAULT NULL,
  `total` bigint(20) NOT NULL DEFAULT 0,
  `bendahara` varchar(255) DEFAULT NULL,
  `catatan` varchar(255) DEFAULT NULL,
  `petugas` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payments_school_id_no_transaksi_unique` (`school_id`,`no_transaksi`),
  KEY `payments_student_id_foreign` (`student_id`),
  CONSTRAINT `payments_school_id_foreign` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE CASCADE,
  CONSTRAINT `payments_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` VALUES (1,1,'TRX-20260701-0001',1,'2026-07-01','2025/2026',350000,'Siti Aminah, S.Pd',NULL,'admin','2026-07-09 10:07:03','2026-07-09 10:07:03');

--
-- Table structure for table `schools`
--

CREATE TABLE `schools` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) DEFAULT NULL,
  `nama_sekolah` varchar(255) NOT NULL,
  `alamat` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `telepon` varchar(255) DEFAULT NULL,
  `wa_sekolah` varchar(255) DEFAULT NULL,
  `kota` varchar(255) DEFAULT NULL,
  `tahun_pelajaran` varchar(255) NOT NULL DEFAULT '2025/2026',
  `logo` varchar(255) DEFAULT NULL,
  `qris` varchar(255) DEFAULT NULL,
  `bank_bayar` varchar(255) DEFAULT NULL,
  `norek_bayar` varchar(255) DEFAULT NULL,
  `atasnama_bayar` varchar(255) DEFAULT NULL,
  `bendahara` varchar(255) DEFAULT NULL,
  `nip_bendahara` varchar(255) DEFAULT NULL,
  `tarif_spp` bigint(20) unsigned NOT NULL DEFAULT 0,
  `lainnya1_nama` varchar(255) NOT NULL DEFAULT 'Uang Gedung',
  `lainnya2_nama` varchar(255) NOT NULL DEFAULT 'Uang Kegiatan',
  `lainnya3_nama` varchar(255) NOT NULL DEFAULT 'Seragam',
  `lainnya4_nama` varchar(255) NOT NULL DEFAULT 'Buku Paket',
  `lainnya5_nama` varchar(255) NOT NULL DEFAULT 'Uang Ujian',
  `lainnya6_nama` varchar(255) NOT NULL DEFAULT 'Study Tour',
  `lainnya1_tarif` bigint(20) unsigned NOT NULL DEFAULT 0,
  `lainnya2_tarif` bigint(20) unsigned NOT NULL DEFAULT 0,
  `lainnya3_tarif` bigint(20) unsigned NOT NULL DEFAULT 0,
  `lainnya4_tarif` bigint(20) unsigned NOT NULL DEFAULT 0,
  `lainnya5_tarif` bigint(20) unsigned NOT NULL DEFAULT 0,
  `lainnya6_tarif` bigint(20) unsigned NOT NULL DEFAULT 0,
  `wa_template` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `schools`
--

INSERT INTO `schools` VALUES (1,'sekolah','SMP TUNAS BANGSA','Jl. Pendidikan No. 120, Jakarta','info@tunasbangsa.sch.id','021-1234567','6281234500001','Jakarta','2025/2026',NULL,NULL,NULL,NULL,NULL,'Siti Aminah, S.Pd','19850101 200901 2 001',150000,'Uang Gedung','Uang Kegiatan','Seragam','Buku Paket','Uang Ujian','Study Tour',1500000,500000,750000,600000,300000,850000,'Yth. Orang Tua/Wali dari *{nama}* (Kelas {kelas}),\n\nKami informasikan tagihan pembayaran di *{sekolah}*:\n{rincian}\n\nTotal tunggakan: *{total}*\n\nMohon dapat segera diselesaikan. Terima kasih.','2026-07-09 10:07:03','2026-07-09 10:07:03');

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

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `sessions` VALUES ('3BUHqBx5CDGJTQBQDa9r35KSAj8Afxhe4fVQuAvn',NULL,'127.0.0.1','curl/8.6.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZFVucU1wclZsVVpJSDYwYVpkdDNUcktKcEVhcVJ1Z1d6R2tLUU96aCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjg6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9wb3J0YWwiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1783591752),('4A95eDFJzAEYndWaYc7Or6Agz4gvjiJhGjKmBXm9',1,'127.0.0.1','curl/8.6.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiamJpVFUwS0p0eFozNENwcnJvUjh4NDNiVVA4cXlYNlJSWkpmRjl0TyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9rYXJ0dS8xIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9',1783591729),('8zMsD7t7DGN6UgZ2N9B6JKdzajsMktsJqJmteuNJ',NULL,'127.0.0.1','curl/8.6.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiOWt4NGVxYVdpMGFIN1Boem0wUFAxa0RIeUdmR0JFYXlRRWh5RXlMSSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1783591647),('a5mF5E09BCNUSYIIFNMrU6YIaQCE9ZPwncbUWjTD',NULL,'127.0.0.1','curl/8.6.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMDhscTVTdnBRUkduWk1qT0dQVU9tdVN1akJ2UHdhbHR1SkJFQ3FEMSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1783591645),('ATCOjKK5yVAxdyGi8AQD8cUZlHpT0FoUjI88jprk',2,'127.0.0.1','curl/8.6.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoidG1RUkl5MGVxemhEMTVsWTJBVENxZlFUR0dDU05LUU51dUkxZTRUNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9kYXNoYm9hcmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToyO30=',1783591755),('Cpsg4clPoou3znLt6uh6LdUFEmE2a7YqzRugbi88',NULL,'127.0.0.1','curl/8.6.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiR283NFNnSDh6ekczMUVGaEc3Rkg4enhyYzZNMUtTdldzYU4wUXdkdSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC92ZXJpZmlrYXNpLzEiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1783591753),('fht2MoVJL1BMtRYBDvWiFTvUPDT3PSVk0V0iTNMp',NULL,'127.0.0.1','curl/8.6.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiaDlCWm82Y3NuYUZwWkpPWE9oTmtYZHJRSVhyRnJjSTFYTk9KWjExSyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjg6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9wb3J0YWwiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1783591646),('mfCo95RZMtvLcb1sXn3QSeCBftfV2lZyvAABzVz4',1,'127.0.0.1','curl/8.6.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoieEhvM25sUWJacDAzQWpDTWZVNVZ5RTFnb1Zqd0VBZ05OQnRQOW5PTyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDc6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9wZW1iYXlhcmFuL2JhY2t1cC1sZW5na2FwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9',1783591754),('MIzAirxJCIj1LxMBnJaToLjXirIvq5IuXAi01eM2',NULL,'127.0.0.1','curl/8.6.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZVlVM1Yya3J0eVhhbDhuYWgyOGt5SkRNOXVvRzFVRE9GMnVwV2ZENyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1783591646),('qu4nriujCKycSMwgZoqZOjy2tUnxydApqxyn4Iwb',NULL,'127.0.0.1','curl/8.6.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiQ0Y5d2lsMlRjbmt0T0NneERleFBzUGQ0WUp1cmFnRFhNMFZXbUZuNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1783591722),('wPqM80gmtSMfz4ZB75vA8wBEzqcOuAZLlBwW78mF',1,'127.0.0.1','curl/8.6.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiOFdFeER4MG5XanNLc09xdHEzaTBtakhWS0VYS1VWbUdPZktkRkxzQiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9sb2ctYWt0aXZpdGFzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9',1783591834);

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `school_id` bigint(20) unsigned NOT NULL,
  `no_induk` varchar(255) NOT NULL,
  `nama` varchar(255) NOT NULL,
  `kelas` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `tunggakan_awal` bigint(20) unsigned NOT NULL DEFAULT 0,
  `wa_ortu` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `students_school_id_no_induk_unique` (`school_id`,`no_induk`),
  CONSTRAINT `students_school_id_foreign` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `students`
--

INSERT INTO `students` VALUES (1,1,'2025001','Andi Pratama','7A','Umum',300000,'6281234567001','2026-07-09 10:07:03','2026-07-09 10:07:03'),(2,1,'2025002','Bella Safitri','7A','Umum',0,'6281234567002','2026-07-09 10:07:03','2026-07-09 10:07:03'),(3,1,'2025003','Citra Dewi','7B','Yayasan',150000,'6281234567003','2026-07-09 10:07:03','2026-07-09 10:07:03'),(4,1,'2025004','Dimas Anggara','8A','Umum',0,'6281234567004','2026-07-09 10:07:03','2026-07-09 10:07:03'),(5,1,'2025005','Eka Putri','8B','Beasiswa',0,'6281234567005','2026-07-09 10:07:03','2026-07-09 10:07:03'),(6,1,'2025006','Fajar Nugroho','9A','Umum',450000,'6281234567006','2026-07-09 10:07:03','2026-07-09 10:07:03');


