-- XAMPP-Lite
-- version 8.4.6
-- https://xampplite.sf.net/
--
-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Waktu pembuatan: 09 Jun 2026 pada 14.23
-- Versi server: 11.4.5-MariaDB-log
-- Versi PHP: 8.4.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `tb_expert_laravel`
--

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

--
-- Struktur dari tabel `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `cache`
--

INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES
('laravel-cache-5c785c036466adea360111aa28563bfd556b5fba', 'i:2;', 1781010674),
('laravel-cache-5c785c036466adea360111aa28563bfd556b5fba:timer', 'i:1781010674;', 1781010674),
('laravel-cache-da4b9237bacccdf19c0760cab7aec4a8359010b0', 'i:1;', 1780374589),
('laravel-cache-da4b9237bacccdf19c0760cab7aec4a8359010b0:timer', 'i:1780374589;', 1780374589);

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

--
-- Struktur dari tabel `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `consultations`
--

CREATE TABLE `consultations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `disease_id` bigint(20) UNSIGNED DEFAULT NULL,
  `cf_akhir` decimal(5,4) DEFAULT NULL,
  `cf_persen` decimal(5,2) DEFAULT NULL,
  `interpretasi` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `consultations`
--

INSERT INTO `consultations` (`id`, `user_id`, `disease_id`, `cf_akhir`, `cf_persen`, `interpretasi`, `created_at`, `updated_at`) VALUES
(1, 2, 1, 0.8553, 85.53, 'Hampir Pasti', '2026-05-26 19:14:43', '2026-05-26 19:14:43'),
(2, 2, 4, 0.1600, 16.00, 'Tidak Yakin', '2026-05-27 00:41:21', '2026-05-27 00:41:21'),
(3, 2, 4, 0.4832, 48.32, 'Kemungkinan', '2026-05-27 01:59:20', '2026-05-27 01:59:20'),
(4, 2, 1, 0.9892, 98.92, 'Hampir Pasti', '2026-05-30 06:09:47', '2026-05-30 06:09:47'),
(5, 2, 1, 0.8124, 81.24, 'Hampir Pasti', '2026-06-01 21:22:58', '2026-06-01 21:22:58');

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

--
-- Struktur dari tabel `consultation_details`
--

CREATE TABLE `consultation_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `consultation_id` bigint(20) UNSIGNED NOT NULL,
  `symptom_id` bigint(20) UNSIGNED NOT NULL,
  `bobot_user` decimal(3,2) NOT NULL,
  `cf_individual` decimal(5,4) 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 untuk tabel `consultation_details`
--

INSERT INTO `consultation_details` (`id`, `consultation_id`, `symptom_id`, `bobot_user`, `cf_individual`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 0.60, 0.4200, '2026-05-26 19:14:43', '2026-05-26 19:14:43'),
(2, 1, 2, 0.60, 0.5100, '2026-05-26 19:14:43', '2026-05-26 19:14:43'),
(3, 1, 3, 0.60, 0.3300, '2026-05-26 19:14:43', '2026-05-26 19:14:43'),
(4, 1, 4, 0.60, 0.2400, '2026-05-26 19:14:43', '2026-05-26 19:14:43'),
(5, 2, 18, 0.20, 0.1600, '2026-05-27 00:41:21', '2026-05-27 00:41:21'),
(6, 3, 18, 0.40, 0.3200, '2026-05-27 01:59:20', '2026-05-27 01:59:20'),
(7, 3, 20, 0.40, 0.2400, '2026-05-27 01:59:20', '2026-05-27 01:59:20'),
(8, 4, 1, 1.00, 0.7000, '2026-05-30 06:09:47', '2026-05-30 06:09:47'),
(9, 4, 2, 0.80, 0.6800, '2026-05-30 06:09:47', '2026-05-30 06:09:47'),
(10, 4, 3, 1.00, 0.5500, '2026-05-30 06:09:47', '2026-05-30 06:09:47'),
(11, 4, 4, 1.00, 0.4000, '2026-05-30 06:09:47', '2026-05-30 06:09:47'),
(12, 4, 5, 0.40, 0.2400, '2026-05-30 06:09:47', '2026-05-30 06:09:47'),
(13, 4, 8, 1.00, 0.4500, '2026-05-30 06:09:47', '2026-05-30 06:09:47'),
(14, 5, 1, 0.80, 0.5600, '2026-06-01 21:22:58', '2026-06-01 21:22:58'),
(15, 5, 5, 0.80, 0.4800, '2026-06-01 21:22:58', '2026-06-01 21:22:58'),
(16, 5, 8, 0.40, 0.1800, '2026-06-01 21:22:58', '2026-06-01 21:22:58');

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

