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

START TRANSACTION;



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

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

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` smallint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

--
-- Table structure for table `laboratories`
--

CREATE TABLE `laboratories` (
  `id` bigint UNSIGNED NOT NULL,
  `kategori` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_pemeriksaan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `harga_purwokerto_baru` int NOT NULL,
  `harga_cilacap_baru` int NOT NULL,
  `harga_wonosobo_baru` int NOT NULL,
  `harga_yogyakarta_baru` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `laboratories`
--

INSERT INTO `laboratories` (`id`, `kategori`, `nama_pemeriksaan`, `harga_purwokerto_baru`, `harga_cilacap_baru`, `harga_wonosobo_baru`, `harga_yogyakarta_baru`, `created_at`, `updated_at`) VALUES
(1, 'Hematologi', 'Darah Lengkap/Rutin', 80000, 80000, 80000, 80000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(2, 'Hematologi', 'Hemoglobin', 30000, 30000, 25000, 30000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(3, 'Hematologi', 'Lekosit', 30000, 30000, 25000, 30000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(4, 'Hematologi', 'Hitung Jenis Lekosit', 30000, 30000, 25000, 30000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(5, 'Hematologi', 'Laju Endap Darah', 30000, 30000, 25000, 30000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(6, 'Hematologi', 'Eritrosit', 30000, 30000, 25000, 30000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(7, 'Hematologi', 'Hematokrit', 30000, 30000, 25000, 30000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(8, 'Hematologi', 'Trombosit', 30000, 30000, 25000, 30000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(9, 'Hematologi', 'Gambaran Darah Tepi', 150000, 150000, 125000, 150000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(10, 'Hematologi', 'Waktu Pendarahan (BT)', 75000, 75000, 25000, 75000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(11, 'Hematologi', 'Waktu Pembekuan (CT)', 75000, 75000, 25000, 75000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(12, 'Hematologi', 'Golongan Darah ABO + RH', 20000, 20000, 20000, 20000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(13, 'Hematologi', 'Malaria', 125000, 125000, 75000, 125000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(14, 'Hematologi', 'Faktor Rhesus', 20000, 20000, 20000, 20000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(15, 'Sero Imunologi', 'HBsAg (ELISA)', 200000, 200000, 175000, 200000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(16, 'Sero Imunologi', 'HBs Ag Kualitatif', 125000, 125000, 75000, 125000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(17, 'Sero Imunologi', 'Anti HBs', 150000, 150000, 75000, 150000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(18, 'Sero Imunologi', 'Anti HCV (ELISA)', 150000, 150000, 200000, 200000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(19, 'Sero Imunologi', 'Anti HIV (ELISA)', 200000, 250000, 50000, 50000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(20, 'Sero Imunologi', 'VDRL', 50000, 50000, 75000, 75000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(21, 'Sero Imunologi', 'TPHA', 110000, 110000, 110000, 110000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(22, 'Sero Imunologi', 'Widal (8 parameter)', 300000, 300000, 150000, 150000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(23, 'Sero Imunologi', 'IgG/m Salmonella', 200000, 200000, 125000, 200000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(24, 'Sero Imunologi', 'IgG/m Dengue', 750000, 750000, 750000, 750000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(25, 'Kimia Klinik', 'SGOT', 40000, 40000, 30000, 40000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(26, 'Kimia Klinik', 'SGPT', 40000, 40000, 30000, 40000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(27, 'Kimia Klinik', 'Bilirubin Total', 60000, 60000, 40000, 55000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(28, 'Kimia Klinik', 'Bilirubin Direk', 100000, 100000, 75000, 100000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(29, 'Kimia Klinik', 'Protein Total', 65000, 65000, 50000, 65000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(30, 'Kimia Klinik', 'Albumin', 65000, 65000, 45000, 65000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(31, 'Kimia Klinik', 'Globulin', 65000, 65000, 45000, 65000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(32, 'Kimia Klinik', 'Gamma GT', 125000, 125000, 170000, 125000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(33, 'Kimia Klinik', 'Alkali Phospate', 110000, 110000, 110000, 110000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(34, 'Glukosa', 'Glukosa Puasa', 30000, 30000, 30000, 30000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(35, 'Glukosa', 'Glukosa 2 Jam PP', 30000, 30000, 30000, 30000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(36, 'Glukosa', 'Glukosa Sewaktu', 30000, 30000, 30000, 30000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(37, 'Glukosa', 'HbA1c', 175000, 200000, 175000, 175000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(38, 'Fungsi Ginjal', 'Ureum', 40000, 40000, 35000, 40000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(39, 'Fungsi Ginjal', 'Creatinine', 50000, 50000, 35000, 50000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(40, 'Fungsi Ginjal', 'Asam Urat', 45000, 45000, 35000, 45000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(41, 'Lemak Darah', 'Trigliseride', 55000, 55000, 40000, 55000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(42, 'Lemak Darah', 'Kolesterol', 55000, 55000, 40000, 55000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(43, 'Lemak Darah', 'Kolesterol HDL', 55000, 55000, 45000, 55000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(44, 'Lemak Darah', 'Kolesterol LDL', 75000, 75000, 70000, 75000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(45, 'Lemak Darah', 'Profil Lemak', 240000, 240000, 150000, 240000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(46, 'Mikrobiologi', 'Feses Rutin', 45000, 45000, 50000, 45000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(47, 'Mikrobiologi', 'BTA SPS', 100000, 100000, 100000, 100000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(48, 'Urinalisis', 'Urine Lengkap', 35000, 35000, 35000, 35000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(49, 'Urinalisis', 'Urine 3 Parameter', 35000, 35000, 35000, 35000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(50, 'Urinalisis', 'Microalbuminaria', 150000, 150000, 150000, 150000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(51, 'Lain Lain', 'Amphetamine', 65000, 65000, 65000, 65000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(52, 'Lain Lain', 'Marijuana', 65000, 65000, 65000, 65000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(53, 'Lain Lain', 'Morfin', 65000, 65000, 65000, 65000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(54, 'Lain Lain', 'Opiat', 65000, 65000, 65000, 65000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(55, 'Lain Lain', 'Methampethamin', 65000, 65000, 65000, 65000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(56, 'Lain Lain', 'Benzo', 65000, 65000, 65000, 65000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(57, 'Lain Lain', 'Phencyclidine', 250000, 250000, 250000, 250000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(58, 'Lain Lain', 'Pap Smear', 200000, 200000, 200000, 200000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(59, 'Lain Lain', 'Audiometri', 125000, 125000, 125000, 125000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(60, 'Lain Lain', 'Spirometri', 125000, 125000, 125000, 125000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(61, 'Lain Lain', 'Treadmill', 800000, 800000, 500000, 800000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(62, 'Lain Lain', 'USG Abdomen', 200000, 200000, 250000, 250000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(63, 'Lain Lain', 'EKG', 85000, 85000, 125000, 85000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(64, 'Lain Lain', 'Mata', 250000, 250000, 250000, 250000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(65, 'Lain Lain', 'Konsul', 35000, 35000, 35000, 35000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(66, 'Lain Lain', 'Fisik dan Dokter', 55000, 55000, 55000, 55000, '2026-06-17 09:52:39', '2026-06-22 00:44:31'),
(67, 'Lain Lain', 'Rectal Swab', 350000, 350000, 350000, 350000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(68, 'Lain Lain', 'Dental Test (Rujuk Joydental)', 200000, 200000, 200000, 200000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(69, 'Lain Lain', 'Mantoux (Rujuk Omnia)', 250000, 250000, 250000, 250000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(70, 'Lain Lain', 'Pemeriksaan Mata (dr. Spesialis)', 250000, 250000, 250000, 250000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(71, 'Vaksinasi', 'Inactivated Polio Vaccine (IPV)', 345000, 345000, 345000, 345000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(72, 'Vaksinasi', 'Meningtis Menivax', 335000, 335000, 335000, 335000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(73, 'Vaksinasi', 'Yellow Fever (Stamaril)', 550000, 550000, 550000, 550000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(74, 'Vaksinasi', 'Hepatitis A (Avaxim) Booster', 650000, 650000, 650000, 650000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(75, 'Vaksinasi', 'Hepatitis A Combo + Demam Typ', 1000000, 1000000, 1000000, 1000000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(76, 'Vaksinasi', 'Hepatitis B (Euvax Adult)', 300000, 300000, 300000, 300000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(77, 'Vaksinasi', 'Typhim (Typhoid)', 465000, 465000, 465000, 465000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(78, 'Vaksinasi', 'Influenza Flubio', 270000, 270000, 270000, 270000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(79, 'Vaksinasi', 'Influenza Caxigrip Adult', 400000, 400000, 400000, 400000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(80, 'Vaksinasi', 'Influenza Flu Quadri Adult NH', 650000, 650000, 650000, 650000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(81, 'Vaksinasi', 'Combo Vak Meningitis + Influenz', 500000, 500000, 500000, 500000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(82, 'Vaksinasi', 'Combo Vak Meningitis + Influenz (Extended)', 700000, 700000, 700000, 700000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(83, 'Radiologi', 'Thorax PA (Dewasa)', 115000, 115000, 105000, 115000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(84, 'Radiologi', 'Thorax PA (Anak)', 115000, 115000, 105000, 115000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(85, 'Radiologi', 'Thorax AP/Lat (Dewasa)', 175000, 175000, 175000, 175000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(86, 'Radiologi', 'Thorax AP/Lat (Anak)', 155000, 155000, 155000, 155000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(87, 'Radiologi', 'Thorax Costae', 115000, 115000, 100000, 115000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(88, 'Radiologi', 'Clavicula', 115000, 115000, 100000, 115000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(89, 'Radiologi', 'Shoulder joint (bahu)', 125000, 125000, 125000, 125000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(90, 'Radiologi', 'Humerus (lengan atas)', 125000, 125000, 125000, 125000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(91, 'Radiologi', 'Elbow Joint (Siku)', 125000, 125000, 125000, 125000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(92, 'Radiologi', 'Antebrachii (lengan bawah)', 125000, 125000, 125000, 125000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(93, 'Radiologi', 'Manus (telapak tangan)', 125000, 125000, 125000, 125000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(94, 'Radiologi', 'Wrist joint', 125000, 125000, 100000, 115000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(95, 'Radiologi', 'Digiti (jari)', 115000, 115000, 115000, 165000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(96, 'Radiologi', 'Femur (paha)', 165000, 165000, 150000, 150000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(97, 'Radiologi', 'Hip Joint', 150000, 150000, 135000, 135000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(98, 'Radiologi', 'Art. Genu (lutut)', 135000, 135000, 150000, 150000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(99, 'Radiologi', 'Cruris (tungkai)', 150000, 150000, 135000, 135000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(100, 'Radiologi', 'Ankle Joint', 135000, 135000, 135000, 135000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(101, 'Radiologi', 'Pedis (Kaki)', 135000, 135000, 110000, 110000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(102, 'Radiologi', 'Pelvis (panggul)', 115000, 115000, 110000, 110000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(103, 'Radiologi', 'Costae', 115000, 115000, 175000, 175000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(104, 'Radiologi', 'Vertebrae cervical 2 posisi', 175000, 175000, 200000, 200000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(105, 'Radiologi', 'Vertebrae cervical 3 posisi', 200000, 200000, 200000, 200000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(106, 'Radiologi', 'Vertebrae Thoracal 2 posisi', 200000, 200000, 250000, 250000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(107, 'Radiologi', 'Vertebrae Thoracal 3 posisi', 250000, 250000, 200000, 200000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(108, 'Radiologi', 'Vertebrae Lumbal 2 posisi', 200000, 200000, 250000, 250000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(109, 'Radiologi', 'Vertebrae Lumbal 3 posisi', 250000, 250000, 125000, 125000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(110, 'Radiologi', 'Vertebrae coccigeal 2 posisi', 125000, 125000, 200000, 200000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(111, 'Radiologi', 'Vertebrae coccigeal 3 posisi', 200000, 200000, 150000, 150000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(112, 'Radiologi', 'Cranium AP/Lat', 150000, 150000, 150000, 150000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(113, 'Radiologi', 'Sinus paranasal', 150000, 150000, 150000, 150000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(114, 'Radiologi', 'Orbita', 150000, 150000, 150000, 150000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(115, 'Radiologi', 'TMJ (Temporomandibular.J)', 150000, 150000, 150000, 150000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(116, 'Radiologi', 'Nassal', 150000, 150000, 150000, 150000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(117, 'Radiologi', 'Maxilla', 150000, 150000, 150000, 150000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(118, 'Radiologi', 'Mandibula (Townes, Eisler)', 150000, 150000, 150000, 150000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(119, 'Radiologi', 'Mastoid', 150000, 150000, 150000, 150000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(120, 'Radiologi', 'BNO (Abdomen Polos)', 110000, 110000, 110000, 110000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(121, 'Radiologi', 'Abdomen 2 posisi', 200000, 200000, 200000, 200000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(122, 'Radiologi', 'Abdomen 3 posisi', 250000, 250000, 250000, 250000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(123, 'Radiologi', 'Elektrolit (Kalium, Natrium, Klorida)', 400000, 400000, 400000, 400000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(124, 'Radiologi', 'Elektrolit (Kalium, Natrium, Kalsium, Klorida)', 500000, 500000, 500000, 500000, '2026-06-17 09:52:39', '2026-06-17 09:52:39'),
(125, 'Mikrobiologi', 'Kultur Feses', 900000, 900000, 900000, 900000, '2026-06-21 23:34:57', '2026-06-21 23:34:57');

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

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

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_06_16_145753_create_laboratories_table', 1),
(5, '2026_06_17_145101_create_packages_table', 1),
(6, '2026_06_17_145104_create_package_laboratory_table', 1),
(7, '2026_06_17_235310_create_payments_table', 2),
(8, '2026_06_18_024745_update_nama_pasien_in_payments_table', 3),
(9, '2026_06_18_092222_add_piutang_columns_to_payments_table', 4),
(10, '2026_06_18_095322_add_tipe_pelanggan_to_payments_table', 5),
(11, '2026_06_21_152356_create_payment_package_table', 6),
(12, '2026_06_21_153055_remove_package_id_from_payments_table', 7);

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

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` bigint UNSIGNED NOT NULL,
  `nama_paket` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `harga_paket` decimal(15,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` (`id`, `nama_paket`, `harga_paket`, `created_at`, `updated_at`) VALUES
(1, 'MCU JEPANG (BP2MI)', 1000000.00, '2026-06-17 09:50:28', '2026-06-17 10:27:27'),
(2, 'PAKET MCU PT CHEMCO,ARAI,IPM DLL', 175000.00, '2026-06-17 09:50:28', '2026-06-17 10:27:27'),
(3, 'PT MARDIZU SEJAHTERA PAKET 1', 200000.00, '2026-06-17 09:50:28', '2026-06-17 10:27:27'),
(4, 'STANDAR SINGAPURA / HONGKONG GCU', 1055000.00, '2026-06-17 09:50:28', '2026-06-21 22:59:24'),
(5, 'GCU MALAYSIA NON TKI', 1065000.00, '2026-06-17 09:50:28', '2026-06-17 10:27:27'),
(6, 'MCU PRA MEDIKAL / SCREENING', 250000.00, '2026-06-17 09:56:47', '2026-06-21 08:43:42'),
(7, '[SATUAN] Darah Lengkap/Rutin', 80000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(8, '[SATUAN] Hemoglobin', 30000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(9, '[SATUAN] Lekosit', 30000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(10, '[SATUAN] Hitung Jenis Lekosit', 30000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(11, '[SATUAN] Laju Endap Darah', 30000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(12, '[SATUAN] Eritrosit', 30000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(13, '[SATUAN] Hematokrit', 30000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(14, '[SATUAN] Trombosit', 30000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(15, '[SATUAN] Gambaran Darah Tepi', 150000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(16, '[SATUAN] Waktu Pendarahan (BT)', 75000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(17, '[SATUAN] Waktu Pembekuan (CT)', 75000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(18, '[SATUAN] Golongan Darah ABO + RH', 20000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(19, '[SATUAN] Malaria', 125000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(20, '[SATUAN] Faktor Rhesus', 20000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(21, '[SATUAN] HBsAg (ELISA)', 200000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(22, '[SATUAN] HBs Ag Kualitatif', 125000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(23, '[SATUAN] Anti HBs', 150000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(24, '[SATUAN] Anti HCV (ELISA)', 150000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(25, '[SATUAN] Anti HIV (ELISA)', 200000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(26, '[SATUAN] VDRL', 50000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(27, '[SATUAN] TPHA', 110000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(28, '[SATUAN] Widal (8 parameter)', 300000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(29, '[SATUAN] IgG/m Salmonella', 200000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(30, '[SATUAN] IgG/m Dengue', 750000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(31, '[SATUAN] SGOT', 40000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(32, '[SATUAN] SGPT', 40000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(33, '[SATUAN] Bilirubin Total', 60000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(34, '[SATUAN] Bilirubin Direk', 100000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(35, '[SATUAN] Protein Total', 65000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(36, '[SATUAN] Albumin', 65000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(37, '[SATUAN] Globulin', 65000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(38, '[SATUAN] Gamma GT', 125000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(39, '[SATUAN] Alkali Phospate', 110000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(40, '[SATUAN] Glukosa Puasa', 30000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(41, '[SATUAN] Glukosa 2 Jam PP', 30000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(42, '[SATUAN] Glukosa Sewaktu', 30000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(43, '[SATUAN] HbA1c', 175000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(44, '[SATUAN] Ureum', 40000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(45, '[SATUAN] Creatinine', 50000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(46, '[SATUAN] Asam Urat', 45000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(47, '[SATUAN] Trigliseride', 55000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(48, '[SATUAN] Kolesterol', 55000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(49, '[SATUAN] Kolesterol HDL', 55000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(50, '[SATUAN] Kolesterol LDL', 75000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(51, '[SATUAN] Profil Lemak', 240000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(52, '[SATUAN] Feses Rutin', 45000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(53, '[SATUAN] BTA SPS', 100000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(54, '[SATUAN] Urine Lengkap', 35000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(55, '[SATUAN] Urine 3 Parameter', 35000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(56, '[SATUAN] Microalbuminaria', 150000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(57, '[SATUAN] Amphetamine', 65000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(58, '[SATUAN] Marijuana', 65000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(59, '[SATUAN] Morfin', 65000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(60, '[SATUAN] Opiat', 65000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(61, '[SATUAN] Methampethamin', 65000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(62, '[SATUAN] Benzo', 65000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(63, '[SATUAN] Phencyclidine', 250000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(64, '[SATUAN] Pap Smear', 200000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(65, '[SATUAN] Audiometri', 125000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(66, '[SATUAN] Spirometri', 125000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(67, '[SATUAN] Treadmill', 800000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(68, '[SATUAN] USG Abdomen', 200000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(69, '[SATUAN] EKG', 85000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(70, '[SATUAN] Mata', 250000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(71, '[SATUAN] Konsul', 35000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(72, '[SATUAN] Fisik + Dokter', 55000.00, '2026-06-18 03:13:01', '2026-06-21 23:04:44'),
(73, '[SATUAN] Rectal Swab', 350000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(74, '[SATUAN] Dental Test (Rujuk Joydental)', 200000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(75, '[SATUAN] Mantoux (Rujuk Omnia)', 250000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(76, '[SATUAN] Pemeriksaan Mata (dr. Spesialis)', 250000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(77, '[SATUAN] Inactivated Polio Vaccine (IPV)', 345000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(78, '[SATUAN] Meningtis Menivax', 335000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(79, '[SATUAN] Yellow Fever (Stamaril)', 550000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(80, '[SATUAN] Hepatitis A (Avaxim) Booster', 650000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(81, '[SATUAN] Hepatitis A Combo + Demam Typ', 1000000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(82, '[SATUAN] Hepatitis B (Euvax Adult)', 300000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(83, '[SATUAN] Typhim (Typhoid)', 465000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(84, '[SATUAN] Influenza Flubio', 270000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(85, '[SATUAN] Influenza Caxigrip Adult', 400000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(86, '[SATUAN] Influenza Flu Quadri Adult NH', 650000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(87, '[SATUAN] Combo Vak Meningitis + Influenz', 500000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(88, '[SATUAN] Combo Vak Meningitis + Influenz (Extended)', 700000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(89, '[SATUAN] Thorax PA (Dewasa)', 115000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(90, '[SATUAN] Thorax PA (Anak)', 115000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(91, '[SATUAN] Thorax AP/Lat (Dewasa)', 175000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(92, '[SATUAN] Thorax AP/Lat (Anak)', 155000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(93, '[SATUAN] Thorax Costae', 115000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(94, '[SATUAN] Clavicula', 115000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(95, '[SATUAN] Shoulder joint (bahu)', 125000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(96, '[SATUAN] Humerus (lengan atas)', 125000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(97, '[SATUAN] Elbow Joint (Siku)', 125000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(98, '[SATUAN] Antebrachii (lengan bawah)', 125000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(99, '[SATUAN] Manus (telapak tangan)', 125000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(100, '[SATUAN] Wrist joint', 125000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(101, '[SATUAN] Digiti (jari)', 115000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(102, '[SATUAN] Femur (paha)', 165000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(103, '[SATUAN] Hip Joint', 150000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(104, '[SATUAN] Art. Genu (lutut)', 135000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(105, '[SATUAN] Cruris (tungkai)', 150000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(106, '[SATUAN] Ankle Joint', 135000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(107, '[SATUAN] Pedis (Kaki)', 135000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(108, '[SATUAN] Pelvis (panggul)', 115000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(109, '[SATUAN] Costae', 115000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(110, '[SATUAN] Vertebrae cervical 2 posisi', 175000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(111, '[SATUAN] Vertebrae cervical 3 posisi', 200000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(112, '[SATUAN] Vertebrae Thoracal 2 posisi', 200000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(113, '[SATUAN] Vertebrae Thoracal 3 posisi', 250000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(114, '[SATUAN] Vertebrae Lumbal 2 posisi', 200000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(115, '[SATUAN] Vertebrae Lumbal 3 posisi', 250000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(116, '[SATUAN] Vertebrae coccigeal 2 posisi', 125000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(117, '[SATUAN] Vertebrae coccigeal 3 posisi', 200000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(118, '[SATUAN] Cranium AP/Lat', 150000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(119, '[SATUAN] Sinus paranasal', 150000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(120, '[SATUAN] Orbita', 150000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(121, '[SATUAN] TMJ (Temporomandibular.J)', 150000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(122, '[SATUAN] Nassal', 150000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(123, '[SATUAN] Maxilla', 150000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(124, '[SATUAN] Mandibula (Townes, Eisler)', 150000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(125, '[SATUAN] Mastoid', 150000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(126, '[SATUAN] BNO (Abdomen Polos)', 110000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(127, '[SATUAN] Abdomen 2 posisi', 200000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(128, '[SATUAN] Abdomen 3 posisi', 250000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(129, '[SATUAN] Elektrolit (Kalium, Natrium, Klorida)', 400000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(130, '[SATUAN] Elektrolit (Kalium, Natrium, Kalsium, Klorida)', 500000.00, '2026-06-18 03:13:01', '2026-06-18 03:13:01'),
(131, 'PT MEKAR ARMADA', 250000.00, '2026-06-21 22:49:11', '2026-06-21 22:49:11'),
(132, 'JEPANG MAHASISWA PERTANIAN / BU TUTI /UNSOED', 1000000.00, '2026-06-21 23:14:59', '2026-06-21 23:38:41');

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

--
-- Table structure for table `package_laboratory`
--

CREATE TABLE `package_laboratory` (
  `package_id` bigint UNSIGNED NOT NULL,
  `laboratory_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `package_laboratory`
--

INSERT INTO `package_laboratory` (`package_id`, `laboratory_id`) VALUES
(1, 20),
(1, 21),
(1, 25),
(1, 26),
(1, 59),
(1, 63),
(2, 48),
(3, 48),
(4, 20),
(4, 21),
(4, 25),
(4, 26),
(4, 38),
(5, 20),
(5, 21),
(5, 25),
(5, 26),
(5, 38),
(6, 20),
(1, 1),
(1, 15),
(1, 32),
(1, 36),
(1, 41),
(1, 42),
(1, 47),
(1, 48),
(1, 66),
(1, 83),
(2, 12),
(2, 15),
(2, 66),
(2, 83),
(3, 1),
(3, 66),
(3, 83),
(4, 1),
(4, 12),
(4, 15),
(4, 19),
(4, 36),
(4, 39),
(4, 47),
(4, 48),
(4, 66),
(4, 83),
(5, 1),
(5, 12),
(5, 15),
(5, 19),
(5, 36),
(5, 39),
(5, 47),
(5, 48),
(5, 66),
(5, 83),
(6, 15),
(6, 48),
(6, 66),
(6, 83),
(131, 1),
(131, 66),
(131, 83),
(131, 48),
(132, 1),
(132, 12),
(132, 16),
(132, 22),
(132, 48),
(132, 59),
(132, 66),
(132, 125),
(132, 83);

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

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

CREATE TABLE `payments` (
  `id` bigint UNSIGNED NOT NULL,
  `harga_dasar` decimal(15,2) NOT NULL,
  `diskon` decimal(15,2) NOT NULL DEFAULT '0.00',
  `total_bayar` decimal(15,2) NOT NULL,
  `tipe_pelanggan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pribadi',
  `nama_pasien` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status_pembayaran` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'lunas',
  `nama_instansi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jatuh_tempo` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `payments` (`id`, `harga_dasar`, `diskon`, `total_bayar`, `tipe_pelanggan`, `nama_pasien`, `created_at`, `updated_at`, `status_pembayaran`, `nama_instansi`, `jatuh_tempo`) VALUES
(1, 250000.00, 0.00, 250000.00, 'pribadi', 'MOCHAMMAD REZA DITYA P', '2026-06-17 18:01:37', '2026-06-17 18:15:31', 'lunas', NULL, NULL),
(2, 85000.00, 0.00, 85000.00, 'pribadi', 'MOCHAMMAD REZA DITYA P', '2026-06-17 20:13:37', '2026-06-17 20:13:37', 'lunas', NULL, NULL),
(3, 250000.00, 0.00, 250000.00, 'pt', 'ALDILA EVA SUCI WULANDARI', '2026-06-18 02:57:09', '2026-06-18 03:06:02', 'piutang', 'LPK MASTER', '2026-07-18'),
(4, 250000.00, 0.00, 250000.00, 'lpk', 'FIRLI', '2026-06-19 03:47:33', '2026-06-21 09:54:57', 'piutang', 'LPK MASTER', '2026-07-19'),
(5, 250000.00, 0.00, 250000.00, 'pt', 'BUNGA', '2026-06-19 04:19:08', '2026-06-21 09:26:35', 'piutang', 'GRAHA MITRA BALINDO', '2026-07-21'),
(6, 90000.00, 0.00, 90000.00, 'pribadi', 'PASIEN', '2026-06-21 08:32:01', '2026-06-21 08:32:01', 'lunas', NULL, NULL);

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

--
-- Table structure for table `payment_package`
--

CREATE TABLE `payment_package` (
  `id` bigint UNSIGNED NOT NULL,
  `payment_id` bigint UNSIGNED NOT NULL,
  `package_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_package`
--

INSERT INTO `payment_package` (`id`, `payment_id`, `package_id`, `created_at`, `updated_at`) VALUES
(1, 6, 44, '2026-06-21 08:32:02', '2026-06-21 08:32:02'),
(2, 6, 45, '2026-06-21 08:32:02', '2026-06-21 08:32:02'),
(3, 3, 6, '2026-06-21 08:44:17', '2026-06-21 08:44:17'),
(4, 4, 6, '2026-06-21 08:45:30', '2026-06-21 08:45:30'),
(5, 1, 6, '2026-06-21 08:53:05', '2026-06-21 08:53:05'),
(6, 2, 69, '2026-06-21 09:06:15', '2026-06-21 09:06:15'),
(7, 5, 6, '2026-06-21 09:26:35', '2026-06-21 09:26:35');

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

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

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('8OdDiLuZeu0nf27VpJuqEXWfOySRfeNJZXRoQRFb', NULL, '16.58.56.214', 'visionheight.com/scan Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) Chrome/126.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJGZjMxSXF3WmVNVTlzNDhnTjM1eWtwS2Zjek03YVBOQm83NXE0Q2dTIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEwMy4yNTUuMjQxLjEwNzo4MDAwIiwicm91dGUiOm51bGx9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19', 1782113129),
('sD9Qmv7ziF8lUzLJ0Q8vdcUcazbtuLy52Zk2LKSY', 3, '182.253.58.78', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJBeHY3MVJNNmJ4TE0yUlZ0Y3JoSTRBcWpiaHYxdU1pOGJ1TGZaNVFiIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvMTAzLjI1NS4yNDEuMTA3OjgwMDBcL2FkbWluXC9waXV0YW5ncyIsInJvdXRlIjoiZmlsYW1lbnQuYWRtaW4ucmVzb3VyY2VzLnBpdXRhbmdzLmluZGV4In0sImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjozLCJwYXNzd29yZF9oYXNoX3dlYiI6IjUyYTkxM2QwYmFkNjFiMTkwMjkyZmZkMGNkOTU3NzNiYjQyMzZlOTNhMDY5NTgwNmU4YTQ4ZDdjMmU2YWZjMzEiLCJmaWxhbWVudCI6W119', 1782117303),
('SfoRL3tKJB8WHBRhM2kBzMgZ9jxaXi990pdYKnge', NULL, '16.58.56.214', 'visionheight.com/scan Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) Chrome/126.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJUbjVUc1NLSGs0NWdxYnZZR1VrNVlJQ04zMUd5akhCeURDMHFpSXZ0IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEwMy4yNTUuMjQxLjEwNzo4MDAwIiwicm91dGUiOm51bGx9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19', 1782113109),
('XMVImX6GbHKSW3Z1JZCwiLHVCslWaGrhB2Uijc7i', NULL, '16.58.56.214', 'visionheight.com/scan Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) Chrome/126.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJOYnJOeTg5MmlodXluMEFaSHdGNGtDWm8xSnNTS3ZCNGdJS3V2ZDhxIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEwMy4yNTUuMjQxLjEwNzo4MDAwXC9hZG1pblwvbG9naW4iLCJyb3V0ZSI6ImZpbGFtZW50LmFkbWluLmF1dGgubG9naW4ifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1782113110),
('xP5iZPGb1VJ2ke8MYJi9pVOm2RRAO3mHP8mN8Nyi', NULL, '45.194.67.26', 'curl/7.68.0', 'eyJfdG9rZW4iOiJqcW5vak4zMG5wUng2cGVRRU9EWGFVc08wMHJhYjdyR3RqZW8zaFAyIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzAuMC4wLjA6ODAwMCIsInJvdXRlIjpudWxsfSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1782108289);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`),
  ADD KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `laboratories`
--
ALTER TABLE `laboratories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `packages`
--
ALTER TABLE `packages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `package_laboratory`
--
ALTER TABLE `package_laboratory`
  ADD KEY `package_laboratory_package_id_foreign` (`package_id`),
  ADD KEY `package_laboratory_laboratory_id_foreign` (`laboratory_id`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payment_package`
--
ALTER TABLE `payment_package`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payment_package_payment_id_foreign` (`payment_id`),
  ADD KEY `payment_package_package_id_foreign` (`package_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `laboratories`
--
ALTER TABLE `laboratories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=126;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=133;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `payment_package`
--
ALTER TABLE `payment_package`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `package_laboratory`
--
ALTER TABLE `package_laboratory`
  ADD CONSTRAINT `package_laboratory_laboratory_id_foreign` FOREIGN KEY (`laboratory_id`) REFERENCES `laboratories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_laboratory_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `payment_package`
--
ALTER TABLE `payment_package`
  ADD CONSTRAINT `payment_package_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payment_package_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE CASCADE;
COMMIT;

