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

START TRANSACTION;



--
-- Database: `dbcounselling`
--

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

--
-- Table structure for table `educations`
--

CREATE TABLE `educations` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `university` varchar(255) DEFAULT NULL,
  `study_program` varchar(255) DEFAULT NULL,
  `year_start` year(4) DEFAULT NULL,
  `year_end` year(4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `educations`
--

INSERT INTO `educations` (`id`, `user_id`, `university`, `study_program`, `year_start`, `year_end`, `created_at`, `updated_at`) VALUES
(1, 3, 'Universitas Negeri Jakarta', 'Psikologi', NULL, 2020, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(2, 4, 'Universitas Udayana', 'Psikologi', NULL, 2015, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(3, 4, 'Universitas Surabaya', 'Magister Psikologi Profesi', NULL, 2019, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(4, 5, 'Universitas Surabaya', 'Psikologi', NULL, 2017, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(5, 5, 'Universitas Surabaya', 'Magister Profesi Psikologi', NULL, 2020, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(6, 6, 'Universitas Gadjah Mada', 'Psikologi', NULL, 2009, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(7, 6, 'Universitas Gadjah Mada', 'Psikologi Profesi', NULL, 2013, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(8, 7, 'Universitas Sumatera Utara', 'Psikologi', NULL, 2022, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(9, 8, 'Universitas Islam Indonesia', 'Psikologi', NULL, 2013, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(10, 8, 'Universitas Gadjah Mada', 'Magister Profesi Psikologi Pendidikan', NULL, 2017, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(11, 9, 'UIN Sunan Kalijaga Yogyakarta', 'Psikologi', NULL, 2011, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(12, 9, 'Universitas Islam Indonesia', 'PIO', NULL, 2016, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(13, 10, 'Universitas Medan Area', 'Psikologi', NULL, 2013, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(14, 10, 'Universitas Sumatera Utara', 'Psikologi Profesi / Pendidikan', NULL, 2019, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(15, 11, 'Universitas Sumatera Utara', 'Psikologi', NULL, 2011, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(16, 11, 'Universitas Gadjah Mada', 'Magister Psikologi Profesi', NULL, 2018, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(17, 12, 'Universitas Surabaya', 'Psikologi', NULL, 2015, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(18, 12, 'Universitas Surabaya', 'Psikologi - Klinis', NULL, 2020, '2024-09-10 06:58:04', '2024-09-10 06:58:04'),
(45, 1, 'UPN', 'Psikologi', 2013, 2017, '2024-09-12 00:08:44', '2024-09-12 01:20:09'),
(46, 1, 'UGM', 'Psikologi', 2018, 2020, '2024-09-12 01:20:09', '2024-09-12 01:20:09');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text 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(20) UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) 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;

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

--
-- Table structure for table `password_resets`
--

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

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

--
-- Table structure for table `password_reset_tokens`
--

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

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL 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 for table `personal_access_tokens`
--

INSERT INTO `personal_access_tokens` (`id`, `tokenable_type`, `tokenable_id`, `name`, `token`, `abilities`, `last_used_at`, `expires_at`, `created_at`, `updated_at`) VALUES
(1, 'App\\Models\\User', 2, 'auth_token', '32badc60314e0ef40547792955deeff07a0e1b1a7f06d1b89053185ebe3fc222', '[\"*\"]', '2024-06-26 19:37:58', NULL, '2024-06-26 19:37:10', '2024-06-26 19:37:58'),
(2, 'App\\Models\\User', 2, 'auth_token', '08a768a0467f61e3d4f9483d5d397983b2c3020324287b4d1ea3de16b85635d4', '[\"*\"]', '2024-07-02 01:54:48', NULL, '2024-06-26 22:03:35', '2024-07-02 01:54:48'),
(3, 'App\\Models\\User', 2, 'auth_token', '8e2a70a6f100b90c81cea9a9be0806c8b0440b62d7d7f6e4e59ff8a5a9670f7a', '[\"*\"]', '2024-06-27 00:02:22', NULL, '2024-06-26 22:04:51', '2024-06-27 00:02:22'),
(4, 'App\\Models\\User', 2, 'auth_token', 'a46323566f58e1a42da3a40bc28d9af0caf144f1adbf9a3e5ed3b2f01252755d', '[\"*\"]', '2024-06-27 01:34:46', NULL, '2024-06-27 00:33:31', '2024-06-27 01:34:46'),
(5, 'App\\Models\\User', 2, 'auth_token', '5adb45938645b74532497ce61693880256e1b7cb78f5e28d0cdc293f4b020f05', '[\"*\"]', '2024-06-27 01:45:51', NULL, '2024-06-27 01:45:45', '2024-06-27 01:45:51'),
(6, 'App\\Models\\User', 2, 'auth_token', '819a3ac4fcb7b75a1b2772aa4b238d64e9f3ae3caec721c2863de908a4ac4735', '[\"*\"]', '2024-06-27 01:55:43', NULL, '2024-06-27 01:55:38', '2024-06-27 01:55:43'),
(7, 'App\\Models\\User', 2, 'auth_token', '6344df73b03f90f3ce11683ef66240ffe86d75415c7c8835fea0c2194af39041', '[\"*\"]', '2024-06-27 03:41:36', NULL, '2024-06-27 02:49:36', '2024-06-27 03:41:36'),
(8, 'App\\Models\\User', 2, 'auth_token', '625e629bb8e51fc25ab2b9325b802b29c48fdc5d27d87a10300c529086ee0e1a', '[\"*\"]', '2024-06-27 03:45:49', NULL, '2024-06-27 03:45:44', '2024-06-27 03:45:49'),
(9, 'App\\Models\\User', 2, 'auth_token', '81aa2fae23667b034909d74da5cd52fe278a4b30f5065bb6f2d7d92637e786a6', '[\"*\"]', '2024-06-27 04:26:17', NULL, '2024-06-27 03:48:18', '2024-06-27 04:26:17'),
(10, 'App\\Models\\User', 2, 'auth_token', 'ded29525c2ec26b9e98b9191d70299879bcc97daaff2f72a14bfdf2e36aa4c55', '[\"*\"]', '2024-06-27 04:38:28', NULL, '2024-06-27 04:38:23', '2024-06-27 04:38:28'),
(11, 'App\\Models\\User', 2, 'auth_token', '3a61f80a75c9fe5324d68c590813356dfc10a119e6d66c27618ee4cb7e872ec7', '[\"*\"]', '2024-06-27 05:26:07', NULL, '2024-06-27 05:13:35', '2024-06-27 05:26:07'),
(12, 'App\\Models\\User', 2, 'auth_token', 'db6e79bd7cfe700b595f764ce7eb051b20eb7a9cafc6a466950cd07129a982c5', '[\"*\"]', '2024-06-27 06:06:06', NULL, '2024-06-27 05:31:18', '2024-06-27 06:06:06'),
(13, 'App\\Models\\User', 2, 'auth_token', '4234112d37bc6da741612489021e595bd4345483d7b0bc76adaa3849a6ca5745', '[\"*\"]', '2024-06-27 06:11:58', NULL, '2024-06-27 06:11:53', '2024-06-27 06:11:58'),
(14, 'App\\Models\\User', 2, 'auth_token', 'ed665d3acd92605fd84155546f2bdff98bc11fcf98d681cdc959f97c0f57247b', '[\"*\"]', '2024-06-27 19:35:20', NULL, '2024-06-27 06:18:41', '2024-06-27 19:35:20'),
(15, 'App\\Models\\User', 2, 'auth_token', 'c0ae162c0249f85e7ea6b80812b09f24218d052e47c374238b1a0447da04f199', '[\"*\"]', NULL, NULL, '2024-06-27 19:47:44', '2024-06-27 19:47:44'),
(16, 'App\\Models\\User', 2, 'auth_token', '1f5f437422acc284c1024b75f91552a2713382bbe3fb3a4f4ce34886da50db56', '[\"*\"]', NULL, NULL, '2024-06-27 19:50:16', '2024-06-27 19:50:16'),
(17, 'App\\Models\\User', 2, 'auth_token', '3b57976fb0d80cc8c0e3cc6f0b8bc44f32ec140e43b835000d2d54ccabc7c2ff', '[\"*\"]', '2024-06-27 23:27:23', NULL, '2024-06-27 19:52:19', '2024-06-27 23:27:23');

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

--
-- Table structure for table `psychologists`
--

CREATE TABLE `psychologists` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `description` text,
  `sipp` varchar(100) DEFAULT NULL,
  `str` varchar(100) DEFAULT NULL,
  `session` int(11) DEFAULT NULL,
  `review` int(11) DEFAULT NULL,
  `experience` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `psychologists`
--

INSERT INTO `psychologists` (`id`, `user_id`, `type`, `description`, `sipp`, `str`, `session`, `review`, `experience`, `created_at`, `updated_at`) VALUES
(1, 3, 'Psikolog Klinis Umum', 'Muchamad Salamun Abdul Rahman, S.Psi merupakan Psikolog yang memiliki pengalaman menangani berbagai kasus. Adapun beberapa kasus yang ditangani diantaranya adalah kecemasan, depresi dengan melukai diri & keinginan bunuh diri, hubungan relasi, managemen stres, dan pengembangan diri. Terapi yang digunakan bersifat eklektik dengan menyesuaikan kondisi serta permasalahan klien. Beberapa teknik yang digunakan ialah BT, CBT, Humanistik, Gestalt, dan Solution Focus.', NULL, NULL, 125, 42, '9 tahun', NULL, NULL),
(2, 4, 'Psikolog Klinis Umum', 'I Dewa Gede Udayana Putra, M.Psi seorang psikolog industri & organisasi. Sejak 2019 berpengalaman sebagai psikolog, Dewa biasa menangani topik terkait leadership, pekerjaan, kecemasan, depresi ringan, frustrasi, suicidal intention, relasi hubungan sebelum/sesudah pernikahan, & seksualitas sebelum/sesudah pernikahan. Dewa dikenal melakukan sesi terapinya dengan sangat santai & hangat; menggunakan pendekatan coaching, counselling, logotherapy, hypnotherapy, dream interpretation, & free association. ', NULL, NULL, 115, 34, '5 tahun', NULL, NULL),
(3, 5, 'Psikolog Klinis Umum', 'Anak Agung Sagung Ratih Damayanti, M.Psi., Psikolog merupakan psikolog klinis dengan pengalaman menangani berbagai kasus klinis. Kasus yang menjadi fokus perhatian Ratih antara lain kecemasan, depresi, kepribadian, hubungan relasional, perencanaan kehidupan dan manajemen stres. Ratih menerapkan terapi ekletik yang disesuaikan dengan kondisi dan situasi klien. Ia biasa menggunakan teknik CBT, Mindfulness, BT dan psikologi positif.', NULL, NULL, 80, 22, '4 tahun', NULL, NULL),
(4, 6, 'Psikolog Klinis Umum', 'Psikolog Annisa merupakan psikolog klinis umum yang berpengalaman dalam menangani kasus gangguan emosi (depresi, kecemasan, bipolar), permasalahan diri, permasalahan relasi, dan permasalahan psikologis berkaitan dengan kondisi kesehatan. Selama praktiknya, Psikolog Annisa biasa menggunakan pendekatan client-centered therapy, narrative therapy, dan cognitive behavioral therapy. Psikolog Ainun juga aktif menuliskan pengalaman dan pandangannya tentang kesehatan mental melalui laman media sosial pribadinya dan menjadi sukarelawan di bidang kesehatan mental. Ia ingin mengupayakan kemudahan aksesibilitas layanan kesehatan mental yang inklusif bagi masyarakat Indonesia.', NULL, NULL, 315, 56, '9 tahun', NULL, NULL),
(5, 7, 'Psikolog Klinis Umum', 'Aliffiya Tasya Aqilah, S.Psi merupakan seorang psikolog klinis anak dan remaja. Sebagai psikolog, Aliffiya memiliki pengalaman menangani kasus hambatan belajar, keterlambatan bahasa, hubungan anak - orang tua, pengasuhan, kelekatan, dan masalah perilaku pada anak dan remaja. Ia juga aktif melakukan psikoedukasi baik dengan membuat konten di media sosial maupun menjadi pembicara terkait topik perkembangan anak, pengasuhan dan isu tentang keluarga.', NULL, NULL, 30, 12, '2 tahun', NULL, NULL),
(6, 8, 'Psikolog Klinis Umum', 'Annisa Karina, S. Psi., Psikolog atau Annisa merupakan psikolog klinis dewasa yang telah berpengalaman dalam menangani kasus seperti masalah diri (gangguan kecemasan) dan masalah relasi (hubungan dengan pasangan, pertemanan, dan keluarga). Annisa melakukan sesi terapi dengan Rational Emotive Behaviour dimana klien diajak mengenali emosinya terlebih dahulu serta memahami diri sendiri sehingga mampu menyelesaikan permasalahan yang akan dihadapi.', NULL, NULL, 352, 72, '10 tahun', NULL, NULL),
(7, 9, 'Psikolog Klinis Umum', 'Ammy Novita Setiawati, M.Psi., Psikolog merupakan psikolog klinis yang berpraktik sejak 2015. Keunikan Ammy dalam menangani klien adalah dengan menggunakan Optimal Health Program sehingga klien dapat mengenal & mengelola dirinya secara holistik (aspek fisik, mental, sosial, serta spiritual). Annisa juga menguasai mindfulness, compassion, forgiveness therapy, art therapy, behavior activation, stabilisasi emosi, transpersonal psychotherapy, dan transgenerational psychotherapy dengan metode relaksasi, breathwork, meditasi, visualisasi, guided imagery, journaling, self-talk dengan afirmasi positif, & menggambar untuk membantu para klien memulihkan luka batin, mencapai potensi optimal, dan bertumbuh menjadi pribadi yang sehat mental maupun produktif. Selain itu, Ammy juga aktif membuat konten edukasi terkait kesehatan mental dan menjadi pembicara di berbagai event dengan topik terkait kesehatan mental, mindfulness, compassion, maupun manajemen stres.', NULL, NULL, 375, 92, '12 tahun', NULL, NULL),
(8, 10, 'Psikolog Klinis Umum', 'Psikolog Ayu merupakan psikolog klinis umum yang berpengalaman dalam menangani kasus gangguan emosi (depresi, kecemasan, bipolar), permasalahan diri, permasalahan relasi, dan permasalahan psikologis berkaitan dengan kondisi kesehatan. Selama praktiknya, Psikolog Ayu biasa menggunakan pendekatan client-centered therapy, narrative therapy, dan cognitive behavioral therapy. Psikolog Ayu juga aktif menuliskan pengalaman dan pandangannya tentang kesehatan mental melalui laman media sosial pribadinya dan menjadi sukarelawan di bidang kesehatan mental. Ia ingin mengupayakan kemudahan aksesibilitas layanan kesehatan mental yang inklusif bagi masyarakat Indonesia.', NULL, NULL, 412, 89, '13 tahun', NULL, NULL),
(9, 11, 'Psikolog Klinis Umum', 'Adelin Australiati Saragih, S. Psi., M.Psi., Psikolog merupakan seorang psikolog klinis anak dan remaja. Sebagai psikolog, Adelin memiliki pengalaman menangani kasus hambatan belajar, keterlambatan bahasa, hubungan anak - orang tua, pengasuhan, kelekatan, dan masalah perilaku pada anak dan remaja. Ia juga aktif melakukan psikoedukasi baik dengan membuat konten di media sosial maupun menjadi pembicara terkait topik perkembangan anak, pengasuhan dan isu tentang keluarga.', NULL, NULL, 127, 43, '6 tahun', NULL, NULL),
(10, 12, 'Psikolog Klinis Umum', 'Deacy Anindya Putri, M.Psi., Psikolog atau Deacy merupakan psikolog klinis dewasa yang telah berpengalaman dalam menangani kasus seperti masalah diri (gangguan kecemasan) dan masalah relasi (hubungan dengan pasangan, pertemanan, dan keluarga). Deacy melakukan sesi terapi dengan Rational Emotive Behaviour dimana klien diajak mengenali emosinya terlebih dahulu serta memahami diri sendiri sehingga mampu menyelesaikan permasalahan yang akan dihadapi.', NULL, NULL, 189, 78, '9 tahun', NULL, NULL),
(11, 1, 'Psikolog Klinis Umum', 'Deacy Anindya Putri, M.Psi., Psikolog atau Deacy merupakan psikolog klinis dewasa yang telah berpengalaman dalam menangani kasus seperti masalah diri (gangguan kecemasan) dan masalah relasi (hubungan dengan pasangan, pertemanan, dan keluarga). Deacy melakukan sesi terapi dengan Rational Emotive Behaviour dimana klien diajak mengenali emosinya terlebih dahulu serta memahami diri sendiri sehingga mampu menyelesaikan permasalahan yang akan dihadapi.', '7544 8906 3445', '001 6788880888', 189, 78, '9 tahun', NULL, '2024-09-11 01:48:27');

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

--
-- Table structure for table `regional_entity`
--

CREATE TABLE `regional_entity` (
  `id` int(11) NOT NULL,
  `nama` varchar(512) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `regional_entity`
--

INSERT INTO `regional_entity` (`id`, `nama`, `created_at`, `updated_at`) VALUES
(1, 'Holding', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(2, 'Palm Co', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(3, 'Supporting Co', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(4, 'SugarCo', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(5, 'PalmCo-Regional 1', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(6, 'PalmCo-Regional 2', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(7, 'PalmCo-Regional 3', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(8, 'PalmCo-Regional 4', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(9, 'PalmCo-Regional 5', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(10, 'SuppCo-Regional 1', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(11, 'SuppCo-Regional 2', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(12, 'SuppCo-Regional 3', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(13, 'SuppCo-Regional 4', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(14, 'SuppCo-Regional 5', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(15, 'SuppCo-Regional 6', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(16, 'SuppCo-Regional 7', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(17, 'SuppCo-Regional 8', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(18, 'PT ASN', '2024-07-19 02:51:28', '2024-07-19 02:51:28'),
(19, 'PT IKN', '2024-07-19 02:51:29', '2024-07-19 02:51:29'),
(20, 'PT KPBN', '2024-07-19 02:51:29', '2024-07-19 02:51:29'),
(21, 'PT SPN', '2024-07-19 02:51:29', '2024-07-19 02:51:29'),
(22, 'PT INL', '2024-07-19 02:51:29', '2024-07-19 02:51:29'),
(23, 'PT RPN', '2024-07-19 02:51:29', '2024-07-19 02:51:29'),
(24, 'PT BIN', '2024-07-19 02:51:29', '2024-07-19 02:51:29'),
(25, 'PT LPPAN', '2024-07-19 02:51:29', '2024-07-19 02:51:29'),
(26, 'PT KIN', '2024-07-19 02:51:29', '2024-07-19 02:51:29'),
(27, 'PT SPMN', '2024-07-19 02:51:29', '2024-07-19 02:51:29'),
(28, 'Lainnya', '2024-07-19 02:51:29', '2024-07-19 02:51:29');

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `user_reviewer` int(11) NOT NULL,
  `user_reviewee` int(11) NOT NULL,
  `comment` text NOT NULL,
  `category` varchar(50) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci 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 `roles`
--

INSERT INTO `roles` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Admin', NULL, NULL),
(2, 'User', NULL, NULL),
(3, 'Pyschologyst', NULL, NULL);

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

--
-- Table structure for table `schedules`
--

CREATE TABLE `schedules` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `datetime_start` timestamp NULL DEFAULT NULL,
  `datetime_end` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `schedules`
--

INSERT INTO `schedules` (`id`, `user_id`, `service_id`, `datetime_start`, `datetime_end`, `created_at`, `updated_at`) VALUES
(2, 1, 1, '2024-09-18 00:00:00', '2024-09-18 00:59:00', '2024-09-16 18:45:11', '2024-09-16 18:45:11'),
(3, 1, 1, '2024-09-18 01:00:00', '2024-09-18 02:59:00', '2024-09-17 02:51:05', '2024-09-17 02:51:05');

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

--
-- Table structure for table `schedule_assigned`
--

CREATE TABLE `schedule_assigned` (
  `id` int(11) NOT NULL,
  `schedule_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `code` varchar(100) NOT NULL,
  `status` varchar(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `schedule_assigned`
--

INSERT INTO `schedule_assigned` (`id`, `schedule_id`, `user_id`, `code`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 2, '65347', 'approved', '2024-09-17 03:46:06', '2024-09-17 06:49:34'),
(3, 3, 2, '24-09-17hQeXm', 'pending', '2024-09-17 09:51:26', '2024-09-17 09:51:26');

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'e-Conselling', '2024-09-11 08:15:08', '2024-09-11 08:15:08'),
(2, 'e-Mentoring', '2024-09-11 08:15:08', '2024-09-11 08:15:08');

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

--
-- Table structure for table `topics`
--

CREATE TABLE `topics` (
  `id` int(11) NOT NULL,
  `slug` varchar(300) NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `topics`
--

INSERT INTO `topics` (`id`, `slug`, `name`, `created_at`, `updated_at`) VALUES
(1, 'anak-dan-remaja', 'Anak & Remaja', NULL, NULL),
(2, 'kekerasan-fisik-atau-seksual', 'Kekerasan Fisik/Seksual', NULL, NULL),
(3, 'keluarga', 'Keluarga', NULL, NULL),
(4, 'pengambangan-diri', 'Pengembangan Diri', NULL, NULL),
(5, 'pranikah', 'Pranikah', NULL, NULL),
(6, 'phobia', 'Phobia', NULL, NULL),
(7, 'karir', 'Karir', NULL, NULL),
(8, 'Trauma', 'trauma', NULL, NULL);

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

--
-- Table structure for table `topic_expertises`
--

CREATE TABLE `topic_expertises` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `topic_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `topic_expertises`
--

INSERT INTO `topic_expertises` (`id`, `user_id`, `topic_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, NULL, NULL),
(2, 1, 3, NULL, NULL),
(3, 1, 7, NULL, NULL),
(4, 1, 2, NULL, NULL),
(5, 1, 4, NULL, NULL),
(6, 1, 5, NULL, NULL),
(7, 1, 6, NULL, NULL);

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nik` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` text COLLATE utf8mb4_unicode_ci,
  `is_verified` tinyint(1) 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 for table `users`
--

INSERT INTO `users` (`id`, `role_id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `nik`, `address`, `phone`, `username`, `image`, `is_verified`, `created_at`, `updated_at`) VALUES
(1, 3, 'Andreas Dan', 'admin@gmail.com', NULL, '$2y$10$dKMJAezsnKgLDuXIbZBEb.s2Xb4TzE8Yg5OtiR59bZ0VhCu5546U.', NULL, '044954333466885', 'Jl. LPP No.1, Klitren, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55222', '0821375885566', 'andreas', 'dan-romawi - 1726110839.png', 1, NULL, '2024-09-11 20:13:59'),
(2, 2, 'Lisa Anis', 'user@gmail.com', NULL, '$2y$10$MlNLIuCg3w7Eh1joSixrZ.1wdm.q55qwl9QZi4EjfNAdLI/vK9.Va', NULL, '123123', 'Jl. LPP No.1, Klitren, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55222', '0876776', 'lisa', NULL, 1, NULL, '2024-07-17 12:04:55'),
(3, 3, 'Muchamad Salamun Abdul Rahman, S.Psi.', 'salamun.abdul@gmail.com', NULL, '$2y$10$MlNLIuCg3w7Eh1joSixrZ.1wdm.q55qwl9QZi4EjfNAdLI/vK9.Va', NULL, '3174010607970001', 'Jl. LPP No.1, Klitren, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55222', NULL, 'm-salamun-abdul-rahman', 'psychologist_1.png', 1, NULL, '2024-07-17 12:04:55'),
(4, 3, 'I Dewa Gede Udayana Putra, M.Psi., Psikolog', 'dewa.gede@gmail.com', NULL, '$2y$10$MlNLIuCg3w7Eh1joSixrZ.1wdm.q55qwl9QZi4EjfNAdLI/vK9.Va', NULL, '1803101409920001', 'Jl. LPP No.1, Klitren, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55222', NULL, 'i-dewa-gede-udayana-putra', 'psychologist_2.PNG', 1, NULL, '2024-07-17 12:04:55'),
(5, 3, 'Anak Agung Sagung Ratih Damayanti, M.Psi., Psikolog', 'ratih.damayanti@gmail.com', NULL, '$2y$10$MlNLIuCg3w7Eh1joSixrZ.1wdm.q55qwl9QZi4EjfNAdLI/vK9.Va', NULL, '5201146904950002', 'Jl. LPP No.1, Klitren, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55222', NULL, 'aa-sagung-ratih-damayanti', 'psychologist_3.PNG', 1, NULL, '2024-07-17 12:04:55'),
(6, 3, 'Annisa Miranty Nurendra, M.Psi., Psikolog', 'annisa.miranty@gmail.com', NULL, '$2y$10$MlNLIuCg3w7Eh1joSixrZ.1wdm.q55qwl9QZi4EjfNAdLI/vK9.Va', NULL, '3471056003860001', 'Jl. LPP No.1, Klitren, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55222', NULL, 'annisa-miranty-nurendra', 'psychologist_4.PNG', 1, NULL, '2024-07-17 12:04:55'),
(7, 3, 'Aliffiya Tasya Aqilah, S.Psi', 'aliffiya.tasya@gmail.com', NULL, '$2y$10$MlNLIuCg3w7Eh1joSixrZ.1wdm.q55qwl9QZi4EjfNAdLI/vK9.Va', NULL, '1271016904000002', 'Jl. LPP No.1, Klitren, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55222', NULL, 'aliffiya-tasya-aqilah', 'psychologist_5.PNG', 1, NULL, '2024-07-17 12:04:55'),
(8, 3, 'Annisa Karina, S. Psi., Psikolog', 'annisa.karina@gmail.com', NULL, '$2y$10$MlNLIuCg3w7Eh1joSixrZ.1wdm.q55qwl9QZi4EjfNAdLI/vK9.Va', NULL, '1671115603900006', 'Jl. LPP No.1, Klitren, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55222', NULL, 'annisa-karina', 'psychologist_6.PNG', 1, NULL, '2024-07-17 12:04:55'),
(9, 3, 'Ammy Novita Setiawati, M.Psi., Psikolog', 'ammy.novita@gmail.com', NULL, '$2y$10$MlNLIuCg3w7Eh1joSixrZ.1wdm.q55qwl9QZi4EjfNAdLI/vK9.Va', NULL, '3313094311890005', 'Jl. LPP No.1, Klitren, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55222', NULL, 'ammy-novita-setiawati', 'psychologist_7.PNG', 1, NULL, '2024-07-17 12:04:55'),
(10, 3, 'Ayu Nindyah Putri Siswanto., M.Psi., Psikolog', 'ayu.nindyah@gmail.com', NULL, '$2y$10$MlNLIuCg3w7Eh1joSixrZ.1wdm.q55qwl9QZi4EjfNAdLI/vK9.Va', NULL, '1571025808910061', 'Jl. LPP No.1, Klitren, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55222', NULL, 'ayu-nindyah-putri-siswanto', 'psychologist_8.PNG', 1, NULL, '2024-07-17 12:04:55'),
(11, 3, 'Adelin Australiati Saragih, S. Psi., M.Psi., Psikolog', 'adelin-australiati@gmail.com', NULL, '$2y$10$MlNLIuCg3w7Eh1joSixrZ.1wdm.q55qwl9QZi4EjfNAdLI/vK9.Va', NULL, '1207026009890001', 'Jl. LPP No.1, Klitren, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55222', NULL, 'adelin-australiati-saragih', 'psychologist_9.PNG', 1, NULL, '2024-07-17 12:04:55'),
(12, 3, 'Deacy Anindya Putri, M.Psi., Psikolog', 'deacy.anindya@gmail.com', NULL, '$2y$10$MlNLIuCg3w7Eh1joSixrZ.1wdm.q55qwl9QZi4EjfNAdLI/vK9.Va', NULL, '3578034412930003', 'Jl. LPP No.1, Klitren, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55222', NULL, 'deacy-anindya-putri', 'psychologist_10.PNG', 1, NULL, '2024-07-17 12:04:55');

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `educations`
--
ALTER TABLE `educations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

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

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

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `psychologists`
--
ALTER TABLE `psychologists`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `regional_entity`
--
ALTER TABLE `regional_entity`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `schedules`
--
ALTER TABLE `schedules`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `schedule_assigned`
--
ALTER TABLE `schedule_assigned`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `topics`
--
ALTER TABLE `topics`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `topic_expertises`
--
ALTER TABLE `topic_expertises`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
COMMIT;