--
-- Struktur dari tabel `diseases`
--

CREATE TABLE `diseases` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `kode` varchar(10) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `deskripsi` text DEFAULT NULL,
  `gejala_umum` text DEFAULT NULL,
  `saran_penanganan` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `diseases`
--

INSERT INTO `diseases` (`id`, `kode`, `nama`, `deskripsi`, `gejala_umum`, `saran_penanganan`, `created_at`, `updated_at`) VALUES
(1, 'P001', 'Tuberkulosis Paru', 'Tuberkulosis Paru adalah infeksi Mycobacterium tuberculosis yang menyerang jaringan paru-paru dan dapat menular melalui udara.', 'Batuk berdahak, batuk berdarah, sesak napas, nyeri dada, demam, keringat malam, penurunan berat badan, dan nafsu makan menurun.', 'Segera ke puskesmas, lakukan pemeriksaan dahak (TCM/BTA) dan rontgen dada.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(2, 'P002', 'Tuberkulosis Kelenjar', 'Tuberkulosis Kelenjar adalah infeksi TB yang menyerang kelenjar getah bening, terutama pada area leher, ketiak, atau selangkangan.', 'Pembengkakan kelenjar getah bening di leher, benjolan di ketiak, demam ringan, benjolan lunak tidak nyeri, penurunan berat badan, dan nafsu makan menurun.', 'Konsultasi dokter untuk biopsi kelenjar getah bening.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(3, 'P003', 'Tuberkulosis Tulang', 'Tuberkulosis Tulang adalah infeksi TB yang menyerang tulang dan sendi, termasuk tulang belakang atau Pott\'s disease.', 'Nyeri punggung kronis, kaku sendi, pembengkakan tulang atau sendi, lemah otot, demam, dan keterbatasan gerak.', 'Konsultasi dokter spesialis ortopedi dan hindari aktivitas berat.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(4, 'P004', 'Tuberkulosis Otak (Meningitis TB)', 'Tuberkulosis Otak atau Meningitis TB adalah infeksi TB yang menyerang selaput otak dan merupakan bentuk TB yang paling berbahaya.', 'Sakit kepala berat, kaku kuduk, mual muntah, kejang, penurunan kesadaran, fotofobia, dan demam tinggi.', 'SEGERA ke IGD rumah sakit, ini darurat medis.', '2026-05-26 19:12:46', '2026-05-26 19:12:46');

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

--
-- Struktur dari tabel `failed_jobs`
--

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

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

--
-- Struktur dari tabel `jobs`
--

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

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

--
-- Struktur dari tabel `job_batches`
--

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

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

--
-- Struktur dari tabel `migrations`
--

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

--
-- Dumping data untuk tabel `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_05_05_094827_create_diseases_table', 1),
(5, '2026_05_05_094828_create_symptoms_table', 1),
(6, '2026_05_05_094828_z_create_rules_table', 1),
(7, '2026_05_05_094829_create_consultations_table', 1),
(8, '2026_05_05_094829_z_create_consultation_details_table', 1);

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

--
-- Struktur dari tabel `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `rules`
--

CREATE TABLE `rules` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `disease_id` bigint(20) UNSIGNED NOT NULL,
  `symptom_id` bigint(20) UNSIGNED NOT NULL,
  `mb` decimal(3,2) NOT NULL,
  `md` decimal(3,2) NOT NULL,
  `cf_pakar` decimal(4,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 untuk tabel `rules`
--

INSERT INTO `rules` (`id`, `disease_id`, `symptom_id`, `mb`, `md`, `cf_pakar`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 0.80, 0.10, 0.70, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(2, 1, 2, 0.90, 0.05, 0.85, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(3, 1, 3, 0.70, 0.15, 0.55, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(4, 1, 4, 0.60, 0.20, 0.40, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(5, 1, 5, 0.70, 0.10, 0.60, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(6, 1, 6, 0.65, 0.10, 0.55, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(7, 1, 7, 0.75, 0.10, 0.65, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(8, 1, 8, 0.60, 0.15, 0.45, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(9, 2, 9, 0.85, 0.05, 0.80, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(10, 2, 10, 0.75, 0.10, 0.65, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(11, 2, 11, 0.65, 0.10, 0.55, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(12, 2, 12, 0.70, 0.10, 0.60, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(13, 2, 7, 0.75, 0.10, 0.65, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(14, 2, 8, 0.60, 0.15, 0.45, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(15, 3, 13, 0.80, 0.10, 0.70, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(16, 3, 14, 0.75, 0.10, 0.65, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(17, 3, 15, 0.70, 0.10, 0.60, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(18, 3, 16, 0.65, 0.10, 0.55, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(19, 3, 5, 0.70, 0.10, 0.60, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(20, 3, 17, 0.70, 0.10, 0.60, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(21, 4, 18, 0.85, 0.05, 0.80, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(22, 4, 19, 0.90, 0.05, 0.85, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(23, 4, 20, 0.70, 0.10, 0.60, '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(24, 4, 21, 0.80, 0.05, 0.75, '2026-05-26 19:12:46', '2026-05-26 19:12:46');

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

--
-- Struktur dari tabel `sessions`
--

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

--
-- Dumping data untuk tabel `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('D0JunN9eEXJu6IpMO0ssGQW3QOU4VGjPDUDc3eX6', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.123.0 Chrome/148.0.7778.97 Electron/42.2.0 Safari/537.36', 'eyJfdG9rZW4iOiIweHN1c3Q4eGxEc2RUUWtiRlIxdlV0dVJKNHJoQzJTYlNXREpaS1ZnIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDAwIiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=', 1781012318),
('vkCkjzvX9FqfGhae2t0nq8lL9mrCbXxZuTSuPVfr', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJGQ2FSREpKRDVFVmVFaWxuejVxdXJzR1BMVjFLNjhQa2J0Rlo4blJUIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDAwXC9sb2dpbiIsInJvdXRlIjoibG9naW4ifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1781014689);

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

--
-- Struktur dari tabel `symptoms`
--

CREATE TABLE `symptoms` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `kode` varchar(10) NOT NULL,
  `nama_gejala` varchar(200) NOT NULL,
  `deskripsi_gejala` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `symptoms`
--

INSERT INTO `symptoms` (`id`, `kode`, `nama_gejala`, `deskripsi_gejala`, `created_at`, `updated_at`) VALUES
(1, 'G001', 'Batuk berdahak selama 2-3 minggu atau lebih', 'Batuk produktif yang berlangsung lama, biasanya disertai dahak.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(2, 'G002', 'Batuk berdarah', 'Terdapat darah segar atau dahak bercampur darah saat batuk.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(3, 'G003', 'Sesak napas', 'Napas terasa berat atau sulit, terutama saat beraktivitas.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(4, 'G004', 'Nyeri dada', 'Rasa sakit atau tidak nyaman pada area dada, terutama saat bernapas dalam atau batuk.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(5, 'G005', 'Demam', 'Suhu tubuh meningkat, sering muncul pada sore atau malam hari.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(6, 'G006', 'Berkeringat pada malam hari tanpa aktivitas', 'Keringat berlebihan saat tidur meskipun tidak melakukan aktivitas berat.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(7, 'G007', 'Penurunan berat badan tanpa sebab jelas', 'Berat badan turun tanpa diet, olahraga berat, atau penyebab yang jelas.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(8, 'G008', 'Nafsu makan menurun', 'Selera makan berkurang dalam jangka waktu cukup lama.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(9, 'G009', 'Pembengkakan kelenjar getah bening di leher', 'Teraba benjolan atau pembesaran kelenjar pada area leher.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(10, 'G010', 'Benjolan di ketiak atau area selangkangan', 'Pembesaran kelenjar getah bening pada ketiak, selangkangan, atau area lain.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(11, 'G011', 'Demam ringan berkepanjangan', 'Demam ringan yang berlangsung lama dan dapat hilang timbul.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(12, 'G012', 'Benjolan terasa lunak dan tidak nyeri', 'Benjolan teraba lunak atau kenyal dan umumnya tidak menimbulkan rasa sakit.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(13, 'G013', 'Nyeri punggung kronis', 'Nyeri pada punggung atau tulang belakang yang berlangsung lama dan dapat semakin berat.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(14, 'G014', 'Kaku pada sendi', 'Sendi terasa kaku, terutama setelah lama tidak bergerak.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(15, 'G015', 'Pembengkakan pada tulang atau sendi', 'Area tulang atau sendi tampak bengkak dan dapat terasa nyeri.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(16, 'G016', 'Kelemahan otot pada anggota gerak', 'Otot terasa lemah, terutama jika infeksi mengenai tulang belakang.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(17, 'G017', 'Keterbatasan gerak pada tulang belakang atau sendi', 'Gerakan menjadi terbatas, seperti sulit membungkuk, memutar badan, atau menggerakkan sendi.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(18, 'G018', 'Sakit kepala berat dan terus-menerus', 'Nyeri kepala hebat yang tidak mudah membaik dan berlangsung terus-menerus.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(19, 'G019', 'Kaku kuduk atau leher terasa kaku', 'Leher terasa kaku sehingga sulit menunduk atau menggerakkan kepala.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(20, 'G020', 'Mual dan muntah', 'Rasa mual berat disertai muntah yang dapat terjadi berulang.', '2026-05-26 19:12:46', '2026-05-26 19:12:46'),
(21, 'G021', 'Kejang', 'Serangan kejang mendadak yang dapat disertai penurunan kesadaran.', '2026-05-26 19:12:46', '2026-05-26 19:12:46');

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

--
-- Struktur dari tabel `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `role` enum('user','admin') NOT NULL DEFAULT 'user',
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Administrator', 'admin@tb.com', NULL, '$2y$12$bmJgIvmoERPJocFDK3DFHOBKjVeZVUxNbwSFKHoVit1qkpyfhdBeC', 'admin', NULL, '2026-05-26 19:12:45', '2026-05-26 19:12:45'),
(2, 'User Test', 'user@tb.com', NULL, '$2y$12$5RoZ0RBP5Nl4tOr8yFHnNud1lP0t5x.4a53wTDOTNjcRsl83VIkUy', 'user', NULL, '2026-05-26 19:12:46', '2026-05-26 19:12:46');

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_expiration_index` (`expiration`);

--
-- Indeks untuk tabel `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_locks_expiration_index` (`expiration`);

--
-- Indeks untuk tabel `consultations`
--
ALTER TABLE `consultations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `consultations_user_id_foreign` (`user_id`),
  ADD KEY `consultations_disease_id_foreign` (`disease_id`);

--
-- Indeks untuk tabel `consultation_details`
--
ALTER TABLE `consultation_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `consultation_details_consultation_id_foreign` (`consultation_id`),
  ADD KEY `consultation_details_symptom_id_foreign` (`symptom_id`);

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

--
-- Indeks untuk tabel `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

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

--
-- Indeks untuk tabel `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indeks untuk tabel `rules`
--
ALTER TABLE `rules`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rules_disease_id_foreign` (`disease_id`),
  ADD KEY `rules_symptom_id_foreign` (`symptom_id`);

--
-- Indeks untuk tabel `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

--
-- Indeks untuk tabel `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `consultations`
--
ALTER TABLE `consultations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT untuk tabel `consultation_details`
--
ALTER TABLE `consultation_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT untuk tabel `diseases`
--
ALTER TABLE `diseases`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT untuk tabel `rules`
--
ALTER TABLE `rules`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT untuk tabel `symptoms`
--
ALTER TABLE `symptoms`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT untuk tabel `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
--

--
-- Ketidakleluasaan untuk tabel `consultations`
--
ALTER TABLE `consultations`
  ADD CONSTRAINT `consultations_disease_id_foreign` FOREIGN KEY (`disease_id`) REFERENCES `diseases` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `consultations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `consultation_details`
--
ALTER TABLE `consultation_details`
  ADD CONSTRAINT `consultation_details_consultation_id_foreign` FOREIGN KEY (`consultation_id`) REFERENCES `consultations` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `consultation_details_symptom_id_foreign` FOREIGN KEY (`symptom_id`) REFERENCES `symptoms` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `rules`
--
ALTER TABLE `rules`
  ADD CONSTRAINT `rules_disease_id_foreign` FOREIGN KEY (`disease_id`) REFERENCES `diseases` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `rules_symptom_id_foreign` FOREIGN KEY (`symptom_id`) REFERENCES `symptoms` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;