INSERT INTO `master_data_verifikasi_berkas` (`id_verifikasi`, `pencaker_id`, `tanggal_panggilan`, `id_jam`, `id_loket`, `id_user`, `inserted`) VALUES
(4251, 6768, '2023-05-24', 4, 1, 63, '2023-05-24 04:53:20'),
(4252, 6767, '2023-05-24', 4, 2, 63, '2023-05-24 04:53:26'),
(4253, 5313, '2023-05-24', 5, 1, 63, '2023-05-24 04:53:55'),
(4254, 6766, '2023-05-24', 4, 2, 63, '2023-05-24 04:56:05'),
(4255, 6769, '2023-05-24', 4, 1, 63, '2023-05-24 05:02:41'),
(4256, 6758, '2023-05-24', 4, 1, 63, '2023-05-24 05:03:11'),
(4257, 6761, '2023-05-24', 4, 1, 63, '2023-05-24 05:03:54'),
(4258, 6719, '2023-05-24', 4, 1, 63, '2023-05-24 05:06:10'),
(4259, 6770, '2023-05-24', 4, 1, 63, '2023-05-24 05:08:59'),
(4260, 6046, '2023-05-24', 4, 1, 63, '2023-05-24 05:16:07'),
(4261, 6763, '2023-05-24', 5, 1, 63, '2023-05-24 05:16:41'),
(4262, 6762, '2023-05-24', 4, 1, 63, '2023-05-24 05:17:21'),
(4263, 6764, '2023-05-24', 4, 1, 63, '2023-05-24 05:17:48'),
(4264, 6727, '2023-05-24', 4, 2, 63, '2023-05-24 05:18:36'),
(4265, 6727, '2023-05-24', 4, 2, 63, '2023-05-24 05:20:21'),
(4266, 6721, '2023-05-24', 5, 2, 42, '2023-05-24 05:24:44'),
(4267, 6771, '2023-05-24', 4, 1, 63, '2023-05-24 05:26:13'),
(4268, 6720, '2023-05-24', 5, 2, 63, '2023-05-24 05:27:21'),
(4269, 6717, '2023-05-24', 5, 2, 63, '2023-05-24 05:30:14'),
(4270, 6716, '2023-05-24', 5, 2, 63, '2023-05-24 05:32:58'),
(4271, 6715, '2023-05-24', 5, 2, 63, '2023-05-24 05:36:13'),
(4272, 6714, '2023-05-24', 5, 2, 63, '2023-05-24 05:39:40'),
(4273, 6713, '2023-05-24', 5, 2, 63, '2023-05-24 05:41:44'),
(4274, 6710, '2023-05-24', 5, 2, 63, '2023-05-24 05:44:00'),
(4275, 6773, '2023-05-24', 5, 1, 42, '2023-05-24 05:44:57'),
(4276, 6772, '2023-05-24', 5, 1, 42, '2023-05-24 05:46:22'),
(4277, 6774, '2023-05-24', 5, 2, 63, '2023-05-24 05:48:10'),
(4278, 6777, '2023-05-24', 5, 2, 63, '2023-05-24 05:50:57'),
(4279, 6776, '2023-05-24', 5, 1, 63, '2023-05-24 05:52:36'),
(4280, 6775, '2023-05-24', 5, 1, 63, '2023-05-24 05:53:23'),
(4281, 6709, '2023-05-24', 5, 2, 63, '2023-05-24 05:54:16'),
(4282, 6709, '2023-05-24', 5, 2, 63, '2023-05-24 05:54:22'),
(4283, 6778, '2023-05-24', 5, 1, 63, '2023-05-24 05:55:48'),
(4284, 6780, '2023-05-24', 5, 1, 63, '2023-05-24 06:01:53'),
(4285, 6779, '2023-05-24', 5, 1, 63, '2023-05-24 06:09:50'),
(4286, 6781, '2023-05-24', 4, 2, 63, '2023-05-24 06:10:05'),
(4287, 6782, '2023-05-24', 5, 1, 63, '2023-05-24 06:14:32'),
(4288, 6783, '2023-05-24', 5, 1, 63, '2023-05-24 06:34:57'),
(4289, 6784, '2023-05-24', 5, 2, 42, '2023-05-24 06:46:35'),
(4290, 6787, '2023-05-24', 5, 1, 63, '2023-05-24 06:59:22'),
(4291, 6788, '2023-05-24', 5, 2, 63, '2023-05-24 07:03:58'),
(4292, 6048, '2023-05-24', 6, 2, 63, '2023-05-24 08:00:03'),
(4293, 6794, '2023-05-25', 2, 2, 42, '2023-05-25 02:22:45'),
(4294, 6796, '2023-05-25', 2, 2, 63, '2023-05-25 02:36:54'),
(4295, 6795, '2023-05-25', 2, 2, 63, '2023-05-25 02:39:24'),
(4296, 6799, '2023-05-25', 1, 1, 63, '2023-05-25 02:40:41'),
(4297, 6798, '2023-05-25', 2, 1, 63, '2023-05-25 02:43:44'),
(4298, 6803, '2023-05-25', 2, 1, 63, '2023-05-25 02:57:24'),
(4299, 5626, '2023-05-25', 2, 1, 63, '2023-05-25 02:59:47'),
(4300, 6800, '2023-05-25', 2, 1, 63, '2023-05-25 03:02:09'),
(4301, 6806, '2023-05-25', 2, 1, 63, '2023-05-25 03:07:08'),
(4302, 6802, '2023-05-25', 3, 2, 63, '2023-05-25 03:44:26'),
(4303, 6810, '2023-05-25', 2, 1, 63, '2023-05-25 03:45:45'),
(4304, 6805, '2023-05-25', 3, 2, 63, '2023-05-25 03:47:16'),
(4305, 6811, '2023-05-25', 3, 1, 63, '2023-05-25 03:48:43'),
(4306, 6804, '2023-05-25', 3, 2, 63, '2023-05-25 03:50:09'),
(4307, 6808, '2023-05-25', 2, 2, 63, '2023-05-25 03:54:43'),
(4308, 6813, '2023-05-25', 3, 1, 63, '2023-05-25 03:54:56'),
(4309, 6809, '2023-05-25', 2, 2, 63, '2023-05-25 03:56:46'),
(4310, 6797, '2023-05-25', 3, 2, 63, '2023-05-25 03:59:02'),
(4311, 6812, '2023-05-25', 3, 1, 63, '2023-05-25 04:00:21'),
(4312, 6807, '2023-05-25', 3, 2, 63, '2023-05-25 04:01:04'),
(4313, 6815, '2023-05-25', 3, 1, 63, '2023-05-25 04:03:54'),
(4314, 6816, '2023-05-25', 2, 1, 63, '2023-05-25 04:20:10'),
(4315, 6819, '2023-05-25', 4, 2, 63, '2023-05-25 04:23:34'),
(4316, 6817, '2023-05-25', 3, 1, 63, '2023-05-25 04:24:52'),
(4317, 6818, '2023-05-25', 4, 2, 63, '2023-05-25 04:25:45'),
(4318, 6820, '2023-05-25', 4, 1, 63, '2023-05-25 04:29:45'),
(4319, 6643, '2023-05-25', 4, 1, 63, '2023-05-25 04:30:52'),
(4320, 6824, '2023-05-25', 4, 1, 63, '2023-05-25 04:47:55'),
(4321, 6826, '2023-05-25', 4, 1, 63, '2023-05-25 04:53:39'),
(4322, 6792, '2023-05-25', 4, 1, 63, '2023-05-25 04:55:39'),
(4323, 6793, '2023-05-25', 4, 1, 63, '2023-05-25 04:57:22'),
(4324, 6830, '2023-05-25', 4, 1, 42, '2023-05-25 05:24:43'),
(4325, 6833, '2023-05-25', 4, 1, 63, '2023-05-25 06:02:22'),
(4326, 6834, '2023-05-25', 5, 1, 63, '2023-05-25 06:04:51'),
(4327, 6828, '2023-05-25', 5, 2, 63, '2023-05-25 06:09:48'),
(4328, 6837, '2023-05-25', 5, 2, 63, '2023-05-25 06:59:57'),
(4329, 6838, '2023-05-25', 5, 2, 63, '2023-05-25 07:02:35'),
(4330, 6821, '2023-05-25', 6, 2, 63, '2023-05-25 08:39:15'),
(4331, 6836, '2023-05-25', 6, 2, 63, '2023-05-25 08:45:42'),
(4332, 6790, '2023-05-25', 6, 2, 63, '2023-05-25 08:53:31'),
(4333, 6831, '2023-05-25', 6, 2, 63, '2023-05-25 08:56:11'),
(4334, 6823, '2023-05-25', 6, 2, 63, '2023-05-25 08:58:33'),
(4335, 6827, '2023-05-25', 6, 2, 63, '2023-05-25 09:01:21'),
(4336, 6789, '2023-05-25', 6, 2, 63, '2023-05-25 09:03:17'),
(4337, 6825, '2023-05-25', 6, 2, 63, '2023-05-25 09:05:15'),
(4338, 6822, '2023-05-25', 6, 2, 63, '2023-05-25 09:08:58'),
(4339, 6843, '2023-05-26', 1, 1, 63, '2023-05-26 02:37:41'),
(4340, 6318, '2023-05-26', 4, 2, 42, '2023-05-26 02:38:33'),
(4341, 6318, '2023-05-26', 2, 2, 63, '2023-05-26 02:43:32'),
(4342, 6845, '2023-05-26', 1, 1, 63, '2023-05-26 02:46:34'),
(4343, 6844, '2023-05-26', 2, 2, 63, '2023-05-26 02:48:09'),
(4344, 6846, '2023-05-26', 1, 1, 63, '2023-05-26 02:49:03'),
(4345, 6848, '2023-05-26', 2, 2, 63, '2023-05-26 02:54:33'),
(4346, 6847, '2023-05-26', 2, 2, 63, '2023-05-26 02:57:11'),
(4347, 6850, '2023-05-26', 2, 2, 42, '2023-05-26 03:17:40'),
(4348, 6849, '2023-05-26', 2, 2, 63, '2023-05-26 03:20:46'),
(4349, 6851, '2023-05-26', 1, 1, 63, '2023-05-26 03:30:25'),
(4350, 6842, '2023-05-26', 3, 2, 63, '2023-05-26 03:43:28'),
(4351, 5545, '2023-05-26', 3, 2, 63, '2023-05-26 03:59:05'),
(4352, 6852, '2023-05-26', 4, 2, 63, '2023-05-26 04:09:50'),
(4353, 6853, '2023-05-26', 4, 2, 42, '2023-05-26 04:24:23'),
(4354, 6854, '2023-05-26', 3, 2, 63, '2023-05-26 04:34:04'),
(4355, 6856, '2023-05-26', 5, 1, 63, '2023-05-26 04:42:14'),
(4356, 6855, '2023-05-26', 5, 1, 63, '2023-05-26 04:42:44'),
(4357, 6866, '2023-05-29', 1, 2, 63, '2023-05-29 01:23:22'),
(4358, 6867, '2023-05-29', 1, 2, 42, '2023-05-29 01:36:04'),
(4359, 6868, '2023-05-29', 1, 2, 63, '2023-05-29 01:43:18'),
(4360, 6869, '2023-05-29', 1, 2, 63, '2023-05-29 01:46:58'),
(4361, 6829, '2023-05-29', 2, 2, 42, '2023-05-29 02:07:16'),
(4362, 6872, '2023-05-29', 4, 2, 42, '2023-05-29 02:35:15'),
(4363, 6873, '2023-05-29', 1, 1, 63, '2023-05-29 02:39:39'),
(4364, 6871, '2023-05-29', 4, 2, 42, '2023-05-29 02:40:08'),
(4365, 6858, '2023-05-29', 2, 2, 63, '2023-05-29 02:51:19'),
(4366, 6874, '2023-05-29', 2, 1, 63, '2023-05-29 02:55:30'),
(4367, 6875, '2023-05-29', 2, 1, 63, '2023-05-29 02:59:22'),
(4368, 6876, '2023-05-29', 2, 2, 63, '2023-05-29 03:07:32'),
(4369, 6870, '2023-05-29', 2, 1, 63, '2023-05-29 03:20:22'),
(4370, 6877, '2023-05-29', 3, 1, 63, '2023-05-29 03:25:48'),
(4371, 6880, '2023-05-29', 3, 1, 63, '2023-05-29 03:36:00'),
(4372, 6861, '2023-05-29', 3, 2, 42, '2023-05-29 03:38:34'),
(4373, 6879, '2023-05-29', 3, 1, 63, '2023-05-29 03:40:24'),
(4374, 6881, '2023-05-29', 3, 2, 63, '2023-05-29 03:42:28'),
(4375, 6835, '2023-05-29', 3, 1, 63, '2023-05-29 03:45:15'),
(4376, 6882, '2023-05-29', 3, 1, 63, '2023-05-29 03:47:01'),
(4377, 6883, '2023-05-29', 3, 2, 63, '2023-05-29 03:48:18'),
(4378, 6884, '2023-05-29', 4, 2, 63, '2023-05-29 03:54:45'),
(4379, 6886, '2023-05-29', 3, 1, 63, '2023-05-29 03:55:25'),
(4380, 6887, '2023-05-29', 3, 1, 63, '2023-05-29 03:59:49'),
(4381, 6884, '2023-05-29', 4, 2, 63, '2023-05-29 04:01:20'),
(4382, 6885, '2023-05-29', 4, 2, 63, '2023-05-29 04:09:02'),
(4383, 6814, '2023-05-29', 4, 1, 63, '2023-05-29 04:13:43'),
(4384, 6888, '2023-05-29', 4, 1, 63, '2023-05-29 04:24:01'),
(4385, 6889, '2023-05-29', 4, 2, 63, '2023-05-29 04:30:35'),
(4386, 6891, '2023-05-29', 4, 1, 63, '2023-05-29 04:40:30'),
(4387, 6890, '2023-05-29', 4, 2, 63, '2023-05-29 04:40:54'),
(4388, 6892, '2023-05-29', 4, 1, 63, '2023-05-29 04:42:43'),
(4389, 6893, '2023-05-29', 4, 2, 63, '2023-05-29 04:43:19'),
(4390, 6864, '2023-05-29', 4, 1, 63, '2023-05-29 04:49:27'),
(4391, 6894, '2023-05-29', 4, 1, 63, '2023-05-29 05:00:37'),
(4392, 6840, '2023-05-29', 4, 1, 63, '2023-05-29 05:13:23'),
(4393, 6896, '2023-05-29', 4, 1, 63, '2023-05-29 05:16:15'),
(4394, 6895, '2023-05-29', 4, 2, 63, '2023-05-29 05:19:58'),
(4395, 6897, '2023-05-29', 4, 2, 42, '2023-05-29 05:24:15'),
(4396, 6898, '2023-05-29', 4, 2, 42, '2023-05-29 06:11:14'),
(4397, 6899, '2023-05-29', 5, 1, 63, '2023-05-29 06:26:49'),
(4398, 6900, '2023-05-29', 5, 1, 63, '2023-05-29 06:43:28'),
(4399, 6902, '2023-05-29', 5, 1, 63, '2023-05-29 06:58:10'),
(4400, 6905, '2023-05-30', 1, 2, 42, '2023-05-30 01:09:20'),
(4401, 6908, '2023-05-30', 4, 2, 42, '2023-05-30 02:14:59'),
(4402, 6907, '2023-05-30', 4, 2, 42, '2023-05-30 02:20:28'),
(4403, 6909, '2023-05-30', 4, 2, 42, '2023-05-30 02:40:11'),
(4404, 6910, '2023-05-30', 1, 1, 63, '2023-05-30 02:49:08'),
(4405, 6911, '2023-05-30', 2, 1, 63, '2023-05-30 02:52:16'),
(4406, 6904, '2023-05-30', 2, 1, 63, '2023-05-30 02:53:36'),
(4407, 5197, '2023-05-30', 2, 1, 63, '2023-05-30 02:57:10'),
(4408, 6791, '2023-05-30', 2, 1, 63, '2023-05-30 03:00:18'),
(4409, 6913, '2023-05-30', 2, 2, 63, '2023-05-30 03:00:59'),
(4410, 6912, '2023-05-30', 2, 2, 63, '2023-05-30 03:03:46'),
(4411, 6918, '2023-05-30', 2, 1, 63, '2023-05-30 03:24:54'),
(4412, 6919, '2023-05-30', 2, 2, 63, '2023-05-30 03:25:52'),
(4413, 6914, '2023-05-30', 2, 1, 63, '2023-05-30 03:28:08'),
(4414, 6915, '2023-05-30', 2, 1, 63, '2023-05-30 03:31:34'),
(4415, 6916, '2023-05-30', 3, 1, 63, '2023-05-30 03:37:32'),
(4416, 6922, '2023-05-30', 3, 2, 63, '2023-05-30 03:38:54'),
(4417, 6917, '2023-05-30', 3, 1, 63, '2023-05-30 03:39:36'),
(4418, 6921, '2023-05-30', 3, 1, 63, '2023-05-30 03:41:21'),
(4419, 6924, '2023-05-30', 3, 1, 63, '2023-05-30 04:18:55'),
(4420, 6925, '2023-05-30', 3, 1, 63, '2023-05-30 04:23:16'),
(4421, 6923, '2023-05-30', 4, 1, 63, '2023-05-30 04:28:45'),
(4422, 6926, '2023-05-30', 4, 1, 63, '2023-05-30 04:32:34'),
(4423, 6926, '2023-05-30', 4, 1, 63, '2023-05-30 04:32:36'),
(4424, 6927, '2023-05-30', 4, 1, 63, '2023-05-30 04:44:23'),
(4425, 2915, '2023-05-30', 3, 3, 63, '2023-05-30 04:55:09'),
(4426, 6928, '2023-05-30', 4, 1, 63, '2023-05-30 04:57:13'),
(4427, 6929, '2023-05-30', 4, 1, 63, '2023-05-30 05:01:02'),
(4428, 6930, '2023-05-30', 4, 1, 63, '2023-05-30 05:22:09'),
(4429, 6931, '2023-05-30', 5, 1, 63, '2023-05-30 06:31:21'),
(4430, 6932, '2023-05-30', 5, 2, 42, '2023-05-30 06:44:29'),
(4431, 6932, '2023-05-30', 5, 2, 42, '2023-05-30 06:48:23'),
(4432, 6938, '2023-05-31', 1, 2, 42, '2023-05-31 00:37:52'),
(4433, 6943, '2023-05-31', 2, 2, 63, '2023-05-31 02:06:28'),
(4434, 6944, '2023-05-31', 2, 2, 63, '2023-05-31 02:08:50'),
(4435, 6945, '2023-05-31', 2, 2, 63, '2023-05-31 02:14:13'),
(4436, 6946, '2023-05-31', 2, 2, 63, '2023-05-31 02:17:39'),
(4437, 6948, '2023-05-31', 2, 2, 63, '2023-05-31 02:20:03'),
(4438, 6942, '2023-05-31', 2, 2, 63, '2023-05-31 02:24:28'),
(4439, 6947, '2023-05-31', 2, 2, 63, '2023-05-31 02:27:17'),
(4440, 6950, '2023-05-31', 1, 1, 63, '2023-05-31 02:31:49'),
(4441, 6951, '2023-05-31', 2, 1, 63, '2023-05-31 02:36:20'),
(4442, 6449, '2023-05-31', 2, 1, 63, '2023-05-31 02:38:12'),
(4443, 6949, '2023-05-31', 2, 2, 63, '2023-05-31 02:40:28'),
(4444, 6952, '2023-05-31', 2, 1, 63, '2023-05-31 02:53:10'),
(4445, 6935, '2023-05-31', 2, 1, 63, '2023-05-31 02:56:41'),
(4446, 6940, '2023-05-31', 2, 1, 63, '2023-05-31 02:59:43'),
(4447, 6941, '2023-05-31', 2, 1, 63, '2023-05-31 03:03:52'),
(4448, 6939, '2023-05-31', 3, 1, 63, '2023-05-31 03:06:43'),
(4449, 6680, '2023-05-31', 3, 1, 63, '2023-05-31 03:09:40'),
(4450, 6955, '2023-05-31', 3, 1, 63, '2023-05-31 03:13:48'),
(4451, 6954, '2023-05-31', 3, 1, 63, '2023-05-31 03:15:24'),
(4452, 6037, '2023-05-31', 3, 2, 42, '2023-05-31 03:15:54'),
(4453, 6957, '2023-05-31', 3, 1, 63, '2023-05-31 03:17:39'),
(4454, 6958, '2023-05-31', 3, 1, 63, '2023-05-31 03:22:03'),
(4455, 6953, '2023-05-31', 3, 2, 63, '2023-05-31 03:25:40'),
(4456, 6959, '2023-05-31', 3, 1, 63, '2023-05-31 03:26:35'),
(4457, 6961, '2023-05-31', 3, 1, 63, '2023-05-31 03:34:57'),
(4458, 6956, '2023-05-31', 3, 2, 63, '2023-05-31 03:36:33'),
(4459, 6966, '2023-05-31', 3, 1, 63, '2023-05-31 03:37:00'),
(4460, 6963, '2023-05-31', 3, 2, 63, '2023-05-31 03:38:59'),
(4461, 6965, '2023-05-31', 4, 1, 63, '2023-05-31 03:39:10'),
(4462, 6962, '2023-05-31', 4, 1, 63, '2023-05-31 03:42:51'),
(4463, 6960, '2023-05-31', 4, 1, 63, '2023-05-31 03:44:54'),
(4464, 6964, '2023-05-31', 4, 1, 63, '2023-05-31 03:50:12'),
(4465, 6968, '2023-05-31', 4, 1, 63, '2023-05-31 03:52:11'),
(4466, 6967, '2023-05-31', 4, 1, 63, '2023-05-31 03:54:21'),
(4467, 6906, '2023-05-31', 3, 2, 63, '2023-05-31 03:57:47'),
(4468, 6972, '2023-05-31', 4, 1, 63, '2023-05-31 04:08:24'),
(4469, 6937, '2023-05-31', 4, 0, 63, '2023-05-31 04:19:59'),
(4470, 6974, '2023-05-31', 4, 1, 63, '2023-05-31 04:32:18'),
(4471, 6977, '2023-05-31', 4, 1, 63, '2023-05-31 04:33:47'),
(4472, 6978, '2023-05-31', 4, 1, 63, '2023-05-31 04:50:17'),
(4473, 6979, '2023-05-31', 5, 2, 63, '2023-05-31 05:50:10'),
(4474, 6969, '2023-05-31', 5, 2, 63, '2023-05-31 05:52:07'),
(4475, 6981, '2023-05-31', 5, 2, 63, '2023-05-31 05:58:55'),
(4476, 6980, '2023-05-31', 5, 2, 63, '2023-05-31 06:01:35'),
(4477, 6971, '2023-05-31', 5, 2, 63, '2023-05-31 06:04:23'),
(4478, 6983, '2023-05-31', 4, 2, 42, '2023-05-31 06:13:17'),
(4479, 6984, '2023-05-31', 5, 2, 63, '2023-05-31 06:36:09'),
(4480, 6985, '2023-05-31', 5, 2, 63, '2023-05-31 06:40:30'),
(4481, 6986, '2023-05-31', 5, 2, 63, '2023-05-31 06:47:30'),
(4482, 6987, '2023-05-31', 5, 2, 63, '2023-05-31 06:52:44'),
(4483, 6988, '2023-05-31', 5, 2, 63, '2023-05-31 07:02:26'),
(4484, 6989, '2023-05-31', 5, 2, 63, '2023-05-31 07:08:21'),
(4485, 6990, '2023-05-31', 5, 1, 63, '2023-05-31 07:54:55');

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

