sulthan/myskin-api
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
myskin-api/humicpro_myskin_v2.sql
T
sulthan b94ef4a695 deploy commit
2026-07-15 17:23:15 +07:00

452 lines
47 KiB
SQL
Raw Permalink Blame History

/*M!999999\- enable the sandbox mode */
-- MariaDB dump 10.19 Distrib 10.6.25-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: humicpro_myskin_v2
-- ------------------------------------------------------
-- Server version 10.6.25-MariaDB
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `accounts`
--
DROP TABLE IF EXISTS `accounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `accounts` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`phone` varchar(255) NOT NULL,
`dob` date DEFAULT NULL,
`role` enum('patient','doctor','admin') NOT NULL DEFAULT 'patient',
`password` varchar(255) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `accounts_email_unique` (`email`),
UNIQUE KEY `accounts_phone_unique` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `accounts`
--
LOCK TABLES `accounts` WRITE;
/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
INSERT INTO `accounts` (`id`, `name`, `email`, `phone`, `dob`, `role`, `password`, `created_at`, `updated_at`) VALUES (1,'tes pasien','tes@pasien.myskin.ac.id','213123','2025-05-18','patient','$2y$12$ma96DgZjXatIkmws7CFL4uKFAL8/3fpo2AyTKtsBFZ8WBvZaEqgfW','2025-05-18 00:12:39','2025-05-18 00:12:39'),(2,'tes dokter ril','tes@dokter.myskin.ac.id','2312312',NULL,'doctor','$2y$12$yK0ZdPNfJ67DL45FceHw8e/JuczFqGzHSHRrPUtFQo9J8ZL69R52u','2025-05-18 00:24:08','2025-05-18 00:24:08'),(3,'Akmal Rafly','akmalrafly@gmail.com','085801256954','2004-04-01','patient','$2y$12$UALsF.fpvM7Tpc/uT1GMUOcnhHJ/goaDRhTSWX.UPJFNcCjqMhHqS','2025-05-18 02:12:38','2025-05-18 02:12:38'),(4,'Wang Ling','wangli@gmail.com','085623672389',NULL,'doctor','$2y$12$MK.sQm8DivCdhHc1.vnH7eZPwODV70R/vdoznnFOR7qNBiL1hvXnu','2025-05-19 06:17:19','2025-05-19 06:17:19'),(5,'PANDU KAYA HAKIKI','pandukayahakiki@student.telkomuniversity.ac.id','085256632471','2025-05-20','patient','$2y$12$owBApTbzoari5dBxOj4dpe6iL5s23nECor4Oz5NQKVhrjG0d/l4oq','2025-05-19 18:26:50','2025-05-19 18:26:50'),(6,'john doe','johndoe@gmail.com','085801234567',NULL,'doctor','$2y$12$VIw2lMBuxSC1EUkxVEwuL.ohxUtX0IrDZ.AU1OtA1J8qVWtj.i4iy','2025-05-19 19:23:56','2025-05-19 19:23:56'),(7,'asa','asasa@gmail.com','464656565',NULL,'doctor','$2y$12$TzSDdu2KeHDjJeDmhHAtXewTcdaGLK1uv057KrZTbmUW80fFjGVVe','2025-05-19 21:50:36','2025-05-19 21:50:36'),(9,'Setyo Anom','setyoprabowoanom3175@gmail.com','085702458972','2005-07-31','patient','$2y$12$bHDrCPCcc5jeeIOMYSflMuZIRDKbDg3J4TPtcJIIE6YJps.prwXFG','2025-05-19 23:46:10','2025-05-19 23:46:10'),(10,'test tost','test@gmail.com','08166436156646','2025-05-31','patient','$2y$12$NL3DQ4NZXQLD.J7BWc5PyO8lbZ6CWpbW8IoGDIS8MRiN2ECiBTf9W','2025-05-20 00:16:03','2025-05-20 00:16:03'),(11,'Eldwin Fikhar','eldwin.fikhar231104@gmail.com','081225627630','2004-11-24','patient','$2y$12$Bin7N8HLkp0G.GjRdVHKUun13qqAi7HlJ0JR2XvxbHIvwStNvNGn6','2025-05-20 00:38:13','2025-05-20 00:38:13'),(12,'cata ilz','catailz@gmail.com','081336888000','2025-05-15','patient','$2y$12$Ma1xZ.4NssRnTmgNT44PWuG9LMZtgXivsvNBkAr7ZJ9pzySGNUSdC','2025-05-20 03:29:31','2025-05-20 03:29:31'),(13,'rakharuan','rakharuan@gmail.com','08134444000',NULL,'doctor','$2y$12$XKLzchM7qVh5hzeEmqP2p.ikXrCnbd5oLfUoU5Y8rV5V9vb3DBwnu','2025-05-20 03:44:07','2025-05-20 03:44:07'),(14,'ABDILLAH AUFA TAQIYYA','abdillahaufa79@gmail.com','085383090154','2004-07-19','patient','$2y$12$Hkl4gpy3SWilaXSrK82Ux.deuRzcF/gfuvSG3idadkl8kMtYGHgOy','2025-05-20 07:28:19','2025-05-20 07:28:19'),(15,'Syfanadya Wening Adi','syfanadya5@gmail.com','081358008183','2002-06-11','patient','$2y$12$oNhEGAH2xD/2TVvZ0TN1mubd1CXbOX/C3ygBJ7L6URrdN5Dk/hTsy','2025-05-24 23:10:39','2025-05-24 23:10:39'),(16,'Budi Sucipto','budisucipto@gmail.com','123412341234','2025-05-25','patient','$2y$12$wMUP.NtaQs3LLsQYnTmIFOWM8h/kRv57EoPMrNptpD9Wv3cgMmfuG','2025-05-25 02:39:38','2025-05-25 02:39:38'),(17,'Rakha Galih','rakha@gmail.com','081336340166','2025-06-24','patient','$2y$12$1KCkG29n/BpljUDaT3I7RewwqRIjQlqauUFLSEWm1uvzoe31chvsO','2025-06-24 01:32:59','2025-06-24 01:32:59'),(18,'Rakha Galih Nugraha Sukma','rakhag@gmail.com','081336430166',NULL,'doctor','$2y$12$Z7vEMqrm.QEPZ4zsiWg/VuqHioTRilw0d7px3lT7afXtegWUHHTry','2025-08-12 22:31:15','2025-08-12 22:31:15'),(19,'hai','hai@gmail.com','23456',NULL,'doctor','$2y$12$4OybxijcCka6ZCu99/vCa.kxQ4kbEZn5xJziJY8IN0lJUVggv4xUa','2025-11-30 05:41:00','2025-11-30 05:41:00');
/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cache`
--
DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache` (
`key` varchar(255) NOT NULL,
`value` mediumtext NOT NULL,
`expiration` int(11) NOT NULL,
PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cache`
--
LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cache_locks`
--
DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache_locks` (
`key` varchar(255) NOT NULL,
`owner` varchar(255) NOT NULL,
`expiration` int(11) NOT NULL,
PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cache_locks`
--
LOCK TABLES `cache_locks` WRITE;
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doctor_profiles`
--
DROP TABLE IF EXISTS `doctor_profiles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `doctor_profiles` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`specialization` varchar(255) NOT NULL,
`license_number` varchar(255) NOT NULL,
`license_file_path` varchar(255) NOT NULL,
`diploma_file_path` varchar(255) NOT NULL,
`certification_file_path` varchar(255) DEFAULT NULL,
`current_institution` varchar(255) NOT NULL,
`work_history` text NOT NULL,
`publications` text NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`practice_address` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `doctor_profiles_user_id_unique` (`user_id`),
UNIQUE KEY `doctor_profiles_license_number_unique` (`license_number`),
CONSTRAINT `doctor_profiles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doctor_profiles`
--
LOCK TABLES `doctor_profiles` WRITE;
/*!40000 ALTER TABLE `doctor_profiles` DISABLE KEYS */;
INSERT INTO `doctor_profiles` (`id`, `user_id`, `specialization`, `license_number`, `license_file_path`, `diploma_file_path`, `certification_file_path`, `current_institution`, `work_history`, `publications`, `created_at`, `updated_at`, `practice_address`) VALUES (1,2,'kulit','12312312','doctor_profiles/licenses/L6JZNEsSPZ3Jiox3kReAqhhL2JodDNdWh8Uu6brS.png','doctor_profiles/diplomas/7Xui8VMjPIRSELXqkMsZwCZaTXxQStip6A2M9CrM.png','doctor_profiles/certifications/3wotUVvI6mjPmVBRH6JS0AhULGLaHB4jRKNNBfw5.png','Telkom University','5','sdasdadasd','2025-05-18 00:24:09','2025-05-18 00:24:09','Bojongsoang'),(2,4,'kulit','DR-CJ20250123','doctor_profiles/licenses/OzPo5BHfIZ8ysmzWaxWEPNdwkKicb85Aepim0MKi.png','doctor_profiles/diplomas/MQHfx7jK6JVqLxJ4jjWswE2w6ySceMYNQgdc8st5.jpg','doctor_profiles/certifications/iDCuJM9cqigash4VynhWMN5CBF3aQHaX8KW2VWi9.pdf','RSU Purwokerto','1 tahun menjadi dokter specialist kulit','Efektivitas Terapi Topikal Asam Retinoat dalam Pengobatan Jerawat Vulgaris Ringan hingga Sedang: Sebuah Studi Klinik di RSUD Jakarta','2025-05-19 06:17:19','2025-05-19 06:17:19','Kawasan Malioboro, Jl. Sosrowijayan No. 5, Yogyakarta'),(3,6,'kulit','DR-JD02345678','doctor_profiles/licenses/eg14sc52stLKs9WnyrYlTYBgF4JjVLejUQfo6lC3.png','doctor_profiles/diplomas/LAS261lfk6tOqTVtqqtZwg2E30Ej23MPhbIihUhn.jpg','doctor_profiles/certifications/HkQsPfP9CflTLfPdRTtiy6IU7UcmXEbtDST17wCz.pdf','RSUD Purwokerto','1 tahun menjadi dokter specialist kulit','Efektivitas Terapi Topikal Asam Retinoat dalam Pengobatan Jerawat Vulgaris Ringan hingga Sedang: Sebuah Studi Klinik di RSUD Jakarta','2025-05-19 19:23:59','2025-05-19 19:23:59','RSUD Purwokerto'),(4,13,'(Sp.BS) Spesialis Bedah Saraf','rakharuan@gmail.com','doctor_profiles/licenses/PgwGYdUuU29hMAp9MC9crY6UIIs0EdhBOJJt2ghK.png','doctor_profiles/diplomas/GXIWVcter4V8UmVadnhLzoOznhM0KEW040LWhdTt.png','doctor_profiles/certifications/2qkFu2e5CV69YhD8nqIn3fHmG4V4o85ITLhv2loZ.jpg','telkom','magang','ilmiah','2025-05-20 03:44:09','2025-05-20 03:44:09','1234567'),(5,18,'(Sp.B) Spesialis Bedah Umum','rakhag@gmail.com','doctor_profiles/licenses/I7rfo5dEOxqj4yUGFxroUIPJ4cube6hzV0YOX0cI.jpg','doctor_profiles/diplomas/JbfqFBi7albX4QlcWIkJLJAq9ZX4zwIyvRxxzlGj.jpg','doctor_profiles/certifications/8n8nRtKWL1LNeuIQhDNVyrGx9PDw35eEMgqAvlyn.jpg','Telkom','Mobile','a','2025-08-12 22:31:15','2025-08-12 22:31:15','1234'),(6,19,'kulit','12345','doctor_profiles/licenses/AkxzpxHKGzsGTJUbqlPmlpbnCT2cQXqwZsUo7IOR.jpg','doctor_profiles/diplomas/YGyrQnex2j4VJkEoC6mRVg8wYYRecKRWPF9bsjyu.jpg','doctor_profiles/certifications/18MxwTDEPfRMnAWvckosVM10z7yY2EC4sEeJWNQ9.jpg','telkom','banyak','wergfdg','2025-11-30 05:41:00','2025-11-30 05:41:00','bogor');
/*!40000 ALTER TABLE `doctor_profiles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `failed_jobs`
--
DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`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(),
PRIMARY KEY (`id`),
UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `failed_jobs`
--
LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `job_batches`
--
DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
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,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `job_batches`
--
LOCK TABLES `job_batches` WRITE;
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jobs`
--
DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`queue` varchar(255) NOT NULL,
`payload` longtext 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,
PRIMARY KEY (`id`),
KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jobs`
--
LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `migrations`
--
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`migration` varchar(255) NOT NULL,
`batch` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `migrations`
--
LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
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,'2025_04_09_045236_create_accounts_table',1),(5,'2025_04_09_045317_create_submissions_table',1),(6,'2025_04_09_045446_create_doctor_profiles_table',1),(7,'2025_04_09_110312_create_verifications_table',1),(8,'2025_04_19_075048_create_personal_access_tokens_table',1),(9,'2025_04_19_075809_add_admin_to_accounts_role_enum',1),(10,'2025_04_29_063055_add_percentage_to_submissions_table',1),(11,'2025_04_29_144922_add_practice_address_to_doctor_profiles_table',1),(12,'2025_04_29_151211_drop_years_of_experience_from_doctor_profiles_table',1),(13,'2025_04_29_155942_make_dob_nullable_on_accounts_table',1),(14,'2025_05_02_043044_add_is_submitted_to_submissions_table',1),(15,'2025_05_03_084539_add_certification_file_path_to_doctor_profiles',1),(16,'2025_05_18_081320_create_personal_access_tokens_table',2),(17,'2025_05_18_081555_create_personal_access_tokens_table',3);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `password_reset_tokens`
--
DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_reset_tokens` (
`email` varchar(255) NOT NULL,
`token` varchar(255) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `password_reset_tokens`
--
LOCK TABLES `password_reset_tokens` WRITE;
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `personal_access_tokens`
--
DROP TABLE IF EXISTS `personal_access_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `personal_access_tokens` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`tokenable_type` varchar(255) NOT NULL,
`tokenable_id` bigint(20) unsigned NOT NULL,
`name` varchar(255) NOT NULL,
`token` varchar(64) NOT NULL,
`abilities` text DEFAULT NULL,
`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,
PRIMARY KEY (`id`),
UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `personal_access_tokens`
--
LOCK TABLES `personal_access_tokens` WRITE;
/*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */;
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\\Account',1,'auth-token','5fdfa6e229bb9a9e27436816392358b58ec3fc231a3af8d67da64c672999b20a','[\"*\"]','2025-05-18 01:43:50',NULL,'2025-05-18 01:20:38','2025-05-18 01:43:50'),(2,'App\\Models\\Account',1,'auth-token','bf772548210d2fac6803db2021f8017ff5df5d61b1c7f24c88d54a02b784fc03','[\"*\"]','2025-05-18 01:55:38',NULL,'2025-05-18 01:43:54','2025-05-18 01:55:38'),(3,'App\\Models\\Account',1,'auth-token','abc681fd84ee21c422521bfa13a082bfc16054aea0cb37ef0cfe6b555ebf0a8d','[\"*\"]','2025-05-18 02:02:55',NULL,'2025-05-18 01:56:33','2025-05-18 02:02:55'),(4,'App\\Models\\Account',1,'auth-token','47d539824999546af7c8333a4ec7fb13e25df9ca4775173a38fcae0e7079a898','[\"*\"]','2025-05-18 19:25:03',NULL,'2025-05-18 02:03:00','2025-05-18 19:25:03'),(5,'App\\Models\\Account',3,'auth-token','854386ed64a21289b35d3c4f9686ad1c81005efa3aea14d00667cc496ed0670a','[\"*\"]',NULL,NULL,'2025-05-18 02:12:39','2025-05-18 02:12:39'),(6,'App\\Models\\Account',3,'auth-token','b1b2b436f5df46605a8a13c29fa738369022f1d2eed756d127996edb942a2b0b','[\"*\"]','2025-05-18 02:14:21',NULL,'2025-05-18 02:12:50','2025-05-18 02:14:21'),(7,'App\\Models\\Account',2,'auth-token','b7b84be9c9904745dbec02d74b5827323ac656c8abce59dc444527a0dfd95fe0','[\"*\"]','2025-05-18 02:17:22',NULL,'2025-05-18 02:16:56','2025-05-18 02:17:22'),(8,'App\\Models\\Account',3,'auth-token','d582ec4f2816bd5b476c97f19dbb5f61057402e7c9f3737fde47e0728824b39e','[\"*\"]','2025-05-19 00:38:17',NULL,'2025-05-18 04:45:52','2025-05-19 00:38:17'),(9,'App\\Models\\Account',1,'auth-token','f4f99b7775ff29899323e46e50dd25bb7e9b36b06177a970b71e3a786c6f1ba8','[\"*\"]','2025-05-19 00:35:14',NULL,'2025-05-18 19:25:08','2025-05-19 00:35:14'),(10,'App\\Models\\Account',1,'auth-token','706abe673f60732cd8c8e5dcf8096d278665557b3a757d281a75e3ad79e9ebbf','[\"*\"]',NULL,NULL,'2025-05-18 19:43:27','2025-05-18 19:43:27'),(11,'App\\Models\\Account',3,'auth-token','abcfa5424594216bd5b9f5d6333df61f9e8b8801df162295719241ec7331e43f','[\"*\"]','2025-05-19 00:00:47',NULL,'2025-05-18 21:47:36','2025-05-19 00:00:47'),(12,'App\\Models\\Account',3,'auth-token','a09385c1894176b647912385a830ce5c57a28af509c4fed4e6473e8554306e46','[\"*\"]','2025-05-19 05:48:40',NULL,'2025-05-19 05:32:30','2025-05-19 05:48:40'),(13,'App\\Models\\Account',4,'doctor-token','2c7cbf4befe2ad087e998bb983a16b5549a787f0427a518858e2f6e18193ec4f','[\"create\",\"update\",\"delete\"]',NULL,NULL,'2025-05-19 06:17:19','2025-05-19 06:17:19'),(14,'App\\Models\\Account',4,'auth-token','64bdde56de51db07240c8f9da49ec3d9411ba206da1e28ee39be19fa3d79c7c8','[\"*\"]','2025-05-19 06:21:03',NULL,'2025-05-19 06:17:30','2025-05-19 06:21:03'),(15,'App\\Models\\Account',1,'auth-token','3d2a09ced0023a3cd818ac595087ccddb178091eaace791af6700ae8504f78be','[\"*\"]','2025-05-19 08:12:42',NULL,'2025-05-19 08:11:19','2025-05-19 08:12:42'),(16,'App\\Models\\Account',2,'auth-token','62e8e31804df9cabc35ca2be4bc8de29b407d9e908b85bde3af8c31921b64f6e','[\"*\"]','2025-05-20 07:28:26',NULL,'2025-05-19 08:12:56','2025-05-20 07:28:26'),(17,'App\\Models\\Account',3,'auth-token','b50be5a1816c60a80d890fda92241ffbf3ba51784a3bd0a30c79989cce4a673b','[\"*\"]','2025-05-19 08:23:07',NULL,'2025-05-19 08:21:39','2025-05-19 08:23:07'),(18,'App\\Models\\Account',1,'auth-token','ad81cb663e3ba07314fe331582f5d813de89dc0388781fd2edf89b944265bb89','[\"*\"]','2025-05-19 08:31:26',NULL,'2025-05-19 08:23:38','2025-05-19 08:31:26'),(19,'App\\Models\\Account',3,'auth-token','3c45e357f0ded40b649e12e4c68f340faef288cce4b2c6727628662973f5444e','[\"*\"]','2025-05-19 08:38:42',NULL,'2025-05-19 08:25:06','2025-05-19 08:38:42'),(20,'App\\Models\\Account',2,'auth-token','550050a8e732fcd2d5f68ffbbd3ac3c66eeed3c69b1751417cf7bf0d5158263f','[\"*\"]','2025-06-19 11:00:01',NULL,'2025-05-19 09:08:06','2025-06-19 11:00:01'),(21,'App\\Models\\Account',2,'auth-token','8f5328bb75af0c2f2b5adae8bc0a6692ed092c526608ad6f31a8e60e7b26dc2b','[\"*\"]','2025-05-19 09:27:13',NULL,'2025-05-19 09:12:09','2025-05-19 09:27:13'),(22,'App\\Models\\Account',3,'auth-token','6b94949ae2d6fe268a9dbfd175e563b1e6aa34afc34b32d94920f24e850dfcb8','[\"*\"]','2025-05-19 15:52:36',NULL,'2025-05-19 15:39:09','2025-05-19 15:52:36'),(23,'App\\Models\\Account',5,'auth-token','4039846e23e2d071586af9acab9f4cf3c5a3695095c391b7e2e38087db664992','[\"*\"]',NULL,NULL,'2025-05-19 18:26:50','2025-05-19 18:26:50'),(24,'App\\Models\\Account',5,'auth-token','013b1fd1bfd3df5608f1b06d80a96290b87cf74ece65dbfb3f08ac0d70a33895','[\"*\"]','2025-05-19 18:28:03',NULL,'2025-05-19 18:27:07','2025-05-19 18:28:03'),(25,'App\\Models\\Account',5,'auth-token','bbaf73710d7f322e0334f6cb79351ce89155ac6ff167d1d96ab7f635e92b2766','[\"*\"]','2025-05-19 21:53:56',NULL,'2025-05-19 18:29:06','2025-05-19 21:53:56'),(26,'App\\Models\\Account',6,'doctor-token','52a42ed4c028ff5125bd186131ac18c8f5de15901335ba058b748bc1d3db5c92','[\"create\",\"update\",\"delete\"]',NULL,NULL,'2025-05-19 19:24:06','2025-05-19 19:24:06'),(27,'App\\Models\\Account',6,'auth-token','e62f9d95093d02ba755cd8058b3ad290b209402cb4cf2d062913504c4d0787f6','[\"*\"]','2025-05-19 19:24:49',NULL,'2025-05-19 19:24:46','2025-05-19 19:24:49'),(28,'App\\Models\\Account',3,'auth-token','4ed08000e2fc13376126e29c5c6af4de4be0229e6b1ec5e55ffd26e581addaaa','[\"*\"]','2025-05-24 03:01:13',NULL,'2025-05-19 19:25:05','2025-05-24 03:01:13'),(29,'App\\Models\\Account',3,'auth-token','bc4c9a93d2a4d730788b9d6195d506040603991773d0111344daf460518743d2','[\"*\"]','2025-05-26 00:44:55',NULL,'2025-05-19 19:40:03','2025-05-26 00:44:55'),(30,'App\\Models\\Account',9,'auth-token','8886617ae889a5c0cd1315bd8e57f2a8f6810662be59d8b0136409a969ec2d6a','[\"*\"]',NULL,NULL,'2025-05-19 23:46:10','2025-05-19 23:46:10'),(31,'App\\Models\\Account',9,'auth-token','5537a39d6f126bf6514c9abb96281e8ea8d566c3c200082f270a0b8e431f229f','[\"*\"]','2025-05-19 23:47:00',NULL,'2025-05-19 23:46:34','2025-05-19 23:47:00'),(32,'App\\Models\\Account',10,'auth-token','46e4dadbc9d82579da5a5f2855b7288c1f8ebf2f46f1f5376d6497a0a990f1fe','[\"*\"]',NULL,NULL,'2025-05-20 00:16:06','2025-05-20 00:16:06'),(33,'App\\Models\\Account',10,'auth-token','4889fb9a86196a1e3b426dc93f6f663ab13d8f0a497cb0907d45d6871df15287','[\"*\"]','2025-05-20 00:16:33',NULL,'2025-05-20 00:16:24','2025-05-20 00:16:33'),(34,'App\\Models\\Account',11,'auth-token','ee2db9711403483bcf1062ee542c894de9326b1f45411d0d46bc58100f9eb7d6','[\"*\"]',NULL,NULL,'2025-05-20 00:38:15','2025-05-20 00:38:15'),(35,'App\\Models\\Account',11,'auth-token','a54135bbd2dfaf646adbe17f1ebf9213dbc3f9020ad7934e56d6565adcc8f35c','[\"*\"]','2025-05-20 00:54:53',NULL,'2025-05-20 00:39:29','2025-05-20 00:54:53'),(36,'App\\Models\\Account',1,'auth-token','ecd6aa94d4aafb94bdfce6c239b6cc22c873c82eac6bd29adc8af01f268acec0','[\"*\"]','2025-05-20 03:30:58',NULL,'2025-05-20 03:04:19','2025-05-20 03:30:58'),(42,'App\\Models\\Account',12,'auth-token','ba1ca6ec805e6e415ef88a2cb23c08d6904eb662a988b35600d3762d35d9f6cd','[\"*\"]','2025-05-21 20:09:47',NULL,'2025-05-20 04:27:30','2025-05-21 20:09:47'),(44,'App\\Models\\Account',1,'auth-token','0e8864a5d6d5da87bb24561cfd279d2be764957bf7db48ed420aa198cea019b6','[\"*\"]','2025-05-20 06:37:25',NULL,'2025-05-20 06:37:10','2025-05-20 06:37:25'),(45,'App\\Models\\Account',14,'auth-token','7a8bd1156efc1e4d320544df0d04e77b7b9062052f7809f6baee6cba7644b8cb','[\"*\"]',NULL,NULL,'2025-05-20 07:28:20','2025-05-20 07:28:20'),(46,'App\\Models\\Account',2,'auth-token','e174ab220e5d8face8615f7ea398d60b11dbd5da525b9ebb619b283e306e7287','[\"*\"]','2025-11-10 01:19:04',NULL,'2025-05-20 07:40:11','2025-11-10 01:19:04'),(48,'App\\Models\\Account',12,'auth-token','38adaeeb25a8c473e6287585c9c6b13455f5e96ef8c94b0e83624d1804a33771','[\"*\"]','2025-05-20 09:12:22',NULL,'2025-05-20 09:11:54','2025-05-20 09:12:22'),(50,'App\\Models\\Account',12,'auth-token','f981243c67f462a70ef249ae95aa03e9eb0988451e3a6d2c4a894019366c032f','[\"*\"]','2025-05-24 00:13:01',NULL,'2025-05-20 10:17:34','2025-05-24 00:13:01'),(51,'App\\Models\\Account',12,'auth-token','d618d4310d24775c8eecc6769f3d678d38d458ceb1383d81106b379c8e890718','[\"*\"]',NULL,NULL,'2025-05-21 19:47:19','2025-05-21 19:47:19'),(52,'App\\Models\\Account',12,'auth-token','c8462d421601a48852754ea58b552c2afb139a5f51afd4ab68961b3be5f27536','[\"*\"]','2025-05-21 20:02:29',NULL,'2025-05-21 19:47:42','2025-05-21 20:02:29'),(56,'App\\Models\\Account',13,'auth-token','45e414d83a6886fc4859007e8528cac3f9e9b7092f5a81a8a8a6f8e436f3e9e1','[\"*\"]','2025-05-21 21:23:56',NULL,'2025-05-21 21:22:19','2025-05-21 21:23:56'),(57,'App\\Models\\Account',15,'auth-token','0092703a5cf8c42df34981d016c417a55f9d3b6b04e57447e3018723b798abc7','[\"*\"]',NULL,NULL,'2025-05-24 23:10:40','2025-05-24 23:10:40'),(58,'App\\Models\\Account',15,'auth-token','bd52d095d56fdd827ddedcd5a0240007094dec08854e488f66b72a8510d06f75','[\"*\"]','2025-05-24 23:17:01',NULL,'2025-05-24 23:11:33','2025-05-24 23:17:01'),(59,'App\\Models\\Account',16,'auth-token','f06ba16eac7c933ec14bf3693c9916513b6387e0ec169851cfa20fea11077f1a','[\"*\"]',NULL,NULL,'2025-05-25 02:39:40','2025-05-25 02:39:40'),(60,'App\\Models\\Account',16,'auth-token','6b12c40e5d58f7e3293e744b865050b3066dd88a7a948ddfd8f2f6b8599e9d91','[\"*\"]','2025-05-25 02:41:44',NULL,'2025-05-25 02:40:03','2025-05-25 02:41:44'),(61,'App\\Models\\Account',1,'auth-token','597611ab9281a7eba05f738717ca614b19a24289a353a8dd1fff3659e26f7db5','[\"*\"]','2025-11-30 05:37:19',NULL,'2025-06-09 02:25:15','2025-11-30 05:37:19'),(91,'App\\Models\\Account',17,'auth-token','c7f025b6c7ce2c0065321096a79ef3c486a2e729a96c1066bcc466edf71de8cf','[\"*\"]','2025-11-19 09:00:15',NULL,'2025-11-19 08:37:11','2025-11-19 09:00:15'),(92,'App\\Models\\Account',19,'doctor-token','98d4e84a244b5fd9d752665769110fa4fe3ae85d0ec74c5bbcdc72e7a8a08fff','[\"create\",\"update\",\"delete\"]',NULL,NULL,'2025-11-30 05:41:00','2025-11-30 05:41:00'),(93,'App\\Models\\Account',1,'auth-token','539ef643375c4ee9cf9ab0dd7fea7641ea5003386651a4bf8b2f197599feb489','[\"*\"]','2025-11-30 05:41:38',NULL,'2025-11-30 05:41:36','2025-11-30 05:41:38'),(94,'App\\Models\\Account',2,'auth-token','86752080b3e87d1b20f42e9f43ec3f4c8a5e7efa008afbd6057a4d052e9a0ee0','[\"*\"]','2025-11-30 05:42:51',NULL,'2025-11-30 05:41:55','2025-11-30 05:42:51'),(95,'App\\Models\\Account',2,'auth-token','0da2820c131e4ad45b17c90940b9cc86e36266f057501e027e23add51d155992','[\"*\"]','2025-11-30 05:43:34',NULL,'2025-11-30 05:43:19','2025-11-30 05:43:34'),(96,'App\\Models\\Account',1,'auth-token','cfa3a3b655fa7734205b920310d04b91574b27a32519fd7e93d372ae18c3b4e7','[\"*\"]',NULL,NULL,'2026-01-05 20:02:53','2026-01-05 20:02:53'),(97,'App\\Models\\Account',1,'auth-token','c8d7cc06179c1260615dd129c5d191c91306b7fc7da8bfac752140f29fc3f60b','[\"*\"]','2026-01-05 22:27:10',NULL,'2026-01-05 22:26:27','2026-01-05 22:27:10'),(98,'App\\Models\\Account',1,'auth-token','0d94dbd0c0ffd46116094aaf4c2411b452453ad93bd2b15820f9fb854c21e3fe','[\"*\"]','2026-01-28 10:21:08',NULL,'2026-01-28 10:20:45','2026-01-28 10:21:08'),(99,'App\\Models\\Account',2,'auth-token','6cddb5163fd386c66441d53c8a598013ac4f88adba0c862c3c6df04f036bf971','[\"*\"]','2026-02-07 05:46:31',NULL,'2026-02-07 05:45:58','2026-02-07 05:46:31'),(100,'App\\Models\\Account',3,'auth-token','4d8eb89bc38830ff6baf985e9b80d3a13fecc9939add1339fa2a135e1a9e359a','[\"*\"]','2026-02-11 01:11:55',NULL,'2026-02-11 01:11:52','2026-02-11 01:11:55'),(101,'App\\Models\\Account',3,'auth-token','48be422688d2070a44b5140c315fd385a26f83211deae42673177d50c0959d04','[\"*\"]','2026-02-11 01:15:17',NULL,'2026-02-11 01:14:59','2026-02-11 01:15:17'),(102,'App\\Models\\Account',6,'auth-token','7493bc1668b630e2fed4e593eaa9e1a0d4f6997db75dee14250e64031d01875b','[\"*\"]','2026-02-11 01:19:29',NULL,'2026-02-11 01:18:04','2026-02-11 01:19:29'),(103,'App\\Models\\Account',1,'auth-token','2dca763e43aa93e5963a79a45d9061257855df342ad1ebd30c8a07b03e47d668','[\"*\"]','2026-03-03 19:51:54',NULL,'2026-03-03 19:51:52','2026-03-03 19:51:54'),(104,'App\\Models\\Account',1,'auth-token','539564db8b317e0113488fe209472f9ae21397f153bbe63ea05af573d2d44fb9','[\"*\"]','2026-04-29 20:31:05',NULL,'2026-04-10 01:07:57','2026-04-29 20:31:05'),(105,'App\\Models\\Account',1,'auth-token','7a144e52f250d61142a9e86652439b171fa4456bf80b771c8f36955f372b467a','[\"*\"]','2026-05-11 00:34:26',NULL,'2026-05-11 00:04:08','2026-05-11 00:34:26');
/*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sessions`
--
DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
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,
PRIMARY KEY (`id`),
KEY `sessions_user_id_index` (`user_id`),
KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sessions`
--
LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('mTaRD9cXzsJmWK7Ezj38kxFPy2qpXAmEU3WORO0W',NULL,'34.253.38.63','Mozilla/5.0 (compatible; NetcraftSurveyAgent/1.0; +info@netcraft.com)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiamdySnhoTVRVbjRWbUZlUm5RUlFxMWRWeTg1UVF6cFBES1pXQzRuZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDY6Imh0dHBzOi8vd3d3Lm15c2tpbi1hcGktdjIuaHVtaWNwcm90b3R5cGluZy5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1778539606),('X6s47mXRzkhBIB8yaBkcgaEEWWlqk1DNQbZeVO4O',NULL,'35.95.4.153','Mozilla/5.0 (compatible; wpbot/1.4; +https://forms.gle/ajBaxygz9jSR8p8G9)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZzliWXp2akhlaGZPQ25ocmVza0JKaFlyS1JrNnpKNzhyN1h6NVFtdiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHBzOi8vbXlza2luLWFwaS12Mi5odW1pY3Byb3RvdHlwaW5nLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1778566015);
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `submissions`
--
DROP TABLE IF EXISTS `submissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `submissions` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`patient_id` bigint(20) unsigned NOT NULL,
`doctor_id` bigint(20) unsigned DEFAULT NULL,
`image_path` varchar(255) NOT NULL,
`percentage` double DEFAULT NULL,
`complaint` text DEFAULT NULL,
`status` enum('pending','verified','rejected') NOT NULL DEFAULT 'pending',
`diagnosis` varchar(255) DEFAULT NULL,
`doctor_note` text DEFAULT NULL,
`submitted_at` datetime DEFAULT NULL,
`verified_at` datetime DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`is_submitted` varchar(255) NOT NULL DEFAULT 'Tidak',
PRIMARY KEY (`id`),
KEY `submissions_patient_id_foreign` (`patient_id`),
KEY `submissions_doctor_id_foreign` (`doctor_id`),
CONSTRAINT `submissions_doctor_id_foreign` FOREIGN KEY (`doctor_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
CONSTRAINT `submissions_patient_id_foreign` FOREIGN KEY (`patient_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `submissions`
--
LOCK TABLES `submissions` WRITE;
/*!40000 ALTER TABLE `submissions` DISABLE KEYS */;
INSERT INTO `submissions` (`id`, `patient_id`, `doctor_id`, `image_path`, `percentage`, `complaint`, `status`, `diagnosis`, `doctor_note`, `submitted_at`, `verified_at`, `created_at`, `updated_at`, `is_submitted`) VALUES (1,1,NULL,'submissions/hbYBqyJRVvdGO6AsgdVJz4wglU2yjD3tKz16At70.jpg',96.28,NULL,'pending',NULL,NULL,'2025-05-18 07:27:06',NULL,'2025-05-18 00:27:07','2025-05-18 00:27:07','Tidak'),(2,1,NULL,'submissions/pfGQ8rxtqor9dsQLTe4jLjIfFmNiALOmQuwPXjm0.jpg',96.28,NULL,'pending',NULL,NULL,'2025-05-18 07:37:13',NULL,'2025-05-18 00:37:13','2025-05-18 00:37:13','Tidak'),(3,1,NULL,'submissions/u0j6o0fMK7yGySzCxGvreT0lO1C40I5YsR1UOrFc.jpg',96.28,NULL,'pending',NULL,NULL,'2025-05-18 08:20:52',NULL,'2025-05-18 01:20:53','2025-05-18 01:20:53','Tidak'),(4,1,NULL,'submissions/wj6AR7GvEsZxuWRfmOiVhYJBKMcmuZAFNhy1VhV4.jpg',96.28,NULL,'pending',NULL,NULL,'2025-05-18 08:44:25',NULL,'2025-05-18 01:44:26','2025-05-18 01:44:26','Tidak'),(6,1,NULL,'submissions/V7g9LcTyZQowfqSZf3CkjpVSXelhGMDOkAx1bkUI.jpg',96.28,NULL,'pending',NULL,NULL,'2025-05-18 09:07:06',NULL,'2025-05-18 02:07:07','2025-05-18 02:07:07','Tidak'),(9,3,2,'submissions/pcHgjyFd9FqwuTIntSR6iu1c8QE0dgREgaH4w79u.jpg',1.2,'Hai dok ini ngetest','verified','Bukan Melanoma','oke ini bukan melanomi','2025-05-19 04:47:51','2025-05-19 15:13:25','2025-05-18 21:47:51','2025-05-19 08:13:25','Sudah'),(11,3,NULL,'submissions/GpM56OSoUAZiAxT8i6Zk6bMIJBJhXO8tZba8ZVxc.jpg',19.18,NULL,'pending',NULL,NULL,'2025-05-19 07:28:59',NULL,'2025-05-19 00:28:59','2025-05-19 00:28:59','Tidak'),(12,3,2,'submissions/iNHlBnSOphGXnsnEIl1FPr3ril36jRFEHCh0NSZr.jpg',19.18,'sakit dok tangan saya','pending',NULL,NULL,'2025-05-19 12:37:12',NULL,'2025-05-19 05:37:13','2025-05-19 05:37:25','Sudah'),(13,1,2,'submissions/gYwWHw9Kn0Ur8tcg2eiP6V0ymNRewoCAXiAxvx4E.jpg',18.95,'bahaya ini bro','pending',NULL,NULL,'2025-05-19 15:12:04',NULL,'2025-05-19 08:12:04','2025-05-19 08:12:23','Sudah'),(14,3,4,'submissions/3iURDLsOerwkPGXT9nxMIjvtPhUYcG5JjDgLIEd4.jpg',1.2,'Saya jadi pingin ngecek kondisi kulit dok','pending',NULL,NULL,'2025-05-19 15:22:06',NULL,'2025-05-19 08:22:06','2025-05-19 15:40:09','Sudah'),(18,3,NULL,'submissions/S7h3pFBZUpLbTYvSBXlWjirOyHZ5fnhgeoUyinrG.jpg',17.76,NULL,'pending',NULL,NULL,'2025-05-20 02:40:55',NULL,'2025-05-19 19:40:56','2025-05-19 19:40:56','Tidak'),(19,5,NULL,'submissions/ueJ1VcSOvc2DFYRmOzORSibmFohmDESL5yXpbG0t.jpg',NULL,NULL,'pending',NULL,NULL,'2025-05-20 04:54:00',NULL,'2025-05-19 21:54:01','2025-05-19 21:54:01','Tidak'),(20,11,NULL,'submissions/NcrrQ3RbYlHNQQi4TTbYH0iaeuQPkduIwno6LkTv.jpg',26.67,NULL,'pending',NULL,NULL,'2025-05-20 07:43:45',NULL,'2025-05-20 00:43:45','2025-05-20 00:43:45','Tidak'),(21,11,6,'submissions/qs9xP7fcG6xVsSbhBWJmesBBD01puNub06ZxogL6.jpg',26.67,'Wellll','pending',NULL,NULL,'2025-05-20 07:44:22',NULL,'2025-05-20 00:44:23','2025-05-20 00:44:43','Sudah'),(22,11,2,'submissions/P1m2jCtJWrTy18jiGeyUI4ZEXuVa4hEO7d8bhClQ.jpg',52.74,'Very Good','pending',NULL,NULL,'2025-05-20 07:49:17',NULL,'2025-05-20 00:49:19','2025-05-20 00:49:36','Sudah'),(23,1,7,'submissions/aTDrPioLFaNKBsuBa5oDokvAZRE6HhaQhAY5Xtz3.jpg',97.04,'sakit','pending',NULL,NULL,'2025-05-20 10:07:08',NULL,'2025-05-20 03:07:10','2025-05-20 03:07:23','Sudah'),(24,12,7,'submissions/TN0gW2NF2mtMcmUPDgy4rPJRuzRtRzjB0cGxPy0r.jpg',98.59,'oke','pending',NULL,NULL,'2025-05-20 10:29:41',NULL,'2025-05-20 03:29:41','2025-05-20 03:29:59','Sudah'),(25,12,13,'submissions/azD0ZhOPgw06Cm7sj5kpjGNvjgLAkWGtMtbKFgvX.jpg',96.64,'coba','verified','Melanoma','ya','2025-05-20 10:44:51','2025-05-20 12:51:02','2025-05-20 03:44:52','2025-05-20 05:51:02','Sudah'),(26,12,13,'submissions/f47p13gJLQyavoWHPOMLCTgzcdHvMnYhQsuChrJn.jpg',97.69,'alright','verified','Melanoma','kamu terdeteksi melanoma','2025-05-20 10:45:21','2025-08-24 07:52:05','2025-05-20 03:45:22','2025-08-24 00:52:05','Sudah'),(27,12,13,'submissions/rhnnuaizacU3GMouGuHXP3m0c19qDUHFtlE76SxP.jpg',75.41,'aa','verified','Melanoma','ss','2025-05-20 11:27:53','2025-08-19 11:52:38','2025-05-20 04:27:53','2025-08-19 04:52:38','Sudah'),(28,1,NULL,'submissions/nlYeNnXar2mtkwTzXg2RNLZaKTo0NYDaARQEUcPN.jpg',53.64,NULL,'pending',NULL,NULL,'2025-05-20 13:37:27',NULL,'2025-05-20 06:37:27','2025-05-20 06:37:27','Tidak'),(29,12,13,'submissions/jTQ6p4RDFupyZDW4Xm7Q0DMiAawFgJ3JoXpyLZUm.jpg',97.3,'yey','verified','Bukan Melanoma','test','2025-05-20 17:17:55','2025-05-22 03:52:11','2025-05-20 10:17:55','2025-05-21 20:52:11','Sudah'),(30,3,NULL,'submissions/wiePYOLIfJO0m9zK4Cv19YcIbCf7D0YwT3ejZE1S.jpg',1.2,NULL,'pending',NULL,NULL,'2025-05-22 01:45:46',NULL,'2025-05-21 18:45:47','2025-05-21 18:45:47','Tidak'),(31,12,NULL,'submissions/Fbb2qwGBlf2AIFSoIeGH8MeGRqWV37MsMkWCVkDn.jpg',NULL,NULL,'pending',NULL,NULL,'2025-05-22 02:56:51',NULL,'2025-05-21 19:56:52','2025-05-21 19:56:52','Tidak'),(32,12,NULL,'submissions/Gp67Y7wfu7HmGin8NM4pckjX1cKSGeddRDgvM9sy.jpg',NULL,NULL,'pending',NULL,NULL,'2025-05-22 02:57:13',NULL,'2025-05-21 19:57:13','2025-05-21 19:57:13','Tidak'),(33,12,NULL,'submissions/NdxHb9q9lNAOk37Qu2XgRHOaJnmm5dMzd320YR3w.jpg',NULL,NULL,'pending',NULL,NULL,'2025-05-22 02:59:08',NULL,'2025-05-21 19:59:09','2025-05-21 19:59:09','Tidak'),(34,12,NULL,'submissions/QXkwTa5jxyfFYuo20jBSSeZbEdxyqz6qTbfNP5um.jpg',NULL,NULL,'pending',NULL,NULL,'2025-05-22 02:59:49',NULL,'2025-05-21 19:59:50','2025-05-21 19:59:50','Tidak'),(35,12,NULL,'submissions/Be5hzgkbjo8DXelQ9R80qmZLJSclIYAzrd4GIW2k.jpg',NULL,NULL,'pending',NULL,NULL,'2025-05-22 03:02:31',NULL,'2025-05-21 20:02:31','2025-05-21 20:02:31','Tidak'),(36,12,NULL,'submissions/Lq5UFnOIvRvWscqGRvU0WmrJNUJi39bB4CtJppkx.jpg',NULL,NULL,'pending',NULL,NULL,'2025-05-22 03:05:17',NULL,'2025-05-21 20:05:17','2025-05-21 20:05:17','Tidak'),(37,12,13,'submissions/YayCChLghOmUxT1DVjDxVg1NklHCWVIa2K0QLJjv.jpg',NULL,'rakh','verified','Melanoma','y','2025-05-22 03:06:39','2025-05-22 03:49:37','2025-05-21 20:06:40','2025-05-21 20:49:37','Sudah'),(39,12,NULL,'submissions/I6jcjfty29AsSnTliWaBwNGvi6Pc5UX5pefq5LdQ.jpg',75.41,NULL,'pending',NULL,NULL,'2025-05-22 03:09:48',NULL,'2025-05-21 20:09:48','2025-05-21 20:09:48','Tidak'),(42,12,NULL,'submissions/TdI2hI2EIkdVjCiZW9ueG9HLmG4vJ6usOA07C7KK.jpg',86.15,NULL,'pending',NULL,NULL,'2025-05-22 03:20:02',NULL,'2025-05-21 20:20:03','2025-05-21 20:20:03','Tidak'),(45,12,NULL,'submissions/uLqfCcETjZS6QJvofieKZbsy5RmslsEWXmyNxg8m.jpg',NULL,NULL,'pending',NULL,NULL,'2025-05-22 03:24:23',NULL,'2025-05-21 20:24:23','2025-05-21 20:24:23','Tidak'),(46,12,NULL,'submissions/jijSZ1l8GvaTHiEaOnNeMFepUFcbrmU4izy3bCb2.jpg',NULL,NULL,'pending',NULL,NULL,'2025-05-22 03:35:51',NULL,'2025-05-21 20:35:51','2025-05-21 20:35:51','Tidak'),(47,12,NULL,'submissions/h4uMrXnRehtckmGRCOAom9AaTuhjIvJIDWtcewkp.jpg',NULL,NULL,'pending',NULL,NULL,'2025-05-22 03:36:26',NULL,'2025-05-21 20:36:26','2025-05-21 20:36:26','Tidak'),(48,12,NULL,'submissions/qS93xYCyJ3CCi97W1qpKIKcgSkjgx68LqabPHIMA.jpg',91.51,NULL,'pending',NULL,NULL,'2025-05-22 03:37:02',NULL,'2025-05-21 20:37:02','2025-05-21 20:37:02','Tidak'),(49,12,NULL,'submissions/tw8DT9OomaXf3lgXY0H5OCBgyabXJTOLMKgc9zF6.jpg',NULL,NULL,'pending',NULL,NULL,'2025-05-22 03:37:21',NULL,'2025-05-21 20:37:22','2025-05-21 20:37:22','Tidak'),(50,12,NULL,'submissions/Vrz2gEhYN6ANTGohVnPrCv6gruSX6l2CTOy2HnTo.jpg',NULL,NULL,'pending',NULL,NULL,'2025-05-22 03:39:09',NULL,'2025-05-21 20:39:09','2025-05-21 20:39:09','Tidak'),(51,12,NULL,'submissions/lWCWAauNX6KgE7xwcMX5ckv3k47L0IAyRATEtG0U.jpg',60.32,NULL,'pending',NULL,NULL,'2025-05-22 03:41:43',NULL,'2025-05-21 20:41:44','2025-05-21 20:41:44','Tidak'),(52,12,NULL,'submissions/vawwQnRQct5YyC5RR5ZXphEQ2knvF40EbAFssh6S.jpg',48.2,NULL,'pending',NULL,NULL,'2025-05-22 03:42:08',NULL,'2025-05-21 20:42:08','2025-05-21 20:42:08','Tidak'),(53,12,NULL,'submissions/exCicgvI88WTbAGeD2v4jBAQgiuvfH3kxKXzkUbn.jpg',17.3,NULL,'pending',NULL,NULL,'2025-05-22 03:43:12',NULL,'2025-05-21 20:43:12','2025-05-21 20:43:12','Tidak'),(57,12,NULL,'submissions/XPAxGCcR1KKe61H7r4EVVLqmVKcfRehpcIy0drlS.jpg',81.97,NULL,'pending',NULL,NULL,'2025-05-22 03:45:48',NULL,'2025-05-21 20:45:48','2025-05-21 20:45:48','Tidak'),(58,12,NULL,'submissions/gEwU2XhiiC5CqRF8I6zGjcnXO1d58dmhXFYvXhRJ.jpg',53.25,NULL,'pending',NULL,NULL,'2025-05-22 03:46:02',NULL,'2025-05-21 20:46:02','2025-05-21 20:46:02','Tidak'),(59,12,7,'submissions/oeqprXjYweuuKtcsoXB7nFIBBJT9DsTxfkEdB1Yy.jpg',40.2,'jju','pending',NULL,NULL,'2025-05-22 03:53:30',NULL,'2025-05-21 20:53:30','2025-05-21 20:54:32','Sudah'),(60,12,NULL,'submissions/G09DQjaOtrykdCKFVpMm9BnuTuP0FfX9sMhBiiG6.jpg',30.6,NULL,'pending',NULL,NULL,'2025-05-22 04:04:06',NULL,'2025-05-21 21:04:07','2025-05-21 21:04:07','Tidak'),(61,3,6,'submissions/KVVlujUzwg5Y31j8MLcMIOPTaJozzUyLnJszC95M.jpg',2.37,'COBA','pending',NULL,NULL,'2025-05-24 10:00:37',NULL,'2025-05-24 03:00:37','2025-05-24 03:01:05','Sudah'),(62,15,NULL,'submissions/IiERmYO4qhVaNiStd3YXwIqMkhqwRpXt6ijHDNot.jpg',2.84,NULL,'pending',NULL,NULL,'2025-05-25 06:16:35',NULL,'2025-05-24 23:16:38','2025-05-24 23:16:38','Tidak'),(63,16,13,'submissions/dqnHzCnX5clCDF2TBcvLpIbNUG8zrebXrwljWKSV.jpg',99.83,'Saya mengeluh','verified','Melanoma','aa','2025-05-25 09:40:25','2025-08-19 11:50:13','2025-05-25 02:40:26','2025-08-19 04:50:13','Sudah'),(64,1,NULL,'submissions/82DaVpry5BTxjILy3EeXfs2PQxOejNf3CWz9lsAL.jpg',46.13,NULL,'pending',NULL,NULL,'2025-06-09 09:26:03',NULL,'2025-06-09 02:26:05','2025-06-09 02:26:05','Tidak'),(65,12,18,'submissions/NlXRQHF4xRWkNCGiwOGpQRFnCA8bwjr0CKm1oQxg.jpg',25.78,'anjay','pending',NULL,NULL,'2025-08-13 05:31:57',NULL,'2025-08-12 22:31:58','2025-08-12 22:32:26','Sudah'),(66,12,18,'submissions/roGHiCSwQVht8EBU7f5cWHSPMMjH1pVbNaJut8Fs.jpg',0.02,'gaj','pending',NULL,NULL,'2025-08-16 10:35:30',NULL,'2025-08-16 03:35:31','2025-08-16 03:35:48','Sudah'),(67,12,NULL,'submissions/u0Ej44JFPk1BkWobjivtfr5CdQSmiKaxx3d4Q8yJ.jpg',0.04,NULL,'pending',NULL,NULL,'2025-08-16 10:36:34',NULL,'2025-08-16 03:36:34','2025-08-16 03:36:34','Tidak'),(68,12,NULL,'submissions/wP87PWA5xlYtB9VFhgzOxfRbYiIe6bQKpKR8iAfk.jpg',5.48,NULL,'pending',NULL,NULL,'2025-08-16 10:36:49',NULL,'2025-08-16 03:36:49','2025-08-16 03:36:49','Tidak'),(69,12,NULL,'submissions/LmmwmYUiQEHfaw7C3hyqm99baJa7hsTLySOEpjR6.jpg',47.52,NULL,'pending',NULL,NULL,'2025-08-16 10:37:43',NULL,'2025-08-16 03:37:44','2025-08-16 03:37:44','Tidak'),(70,12,NULL,'submissions/teUsUAz5mPHRtx4a1g2cbndk21LIYavCW5to2QiA.jpg',5.93,NULL,'pending',NULL,NULL,'2025-08-16 10:38:10',NULL,'2025-08-16 03:38:10','2025-08-16 03:38:10','Tidak'),(71,12,NULL,'submissions/qgKQOK7XxDWUAgdbmXpjJ2QtAsvr44gkXL1jRefj.jpg',68.92,NULL,'pending',NULL,NULL,'2025-08-16 10:38:25',NULL,'2025-08-16 03:38:25','2025-08-16 03:38:25','Tidak'),(72,12,NULL,'submissions/yHgbmrIHWKYxLTXPaEqakAViGyeGfuLvq0o9PYRs.jpg',72.56,NULL,'pending',NULL,NULL,'2025-08-16 10:40:51',NULL,'2025-08-16 03:40:51','2025-08-16 03:40:51','Tidak'),(73,12,NULL,'submissions/FyjpkGuyEEO6WOW5rPLaGmmeMlSbU6CLWfFOM0F6.jpg',0.98,NULL,'pending',NULL,NULL,'2025-08-19 10:43:28',NULL,'2025-08-19 03:43:29','2025-08-19 03:43:29','Tidak'),(74,17,13,'submissions/BlMVBTObTrT8zpLuPfD405d8tdwwVajcfYyVHgW1.jpg',25.62,'tes','verified','Bukan Melanoma','bukan','2025-11-14 08:04:24','2025-11-19 15:35:05','2025-11-14 01:04:25','2025-11-19 08:35:05','Sudah'),(76,17,NULL,'submissions/wn59vDNu587SPtFTLgydcf5xLuMluiGuYyHDg1jo.jpg',3.58,NULL,'pending',NULL,NULL,'2025-11-14 08:57:43',NULL,'2025-11-14 01:57:43','2025-11-14 01:57:43','Tidak'),(78,17,7,'submissions/vLhpXcryCfibQQi0t79iJW1sTTJrNkOWjPdS0ui3.jpg',20.41,'tes','pending',NULL,NULL,'2025-11-19 15:27:51',NULL,'2025-11-19 08:27:52','2025-11-19 08:28:20','Sudah'),(79,17,13,'submissions/4HKEgI5IaZtNeD7eEtcoJ5424lCgzasdW4mm7XuN.jpg',76.03,'tes lagi','verified','Bukan Melanoma','bukan inj mah','2025-11-19 15:28:51','2025-11-19 15:35:29','2025-11-19 08:28:51','2025-11-19 08:35:29','Sudah'),(82,1,NULL,'submissions/ktjuSs3fUH4z6rpVPHs4MSCWZh4IWP4jfJEBu0As.jpg',19.82,NULL,'pending',NULL,NULL,'2025-11-30 12:35:39',NULL,'2025-11-30 05:35:40','2025-11-30 05:35:40','Tidak'),(83,1,NULL,'submissions/iRoh2wqG1FPejw3jXBzSgJlDJtzGHRGEb9wtViSq.jpg',13.1,NULL,'pending',NULL,NULL,'2025-11-30 12:37:10',NULL,'2025-11-30 05:37:10','2025-11-30 05:37:10','Tidak'),(84,1,NULL,'submissions/RFweK6Xr5XM7TjHrzIpQIxalphIGLJwoY4uuXJs7.jpg',13.14,NULL,'pending',NULL,NULL,'2025-11-30 12:37:19',NULL,'2025-11-30 05:37:20','2025-11-30 05:37:20','Tidak'),(85,1,NULL,'submissions/XnQyqI1TgKiCKDnZuQQjfSqMf9dRHkDqE0mWrD4m.jpg',3.95,NULL,'pending',NULL,NULL,'2026-01-06 05:26:52',NULL,'2026-01-05 22:26:53','2026-01-05 22:26:53','Tidak'),(86,1,NULL,'submissions/PFNCXfhLCGhhtBvcWqEZqorau4p28jwzsaJymB9q.jpg',1.02,NULL,'pending',NULL,NULL,'2026-04-10 08:08:14',NULL,'2026-04-10 01:08:14','2026-04-10 01:08:14','Tidak'),(87,1,NULL,'submissions/Uy2Twa39Q1olvV98M7goW4uxFkzH6deBgZafX2UY.jpg',1.02,NULL,'pending',NULL,NULL,'2026-04-21 06:45:52',NULL,'2026-04-20 23:45:53','2026-04-20 23:45:53','Tidak'),(88,1,NULL,'submissions/wqP4plvHPcyas9N2QA0qUajSynCTXMnxyRchujXs.jpg',1.02,NULL,'pending',NULL,NULL,'2026-04-30 03:31:06',NULL,'2026-04-29 20:31:07','2026-04-29 20:31:07','Tidak');
/*!40000 ALTER TABLE `submissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(255) NOT NULL,
`remember_token` varchar(100) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `verifications`
--
DROP TABLE IF EXISTS `verifications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `verifications` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `verifications`
--
LOCK TABLES `verifications` WRITE;
/*!40000 ALTER TABLE `verifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `verifications` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping events for database 'humicpro_myskin_v2'
--
--
-- Dumping routines for database 'humicpro_myskin_v2'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2026-05-12 16:17:47
Reference in New Issue View Git Blame Copy Permalink