-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             11.3.0.6295
-- --------------------------------------------------------



-- Dumping database structure for sman4_db_spmb
CREATE DATABASE IF NOT EXISTS `sman4_db_spmb` /*!40100 DEFAULT CHARACTER SET armscii8 COLLATE armscii8_bin */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `sman4_db_spmb`;

-- Dumping structure for table sman4_db_spmb.daftar_smp
CREATE TABLE IF NOT EXISTS `daftar_smp` (
  `id` int NOT NULL,
  `nama` varchar(255) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '',
  `status` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=armscii8 COLLATE=armscii8_bin;

-- Dumping data for table sman4_db_spmb.daftar_smp: ~86 rows (approximately)
INSERT INTO `daftar_smp` (`id`, `nama`, `status`) VALUES
	(1, 'PKBM ANGGREK', 1),
	(2, 'PKBM BUNGA HARAPAN', 1),
	(3, 'PKBM CAHAYA PELITA', 1),
	(4, 'PKBM GUNUNG SARI', 1),
	(5, 'PKBM NURUL ILMI LAHAT', 1),
	(6, 'PKBM NUSANTARA', 1),
	(7, 'PKBM SEROJA', 1),
	(8, 'PKBM TEMBELING SAKTI', 1),
	(9, 'SKB KABUPATEN LAHAT', 1),
	(10, 'SMP ARIEF BUDIMAN LAHAT', 1),
	(11, 'SMP EMIRATES ISLAMIC SCHOOL', 1),
	(12, 'SMP ISLAM TERPADU AL-KAUTSAR LAHAT', 1),
	(13, 'SMP ISLAM TERPADU IKHLAS CENDEKIA LAHAT', 1),
	(14, 'SMP IT DARUSSALAM KIKIM BARAT', 1),
	(15, 'SMP IT INSAN RABBANI KABUPATEN LAHAT', 1),
	(16, 'SMP KARTIKA II-3 LAHAT', 1),
	(17, 'SMP MUHAMMADIYAH 26 JARAI', 1),
	(18, 'SMP MUHAMMADIYAH BATU RANCING TANJUNG SAKTI PUMU', 1),
	(19, 'SMP MUHAMMADIYAH LAHAT', 1),
	(20, 'SMP PURNAMASARI KIKIM BARAT', 1),
	(21, 'SMP SANTO YOSEF LAHAT', 1),
	(22, 'SMP SP II PGRI', 1),
	(23, 'SMP TUNAS BANGSA', 1),
	(24, 'SMP TUNAS NUSA LAHAT', 1),
	(25, 'SMP XAVERIUS TANJUNG SAKTI PUMI', 1),
	(26, 'SMPN 1 GUMAY TALANG', 1),
	(27, 'SMPN 1 GUMAY ULU', 1),
	(28, 'SMPN 1 JARAI', 1),
	(29, 'SMPN 1 KIKIM BARAT', 1),
	(30, 'SMPN 1 KIKIM SELATAN', 1),
	(31, 'SMPN 1 KIKIM TENGAH', 1),
	(32, 'SMPN 1 KIKIM TIMUR', 1),
	(33, 'SMPN 1 KOTA AGUNG', 1),
	(34, 'SMPN 1 LAHAT', 1),
	(35, 'SMPN 1 LAHAT SELATAN', 1),
	(36, 'SMPN 1 MERAPI BARAT', 1),
	(37, 'SMPN 1 MERAPI SELATAN', 1),
	(38, 'SMPN 1 MERAPI TIMUR', 1),
	(39, 'SMPN 1 MUARA PAYANG', 1),
	(40, 'SMPN 1 MULAK SEBINGKAI', 1),
	(41, 'SMPN 1 MULAK ULU', 1),
	(42, 'SMPN 1 PAGAR GUNUNG', 1),
	(43, 'SMPN 1 PAJAR BULAN', 1),
	(44, 'SMPN 1 PSEKSU', 1),
	(45, 'SMPN 1 PULAU PINANG', 1),
	(46, 'SMPN 1 SUKA MERINDU', 1),
	(47, 'SMPN 1 TANJUNG SAKTI PUMI', 1),
	(48, 'SMPN 1 TANJUNG SAKTI PUMU', 1),
	(49, 'SMPN 1 TANJUNG TEBAT', 1),
	(50, 'SMPN 2 GUMAY ULU', 1),
	(51, 'SMPN 2 KIKIM BARAT', 1),
	(52, 'SMPN 2 KIKIM SELATAN', 1),
	(53, 'SMPN 2 KIKIM TENGAH', 1),
	(54, 'SMPN 2 KIKIM TIMUR', 1),
	(55, 'SMPN 2 KOTA AGUNG', 1),
	(56, 'SMPN 2 LAHAT', 1),
	(57, 'SMPN 2 LAHAT SELATAN', 1),
	(58, 'SMPN 2 MERAPI BARAT', 1),
	(59, 'SMPN 2 MERAPI TIMUR', 1),
	(60, 'SMPN 2 MULAK SEBINGKAI', 1),
	(61, 'SMPN 2 MULAK ULU', 1),
	(62, 'SMPN 2 PAGAR GUNUNG', 1),
	(63, 'SMPN 2 PSEKSU', 1),
	(64, 'SMPN 2 TANJUNG SAKTI PUMI', 1),
	(65, 'SMPN 2 TANJUNG SAKTI PUMU', 1),
	(66, 'SMPN 2 TANJUNG TEBAT', 1),
	(67, 'SMPN 3 KIKIM BARAT', 1),
	(68, 'SMPN 3 KIKIM SELATAN', 1),
	(69, 'SMPN 3 KIKIM TIMUR', 1),
	(70, 'SMPN 3 KOTA AGUNG', 1),
	(71, 'SMPN 3 LAHAT', 1),
	(72, 'SMPN 3 MERAPI BARAT', 1),
	(73, 'SMPN 3 PSEKSU', 1),
	(74, 'SMPN 3 TANJUNG SAKTI PUMI', 1),
	(75, 'SMPN 4 KIKIM SELATAN', 1),
	(76, 'SMPN 4 KIKIM TIMUR', 1),
	(77, 'SMPN 4 KOTA AGUNG', 1),
	(78, 'SMPN 4 LAHAT', 1),
	(79, 'SMPN 4 TANJUNG SAKTI PUMI', 1),
	(80, 'SMPN 5 KIKIM TIMUR', 1),
	(81, 'SMPN 5 LAHAT', 1),
	(82, 'SMPN 6 LAHAT', 1),
	(83, 'SMPN 6 SATU ATAP KIKIM TIMUR', 1),
	(84, 'SMPN 7 LAHAT', 1),
	(85, 'SMPN 8 LAHAT', 1),
	(86, 'SMPN 9 LAHAT', 1);

-- Dumping structure for table sman4_db_spmb.frontends
CREATE TABLE IF NOT EXISTS `frontends` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `nama_sekolah` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun_ajaran` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `akreditasi_sekolah` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat_sekolah` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jumlah_jalur_prestasi` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jumlah_jalur_nonprestasi` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no_hp_sekolah` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_kepala_sekolah` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_ketua_panitia` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_jurusan` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url_logo` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url_image1` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url_image2` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url_image3` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url_image4` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `judul_image1` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `judul_image2` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `judul_image3` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `judul_image4` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deskripsi_image1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deskripsi_image2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deskripsi_image3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deskripsi_image4` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `informasi_penting` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `cara_mendaftar` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `tentang_aplikasi` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `tahap` varchar(1) COLLATE utf8mb4_unicode_ci 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 sman4_db_spmb.frontends: ~1 rows (approximately)
INSERT INTO `frontends` (`id`, `nama_sekolah`, `tahun_ajaran`, `akreditasi_sekolah`, `alamat_sekolah`, `jumlah_jalur_prestasi`, `jumlah_jalur_nonprestasi`, `no_hp_sekolah`, `nama_kepala_sekolah`, `nama_ketua_panitia`, `total_jurusan`, `url_logo`, `url_image1`, `url_image2`, `url_image3`, `url_image4`, `judul_image1`, `judul_image2`, `judul_image3`, `judul_image4`, `deskripsi_image1`, `deskripsi_image2`, `deskripsi_image3`, `deskripsi_image4`, `informasi_penting`, `cara_mendaftar`, `tentang_aplikasi`, `tahap`, `created_at`, `updated_at`) VALUES
	(1, 'SPMB SMAN 4 LAHAT', '2026-2027', 'A', 'Jln. Raya Tanjung Payang Lahat', '200', '250', 'Website : https://www.sman4lahat.sch.id  Email : smaun4lahat@gmail.com', 'Baslini', '-', '2', '69e9e5f10c45c.png', '65e0b74997bc7.jpg', '65e0b74998bc4.jpg', '65e0b7499991d.jpg', NULL, 'Slide 1', 'Slide 2', 'Slide 3', NULL, 'Tentang Sekolah', 'Tentang Jurusan', 'Tentang Siswa', NULL, 'test', 'Terlampir', 'Terlampir', '1', '2024-02-29 16:56:41', '2026-04-25 01:25:33');

-- Dumping structure for table sman4_db_spmb.jurusan
CREATE TABLE IF NOT EXISTS `jurusan` (
  `id` int NOT NULL AUTO_INCREMENT,
  `kode` varchar(50) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0',
  `nama` varchar(50) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=armscii8 COLLATE=armscii8_bin;

-- Dumping data for table sman4_db_spmb.jurusan: ~12 rows (approximately)
INSERT INTO `jurusan` (`id`, `kode`, `nama`) VALUES
	(1, 'TKP', 'Teknik Konstruksi dan Perumahan (TKP)'),
	(2, 'DPIB', 'Desain Pemodelan dan Informasi Bangunan (DPIB)'),
	(3, 'TP', 'Teknik Pemesinan (TP)'),
	(4, 'TITL', 'Teknik Instalasi Tenaga Listrik (TITL)'),
	(5, 'TLAS', 'Teknik Pengelasan (TLAS)'),
	(6, 'TKR', 'Teknik Kendaraan Ringan (TKR)'),
	(7, 'TSM', 'Teknik Sepeda Motor (TSM)'),
	(8, 'TEI', 'Teknik Elektronika Industri (TEI)'),
	(9, 'TJKT', 'Teknik Jaringan Komputer dan Telekomunikasi (TJKT)'),
	(10, 'PPLG', 'Pengembangan Perangkat Lunak dan Gim (PPLG)'),
	(11, 'TGP', 'Teknik Geologi Pertambangan (TGP)'),
	(12, 'TAB', 'Teknik Alat Berat (TAB)');

-- Dumping structure for table sman4_db_spmb.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table sman4_db_spmb.migrations: ~9 rows (approximately)
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '2014_10_12_000000_create_users_table', 1),
	(2, '2014_10_12_100000_create_password_resets_table', 1),
	(3, '2020_05_18_033613_create_table_conf_sekolah', 1),
	(4, '2020_05_30_141107_create_table_data_diri', 1),
	(5, '2020_06_01_013658_create_table_sekolah_asal', 1),
	(6, '2020_06_01_025657_create_table_data_ortu', 1),
	(7, '2020_06_06_043032_create_table_nilai', 1),
	(8, '2020_06_09_161638_create_table_dokumen_pendukung', 1),
	(9, '2024_02_29_153658_create_frontends_table', 1);

-- Dumping structure for table sman4_db_spmb.pilihan_jurusan
CREATE TABLE IF NOT EXISTS `pilihan_jurusan` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `pilihan_1` varchar(50) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '',
  `pilihan_2` varchar(50) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '',
  `pilihan_3` varchar(50) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '',
  `pilihan_4` varchar(50) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '',
  `pilihan_5` varchar(50) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0',
  `pilihan_6` varchar(50) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '',
  `pilihan_7` varchar(50) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '',
  `pilihan_8` varchar(50) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '',
  `pilihan_9` varchar(50) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '',
  `pilihan_10` varchar(50) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '',
  `pilihan_11` varchar(50) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '',
  `pilihan_12` varchar(50) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '',
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_user` (`user_id`),
  CONSTRAINT `FK_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=armscii8 COLLATE=armscii8_bin;

-- Dumping data for table sman4_db_spmb.pilihan_jurusan: ~0 rows (approximately)

-- Dumping structure for table sman4_db_spmb.table_conf_sekolah
CREATE TABLE IF NOT EXISTS `table_conf_sekolah` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `npsn_sekolah` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_sekolah` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `jenjang_sekolah` enum('SD','SMP','SMA') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `alamat_sekolah` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `kota_sekolah` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `telepon_sekolah` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_sekolah` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fax_sekolah` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `web_sekolah` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tipe_sekolah` enum('NEGERI','SWASTA') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo_sekolah` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status_ppdb` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `informasi_penting` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tahap` enum('1','2') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table sman4_db_spmb.table_conf_sekolah: ~1 rows (approximately)
INSERT INTO `table_conf_sekolah` (`id`, `npsn_sekolah`, `nama_sekolah`, `jenjang_sekolah`, `alamat_sekolah`, `kota_sekolah`, `telepon_sekolah`, `email_sekolah`, `fax_sekolah`, `web_sekolah`, `tipe_sekolah`, `logo_sekolah`, `status_ppdb`, `informasi_penting`, `created_at`, `updated_at`, `tahap`) VALUES
	(1, '', 'SMKN 1 Lahat', 'SMA', 'Jalan Bandar Agung', 'Lahat', '(0731) 323023', 'smkn1lahat@yahoo.com', NULL, 'smkn1lahat.sch.id', 'NEGERI', '', '1', '', NULL, NULL, NULL);

-- Dumping structure for table sman4_db_spmb.table_data_diri
CREATE TABLE IF NOT EXISTS `table_data_diri` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nisn` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nik` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tempat_lahir` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `agama` enum('Islam','Kristen Katolik','Kristen Protestan','Hindu','Buddha') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `jenis_kelamin` enum('Laki-laki','Perempuan') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_hp_wali` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `alamat_lengkap` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `kota` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `provinsi` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_pos` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jarak_rumah` decimal(10,2) DEFAULT NULL,
  `latitude` decimal(10,8) DEFAULT NULL,
  `longitude` decimal(11,8) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `table_data_diri_user_id_foreign` (`user_id`),
  CONSTRAINT `table_data_diri_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table sman4_db_spmb.table_data_diri: ~1 rows (approximately)
INSERT INTO `table_data_diri` (`id`, `user_id`, `name`, `nisn`, `nik`, `tempat_lahir`, `tanggal_lahir`, `agama`, `jenis_kelamin`, `no_hp_wali`, `alamat_lengkap`, `kota`, `provinsi`, `kode_pos`, `jarak_rumah`, `latitude`, `longitude`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 2007, 'Zulkipli', '1234567891', '1604102004970011', 'Lahat', '1997-04-20', 'Islam', 'Laki-laki', '083176818736', 'Perumas Selawi Indah Blok C No. 039 KEL. Selawi', 'Kabupaten Lahat', 'Sumatera Selatan', '31419', 3.56, -3.78192491, 103.51105900, '2026-04-24 04:09:24', '2026-04-24 15:23:12', NULL),
	(2, 2008, 'Akun Test Kedua', '1111111111', '1604102406960004', 'LAHAT', '2009-04-06', 'Islam', 'Laki-laki', '083138335334', 'DS. LUBUK KEPAYANG', 'LAHAT', 'SUMATERA SELATAN', '31419', 3.57, -3.78213902, 103.51096487, '2026-04-24 23:00:00', '2026-04-24 23:00:00', NULL),
	(3, 2009, '2222222222', '2222222222', '1604102004970016', 'LAHAT', '2026-04-21', 'Islam', 'Laki-laki', '083176818736', 'Perumas Selawi Indah Blok C No. 039 KEL. Selawi', 'Kabupaten Lahat', 'Sumatera Selatan', '31419', 0.47, -3.78565421, 103.53878021, '2026-04-28 14:37:44', '2026-04-28 14:37:44', NULL),
	(4, 2010, '3333333333', '3333333333', '1604102406960006', 'LAHAT', '2026-04-14', 'Islam', 'Laki-laki', '083176818736', 'Perumas Selawi Indah Blok C No. 039 KEL. Selawi', 'Kabupaten Lahat', 'Sumatera Selatan', '31419', 3.58, -3.79199180, 103.51148605, '2026-04-29 03:26:11', '2026-04-29 03:26:11', NULL);

-- Dumping structure for table sman4_db_spmb.table_data_ortu
CREATE TABLE IF NOT EXISTS `table_data_ortu` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `nama_ayah` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pendidikan_ayah` enum('Tidak Lulus Sekolah/Tidak Sekolah','SD/MI/Sederajat','SMP/MTs/Sederajat','SMA/SMK/Sederajat','Diploma','S1','S2','S3') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pekerjaan_ayah` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `gaji_ayah` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `alamat_ayah` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `kota_ayah` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `provinsi_ayah` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_pos_ayah` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_ibu` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pendidikan_ibu` enum('Tidak Lulus Sekolah/Tidak Sekolah','SD/MI/Sederajat','SMP/MTs/Sederajat','SMA/SMK/Sederajat','Diploma','S1','S2','S3') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pekerjaan_ibu` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `gaji_ibu` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat_ibu` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `kota_ibu` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `provinsi_ibu` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_pos_ibu` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `table_data_ortu_user_id_foreign` (`user_id`),
  CONSTRAINT `table_data_ortu_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table sman4_db_spmb.table_data_ortu: ~2 rows (approximately)
INSERT INTO `table_data_ortu` (`id`, `user_id`, `nama_ayah`, `pendidikan_ayah`, `pekerjaan_ayah`, `gaji_ayah`, `alamat_ayah`, `kota_ayah`, `provinsi_ayah`, `kode_pos_ayah`, `nama_ibu`, `pendidikan_ibu`, `pekerjaan_ibu`, `gaji_ibu`, `alamat_ibu`, `kota_ibu`, `provinsi_ibu`, `kode_pos_ibu`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 2007, 'Suhib', 'S1', 'Pensiun', 'Rp. 2.000.000 - Rp. 5.000.000', 'Perumas Selawi Indah Blok C No. 039 KEL. Selawi', 'Kabupaten Lahat', 'Sumatera Selatan', '31419', 'Zubaidah', 'Tidak Lulus Sekolah/Tidak Sekolah', 'IRT', 'Rp. 2.000.000 - Rp. 5.000.000', 'Perumas Selawi Indah Blok C No. 039 KEL. Selawi', 'Kabupaten Lahat', 'Sumatera Selatan', '31419', '2026-04-24 04:11:14', '2026-04-24 04:11:14', NULL),
	(2, 2008, 'Purwanto', 'SD/MI/Sederajat', 'Wiraswasta', 'Rp. 2.000.000 - Rp. 5.000.000', 'DS. LUBUK KEPAYANG', 'LAHAT', 'SUMATERA SELATAN', '31419', 'Zubaidah', 'SD/MI/Sederajat', 'IRT', 'Rp. 2.000.000 - Rp. 5.000.000', 'DS. LUBUK KEPAYANG', 'LAHAT', 'SUMATERA SELATAN', '31419', '2026-04-24 23:00:45', '2026-04-24 23:00:45', NULL),
	(3, 2009, 'Purwanto', 'Tidak Lulus Sekolah/Tidak Sekolah', 'Pensiun', 'Rp. 2.000.000 - Rp. 5.000.000', 'Perumas Selawi Indah Blok C No. 039 KEL. Selawi', 'Kabupaten Lahat', 'Sumatera Selatan', '31419', 'Zubaidah', 'Tidak Lulus Sekolah/Tidak Sekolah', 'dsa', 'Rp. 1.000.000 - Rp. 2.000.000', 'Perumas Selawi Indah Blok C No. 039 KEL. Selawi', 'Kabupaten Lahat', 'Sumatera Selatan', '31419', '2026-04-28 14:38:12', '2026-04-28 14:38:12', NULL),
	(4, 2010, 'Suhib', 'SD/MI/Sederajat', 'Pensiun', 'Rp. 2.000.000 - Rp. 5.000.000', 'Perumas Selawi Indah Blok C No. 039 KEL. Selawi', 'Kabupaten Lahat', 'Sumatera Selatan', '31419', 'Zubaidah', 'Tidak Lulus Sekolah/Tidak Sekolah', 'IRT', 'Rp. 1.000.000 - Rp. 2.000.000', 'Perumas Selawi Indah Blok C No. 039 KEL. Selawi', 'Kabupaten Lahat', 'Sumatera Selatan', '31419', '2026-04-29 03:27:15', '2026-04-29 03:27:15', NULL);

-- Dumping structure for table sman4_db_spmb.table_dokumen_jalur_afirmasi
CREATE TABLE IF NOT EXISTS `table_dokumen_jalur_afirmasi` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dokumen_pendukung_id` bigint DEFAULT NULL,
  `jenis_afirmasi` varchar(50) CHARACTER SET armscii8 COLLATE armscii8_bin DEFAULT NULL,
  `kip` varchar(255) CHARACTER SET armscii8 COLLATE armscii8_bin DEFAULT NULL,
  `pkh` varchar(255) CHARACTER SET armscii8 COLLATE armscii8_bin DEFAULT NULL,
  `kis` varchar(255) CHARACTER SET armscii8 COLLATE armscii8_bin DEFAULT NULL,
  `sktm` varchar(255) CHARACTER SET armscii8 COLLATE armscii8_bin DEFAULT NULL,
  `suket_disabilitas` varchar(255) CHARACTER SET armscii8 COLLATE armscii8_bin DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `bmtt` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=armscii8 COLLATE=armscii8_bin;

-- Dumping data for table sman4_db_spmb.table_dokumen_jalur_afirmasi: ~2 rows (approximately)
INSERT INTO `table_dokumen_jalur_afirmasi` (`id`, `dokumen_pendukung_id`, `jenis_afirmasi`, `kip`, `pkh`, `kis`, `sktm`, `suket_disabilitas`, `created_at`, `updated_at`, `bmtt`) VALUES
	(1, 3, 'Tidak Mampu', '', '', '', '', '', NULL, NULL, 'bmtt.pdf'),
	(2, 1, 'Tidak Mampu', NULL, NULL, NULL, NULL, NULL, '2026-04-24 04:26:40', '2026-04-24 15:52:50', 'bmtt.pdf');

-- Dumping structure for table sman4_db_spmb.table_dokumen_jalur_anak_guru
CREATE TABLE IF NOT EXISTS `table_dokumen_jalur_anak_guru` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dokumen_pendukung_id` int DEFAULT NULL,
  `sk_tugas` varchar(200) COLLATE armscii8_bin DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=armscii8 COLLATE=armscii8_bin;

-- Dumping data for table sman4_db_spmb.table_dokumen_jalur_anak_guru: ~0 rows (approximately)

-- Dumping structure for table sman4_db_spmb.table_dokumen_jalur_mutasi
CREATE TABLE IF NOT EXISTS `table_dokumen_jalur_mutasi` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dokumen_pendukung_id` int DEFAULT NULL,
  `suket_pindah` varchar(200) CHARACTER SET armscii8 COLLATE armscii8_bin DEFAULT NULL,
  `suket_keputusan` varchar(200) CHARACTER SET armscii8 COLLATE armscii8_bin DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=armscii8 COLLATE=armscii8_bin;

-- Dumping data for table sman4_db_spmb.table_dokumen_jalur_mutasi: ~2 rows (approximately)
INSERT INTO `table_dokumen_jalur_mutasi` (`id`, `dokumen_pendukung_id`, `suket_pindah`, `suket_keputusan`, `created_at`, `updated_at`) VALUES
	(1, 3, 'suket_pindah.pdf', 'suket_keputusan.pdf', NULL, NULL),
	(2, 1, 'suket_pindah.pdf', 'suket_keputusan.pdf', '2026-04-24 04:26:40', '2026-04-24 15:52:50');

-- Dumping structure for table sman4_db_spmb.table_dokumen_jalur_prestasi_akademik
CREATE TABLE IF NOT EXISTS `table_dokumen_jalur_prestasi_akademik` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dokumen_pendukung_id` bigint DEFAULT NULL,
  `nama_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `penyelenggara_1` text COLLATE utf8mb4_unicode_ci,
  `capaian_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tingkat_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `piagam_1` text COLLATE utf8mb4_unicode_ci,
  `nama_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `penyelenggara_2` text COLLATE utf8mb4_unicode_ci,
  `capaian_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tingkat_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `piagam_2` text COLLATE utf8mb4_unicode_ci,
  `nama_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `penyelenggara_3` text COLLATE utf8mb4_unicode_ci,
  `capaian_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tingkat_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `piagam_3` text COLLATE utf8mb4_unicode_ci,
  `nama_4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `capaian_4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tingkat_4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun_4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `penyelenggara_4` text COLLATE utf8mb4_unicode_ci,
  `piagam_4` text COLLATE utf8mb4_unicode_ci,
  `nama_5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `capaian_5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tingkat_5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun_5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `penyelenggara_5` text COLLATE utf8mb4_unicode_ci,
  `piagam_5` text COLLATE utf8mb4_unicode_ci,
  `nama_6` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `capaian_6` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tingkat_6` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun_6` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `penyelenggara_6` text COLLATE utf8mb4_unicode_ci,
  `piagam_6` text COLLATE utf8mb4_unicode_ci,
  `juara_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `juara_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `juara_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `juara_4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `juara_5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kelas_1` text COLLATE utf8mb4_unicode_ci,
  `kelas_2` text COLLATE utf8mb4_unicode_ci,
  `kelas_3` text COLLATE utf8mb4_unicode_ci,
  `kelas_4` text COLLATE utf8mb4_unicode_ci,
  `kelas_5` text COLLATE utf8mb4_unicode_ci,
  `sertifikat_1` text COLLATE utf8mb4_unicode_ci,
  `sertifikat_2` text COLLATE utf8mb4_unicode_ci,
  `sertifikat_3` text COLLATE utf8mb4_unicode_ci,
  `sertifikat_4` text COLLATE utf8mb4_unicode_ci,
  `sertifikat_5` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table sman4_db_spmb.table_dokumen_jalur_prestasi_akademik: ~0 rows (approximately)
INSERT INTO `table_dokumen_jalur_prestasi_akademik` (`id`, `dokumen_pendukung_id`, `nama_1`, `penyelenggara_1`, `capaian_1`, `tingkat_1`, `tahun_1`, `piagam_1`, `nama_2`, `penyelenggara_2`, `capaian_2`, `tingkat_2`, `tahun_2`, `piagam_2`, `nama_3`, `penyelenggara_3`, `capaian_3`, `tingkat_3`, `tahun_3`, `piagam_3`, `nama_4`, `capaian_4`, `tingkat_4`, `tahun_4`, `penyelenggara_4`, `piagam_4`, `nama_5`, `capaian_5`, `tingkat_5`, `tahun_5`, `penyelenggara_5`, `piagam_5`, `nama_6`, `capaian_6`, `tingkat_6`, `tahun_6`, `penyelenggara_6`, `piagam_6`, `juara_1`, `juara_2`, `juara_3`, `juara_4`, `juara_5`, `kelas_1`, `kelas_2`, `kelas_3`, `kelas_4`, `kelas_5`, `sertifikat_1`, `sertifikat_2`, `sertifikat_3`, `sertifikat_4`, `sertifikat_5`, `created_at`, `updated_at`) VALUES
	(5, 5, 'TEST', 'TEST', 'Juara 1 (Solo)', 'Kabupaten', '2024', 'piagam1.pdf', 'Programmer', 'TEST 2', 'Juara 1 (Regu)', 'Provinsi', '2024', 'piagam2.pdf', NULL, NULL, 'Ketua Osis', NULL, '2024', 'piagam3.pdf', NULL, 'Ketua Pramuka', NULL, '2024', NULL, 'piagam4.pdf', NULL, 'Ketua Eksrakulikuler', NULL, '2024', NULL, 'piagam5.pdf', NULL, NULL, NULL, NULL, NULL, NULL, 'Juara Umum 1', 'Juara Umum 2', 'Juara Umum 3', 'Juara 1 Kelas', 'Juara 2 Kelas', 'VII Semester 1', 'VII Semester 2', 'VIII Semester 1', 'VIII Semester 2', 'IX Semester 1', 'sertifikat1.pdf', 'sertifikat2.pdf', 'sertifikat3.pdf', 'sertifikat4.pdf', 'sertifikat5.pdf', '2026-04-25 13:09:43', '2026-04-25 14:14:02'),
	(12, 26, 'Memancing', 'TEST', 'Juara 1 (Solo)', 'Kabupaten', '2023', 'piagam_akademik1.pdf', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, '', 'ada', 'Juara 2 (Solo)', 'Nasional', '2024', 'ada', 'piagam_akademik5.pdf', NULL, NULL, NULL, NULL, NULL, NULL, 'Juara Umum 1', NULL, NULL, NULL, NULL, 'VII Semester 1', NULL, NULL, NULL, NULL, 'sertifikat1.pdf', '', '', '', '', '2026-04-29 01:00:14', '2026-04-29 01:49:42'),
	(13, 27, 'Programmer', 'Sekolah', 'Juara 1 (Solo)', 'Kabupaten', '2024', 'piagam_akademik1.pdf', 'Ketua Osis', 'Sekolah', 'Ketua Osis', NULL, '2024', 'piagam_akademik2.pdf', 'Ketua Eksrakulikuler', 'Sekolah', 'Ketua Eksrakulikuler', NULL, '2024', 'piagam_akademik3.pdf', 'Ketua Pramuka', 'Ketua Pramuka', NULL, '2024', 'Sekolah', 'piagam_akademik4.pdf', 'Ketua Pramuka', 'Ketua Pramuka', NULL, '2024', 'Sekolah', 'piagam_akademik5.pdf', NULL, NULL, NULL, NULL, NULL, NULL, 'Juara Umum 1', 'Juara Umum 1', 'Juara 1 Kelas', 'Juara 3 Kelas', 'Juara 2 Kelas', 'VII Semester 1', 'VII Semester 2', 'VIII Semester 1', 'VIII Semester 2', 'IX Semester 1', 'sertifikat1.pdf', 'sertifikat2.pdf', 'sertifikat3.pdf', 'sertifikat4.pdf', 'sertifikat5.pdf', '2026-04-29 10:30:38', '2026-04-29 10:30:57');

-- Dumping structure for table sman4_db_spmb.table_dokumen_jalur_prestasi_non_akademik
CREATE TABLE IF NOT EXISTS `table_dokumen_jalur_prestasi_non_akademik` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dokumen_pendukung_id` bigint NOT NULL,
  `nama_1` varchar(50) COLLATE armscii8_bin DEFAULT NULL,
  `penyelenggara_1` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `capaian_1` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `tingkat_1` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `tahun_1` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `piagam_1` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `nama_2` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `penyelenggara_2` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `capaian_2` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `tingkat_2` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `tahun_2` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `piagam_2` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `nama_3` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `penyelenggara_3` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `capaian_3` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `tingkat_3` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `tahun_3` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `piagam_3` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `nama_4` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `capaian_4` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `tingkat_4` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `tahun_4` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `penyelenggara_4` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `piagam_4` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `nama_5` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `capaian_5` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `tingkat_5` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `tahun_5` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `penyelenggara_5` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  `piagam_5` varchar(255) COLLATE armscii8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=armscii8 COLLATE=armscii8_bin;

-- Dumping data for table sman4_db_spmb.table_dokumen_jalur_prestasi_non_akademik: ~0 rows (approximately)
INSERT INTO `table_dokumen_jalur_prestasi_non_akademik` (`id`, `dokumen_pendukung_id`, `nama_1`, `penyelenggara_1`, `capaian_1`, `tingkat_1`, `tahun_1`, `piagam_1`, `nama_2`, `penyelenggara_2`, `capaian_2`, `tingkat_2`, `tahun_2`, `piagam_2`, `nama_3`, `penyelenggara_3`, `capaian_3`, `tingkat_3`, `tahun_3`, `piagam_3`, `nama_4`, `capaian_4`, `tingkat_4`, `tahun_4`, `penyelenggara_4`, `piagam_4`, `nama_5`, `capaian_5`, `tingkat_5`, `tahun_5`, `penyelenggara_5`, `piagam_5`) VALUES
	(1, 26, 'TEST', 'TEST', 'Juara 1 (Regu)', 'Kabupaten', '2023', 'piagam_akademik1.pdf', 'Programmer', 'test', 'Juara 1 (Solo)', 'Nasional', '2024', 'piagam2.pdf', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, 'piagam_akademik5.pdf');

-- Dumping structure for table sman4_db_spmb.table_dokumen_jalur_zonasi
CREATE TABLE IF NOT EXISTS `table_dokumen_jalur_zonasi` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dokumen_pendukung_id` bigint DEFAULT NULL,
  `surat_domisili` varchar(255) CHARACTER SET armscii8 COLLATE armscii8_bin DEFAULT NULL,
  `jarak` decimal(20,1) DEFAULT NULL,
  `foto_maps` varchar(255) CHARACTER SET armscii8 COLLATE armscii8_bin DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=armscii8 COLLATE=armscii8_bin;

-- Dumping data for table sman4_db_spmb.table_dokumen_jalur_zonasi: ~0 rows (approximately)

-- Dumping structure for table sman4_db_spmb.table_dokumen_pendukung
CREATE TABLE IF NOT EXISTS `table_dokumen_pendukung` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `jalur` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `foto` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `kk` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `akta` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `raport_sem_1` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `raport_sem_2` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `raport_sem_3` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `raport_sem_4` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `raport_sem_5` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_table_dokumen_pendukung_users` (`user_id`),
  CONSTRAINT `FK_table_dokumen_pendukung_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table sman4_db_spmb.table_dokumen_pendukung: ~2 rows (approximately)
INSERT INTO `table_dokumen_pendukung` (`id`, `user_id`, `jalur`, `foto`, `kk`, `akta`, `raport_sem_1`, `raport_sem_2`, `raport_sem_3`, `raport_sem_4`, `raport_sem_5`, `created_at`, `updated_at`) VALUES
	(4, 2008, 'prestasi_tes_akademik', 'foto.jpg', 'kk.pdf', 'akta.pdf', 'scan_raport1.pdf', 'scan_raport2.pdf', 'scan_raport3.pdf', 'scan_raport4.pdf', 'scan_raport5.pdf', '2026-04-24 23:02:22', '2026-04-24 23:02:22'),
	(5, 2007, 'prestasi-akademik,prestasi-non-akademik', 'foto.jpg', 'kk.pdf', 'akta.pdf', 'scan_raport1.pdf', 'scan_raport2.pdf', 'scan_raport3.pdf', 'scan_raport4.pdf', 'scan_raport5.pdf', '2026-04-25 02:23:04', '2026-04-25 02:23:04'),
	(26, 2009, 'prestasi-akademik,prestasi-non-akademik', 'foto.jpeg', 'kk.pdf', 'akta.pdf', 'scan_raport1.pdf', 'scan_raport2.pdf', 'scan_raport3.pdf', 'scan_raport4.pdf', 'scan_raport5.pdf', '2026-04-28 18:00:14', '2026-04-28 18:50:15'),
	(27, 2010, 'prestasi-akademik', 'foto.jpeg', 'kk.pdf', 'akta.pdf', 'scan_raport1.pdf', 'scan_raport2.pdf', 'scan_raport3.pdf', 'scan_raport4.pdf', 'scan_raport5.pdf', '2026-04-29 03:30:38', '2026-04-29 03:30:38');

-- Dumping structure for table sman4_db_spmb.table_nilai
CREATE TABLE IF NOT EXISTS `table_nilai` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `mtk_sem_1` decimal(5,2) NOT NULL DEFAULT '0.00',
  `mtk_sem_2` decimal(5,2) NOT NULL,
  `mtk_sem_3` decimal(5,2) NOT NULL,
  `mtk_sem_4` decimal(5,2) NOT NULL,
  `mtk_sem_5` decimal(5,2) NOT NULL,
  `bin_sem_1` decimal(5,2) DEFAULT NULL,
  `bin_sem_2` decimal(5,2) DEFAULT NULL,
  `bin_sem_3` decimal(5,2) DEFAULT NULL,
  `bin_sem_4` decimal(5,2) DEFAULT NULL,
  `bin_sem_5` decimal(5,2) DEFAULT NULL,
  `bing_sem_1` decimal(5,2) DEFAULT NULL,
  `bing_sem_2` decimal(5,2) DEFAULT NULL,
  `bing_sem_3` decimal(5,2) DEFAULT NULL,
  `bing_sem_4` decimal(5,2) DEFAULT NULL,
  `bing_sem_5` decimal(5,2) DEFAULT NULL,
  `ipa_sem_1` decimal(5,2) DEFAULT NULL,
  `ipa_sem_2` decimal(5,2) DEFAULT NULL,
  `ipa_sem_3` decimal(5,2) DEFAULT NULL,
  `ipa_sem_4` decimal(5,2) DEFAULT NULL,
  `ipa_sem_5` decimal(5,2) DEFAULT NULL,
  `ips_sem_1` decimal(5,2) DEFAULT NULL,
  `ips_sem_2` decimal(5,2) DEFAULT NULL,
  `ips_sem_3` decimal(5,2) DEFAULT NULL,
  `ips_sem_4` decimal(5,2) DEFAULT NULL,
  `ips_sem_5` decimal(5,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `table_nilai_user_id_foreign` (`user_id`),
  CONSTRAINT `table_nilai_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table sman4_db_spmb.table_nilai: ~2 rows (approximately)
INSERT INTO `table_nilai` (`id`, `user_id`, `mtk_sem_1`, `mtk_sem_2`, `mtk_sem_3`, `mtk_sem_4`, `mtk_sem_5`, `bin_sem_1`, `bin_sem_2`, `bin_sem_3`, `bin_sem_4`, `bin_sem_5`, `bing_sem_1`, `bing_sem_2`, `bing_sem_3`, `bing_sem_4`, `bing_sem_5`, `ipa_sem_1`, `ipa_sem_2`, `ipa_sem_3`, `ipa_sem_4`, `ipa_sem_5`, `ips_sem_1`, `ips_sem_2`, `ips_sem_3`, `ips_sem_4`, `ips_sem_5`, `created_at`, `updated_at`) VALUES
	(1, 2007, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, '2026-04-24 04:11:44', '2026-04-24 04:11:44'),
	(2, 2008, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, 81.00, '2026-04-24 23:01:18', '2026-04-24 23:01:18'),
	(3, 2009, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, '2026-04-28 14:38:28', '2026-04-28 14:38:28'),
	(4, 2010, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, 80.00, '2026-04-29 03:27:45', '2026-04-29 03:27:45');

-- Dumping structure for table sman4_db_spmb.table_sekolah_asal
CREATE TABLE IF NOT EXISTS `table_sekolah_asal` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `nama_sekolah` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `npsn` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `jenis_sekolah` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tahun_lulus` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `alamat` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `table_sekolah_asal_user_id_foreign` (`user_id`),
  CONSTRAINT `table_sekolah_asal_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table sman4_db_spmb.table_sekolah_asal: ~2 rows (approximately)
INSERT INTO `table_sekolah_asal` (`id`, `user_id`, `nama_sekolah`, `npsn`, `jenis_sekolah`, `tahun_lulus`, `alamat`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 2007, 'SMPN 4 LAHAT', '-', 'Negeri', '2026', 'Gunung Gajah Lahat', '2026-04-24 04:10:55', '2026-04-24 04:10:55', NULL),
	(2, 2008, 'SMPN 1 LAHAT', '-', 'Negeri', '2026', 'Lahat', '2026-04-24 23:00:21', '2026-04-24 23:00:21', NULL),
	(3, 2009, 'SMPN 1 GUMAY ULU', '-', 'Swasta', '2025', 'ada', '2026-04-28 14:37:53', '2026-04-28 14:37:53', NULL),
	(4, 2010, 'SMPN 1 GUMAY ULU', '-', 'Swasta', '2025', 'ada', '2026-04-29 03:26:20', '2026-04-29 03:26:20', NULL);

-- Dumping structure for table sman4_db_spmb.visitors
CREATE TABLE IF NOT EXISTS `visitors` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(50) CHARACTER SET armscii8 COLLATE armscii8_bin DEFAULT NULL,
  `visit_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=armscii8 COLLATE=armscii8_bin;

-- Dumping data for table sman4_db_spmb.visitors: ~0 rows (approximately)