--
-- Struktur dari tabel `tb_gambar`
--

CREATE TABLE `tb_gambar` (
  `id_gambar` int(11) NOT NULL,
  `gambar` blob NOT NULL,
  `nama_gambar` varchar(255) NOT NULL,
  `tipe_gambar` varchar(255) NOT NULL,
  `ukuran_gambar` int(11) NOT NULL,
  `keterangan` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `tb_gambar`
--

INSERT INTO `tb_gambar` (`id_gambar`, `gambar`, `nama_gambar`, `tipe_gambar`, `ukuran_gambar`, `keterangan`) VALUES
(1, 0x[encoded data, 66678 characters], 'Screenshot 2023-10-12 141739.png', 'image/png', 33339, '');

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

--
-- Struktur dari tabel `tb_panggilan_ambil_kartu`
--

CREATE TABLE `tb_panggilan_ambil_kartu` (
  `id_panggilan` int(11) NOT NULL,
  `pencaker_id` int(11) NOT NULL,
  `tanggal_panggilan` date NOT NULL,
  `id_jam` int(11) NOT NULL,
  `loket` int(11) NOT NULL,
  `id_user` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `tb_panggilan_ambil_kartu`
--

INSERT INTO `tb_panggilan_ambil_kartu` (`id_panggilan`, `pencaker_id`, `tanggal_panggilan`, `id_jam`, `loket`, `id_user`) VALUES
(1, 1, '2022-06-09', 0, 0, 42),
(2, 75, '2022-06-22', 0, 0, 42),
(3, 78, '2022-06-22', 0, 0, 42);

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`no`);

--
-- Indeks untuk tabel `master_data_agama`
--
ALTER TABLE `master_data_agama`
  ADD PRIMARY KEY (`id_agama`);

--
-- Indeks untuk tabel `master_data_bahasa`
--
ALTER TABLE `master_data_bahasa`
  ADD PRIMARY KEY (`id_bahasa`);

--
-- Indeks untuk tabel `master_data_disabilitas`
--
ALTER TABLE `master_data_disabilitas`
  ADD PRIMARY KEY (`id_status_disabilitas`);

--
-- Indeks untuk tabel `master_data_gaji`
--
ALTER TABLE `master_data_gaji`
  ADD PRIMARY KEY (`id_gaji`);

--
-- Indeks untuk tabel `master_data_jabatan`
--
ALTER TABLE `master_data_jabatan`
  ADD PRIMARY KEY (`id_jabatan`);

--
-- Indeks untuk tabel `master_data_jam`
--
ALTER TABLE `master_data_jam`
  ADD PRIMARY KEY (`id_jam`);

--
-- Indeks untuk tabel `master_data_jaminan_sosial`
--
ALTER TABLE `master_data_jaminan_sosial`
  ADD PRIMARY KEY (`id_jaminan_sosial`);

--
-- Indeks untuk tabel `master_data_jenis_kelamin`
--
ALTER TABLE `master_data_jenis_kelamin`
  ADD PRIMARY KEY (`id_jenis_kelamin`);

--
-- Indeks untuk tabel `master_data_legalisir`
--
ALTER TABLE `master_data_legalisir`
  ADD PRIMARY KEY (`id_legalisir`);

--
-- Indeks untuk tabel `master_data_log_tte`
--
ALTER TABLE `master_data_log_tte`
  ADD PRIMARY KEY (`id_log_tte`);

--
-- Indeks untuk tabel `master_data_lokasi`
--
ALTER TABLE `master_data_lokasi`
  ADD PRIMARY KEY (`id_lokasi`);

--
-- Indeks untuk tabel `master_data_lowongan`
--
ALTER TABLE `master_data_lowongan`
  ADD PRIMARY KEY (`id_lowongan`);

--
-- Indeks untuk tabel `master_data_lowongan_pekerjaan`
--
ALTER TABLE `master_data_lowongan_pekerjaan`
  ADD PRIMARY KEY (`id_lowongan`);

--
-- Indeks untuk tabel `master_data_pendaftar`
--
ALTER TABLE `master_data_pendaftar`
  ADD PRIMARY KEY (`pencaker_id`),
  ADD KEY `JK` (`jk`),
  ADD KEY `agama` (`agama`),
  ADD KEY `lokasi` (`lokasi`),
  ADD KEY `pendidikan` (`pend`),
  ADD KEY `status` (`status`),
  ADD KEY `gaji` (`gaji`),
  ADD KEY `jabatan` (`jabatan`);

--
-- Indeks untuk tabel `master_data_pendidikan`
--
ALTER TABLE `master_data_pendidikan`
  ADD PRIMARY KEY (`id_pendidikan`);

--
-- Indeks untuk tabel `master_data_penempatan_perusahaan`
--
ALTER TABLE `master_data_penempatan_perusahaan`
  ADD PRIMARY KEY (`id_penempatan_perusahaan`);

--
-- Indeks untuk tabel `master_data_pengajuan_perpanjangan`
--
ALTER TABLE `master_data_pengajuan_perpanjangan`
  ADD PRIMARY KEY (`id_pengajuan_perpanjangan`);

--
-- Indeks untuk tabel `master_data_pengalaman`
--
ALTER TABLE `master_data_pengalaman`
  ADD PRIMARY KEY (`id_pengalaman`);

--
-- Indeks untuk tabel `master_data_penolakan`
--
ALTER TABLE `master_data_penolakan`
  ADD PRIMARY KEY (`id_penolakan`);

--
-- Indeks untuk tabel `master_data_perpanjangan_kartu`
--
ALTER TABLE `master_data_perpanjangan_kartu`
  ADD PRIMARY KEY (`id_perpanjangan`);

--
-- Indeks untuk tabel `master_data_perusahaan`
--
ALTER TABLE `master_data_perusahaan`
  ADD PRIMARY KEY (`id_perusahaan`);

--
-- Indeks untuk tabel `master_data_riwayat_cetak`
--
ALTER TABLE `master_data_riwayat_cetak`
  ADD PRIMARY KEY (`id_riwayat`);

--
-- Indeks untuk tabel `master_data_sistem_pengupahan`
--
ALTER TABLE `master_data_sistem_pengupahan`
  ADD PRIMARY KEY (`id_sistem_pengupahan`);

--
-- Indeks untuk tabel `master_data_status`
--
ALTER TABLE `master_data_status`
  ADD PRIMARY KEY (`id_status`);

--
-- Indeks untuk tabel `master_data_status_hubungan_kerja`
--
ALTER TABLE `master_data_status_hubungan_kerja`
  ADD PRIMARY KEY (`id_status_hubungan_kerja`);

--
-- Indeks untuk tabel `master_data_surat_panggilan`
--
ALTER TABLE `master_data_surat_panggilan`
  ADD PRIMARY KEY (`id_surat_panggilan`);

--
-- Indeks untuk tabel `master_data_surat_pengantar`
--
ALTER TABLE `master_data_surat_pengantar`
  ADD PRIMARY KEY (`id_surat_pengantar`);

--
-- Indeks untuk tabel `master_data_syarat_pendaftaran`
--
ALTER TABLE `master_data_syarat_pendaftaran`
  ADD PRIMARY KEY (`id_syarat_pendaftaran`);

--
-- Indeks untuk tabel `master_data_user`
--
ALTER TABLE `master_data_user`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `master_data_user_lakon`
--
ALTER TABLE `master_data_user_lakon`
  ADD PRIMARY KEY (`id_user`);

--
-- Indeks untuk tabel `master_data_verifikasi_berkas`
--
ALTER TABLE `master_data_verifikasi_berkas`
  ADD PRIMARY KEY (`id_verifikasi`);

--
-- Indeks untuk tabel `tb_gambar`
--
ALTER TABLE `tb_gambar`
  ADD PRIMARY KEY (`id_gambar`);

--
-- Indeks untuk tabel `tb_panggilan_ambil_kartu`
--
ALTER TABLE `tb_panggilan_ambil_kartu`
  ADD PRIMARY KEY (`id_panggilan`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `admin`
--
ALTER TABLE `admin`
  MODIFY `no` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `master_data_agama`
--
ALTER TABLE `master_data_agama`
  MODIFY `id_agama` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT untuk tabel `master_data_bahasa`
--
ALTER TABLE `master_data_bahasa`
  MODIFY `id_bahasa` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT untuk tabel `master_data_disabilitas`
--
ALTER TABLE `master_data_disabilitas`
  MODIFY `id_status_disabilitas` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `master_data_gaji`
--
ALTER TABLE `master_data_gaji`
  MODIFY `id_gaji` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT untuk tabel `master_data_jabatan`
--
ALTER TABLE `master_data_jabatan`
  MODIFY `id_jabatan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT untuk tabel `master_data_jam`
--
ALTER TABLE `master_data_jam`
  MODIFY `id_jam` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT untuk tabel `master_data_jaminan_sosial`
--
ALTER TABLE `master_data_jaminan_sosial`
  MODIFY `id_jaminan_sosial` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT untuk tabel `master_data_jenis_kelamin`
--
ALTER TABLE `master_data_jenis_kelamin`
  MODIFY `id_jenis_kelamin` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `master_data_legalisir`
--
ALTER TABLE `master_data_legalisir`
  MODIFY `id_legalisir` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=320;

--
-- AUTO_INCREMENT untuk tabel `master_data_log_tte`
--
ALTER TABLE `master_data_log_tte`
  MODIFY `id_log_tte` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4813;

--
-- AUTO_INCREMENT untuk tabel `master_data_lokasi`
--
ALTER TABLE `master_data_lokasi`
  MODIFY `id_lokasi` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT untuk tabel `master_data_lowongan`
--
ALTER TABLE `master_data_lowongan`
  MODIFY `id_lowongan` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT untuk tabel `master_data_lowongan_pekerjaan`
--
ALTER TABLE `master_data_lowongan_pekerjaan`
  MODIFY `id_lowongan` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT untuk tabel `master_data_pendaftar`
--
ALTER TABLE `master_data_pendaftar`
  MODIFY `pencaker_id` int(225) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7003;

--
-- AUTO_INCREMENT untuk tabel `master_data_pendidikan`
--
ALTER TABLE `master_data_pendidikan`
  MODIFY `id_pendidikan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT untuk tabel `master_data_penempatan_perusahaan`
--
ALTER TABLE `master_data_penempatan_perusahaan`
  MODIFY `id_penempatan_perusahaan` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT untuk tabel `master_data_pengajuan_perpanjangan`
--
ALTER TABLE `master_data_pengajuan_perpanjangan`
  MODIFY `id_pengajuan_perpanjangan` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT untuk tabel `master_data_pengalaman`
--
ALTER TABLE `master_data_pengalaman`
  MODIFY `id_pengalaman` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2098;

--
-- AUTO_INCREMENT untuk tabel `master_data_penolakan`
--
ALTER TABLE `master_data_penolakan`
  MODIFY `id_penolakan` int(40) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT untuk tabel `master_data_perpanjangan_kartu`
--
ALTER TABLE `master_data_perpanjangan_kartu`
  MODIFY `id_perpanjangan` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT untuk tabel `master_data_perusahaan`
--
ALTER TABLE `master_data_perusahaan`
  MODIFY `id_perusahaan` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT untuk tabel `master_data_riwayat_cetak`
--
ALTER TABLE `master_data_riwayat_cetak`
  MODIFY `id_riwayat` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=320;

--
-- AUTO_INCREMENT untuk tabel `master_data_sistem_pengupahan`
--
ALTER TABLE `master_data_sistem_pengupahan`
  MODIFY `id_sistem_pengupahan` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT untuk tabel `master_data_status`
--
ALTER TABLE `master_data_status`
  MODIFY `id_status` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT untuk tabel `master_data_status_hubungan_kerja`
--
ALTER TABLE `master_data_status_hubungan_kerja`
  MODIFY `id_status_hubungan_kerja` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `master_data_surat_panggilan`
--
ALTER TABLE `master_data_surat_panggilan`
  MODIFY `id_surat_panggilan` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `master_data_surat_pengantar`
--
ALTER TABLE `master_data_surat_pengantar`
  MODIFY `id_surat_pengantar` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `master_data_syarat_pendaftaran`
--
ALTER TABLE `master_data_syarat_pendaftaran`
  MODIFY `id_syarat_pendaftaran` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT untuk tabel `master_data_user`
--
ALTER TABLE `master_data_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;

--
-- AUTO_INCREMENT untuk tabel `master_data_user_lakon`
--
ALTER TABLE `master_data_user_lakon`
  MODIFY `id_user` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5783;

--
-- AUTO_INCREMENT untuk tabel `master_data_verifikasi_berkas`
--
ALTER TABLE `master_data_verifikasi_berkas`
  MODIFY `id_verifikasi` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4486;

--
-- AUTO_INCREMENT untuk tabel `tb_gambar`
--
ALTER TABLE `tb_gambar`
  MODIFY `id_gambar` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `tb_panggilan_ambil_kartu`
--
ALTER TABLE `tb_panggilan_ambil_kartu`
  MODIFY `id_panggilan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

