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

START TRANSACTION;



--
-- Database: `laundry_dss`
--

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

--
-- Table structure for table `active_config`
--

CREATE TABLE `active_config` (
  `id` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `config_id` int DEFAULT NULL,
  `activated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `active_config`
--

INSERT INTO `active_config` (`id`, `user_id`, `config_id`, `activated_at`) VALUES
(18, NULL, 11, '2025-12-19 05:22:30'),
(20, 1, 13, '2025-12-20 08:17:30'),
(21, 2, 14, '2025-12-24 00:29:21');

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

--
-- Table structure for table `daily_predictions`
--

CREATE TABLE `daily_predictions` (
  `id` int NOT NULL,
  `prediction_date` date NOT NULL,
  `hari` varchar(10) NOT NULL,
  `durasi_predicted` varchar(20) DEFAULT NULL,
  `durasi_confidence` decimal(5,2) DEFAULT NULL,
  `antar_predicted` varchar(20) DEFAULT NULL,
  `antar_confidence` decimal(5,2) DEFAULT NULL,
  `langganan_predicted` varchar(20) DEFAULT NULL,
  `langganan_confidence` decimal(5,2) DEFAULT NULL,
  `config_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `daily_predictions`
--

INSERT INTO `daily_predictions` (`id`, `prediction_date`, `hari`, `durasi_predicted`, `durasi_confidence`, `antar_predicted`, `antar_confidence`, `langganan_predicted`, `langganan_confidence`, `config_id`, `created_at`) VALUES
(1, '2025-12-17', 'Rabu', 'Reguler', '83.10', 'Tidak', '36.10', 'Ya', '94.50', 9, '2025-12-17 22:45:07');

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

--
-- Table structure for table `laundry_data`
--

CREATE TABLE `laundry_data` (
  `id` int NOT NULL,
  `hari` varchar(10) DEFAULT NULL,
  `layanan` varchar(50) DEFAULT NULL,
  `kuantitas` varchar(10) DEFAULT NULL,
  `jenis_kelamin` varchar(10) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `durasi` varchar(10) DEFAULT NULL,
  `antar` varchar(5) DEFAULT NULL,
  `langganan` varchar(5) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `laundry_data`
--

INSERT INTO `laundry_data` (`id`, `hari`, `layanan`, `kuantitas`, `jenis_kelamin`, `status`, `durasi`, `antar`, `langganan`, `created_at`, `user_id`) VALUES
(400, 'Sabtu', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(401, 'Sabtu', 'Cuci Kering', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(402, 'Sabtu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(403, 'Minggu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(404, 'Minggu', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(405, 'Minggu', 'Cuci Kering', 'Kiloan', 'Pria', 'Mahasiswa', 'Express', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(406, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Tidak Diketahui', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(407, 'Senin', 'Cuci Setrika', 'Kiloan', 'Pria', 'Tidak Diketahui', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(408, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(409, 'Selasa', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(410, 'Selasa', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Express', 'Tidak', 'Tidak', '2025-12-19 05:03:57', 1),
(411, 'Selasa', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(412, 'Rabu', 'Cuci Setrika', 'Satuan', 'Pria', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(413, 'Rabu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Express', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(414, 'Rabu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(415, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(416, 'Kamis', 'Cuci Setrika', 'Satuan', 'Pria', 'Pegawai', 'Reguler', 'Tidak', 'Tidak', '2025-12-19 05:03:57', 1),
(417, 'Kamis', 'Cuci Setrika', 'Kiloan', 'Pria', 'Lainnya', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(418, 'Jumat', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(419, 'Jumat', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Tidak', 'Tidak', '2025-12-19 05:03:57', 1),
(420, 'Jumat', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(421, 'Sabtu', 'Cuci Setrika', 'Kiloan', 'Pria', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(422, 'Sabtu', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Express', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(423, 'Sabtu', 'Cuci Setrika', 'Satuan', 'Pria', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(424, 'Minggu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(425, 'Minggu', 'Cuci Setrika', 'Kiloan', 'Pria', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(426, 'Minggu', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(427, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'IRT', 'Express', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(428, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(429, 'Senin', 'Cuci Setrika', 'Satuan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(430, 'Rabu', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(431, 'Rabu', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Tidak', '2025-12-19 05:03:57', 1),
(432, 'Rabu', 'Cuci Kering', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(433, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(434, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(435, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(436, 'Jumat', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Express', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(437, 'Jumat', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(438, 'Jumat', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(439, 'Minggu', 'Cuci Setrika', 'Kiloan', 'Pria', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(440, 'Minggu', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(441, 'Minggu', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(442, 'Senin', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(443, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(444, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(445, 'Selasa', 'Cuci Setrika', 'Kiloan', 'Pria', 'Pegawai', 'Express', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(446, 'Selasa', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(447, 'Selasa', 'Cuci Setrika', 'Kiloan', 'Pria', 'Mahasiswa', 'Express', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(448, 'Rabu', 'Cuci Setrika', 'Kiloan', 'Pria', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(449, 'Rabu', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Express', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(450, 'Rabu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(451, 'Kamis', 'Cuci Kering', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(452, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(453, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(454, 'Jumat', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(455, 'Jumat', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(456, 'Jumat', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(457, 'Minggu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(458, 'Minggu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(459, 'Minggu', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(460, 'Senin', 'Cuci Setrika', 'Kiloan', 'Wanita', 'IRT', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(461, 'Senin', 'Cuci Kering', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(462, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(463, 'Selasa', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(464, 'Selasa', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(465, 'Selasa', 'Cuci Setrika', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(466, 'Rabu', 'Cuci Setrika', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(467, 'Rabu', 'Cuci Setrika', 'Satuan', 'Pria', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(468, 'Rabu', 'Cuci Kering', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(469, 'Kamis', 'Cuci Setrika', 'Kiloan', 'Pria', 'Tidak Diketahui', 'Express', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(470, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(471, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(472, 'Jumat', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(473, 'Jumat', 'Cuci Kering', 'Kiloan', 'Wanita', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(474, 'Jumat', 'Cuci Kering', 'Kiloan', 'Wanita', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(475, 'Sabtu', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Tidak Diketahui', 'Reguler', 'Ya', 'Tidak', '2025-12-19 05:03:57', 1),
(476, 'Sabtu', 'Cuci Kering', 'Kiloan', 'Pria', 'Lainnya', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(477, 'Sabtu', 'Cuci Setrika', 'Kiloan', 'Pria', 'Tidak Diketahui', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(478, 'Minggu', 'Cuci Kering', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(479, 'Minggu', 'Setrika Saja', 'Kiloan', 'Wanita', 'Tidak Diketahui', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(480, 'Minggu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(481, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(482, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(483, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(484, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(485, 'Senin', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(486, 'Selasa', 'Cuci Kering', 'Kiloan', 'Pria', 'Tidak Diketahui', 'Express', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(487, 'Selasa', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Lainnya', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(488, 'Selasa', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(489, 'Rabu', 'Cuci Kering', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(490, 'Rabu', 'Cuci Setrika', 'Satuan', 'Wanita', 'Tidak Diketahui', 'Reguler', 'Tidak', 'Tidak', '2025-12-19 05:03:57', 1),
(491, 'Rabu', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(492, 'Rabu', 'Cuci Kering', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(493, 'Rabu', 'Cuci Setrika', 'Satuan', 'Wanita', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(494, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(495, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(496, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(497, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-19 05:03:57', 1),
(498, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(499, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-19 05:03:57', 1),
(500, 'Sabtu', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(501, 'Sabtu', 'Cuci Kering', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(502, 'Sabtu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(503, 'Minggu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(504, 'Minggu', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(505, 'Minggu', 'Cuci Kering', 'Kiloan', 'Pria', 'Mahasiswa', 'Express', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(506, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Tidak Diketahui', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(507, 'Senin', 'Cuci Setrika', 'Kiloan', 'Pria', 'Tidak Diketahui', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(508, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(509, 'Selasa', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(510, 'Selasa', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Express', 'Tidak', 'Tidak', '2025-12-24 00:27:40', 2),
(511, 'Selasa', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(512, 'Rabu', 'Cuci Setrika', 'Satuan', 'Pria', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(513, 'Rabu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Express', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(514, 'Rabu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(515, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(516, 'Kamis', 'Cuci Setrika', 'Satuan', 'Pria', 'Pegawai', 'Reguler', 'Tidak', 'Tidak', '2025-12-24 00:27:40', 2),
(517, 'Kamis', 'Cuci Setrika', 'Kiloan', 'Pria', 'Lainnya', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(518, 'Jumat', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(519, 'Jumat', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Tidak', 'Tidak', '2025-12-24 00:27:40', 2),
(520, 'Jumat', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(521, 'Sabtu', 'Cuci Setrika', 'Kiloan', 'Pria', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(522, 'Sabtu', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Express', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(523, 'Sabtu', 'Cuci Setrika', 'Satuan', 'Pria', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(524, 'Minggu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(525, 'Minggu', 'Cuci Setrika', 'Kiloan', 'Pria', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(526, 'Minggu', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(527, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'IRT', 'Express', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(528, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(529, 'Senin', 'Cuci Setrika', 'Satuan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(530, 'Rabu', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(531, 'Rabu', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Tidak', '2025-12-24 00:27:40', 2),
(532, 'Rabu', 'Cuci Kering', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(533, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(534, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(535, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(536, 'Jumat', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Express', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(537, 'Jumat', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(538, 'Jumat', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(539, 'Minggu', 'Cuci Setrika', 'Kiloan', 'Pria', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(540, 'Minggu', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(541, 'Minggu', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(542, 'Senin', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(543, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(544, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(545, 'Selasa', 'Cuci Setrika', 'Kiloan', 'Pria', 'Pegawai', 'Express', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(546, 'Selasa', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(547, 'Selasa', 'Cuci Setrika', 'Kiloan', 'Pria', 'Mahasiswa', 'Express', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(548, 'Rabu', 'Cuci Setrika', 'Kiloan', 'Pria', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(549, 'Rabu', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Express', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(550, 'Rabu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(551, 'Kamis', 'Cuci Kering', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(552, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(553, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(554, 'Jumat', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(555, 'Jumat', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(556, 'Jumat', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(557, 'Minggu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(558, 'Minggu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(559, 'Minggu', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(560, 'Senin', 'Cuci Setrika', 'Kiloan', 'Wanita', 'IRT', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(561, 'Senin', 'Cuci Kering', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(562, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(563, 'Selasa', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(564, 'Selasa', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(565, 'Selasa', 'Cuci Setrika', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(566, 'Rabu', 'Cuci Setrika', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(567, 'Rabu', 'Cuci Setrika', 'Satuan', 'Pria', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(568, 'Rabu', 'Cuci Kering', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(569, 'Kamis', 'Cuci Setrika', 'Kiloan', 'Pria', 'Tidak Diketahui', 'Express', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(570, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(571, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(572, 'Jumat', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(573, 'Jumat', 'Cuci Kering', 'Kiloan', 'Wanita', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(574, 'Jumat', 'Cuci Kering', 'Kiloan', 'Wanita', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(575, 'Sabtu', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Tidak Diketahui', 'Reguler', 'Ya', 'Tidak', '2025-12-24 00:27:40', 2),
(576, 'Sabtu', 'Cuci Kering', 'Kiloan', 'Pria', 'Lainnya', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(577, 'Sabtu', 'Cuci Setrika', 'Kiloan', 'Pria', 'Tidak Diketahui', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(578, 'Minggu', 'Cuci Kering', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(579, 'Minggu', 'Setrika Saja', 'Kiloan', 'Wanita', 'Tidak Diketahui', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(580, 'Minggu', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(581, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(582, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(583, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Express', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(584, 'Senin', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(585, 'Senin', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(586, 'Selasa', 'Cuci Kering', 'Kiloan', 'Pria', 'Tidak Diketahui', 'Express', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(587, 'Selasa', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Lainnya', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(588, 'Selasa', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(589, 'Rabu', 'Cuci Kering', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(590, 'Rabu', 'Cuci Setrika', 'Satuan', 'Wanita', 'Tidak Diketahui', 'Reguler', 'Tidak', 'Tidak', '2025-12-24 00:27:40', 2),
(591, 'Rabu', 'Cuci Setrika', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(592, 'Rabu', 'Cuci Kering', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(593, 'Rabu', 'Cuci Setrika', 'Satuan', 'Wanita', 'Pegawai', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(594, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(595, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(596, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Mahasiswa', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(597, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Pria', 'Mahasiswa', 'Reguler', 'Tidak', 'Ya', '2025-12-24 00:27:40', 2),
(598, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2),
(599, 'Kamis', 'Cuci Kering Lipat', 'Kiloan', 'Wanita', 'Pegawai', 'Reguler', 'Ya', 'Ya', '2025-12-24 00:27:40', 2);

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

--
-- Table structure for table `model_accuracy`
--

CREATE TABLE `model_accuracy` (
  `id` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `model_type` varchar(20) DEFAULT NULL,
  `accuracy` decimal(5,2) DEFAULT NULL,
  `training_percentage` int DEFAULT NULL,
  `config_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `model_accuracy`
--

INSERT INTO `model_accuracy` (`id`, `user_id`, `model_type`, `accuracy`, `training_percentage`, `config_id`, `created_at`) VALUES
(1, NULL, 'durasi', '88.50', 80, 1, '2025-12-14 10:18:50'),
(2, NULL, 'antar', '85.50', 80, 1, '2025-12-14 10:18:50'),
(3, NULL, 'langganan', '90.50', 80, 1, '2025-12-14 10:18:50'),
(4, NULL, 'durasi', '86.00', 75, 2, '2025-12-14 10:41:25'),
(5, NULL, 'antar', '83.00', 75, 2, '2025-12-14 10:41:25'),
(6, NULL, 'langganan', '88.00', 75, 2, '2025-12-14 10:41:25'),
(7, NULL, 'durasi', '86.00', 75, 3, '2025-12-16 03:41:50'),
(8, NULL, 'antar', '83.00', 75, 3, '2025-12-16 03:41:50'),
(9, NULL, 'langganan', '88.00', 75, 3, '2025-12-16 03:41:50'),
(10, NULL, 'durasi', '80.00', 80, 4, '2025-12-16 23:30:15'),
(11, NULL, 'antar', '40.00', 80, 4, '2025-12-16 23:30:15'),
(12, NULL, 'langganan', '95.00', 80, 4, '2025-12-16 23:30:15'),
(13, NULL, 'durasi', '72.00', 75, 5, '2025-12-16 23:33:08'),
(14, NULL, 'antar', '40.00', 75, 5, '2025-12-16 23:33:08'),
(15, NULL, 'langganan', '92.00', 75, 5, '2025-12-16 23:33:08'),
(16, NULL, 'durasi', '88.89', 80, 6, '2025-12-17 00:40:14'),
(17, NULL, 'antar', '55.56', 80, 6, '2025-12-17 00:40:14'),
(18, NULL, 'langganan', '94.44', 80, 6, '2025-12-17 00:40:14'),
(19, NULL, 'durasi', '86.96', 75, 7, '2025-12-17 00:41:36'),
(20, NULL, 'antar', '60.87', 75, 7, '2025-12-17 00:41:36'),
(21, NULL, 'langganan', '95.65', 75, 7, '2025-12-17 00:41:36'),
(22, NULL, 'durasi', '88.89', 80, 8, '2025-12-17 01:48:44'),
(23, NULL, 'antar', '55.56', 80, 8, '2025-12-17 01:48:44'),
(24, NULL, 'langganan', '94.44', 80, 8, '2025-12-17 01:48:44'),
(25, NULL, 'durasi', '86.96', 75, 9, '2025-12-17 03:20:45'),
(26, NULL, 'antar', '60.87', 75, 9, '2025-12-17 03:20:45'),
(27, NULL, 'langganan', '95.65', 75, 9, '2025-12-17 03:20:45'),
(28, NULL, 'durasi', '88.89', 80, 10, '2025-12-18 00:36:06'),
(29, NULL, 'antar', '55.56', 80, 10, '2025-12-18 00:36:06'),
(30, NULL, 'langganan', '94.44', 80, 10, '2025-12-18 00:36:06'),
(31, NULL, 'durasi', '86.96', 75, 11, '2025-12-19 05:22:30'),
(32, NULL, 'antar', '60.87', 75, 11, '2025-12-19 05:22:30'),
(33, NULL, 'langganan', '95.65', 75, 11, '2025-12-19 05:22:30'),
(34, 1, 'durasi', '88.89', 80, 12, '2025-12-19 06:59:11'),
(35, 1, 'antar', '55.56', 80, 12, '2025-12-19 06:59:11'),
(36, 1, 'langganan', '94.44', 80, 12, '2025-12-19 06:59:11'),
(37, 1, 'durasi', '86.96', 75, 13, '2025-12-20 08:17:30'),
(38, 1, 'antar', '60.87', 75, 13, '2025-12-20 08:17:30'),
(39, 1, 'langganan', '95.65', 75, 13, '2025-12-20 08:17:30'),
(40, 2, 'durasi', '81.03', 70, 14, '2025-12-24 00:29:21'),
(41, 2, 'antar', '77.59', 70, 14, '2025-12-24 00:29:21'),
(42, 2, 'langganan', '96.55', 70, 14, '2025-12-24 00:29:21');

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

--
-- Table structure for table `predictions_history`
--

CREATE TABLE `predictions_history` (
  `id` int NOT NULL,
  `prediction_date` date NOT NULL,
  `hari` varchar(10) NOT NULL,
  `feature_type` varchar(20) NOT NULL,
  `predicted_value` varchar(20) NOT NULL,
  `confidence` decimal(5,2) NOT NULL,
  `raw_confidence` decimal(5,2) DEFAULT NULL,
  `data_count` int DEFAULT NULL,
  `config_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `predictions_history`
--

INSERT INTO `predictions_history` (`id`, `prediction_date`, `hari`, `feature_type`, `predicted_value`, `confidence`, `raw_confidence`, `data_count`, `config_id`, `created_at`) VALUES
(1, '2025-12-17', 'Rabu', 'durasi', 'Reguler', '84.20', '96.80', 17, 9, '2025-12-17 22:31:44'),
(2, '2025-12-17', 'Rabu', 'antar', 'Tidak', '37.10', '61.00', 17, 9, '2025-12-17 22:31:44'),
(3, '2025-12-17', 'Rabu', 'langganan', 'Ya', '94.80', '99.20', 17, 9, '2025-12-17 22:31:44'),
(4, '2025-12-17', 'Rabu', 'durasi', 'Reguler', '84.20', '96.80', 17, 9, '2025-12-17 22:31:45'),
(5, '2025-12-17', 'Rabu', 'antar', 'Tidak', '37.10', '61.00', 17, 9, '2025-12-17 22:31:45'),
(6, '2025-12-17', 'Rabu', 'langganan', 'Ya', '94.80', '99.20', 17, 9, '2025-12-17 22:31:45'),
(7, '2025-12-17', 'Rabu', 'durasi', 'Reguler', '84.20', '96.80', 17, 9, '2025-12-17 22:31:51'),
(8, '2025-12-17', 'Rabu', 'antar', 'Tidak', '37.10', '61.00', 17, 9, '2025-12-17 22:31:51'),
(9, '2025-12-17', 'Rabu', 'langganan', 'Ya', '94.80', '99.20', 17, 9, '2025-12-17 22:31:51'),
(10, '2025-12-17', 'Rabu', 'durasi', 'Reguler', '84.20', '96.80', 17, 9, '2025-12-17 22:33:52'),
(11, '2025-12-17', 'Rabu', 'antar', 'Tidak', '37.10', '61.00', 17, 9, '2025-12-17 22:33:52'),
(12, '2025-12-17', 'Rabu', 'langganan', 'Ya', '94.80', '99.20', 17, 9, '2025-12-17 22:33:52'),
(13, '2025-12-17', 'Rabu', 'durasi', 'Reguler', '84.20', '96.80', 17, 9, '2025-12-17 22:35:52'),
(14, '2025-12-17', 'Rabu', 'antar', 'Tidak', '37.10', '61.00', 17, 9, '2025-12-17 22:35:52'),
(15, '2025-12-17', 'Rabu', 'langganan', 'Ya', '94.80', '99.20', 17, 9, '2025-12-17 22:35:52'),
(16, '2025-12-17', 'Rabu', 'durasi', 'Reguler', '84.20', '96.80', 17, 9, '2025-12-17 22:37:52'),
(17, '2025-12-17', 'Rabu', 'antar', 'Tidak', '37.10', '61.00', 17, 9, '2025-12-17 22:37:52'),
(18, '2025-12-17', 'Rabu', 'langganan', 'Ya', '94.80', '99.20', 17, 9, '2025-12-17 22:37:52'),
(19, '2025-12-17', 'Rabu', 'durasi', 'Reguler', '84.20', '96.80', 17, 9, '2025-12-17 22:39:52'),
(20, '2025-12-17', 'Rabu', 'antar', 'Tidak', '37.10', '61.00', 17, 9, '2025-12-17 22:39:52'),
(21, '2025-12-17', 'Rabu', 'langganan', 'Ya', '94.80', '99.20', 17, 9, '2025-12-17 22:39:52'),
(22, '2025-12-17', 'Rabu', 'durasi', 'Reguler', '84.20', '96.80', 17, 9, '2025-12-17 22:41:52'),
(23, '2025-12-17', 'Rabu', 'antar', 'Tidak', '37.10', '61.00', 17, 9, '2025-12-17 22:41:52'),
(24, '2025-12-17', 'Rabu', 'langganan', 'Ya', '94.80', '99.20', 17, 9, '2025-12-17 22:41:52'),
(25, '2025-12-17', 'Rabu', 'durasi', 'Reguler', '84.20', '96.80', 17, 9, '2025-12-17 22:43:52'),
(26, '2025-12-17', 'Rabu', 'antar', 'Tidak', '37.10', '61.00', 17, 9, '2025-12-17 22:43:52'),
(27, '2025-12-17', 'Rabu', 'langganan', 'Ya', '94.80', '99.20', 17, 9, '2025-12-17 22:43:52'),
(28, '2025-12-17', 'Rabu', 'durasi', 'Reguler', '84.20', '96.80', 17, 9, '2025-12-17 23:42:43'),
(29, '2025-12-17', 'Rabu', 'antar', 'Tidak', '37.10', '61.00', 17, 9, '2025-12-17 23:42:43'),
(30, '2025-12-17', 'Rabu', 'langganan', 'Ya', '94.80', '99.20', 17, 9, '2025-12-17 23:42:43');

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

--
-- Table structure for table `saved_models`
--

CREATE TABLE `saved_models` (
  `id` int NOT NULL,
  `model_name` varchar(100) NOT NULL,
  `config_id` int NOT NULL,
  `accuracy_durasi` decimal(5,2) DEFAULT NULL,
  `accuracy_antar` decimal(5,2) DEFAULT NULL,
  `accuracy_langganan` decimal(5,2) DEFAULT NULL,
  `training_percentage` int DEFAULT NULL,
  `total_data` int DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `training_configs`
--

CREATE TABLE `training_configs` (
  `id` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `training_percentage` int NOT NULL,
  `random_state` int DEFAULT '42',
  `total_data` int DEFAULT NULL,
  `training_data_count` int DEFAULT NULL,
  `testing_data_count` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `training_configs`
--

INSERT INTO `training_configs` (`id`, `user_id`, `training_percentage`, `random_state`, `total_data`, `training_data_count`, `testing_data_count`, `created_at`) VALUES
(1, NULL, 80, 42, 99, 79, 20, '2025-12-14 10:18:50'),
(2, NULL, 75, 42, 99, 74, 25, '2025-12-14 10:41:25'),
(3, NULL, 75, 42, 100, 75, 25, '2025-12-16 03:41:50'),
(4, NULL, 80, 42, 100, 80, 20, '2025-12-16 23:30:15'),
(5, NULL, 75, 42, 100, 75, 25, '2025-12-16 23:33:08'),
(6, NULL, 80, 42, 100, 82, 18, '2025-12-17 00:40:14'),
(7, NULL, 75, 42, 100, 77, 23, '2025-12-17 00:41:36'),
(8, NULL, 80, 42, 100, 82, 18, '2025-12-17 01:48:44'),
(9, NULL, 75, 42, 100, 77, 23, '2025-12-17 03:20:45'),
(10, NULL, 80, 42, 100, 82, 18, '2025-12-18 00:36:06'),
(11, NULL, 75, 42, 100, 77, 23, '2025-12-19 05:22:30'),
(12, 1, 80, 42, 100, 82, 18, '2025-12-19 06:59:11'),
(13, 1, 75, 42, 100, 77, 23, '2025-12-20 08:17:30'),
(14, 2, 70, 42, 200, 142, 58, '2025-12-24 00:29:21');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `active_config`
--
ALTER TABLE `active_config`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `daily_predictions`
--
ALTER TABLE `daily_predictions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_date` (`prediction_date`);

--
-- Indexes for table `laundry_data`
--
ALTER TABLE `laundry_data`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`);

--
-- Indexes for table `model_accuracy`
--
ALTER TABLE `model_accuracy`
  ADD PRIMARY KEY (`id`),
  ADD KEY `config_id` (`config_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `predictions_history`
--
ALTER TABLE `predictions_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_date` (`prediction_date`),
  ADD KEY `idx_feature` (`feature_type`);

--
-- Indexes for table `saved_models`
--
ALTER TABLE `saved_models`
  ADD PRIMARY KEY (`id`),
  ADD KEY `config_id` (`config_id`);

--
-- Indexes for table `training_configs`
--
ALTER TABLE `training_configs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `active_config`
--
ALTER TABLE `active_config`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `daily_predictions`
--
ALTER TABLE `daily_predictions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `laundry_data`
--
ALTER TABLE `laundry_data`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=600;

--
-- AUTO_INCREMENT for table `model_accuracy`
--
ALTER TABLE `model_accuracy`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `predictions_history`
--
ALTER TABLE `predictions_history`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `saved_models`
--
ALTER TABLE `saved_models`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `training_configs`
--
ALTER TABLE `training_configs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `active_config`
--
ALTER TABLE `active_config`
  ADD CONSTRAINT `active_config_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_accuracy`
--
ALTER TABLE `model_accuracy`
  ADD CONSTRAINT `model_accuracy_ibfk_1` FOREIGN KEY (`config_id`) REFERENCES `training_configs` (`id`),
  ADD CONSTRAINT `model_accuracy_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `saved_models`
--
ALTER TABLE `saved_models`
  ADD CONSTRAINT `saved_models_ibfk_1` FOREIGN KEY (`config_id`) REFERENCES `training_configs` (`id`);

--
-- Constraints for table `training_configs`
--
ALTER TABLE `training_configs`
  ADD CONSTRAINT `training_configs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

