/*!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 */; /*!50503 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 */; SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN; SET @@SESSION.SQL_LOG_BIN= 0; SET @@GLOBAL.GTID_PURGED=/*!80000 '+'*/ 'feea8968-908c-11f1-93d0-2e30697d3aa9:1-147150'; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `meyahealth_production_export` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */ /*!80016 DEFAULT ENCRYPTION='N' */; USE `meyahealth_production_export`; DROP TABLE IF EXISTS `cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cache` ( `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` bigint NOT NULL, PRIMARY KEY (`key`), KEY `cache_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `cache` WRITE; /*!40000 ALTER TABLE `cache` DISABLE KEYS */; /*!40000 ALTER TABLE `cache` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `cache_locks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cache_locks` ( `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` bigint NOT NULL, PRIMARY KEY (`key`), KEY `cache_locks_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `cache_locks` WRITE; /*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */; /*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `commission_rules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `commission_rules` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `scope_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tenant_id` bigint unsigned DEFAULT NULL, `category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `product_id` bigint unsigned DEFAULT NULL, `percentage_rate` decimal(5,2) NOT NULL DEFAULT '0.00', `fixed_fee` bigint unsigned NOT NULL DEFAULT '0', `priority` smallint unsigned NOT NULL DEFAULT '0', `effective_from` timestamp NOT NULL, `effective_until` timestamp NULL DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `commission_rules_scope_type_is_active_effective_from_index` (`scope_type`,`is_active`,`effective_from`), KEY `commission_rules_tenant_id_is_active_index` (`tenant_id`,`is_active`), KEY `commission_rules_category_is_active_index` (`category`,`is_active`), KEY `commission_rules_product_id_is_active_index` (`product_id`,`is_active`), CONSTRAINT `commission_rules_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE, CONSTRAINT `commission_rules_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `commission_rules` WRITE; /*!40000 ALTER TABLE `commission_rules` DISABLE KEYS */; INSERT INTO `commission_rules` VALUES (1,'Komisi marketplace global','global',NULL,NULL,NULL,10.00,0,0,'2025-12-31 17:00:00',NULL,1,'2026-08-29 00:44:59','2026-08-29 00:44:59'); /*!40000 ALTER TABLE `commission_rules` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `consultation_messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `consultation_messages` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `consultation_id` bigint unsigned NOT NULL, `sender_user_id` bigint unsigned DEFAULT NULL, `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `message_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'text', `attachment_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `read_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `consultation_messages_sender_user_id_foreign` (`sender_user_id`), KEY `consultation_messages_consultation_id_created_at_index` (`consultation_id`,`created_at`), CONSTRAINT `consultation_messages_consultation_id_foreign` FOREIGN KEY (`consultation_id`) REFERENCES `consultations` (`id`) ON DELETE CASCADE, CONSTRAINT `consultation_messages_sender_user_id_foreign` FOREIGN KEY (`sender_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `consultation_messages` WRITE; /*!40000 ALTER TABLE `consultation_messages` DISABLE KEYS */; /*!40000 ALTER TABLE `consultation_messages` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `consultations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `consultations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `consultation_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `patient_user_id` bigint unsigned NOT NULL, `doctor_profile_id` bigint unsigned NOT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'requested', `chief_complaint` text COLLATE utf8mb4_unicode_ci NOT NULL, `scheduled_at` timestamp NOT NULL, `consultation_fee` bigint unsigned NOT NULL DEFAULT '0', `payment_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unpaid', `started_at` timestamp NULL DEFAULT NULL, `completed_at` timestamp NULL DEFAULT NULL, `cancelled_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `consultations_consultation_number_unique` (`consultation_number`), KEY `consultations_doctor_profile_id_status_scheduled_at_index` (`doctor_profile_id`,`status`,`scheduled_at`), KEY `consultations_patient_user_id_created_at_index` (`patient_user_id`,`created_at`), CONSTRAINT `consultations_doctor_profile_id_foreign` FOREIGN KEY (`doctor_profile_id`) REFERENCES `doctor_profiles` (`id`) ON DELETE RESTRICT, CONSTRAINT `consultations_patient_user_id_foreign` FOREIGN KEY (`patient_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `consultations` WRITE; /*!40000 ALTER TABLE `consultations` DISABLE KEYS */; /*!40000 ALTER TABLE `consultations` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `coupon_tenant`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `coupon_tenant` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `coupon_id` bigint unsigned NOT NULL, `tenant_id` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `coupon_tenant_coupon_id_tenant_id_unique` (`coupon_id`,`tenant_id`), KEY `coupon_tenant_tenant_id_foreign` (`tenant_id`), CONSTRAINT `coupon_tenant_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE, CONSTRAINT `coupon_tenant_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `coupon_tenant` WRITE; /*!40000 ALTER TABLE `coupon_tenant` DISABLE KEYS */; /*!40000 ALTER TABLE `coupon_tenant` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `coupon_usages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `coupon_usages` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `coupon_id` bigint unsigned NOT NULL, `user_id` bigint unsigned DEFAULT NULL, `platform_order_id` bigint unsigned NOT NULL, `discount_amount` bigint unsigned NOT NULL, `used_at` timestamp NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `coupon_usages_platform_order_id_unique` (`platform_order_id`), KEY `coupon_usages_user_id_foreign` (`user_id`), KEY `coupon_usages_coupon_id_user_id_index` (`coupon_id`,`user_id`), CONSTRAINT `coupon_usages_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE, CONSTRAINT `coupon_usages_platform_order_id_foreign` FOREIGN KEY (`platform_order_id`) REFERENCES `platform_orders` (`id`) ON DELETE CASCADE, CONSTRAINT `coupon_usages_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `coupon_usages` WRITE; /*!40000 ALTER TABLE `coupon_usages` DISABLE KEYS */; /*!40000 ALTER TABLE `coupon_usages` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `coupons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `coupons` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `issuer_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tenant_id` bigint unsigned DEFAULT NULL, `assigned_user_id` bigint unsigned DEFAULT NULL, `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `banner_image_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `terms` text COLLATE utf8mb4_unicode_ci, `merchant_scope` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'all', `exclude_prescription_products` tinyint(1) NOT NULL DEFAULT '0', `included_categories` json DEFAULT NULL, `excluded_categories` json DEFAULT NULL, `is_featured` tinyint(1) NOT NULL DEFAULT '0', `sort_order` int unsigned NOT NULL DEFAULT '0', `discount_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `discount_value` int unsigned NOT NULL, `max_discount` bigint unsigned DEFAULT NULL, `min_purchase` bigint unsigned NOT NULL DEFAULT '0', `usage_limit` int unsigned DEFAULT NULL, `usage_per_user` int unsigned NOT NULL DEFAULT '1', `funding_source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'platform', `starts_at` timestamp NOT NULL, `expires_at` timestamp NOT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `coupons_code_unique` (`code`), KEY `coupons_tenant_id_foreign` (`tenant_id`), KEY `coupons_assigned_user_id_status_expires_at_index` (`assigned_user_id`,`status`,`expires_at`), CONSTRAINT `coupons_assigned_user_id_foreign` FOREIGN KEY (`assigned_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `coupons_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `coupons` WRITE; /*!40000 ALTER TABLE `coupons` DISABLE KEYS */; INSERT INTO `coupons` VALUES (1,'platform',NULL,NULL,'SEHAT20','Diskon Sehat 20%','images/promos/sehat20.svg','Diskon kebutuhan kesehatan harian dari seluruh apotek terverifikasi.','Minimal belanja Rp50.000. Maksimal satu kali pemakaian per akun. Tidak berlaku untuk obat resep.','all',1,NULL,NULL,1,1,'percentage',20,25000,50000,1000,1,'platform','2026-07-29 00:44:59','2027-08-29 00:44:59','active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(2,'platform',NULL,NULL,'VITAMIN15','Vitamin Lebih Hemat','images/promos/vitamin15.svg','Diskon 15% untuk produk kategori vitamin.','Minimal belanja Rp75.000. Berlaku satu kali per akun.','all',0,'[\"vitamin\"]',NULL,1,2,'percentage',15,30000,75000,1000,1,'platform','2026-08-28 00:44:59','2026-11-29 00:44:59','active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(3,'platform',NULL,NULL,'ONGKIR10','Hemat Pengiriman','images/promos/ongkir10.svg','Potongan belanja untuk membantu biaya pengiriman pilihan Biteship.','Minimal belanja Rp100.000. Berlaku satu kali per akun.','all',0,NULL,NULL,1,3,'fixed',10000,10000,100000,1000,1,'platform','2026-08-28 00:44:59','2026-11-29 00:44:59','active','2026-08-29 00:44:59','2026-08-29 00:44:59'); /*!40000 ALTER TABLE `coupons` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `customer_addresses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customer_addresses` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `label` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `recipient_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `recipient_phone` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `address_line` text COLLATE utf8mb4_unicode_ci NOT NULL, `district` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `province` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `postal_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `delivery_notes` text COLLATE utf8mb4_unicode_ci, `latitude` decimal(10,7) DEFAULT NULL, `longitude` decimal(10,7) DEFAULT NULL, `is_default` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `customer_addresses_user_id_is_default_index` (`user_id`,`is_default`), CONSTRAINT `customer_addresses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `customer_addresses` WRITE; /*!40000 ALTER TABLE `customer_addresses` DISABLE KEYS */; INSERT INTO `customer_addresses` VALUES (1,1,'Rumah','Pelanggan MeyaHealth','081200000001','Jl. Kemang Raya No. 24','Mampang Prapatan','Jakarta Selatan','DKI Jakarta','12730','Hubungi penerima saat tiba.',NULL,NULL,1,'2026-08-29 00:44:55','2026-08-29 00:44:55'); /*!40000 ALTER TABLE `customer_addresses` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `delivery_shipments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `delivery_shipments` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `seller_order_id` bigint unsigned NOT NULL, `tenant_id` bigint unsigned NOT NULL, `outlet_id` bigint unsigned NOT NULL, `shipping_quote_id` bigint unsigned DEFAULT NULL, `recipient_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `recipient_phone` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `delivery_address` text COLLATE utf8mb4_unicode_ci NOT NULL, `delivery_notes` text COLLATE utf8mb4_unicode_ci, `provider` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'demo', `reference_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `external_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `provider_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `provider_payload` longtext COLLATE utf8mb4_unicode_ci, `failure_reason` text COLLATE utf8mb4_unicode_ci, `last_event_at` timestamp NULL DEFAULT NULL, `booking_started_at` timestamp NULL DEFAULT NULL, `reconciliation_required_at` timestamp NULL DEFAULT NULL, `courier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'MeyaExpress', `service_level` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'regular', `tracking_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `shipping_fee` bigint unsigned NOT NULL DEFAULT '0', `quoted_service` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `quoted_cost` bigint unsigned DEFAULT NULL, `quoted_eta` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `quote_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `quoted_at` timestamp NULL DEFAULT NULL, `revalidated_at` timestamp NULL DEFAULT NULL, `selection_strategy_version` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `candidate_count` int unsigned NOT NULL DEFAULT '0', `selection_reason` text COLLATE utf8mb4_unicode_ci, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `ready_at` timestamp NULL DEFAULT NULL, `picked_up_at` timestamp NULL DEFAULT NULL, `delivered_at` timestamp NULL DEFAULT NULL, `failed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `delivery_shipments_seller_order_id_unique` (`seller_order_id`), UNIQUE KEY `delivery_shipments_tracking_number_unique` (`tracking_number`), UNIQUE KEY `delivery_shipments_reference_id_unique` (`reference_id`), UNIQUE KEY `delivery_shipments_external_id_unique` (`external_id`), KEY `delivery_shipments_outlet_id_foreign` (`outlet_id`), KEY `delivery_shipments_tenant_id_status_created_at_index` (`tenant_id`,`status`,`created_at`), KEY `delivery_shipments_provider_index` (`provider`), KEY `delivery_shipments_booking_started_at_index` (`booking_started_at`), KEY `delivery_shipments_shipping_quote_id_foreign` (`shipping_quote_id`), CONSTRAINT `delivery_shipments_outlet_id_foreign` FOREIGN KEY (`outlet_id`) REFERENCES `pharmacy_outlets` (`id`), CONSTRAINT `delivery_shipments_seller_order_id_foreign` FOREIGN KEY (`seller_order_id`) REFERENCES `seller_orders` (`id`) ON DELETE CASCADE, CONSTRAINT `delivery_shipments_shipping_quote_id_foreign` FOREIGN KEY (`shipping_quote_id`) REFERENCES `shipping_quotes` (`id`) ON DELETE SET NULL, CONSTRAINT `delivery_shipments_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `delivery_shipments` WRITE; /*!40000 ALTER TABLE `delivery_shipments` DISABLE KEYS */; /*!40000 ALTER TABLE `delivery_shipments` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `digital_prescription_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `digital_prescription_items` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `digital_prescription_id` bigint unsigned NOT NULL, `product_id` bigint unsigned DEFAULT NULL, `medicine_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `strength` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dosage` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `frequency` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `duration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `quantity` int unsigned NOT NULL, `instructions` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `digital_prescription_items_digital_prescription_id_foreign` (`digital_prescription_id`), KEY `digital_prescription_items_product_id_foreign` (`product_id`), CONSTRAINT `digital_prescription_items_digital_prescription_id_foreign` FOREIGN KEY (`digital_prescription_id`) REFERENCES `digital_prescriptions` (`id`) ON DELETE CASCADE, CONSTRAINT `digital_prescription_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `digital_prescription_items` WRITE; /*!40000 ALTER TABLE `digital_prescription_items` DISABLE KEYS */; /*!40000 ALTER TABLE `digital_prescription_items` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `digital_prescriptions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `digital_prescriptions` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `prescription_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `consultation_id` bigint unsigned NOT NULL, `patient_user_id` bigint unsigned NOT NULL, `doctor_profile_id` bigint unsigned NOT NULL, `clinical_notes` text COLLATE utf8mb4_unicode_ci, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'issued', `issued_at` timestamp NOT NULL, `fulfilled_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `digital_prescriptions_prescription_number_unique` (`prescription_number`), UNIQUE KEY `digital_prescriptions_consultation_id_unique` (`consultation_id`), KEY `digital_prescriptions_doctor_profile_id_foreign` (`doctor_profile_id`), KEY `digital_prescriptions_patient_user_id_status_index` (`patient_user_id`,`status`), CONSTRAINT `digital_prescriptions_consultation_id_foreign` FOREIGN KEY (`consultation_id`) REFERENCES `consultations` (`id`) ON DELETE CASCADE, CONSTRAINT `digital_prescriptions_doctor_profile_id_foreign` FOREIGN KEY (`doctor_profile_id`) REFERENCES `doctor_profiles` (`id`) ON DELETE RESTRICT, CONSTRAINT `digital_prescriptions_patient_user_id_foreign` FOREIGN KEY (`patient_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `digital_prescriptions` WRITE; /*!40000 ALTER TABLE `digital_prescriptions` DISABLE KEYS */; /*!40000 ALTER TABLE `digital_prescriptions` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `doctor_bank_accounts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `doctor_bank_accounts` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `doctor_profile_id` bigint unsigned NOT NULL, `bank_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `account_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `account_holder_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `verification_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `verified_by` bigint unsigned DEFAULT NULL, `verified_at` timestamp NULL DEFAULT NULL, `rejection_reason` text COLLATE utf8mb4_unicode_ci, `is_primary` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `doctor_bank_accounts_doctor_profile_id_account_number_unique` (`doctor_profile_id`,`account_number`), KEY `doctor_bank_accounts_verified_by_foreign` (`verified_by`), CONSTRAINT `doctor_bank_accounts_doctor_profile_id_foreign` FOREIGN KEY (`doctor_profile_id`) REFERENCES `doctor_profiles` (`id`) ON DELETE CASCADE, CONSTRAINT `doctor_bank_accounts_verified_by_foreign` FOREIGN KEY (`verified_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `doctor_bank_accounts` WRITE; /*!40000 ALTER TABLE `doctor_bank_accounts` DISABLE KEYS */; /*!40000 ALTER TABLE `doctor_bank_accounts` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `doctor_earnings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `doctor_earnings` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `doctor_profile_id` bigint unsigned NOT NULL, `consultation_id` bigint unsigned NOT NULL, `gross_amount` bigint unsigned NOT NULL, `platform_fee` bigint unsigned NOT NULL DEFAULT '0', `net_amount` bigint unsigned NOT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'available', `doctor_withdrawal_request_id` bigint unsigned DEFAULT NULL, `available_at` timestamp NOT NULL, `withdrawn_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `doctor_earnings_consultation_id_unique` (`consultation_id`), KEY `doctor_earnings_doctor_profile_id_status_index` (`doctor_profile_id`,`status`), CONSTRAINT `doctor_earnings_consultation_id_foreign` FOREIGN KEY (`consultation_id`) REFERENCES `consultations` (`id`) ON DELETE CASCADE, CONSTRAINT `doctor_earnings_doctor_profile_id_foreign` FOREIGN KEY (`doctor_profile_id`) REFERENCES `doctor_profiles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `doctor_earnings` WRITE; /*!40000 ALTER TABLE `doctor_earnings` DISABLE KEYS */; /*!40000 ALTER TABLE `doctor_earnings` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `doctor_profiles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `doctor_profiles` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `registration_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `specialty` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `bio` text COLLATE utf8mb4_unicode_ci, `experience_years` smallint unsigned NOT NULL DEFAULT '0', `consultation_fee` bigint unsigned NOT NULL DEFAULT '0', `photo_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `rating` decimal(3,2) NOT NULL DEFAULT '0.00', `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `verified_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `doctor_profiles_user_id_unique` (`user_id`), UNIQUE KEY `doctor_profiles_slug_unique` (`slug`), UNIQUE KEY `doctor_profiles_registration_number_unique` (`registration_number`), KEY `doctor_profiles_status_specialty_index` (`status`,`specialty`), CONSTRAINT `doctor_profiles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `doctor_profiles` WRITE; /*!40000 ALTER TABLE `doctor_profiles` DISABLE KEYS */; INSERT INTO `doctor_profiles` VALUES (1,9,'dr-nadia-samudra-sp-pd','STR-3171-2026-0001','Penyakit Dalam','Dokter spesialis penyakit dalam dengan fokus pada penanganan keluhan metabolik, hipertensi, dan kesehatan dewasa.',9,75000,NULL,4.90,'verified','2026-08-29 00:44:55','2026-08-29 00:44:55','2026-08-29 00:44:55'),(2,10,'dr-raka-pratama-sp-a','STR-3171-2026-0002','Kesehatan Anak','Dokter Kesehatan Anak untuk layanan konsultasi online MeyaHealth.',7,69000,NULL,4.82,'verified','2026-08-29 00:44:56','2026-08-29 00:44:56','2026-08-29 00:44:56'),(3,11,'dr-maya-kirana-sp-dv','STR-3171-2026-0003','Kulit & Kecantikan','Dokter Kulit & Kecantikan untuk layanan konsultasi online MeyaHealth.',11,85000,NULL,4.88,'verified','2026-08-29 00:44:56','2026-08-29 00:44:56','2026-08-29 00:44:56'),(4,12,'dr-satria-wijaya-m-gizi','STR-3171-2026-0004','Diet & Gizi','Dokter Diet & Gizi untuk layanan konsultasi online MeyaHealth.',6,55000,NULL,4.76,'verified','2026-08-29 00:44:56','2026-08-29 00:44:56','2026-08-29 00:44:56'),(5,13,'dr-lestari-amalia','STR-3171-2026-0005','Dokter Umum','Dokter Dokter Umum untuk layanan konsultasi online MeyaHealth.',5,45000,NULL,4.71,'verified','2026-08-29 00:44:56','2026-08-29 00:44:56','2026-08-29 00:44:56'); /*!40000 ALTER TABLE `doctor_profiles` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `doctor_schedules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `doctor_schedules` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `doctor_profile_id` bigint unsigned NOT NULL, `day_of_week` tinyint unsigned NOT NULL, `starts_at` time NOT NULL, `ends_at` time NOT NULL, `timezone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Asia/Jakarta', `is_active` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `doctor_schedule_slot_unique` (`doctor_profile_id`,`day_of_week`,`starts_at`,`ends_at`), CONSTRAINT `doctor_schedules_doctor_profile_id_foreign` FOREIGN KEY (`doctor_profile_id`) REFERENCES `doctor_profiles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `doctor_schedules` WRITE; /*!40000 ALTER TABLE `doctor_schedules` DISABLE KEYS */; INSERT INTO `doctor_schedules` VALUES (1,1,1,'09:00:00','17:00:00','Asia/Jakarta',1,'2026-08-29 00:44:55','2026-08-29 00:44:55'),(2,1,2,'09:00:00','17:00:00','Asia/Jakarta',1,'2026-08-29 00:44:55','2026-08-29 00:44:55'),(3,1,3,'09:00:00','17:00:00','Asia/Jakarta',1,'2026-08-29 00:44:55','2026-08-29 00:44:55'),(4,1,4,'09:00:00','17:00:00','Asia/Jakarta',1,'2026-08-29 00:44:55','2026-08-29 00:44:55'),(5,1,5,'09:00:00','17:00:00','Asia/Jakarta',1,'2026-08-29 00:44:55','2026-08-29 00:44:55'),(6,2,1,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(7,2,2,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(8,2,3,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(9,2,4,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(10,2,5,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(11,2,6,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(12,3,1,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(13,3,2,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(14,3,3,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(15,3,4,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(16,3,5,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(17,3,6,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(18,4,1,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(19,4,2,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(20,4,3,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(21,4,4,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(22,4,5,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(23,4,6,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(24,5,1,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(25,5,2,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(26,5,3,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(27,5,4,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(28,5,5,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(29,5,6,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'); /*!40000 ALTER TABLE `doctor_schedules` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `doctor_withdrawal_requests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `doctor_withdrawal_requests` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `doctor_profile_id` bigint unsigned NOT NULL, `doctor_bank_account_id` bigint unsigned NOT NULL, `requested_by` bigint unsigned NOT NULL, `reviewed_by` bigint unsigned DEFAULT NULL, `withdrawal_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `idempotency_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `amount` bigint unsigned NOT NULL, `currency` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'IDR', `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `payout_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `request_note` text COLLATE utf8mb4_unicode_ci, `review_note` text COLLATE utf8mb4_unicode_ci, `requested_at` timestamp NOT NULL, `reviewed_at` timestamp NULL DEFAULT NULL, `paid_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `doctor_withdrawal_requests_withdrawal_number_unique` (`withdrawal_number`), UNIQUE KEY `doctor_withdrawal_requests_idempotency_key_unique` (`idempotency_key`), KEY `doctor_withdrawal_requests_doctor_bank_account_id_foreign` (`doctor_bank_account_id`), KEY `doctor_withdrawal_requests_requested_by_foreign` (`requested_by`), KEY `doctor_withdrawal_requests_reviewed_by_foreign` (`reviewed_by`), KEY `doctor_withdrawal_requests_doctor_profile_id_status_index` (`doctor_profile_id`,`status`), CONSTRAINT `doctor_withdrawal_requests_doctor_bank_account_id_foreign` FOREIGN KEY (`doctor_bank_account_id`) REFERENCES `doctor_bank_accounts` (`id`) ON DELETE RESTRICT, CONSTRAINT `doctor_withdrawal_requests_doctor_profile_id_foreign` FOREIGN KEY (`doctor_profile_id`) REFERENCES `doctor_profiles` (`id`) ON DELETE CASCADE, CONSTRAINT `doctor_withdrawal_requests_requested_by_foreign` FOREIGN KEY (`requested_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT, CONSTRAINT `doctor_withdrawal_requests_reviewed_by_foreign` FOREIGN KEY (`reviewed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `doctor_withdrawal_requests` WRITE; /*!40000 ALTER TABLE `doctor_withdrawal_requests` DISABLE KEYS */; /*!40000 ALTER TABLE `doctor_withdrawal_requests` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `failed_jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`), KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `financial_ledger_entries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `financial_ledger_entries` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint unsigned DEFAULT NULL, `seller_order_id` bigint unsigned DEFAULT NULL, `platform_order_id` bigint unsigned DEFAULT NULL, `refund_id` bigint unsigned DEFAULT NULL, `withdrawal_request_id` bigint unsigned DEFAULT NULL, `idempotency_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `entry_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `account` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `direction` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `amount` bigint unsigned NOT NULL, `currency` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'IDR', `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `metadata` json DEFAULT NULL, `created_by` bigint unsigned DEFAULT NULL, `occurred_at` timestamp NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `financial_ledger_entries_idempotency_key_unique` (`idempotency_key`), KEY `financial_ledger_entries_platform_order_id_foreign` (`platform_order_id`), KEY `financial_ledger_entries_refund_id_foreign` (`refund_id`), KEY `financial_ledger_entries_created_by_foreign` (`created_by`), KEY `financial_ledger_entries_tenant_id_account_occurred_at_index` (`tenant_id`,`account`,`occurred_at`), KEY `financial_ledger_entries_seller_order_id_occurred_at_index` (`seller_order_id`,`occurred_at`), KEY `financial_ledger_entries_withdrawal_request_id_occurred_at_index` (`withdrawal_request_id`,`occurred_at`), CONSTRAINT `financial_ledger_entries_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `financial_ledger_entries_platform_order_id_foreign` FOREIGN KEY (`platform_order_id`) REFERENCES `platform_orders` (`id`) ON DELETE RESTRICT, CONSTRAINT `financial_ledger_entries_refund_id_foreign` FOREIGN KEY (`refund_id`) REFERENCES `refunds` (`id`) ON DELETE RESTRICT, CONSTRAINT `financial_ledger_entries_seller_order_id_foreign` FOREIGN KEY (`seller_order_id`) REFERENCES `seller_orders` (`id`) ON DELETE RESTRICT, CONSTRAINT `financial_ledger_entries_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE RESTRICT, CONSTRAINT `financial_ledger_entries_withdrawal_request_id_foreign` FOREIGN KEY (`withdrawal_request_id`) REFERENCES `withdrawal_requests` (`id`) ON DELETE RESTRICT ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `financial_ledger_entries` WRITE; /*!40000 ALTER TABLE `financial_ledger_entries` DISABLE KEYS */; /*!40000 ALTER TABLE `financial_ledger_entries` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `inventory_batches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `inventory_batches` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint unsigned NOT NULL, `outlet_id` bigint unsigned NOT NULL, `product_id` bigint unsigned NOT NULL, `batch_number` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `expired_at` date NOT NULL, `quantity` int unsigned NOT NULL DEFAULT '0', `purchase_price` bigint unsigned NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `inventory_batch_identity_unique` (`tenant_id`,`outlet_id`,`product_id`,`batch_number`), KEY `inventory_batches_product_id_foreign` (`product_id`), KEY `inventory_batch_expiry_index` (`tenant_id`,`expired_at`,`quantity`), KEY `inventory_batch_fefo_index` (`outlet_id`,`product_id`,`expired_at`), CONSTRAINT `inventory_batches_outlet_id_foreign` FOREIGN KEY (`outlet_id`) REFERENCES `pharmacy_outlets` (`id`) ON DELETE CASCADE, CONSTRAINT `inventory_batches_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE RESTRICT, CONSTRAINT `inventory_batches_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `inventory_batches` WRITE; /*!40000 ALTER TABLE `inventory_batches` DISABLE KEYS */; /*!40000 ALTER TABLE `inventory_batches` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `inventory_reservations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `inventory_reservations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `seller_order_id` bigint unsigned NOT NULL, `order_item_id` bigint unsigned NOT NULL, `tenant_id` bigint unsigned NOT NULL, `outlet_inventory_id` bigint unsigned NOT NULL, `quantity` int unsigned NOT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `reserved_at` timestamp NOT NULL, `expires_at` timestamp NULL DEFAULT NULL, `consumed_at` timestamp NULL DEFAULT NULL, `released_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `inventory_reservations_order_item_id_unique` (`order_item_id`), KEY `inventory_reservations_tenant_id_foreign` (`tenant_id`), KEY `inventory_reservations_seller_order_id_status_index` (`seller_order_id`,`status`), KEY `inventory_reservations_outlet_inventory_id_status_index` (`outlet_inventory_id`,`status`), CONSTRAINT `inventory_reservations_order_item_id_foreign` FOREIGN KEY (`order_item_id`) REFERENCES `order_items` (`id`) ON DELETE CASCADE, CONSTRAINT `inventory_reservations_outlet_inventory_id_foreign` FOREIGN KEY (`outlet_inventory_id`) REFERENCES `outlet_inventories` (`id`) ON DELETE CASCADE, CONSTRAINT `inventory_reservations_seller_order_id_foreign` FOREIGN KEY (`seller_order_id`) REFERENCES `seller_orders` (`id`) ON DELETE CASCADE, CONSTRAINT `inventory_reservations_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `inventory_reservations` WRITE; /*!40000 ALTER TABLE `inventory_reservations` DISABLE KEYS */; /*!40000 ALTER TABLE `inventory_reservations` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `job_batches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `job_batches` ( `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `total_jobs` int NOT NULL, `pending_jobs` int NOT NULL, `failed_jobs` int NOT NULL, `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `options` mediumtext COLLATE utf8mb4_unicode_ci, `cancelled_at` int DEFAULT NULL, `created_at` int NOT NULL, `finished_at` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `job_batches` WRITE; /*!40000 ALTER TABLE `job_batches` DISABLE KEYS */; /*!40000 ALTER TABLE `job_batches` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `attempts` smallint unsigned NOT NULL, `reserved_at` int unsigned DEFAULT NULL, `available_at` int unsigned NOT NULL, `created_at` int unsigned NOT NULL, 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 */; LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `medical_device_profiles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `medical_device_profiles` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `product_id` bigint unsigned NOT NULL, `risk_class` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL, `device_category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `intended_use` text COLLATE utf8mb4_unicode_ci NOT NULL, `registration_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `professional_use_only` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `medical_device_profiles_product_id_unique` (`product_id`), CONSTRAINT `medical_device_profiles_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `medical_device_profiles` WRITE; /*!40000 ALTER TABLE `medical_device_profiles` DISABLE KEYS */; INSERT INTO `medical_device_profiles` VALUES (1,5,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000005',0,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(2,22,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000022',0,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(3,23,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000023',0,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(4,36,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000005',0,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(5,53,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000022',0,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(6,54,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000023',0,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(7,67,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000005',0,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(8,84,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000022',0,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(9,85,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000023',0,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(10,98,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000005',0,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(11,115,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000022',0,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(12,116,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000023',0,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(13,129,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000005',0,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(14,146,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000022',0,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(15,147,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000023',0,'2026-08-29 00:44:59','2026-08-29 00:44:59'); /*!40000 ALTER TABLE `medical_device_profiles` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `medical_records`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `medical_records` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `consultation_id` bigint unsigned NOT NULL, `patient_user_id` bigint unsigned NOT NULL, `doctor_profile_id` bigint unsigned NOT NULL, `diagnosis` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `clinical_notes` longtext COLLATE utf8mb4_unicode_ci, `advice` longtext COLLATE utf8mb4_unicode_ci, `vitals` longtext COLLATE utf8mb4_unicode_ci, `recorded_at` timestamp NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `medical_records_consultation_id_unique` (`consultation_id`), KEY `medical_records_doctor_profile_id_foreign` (`doctor_profile_id`), KEY `medical_records_patient_user_id_recorded_at_index` (`patient_user_id`,`recorded_at`), CONSTRAINT `medical_records_consultation_id_foreign` FOREIGN KEY (`consultation_id`) REFERENCES `consultations` (`id`) ON DELETE CASCADE, CONSTRAINT `medical_records_doctor_profile_id_foreign` FOREIGN KEY (`doctor_profile_id`) REFERENCES `doctor_profiles` (`id`) ON DELETE RESTRICT, CONSTRAINT `medical_records_patient_user_id_foreign` FOREIGN KEY (`patient_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `medical_records` WRITE; /*!40000 ALTER TABLE `medical_records` DISABLE KEYS */; /*!40000 ALTER TABLE `medical_records` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `medicine_profiles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `medicine_profiles` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `product_id` bigint unsigned NOT NULL, `generic_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `medicine_class` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `strength` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dosage_form` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `package_size` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `warning_label` text COLLATE utf8mb4_unicode_ci, `requires_prescription` tinyint(1) NOT NULL DEFAULT '0', `regulatory_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `medicine_profiles_product_id_unique` (`product_id`), KEY `medicine_profiles_medicine_class_index` (`medicine_class`), CONSTRAINT `medicine_profiles_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `medicine_profiles` WRITE; /*!40000 ALTER TABLE `medicine_profiles` DISABLE KEYS */; INSERT INTO `medicine_profiles` VALUES (1,1,'Paracetamol','otc','500 mg','Kaplet','10 kaplet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(2,2,'Echinacea & Zinc','otc',NULL,'Kaplet','10 kaplet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(3,3,'Povidone Iodine','limited_otc','10%','Cairan luar','30 ml','Hanya untuk pemakaian luar. Baca aturan pakai sebelum digunakan.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(4,4,'Amlodipine Besilate','hard_drug','10 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(5,6,'Diazepam','psychotropic','5 mg','Tablet','10 tablet','Tidak tersedia untuk transaksi marketplace online.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(6,7,'Paracetamol','otc','120 mg/5 ml','Sirup','60 ml',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(7,8,'Paracetamol','otc','650 mg','Kaplet','4 kaplet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(8,9,'Paracetamol + Caffeine','limited_otc','500 mg','Tablet','4 tablet','Perhatikan dosis maksimal harian.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(9,10,'Obat Batuk Hitam','limited_otc','60 ml','Sirup','60 ml','Dapat menyebabkan kantuk.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(10,11,'Herbal','otc',NULL,'Cair','12 sachet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(11,12,'Ascorbic Acid','otc','500 mg','Tablet','60 tablet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(12,13,'Multivitamin','otc',NULL,'Tablet','30 tablet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(13,14,'Hydrotalcite + Mg Hydroxide','otc',NULL,'Tablet kunyah','10 tablet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(14,15,'Lansoprazole','hard_drug','30 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(15,16,'Metformin HCl','hard_drug','500 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(16,17,'Simvastatin','hard_drug','20 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(17,18,'Cetirizine','limited_otc','10 mg','Tablet','10 tablet','Dapat menyebabkan kantuk.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(18,19,'Loratadine','limited_otc','10 mg','Tablet','10 tablet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(19,20,'Plester','otc',NULL,'Plester','1 roll',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(20,21,'Kasa Steril','otc',NULL,'Kasa','10 pcs',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(21,24,'Medical Device','otc',NULL,'Alat kesehatan','25 strip',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(22,25,'Skin Care','otc',NULL,'Cleanser','125 ml',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(23,26,'Acne Care','otc',NULL,'Gel','18 g',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(24,27,'Cajuput Oil','otc',NULL,'Cairan luar','60 ml','Hanya untuk pemakaian luar.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(25,28,'Oral Rehydration Salt','otc',NULL,'Sachet','10 sachet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(26,29,'Amoxicillin Trihydrate','hard_drug','500 mg','Kapsul','10 kapsul','Antibiotik harus dengan resep dokter dan dihabiskan sesuai aturan.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(27,30,'Cefixime','hard_drug','100 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(28,31,'Salbutamol','hard_drug','2 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(29,32,'Paracetamol','otc','500 mg','Kaplet','10 kaplet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(30,33,'Echinacea & Zinc','otc',NULL,'Kaplet','10 kaplet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(31,34,'Povidone Iodine','limited_otc','10%','Cairan luar','30 ml','Hanya untuk pemakaian luar. Baca aturan pakai sebelum digunakan.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(32,35,'Amlodipine Besilate','hard_drug','10 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(33,37,'Diazepam','psychotropic','5 mg','Tablet','10 tablet','Tidak tersedia untuk transaksi marketplace online.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(34,38,'Paracetamol','otc','120 mg/5 ml','Sirup','60 ml',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(35,39,'Paracetamol','otc','650 mg','Kaplet','4 kaplet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(36,40,'Paracetamol + Caffeine','limited_otc','500 mg','Tablet','4 tablet','Perhatikan dosis maksimal harian.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(37,41,'Obat Batuk Hitam','limited_otc','60 ml','Sirup','60 ml','Dapat menyebabkan kantuk.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(38,42,'Herbal','otc',NULL,'Cair','12 sachet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(39,43,'Ascorbic Acid','otc','500 mg','Tablet','60 tablet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(40,44,'Multivitamin','otc',NULL,'Tablet','30 tablet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(41,45,'Hydrotalcite + Mg Hydroxide','otc',NULL,'Tablet kunyah','10 tablet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(42,46,'Lansoprazole','hard_drug','30 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(43,47,'Metformin HCl','hard_drug','500 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(44,48,'Simvastatin','hard_drug','20 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(45,49,'Cetirizine','limited_otc','10 mg','Tablet','10 tablet','Dapat menyebabkan kantuk.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(46,50,'Loratadine','limited_otc','10 mg','Tablet','10 tablet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(47,51,'Plester','otc',NULL,'Plester','1 roll',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(48,52,'Kasa Steril','otc',NULL,'Kasa','10 pcs',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(49,55,'Medical Device','otc',NULL,'Alat kesehatan','25 strip',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(50,56,'Skin Care','otc',NULL,'Cleanser','125 ml',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(51,57,'Acne Care','otc',NULL,'Gel','18 g',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(52,58,'Cajuput Oil','otc',NULL,'Cairan luar','60 ml','Hanya untuk pemakaian luar.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(53,59,'Oral Rehydration Salt','otc',NULL,'Sachet','10 sachet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(54,60,'Amoxicillin Trihydrate','hard_drug','500 mg','Kapsul','10 kapsul','Antibiotik harus dengan resep dokter dan dihabiskan sesuai aturan.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(55,61,'Cefixime','hard_drug','100 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(56,62,'Salbutamol','hard_drug','2 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(57,63,'Paracetamol','otc','500 mg','Kaplet','10 kaplet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(58,64,'Echinacea & Zinc','otc',NULL,'Kaplet','10 kaplet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(59,65,'Povidone Iodine','limited_otc','10%','Cairan luar','30 ml','Hanya untuk pemakaian luar. Baca aturan pakai sebelum digunakan.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(60,66,'Amlodipine Besilate','hard_drug','10 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(61,68,'Diazepam','psychotropic','5 mg','Tablet','10 tablet','Tidak tersedia untuk transaksi marketplace online.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(62,69,'Paracetamol','otc','120 mg/5 ml','Sirup','60 ml',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(63,70,'Paracetamol','otc','650 mg','Kaplet','4 kaplet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(64,71,'Paracetamol + Caffeine','limited_otc','500 mg','Tablet','4 tablet','Perhatikan dosis maksimal harian.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(65,72,'Obat Batuk Hitam','limited_otc','60 ml','Sirup','60 ml','Dapat menyebabkan kantuk.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(66,73,'Herbal','otc',NULL,'Cair','12 sachet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(67,74,'Ascorbic Acid','otc','500 mg','Tablet','60 tablet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(68,75,'Multivitamin','otc',NULL,'Tablet','30 tablet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(69,76,'Hydrotalcite + Mg Hydroxide','otc',NULL,'Tablet kunyah','10 tablet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(70,77,'Lansoprazole','hard_drug','30 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(71,78,'Metformin HCl','hard_drug','500 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(72,79,'Simvastatin','hard_drug','20 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(73,80,'Cetirizine','limited_otc','10 mg','Tablet','10 tablet','Dapat menyebabkan kantuk.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(74,81,'Loratadine','limited_otc','10 mg','Tablet','10 tablet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(75,82,'Plester','otc',NULL,'Plester','1 roll',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(76,83,'Kasa Steril','otc',NULL,'Kasa','10 pcs',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(77,86,'Medical Device','otc',NULL,'Alat kesehatan','25 strip',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(78,87,'Skin Care','otc',NULL,'Cleanser','125 ml',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(79,88,'Acne Care','otc',NULL,'Gel','18 g',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(80,89,'Cajuput Oil','otc',NULL,'Cairan luar','60 ml','Hanya untuk pemakaian luar.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(81,90,'Oral Rehydration Salt','otc',NULL,'Sachet','10 sachet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(82,91,'Amoxicillin Trihydrate','hard_drug','500 mg','Kapsul','10 kapsul','Antibiotik harus dengan resep dokter dan dihabiskan sesuai aturan.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(83,92,'Cefixime','hard_drug','100 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(84,93,'Salbutamol','hard_drug','2 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(85,94,'Paracetamol','otc','500 mg','Kaplet','10 kaplet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(86,95,'Echinacea & Zinc','otc',NULL,'Kaplet','10 kaplet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(87,96,'Povidone Iodine','limited_otc','10%','Cairan luar','30 ml','Hanya untuk pemakaian luar. Baca aturan pakai sebelum digunakan.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(88,97,'Amlodipine Besilate','hard_drug','10 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(89,99,'Diazepam','psychotropic','5 mg','Tablet','10 tablet','Tidak tersedia untuk transaksi marketplace online.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(90,100,'Paracetamol','otc','120 mg/5 ml','Sirup','60 ml',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(91,101,'Paracetamol','otc','650 mg','Kaplet','4 kaplet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(92,102,'Paracetamol + Caffeine','limited_otc','500 mg','Tablet','4 tablet','Perhatikan dosis maksimal harian.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(93,103,'Obat Batuk Hitam','limited_otc','60 ml','Sirup','60 ml','Dapat menyebabkan kantuk.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(94,104,'Herbal','otc',NULL,'Cair','12 sachet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(95,105,'Ascorbic Acid','otc','500 mg','Tablet','60 tablet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(96,106,'Multivitamin','otc',NULL,'Tablet','30 tablet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(97,107,'Hydrotalcite + Mg Hydroxide','otc',NULL,'Tablet kunyah','10 tablet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(98,108,'Lansoprazole','hard_drug','30 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(99,109,'Metformin HCl','hard_drug','500 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(100,110,'Simvastatin','hard_drug','20 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(101,111,'Cetirizine','limited_otc','10 mg','Tablet','10 tablet','Dapat menyebabkan kantuk.',0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(102,112,'Loratadine','limited_otc','10 mg','Tablet','10 tablet',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(103,113,'Plester','otc',NULL,'Plester','1 roll',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(104,114,'Kasa Steril','otc',NULL,'Kasa','10 pcs',NULL,0,'active','2026-08-29 00:44:58','2026-08-29 00:44:58'),(105,117,'Medical Device','otc',NULL,'Alat kesehatan','25 strip',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(106,118,'Skin Care','otc',NULL,'Cleanser','125 ml',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(107,119,'Acne Care','otc',NULL,'Gel','18 g',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(108,120,'Cajuput Oil','otc',NULL,'Cairan luar','60 ml','Hanya untuk pemakaian luar.',0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(109,121,'Oral Rehydration Salt','otc',NULL,'Sachet','10 sachet',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(110,122,'Amoxicillin Trihydrate','hard_drug','500 mg','Kapsul','10 kapsul','Antibiotik harus dengan resep dokter dan dihabiskan sesuai aturan.',1,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(111,123,'Cefixime','hard_drug','100 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(112,124,'Salbutamol','hard_drug','2 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(113,125,'Paracetamol','otc','500 mg','Kaplet','10 kaplet',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(114,126,'Echinacea & Zinc','otc',NULL,'Kaplet','10 kaplet',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(115,127,'Povidone Iodine','limited_otc','10%','Cairan luar','30 ml','Hanya untuk pemakaian luar. Baca aturan pakai sebelum digunakan.',0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(116,128,'Amlodipine Besilate','hard_drug','10 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(117,130,'Diazepam','psychotropic','5 mg','Tablet','10 tablet','Tidak tersedia untuk transaksi marketplace online.',1,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(118,131,'Paracetamol','otc','120 mg/5 ml','Sirup','60 ml',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(119,132,'Paracetamol','otc','650 mg','Kaplet','4 kaplet',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(120,133,'Paracetamol + Caffeine','limited_otc','500 mg','Tablet','4 tablet','Perhatikan dosis maksimal harian.',0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(121,134,'Obat Batuk Hitam','limited_otc','60 ml','Sirup','60 ml','Dapat menyebabkan kantuk.',0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(122,135,'Herbal','otc',NULL,'Cair','12 sachet',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(123,136,'Ascorbic Acid','otc','500 mg','Tablet','60 tablet',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(124,137,'Multivitamin','otc',NULL,'Tablet','30 tablet',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(125,138,'Hydrotalcite + Mg Hydroxide','otc',NULL,'Tablet kunyah','10 tablet',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(126,139,'Lansoprazole','hard_drug','30 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(127,140,'Metformin HCl','hard_drug','500 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(128,141,'Simvastatin','hard_drug','20 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(129,142,'Cetirizine','limited_otc','10 mg','Tablet','10 tablet','Dapat menyebabkan kantuk.',0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(130,143,'Loratadine','limited_otc','10 mg','Tablet','10 tablet',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(131,144,'Plester','otc',NULL,'Plester','1 roll',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(132,145,'Kasa Steril','otc',NULL,'Kasa','10 pcs',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(133,148,'Medical Device','otc',NULL,'Alat kesehatan','25 strip',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(134,149,'Skin Care','otc',NULL,'Cleanser','125 ml',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(135,150,'Acne Care','otc',NULL,'Gel','18 g',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(136,151,'Cajuput Oil','otc',NULL,'Cairan luar','60 ml','Hanya untuk pemakaian luar.',0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(137,152,'Oral Rehydration Salt','otc',NULL,'Sachet','10 sachet',NULL,0,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(138,153,'Amoxicillin Trihydrate','hard_drug','500 mg','Kapsul','10 kapsul','Antibiotik harus dengan resep dokter dan dihabiskan sesuai aturan.',1,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(139,154,'Cefixime','hard_drug','100 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'),(140,155,'Salbutamol','hard_drug','2 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-29 00:44:59','2026-08-29 00:44:59'); /*!40000 ALTER TABLE `medicine_profiles` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `migrations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` 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_08_27_122827_create_tenants_table',1),(5,'2026_08_27_122828_create_pharmacy_outlets_table',1),(6,'2026_08_27_122829_create_products_table',1),(7,'2026_08_27_122830_create_medicine_profiles_table',1),(8,'2026_08_27_122831_create_tenant_product_listings_table',1),(9,'2026_08_27_122832_create_outlet_inventories_table',1),(10,'2026_08_27_122833_create_regulatory_rules_table',1),(11,'2026_08_27_122834_create_prescriptions_table',1),(12,'2026_08_27_122835_create_prescription_review_requests_table',1),(13,'2026_08_27_122836_create_prescription_review_logs_table',1),(14,'2026_08_27_122837_create_platform_orders_table',1),(15,'2026_08_27_122838_create_seller_orders_table',1),(16,'2026_08_27_122839_create_order_items_table',1),(17,'2026_08_27_122840_create_coupons_table',1),(18,'2026_08_27_125456_add_platform_role_to_users_table',1),(19,'2026_08_27_125457_create_tenant_users_table',1),(20,'2026_08_27_131414_create_notifications_table',1),(21,'2026_08_27_203432_add_referral_fields_to_users_and_coupons_tables',1),(22,'2026_08_27_203433_create_referral_attributions_table',1),(23,'2026_08_27_203434_create_referral_rewards_table',1),(24,'2026_08_27_205420_create_customer_addresses_table',1),(25,'2026_08_27_205421_create_inventory_reservations_table',1),(26,'2026_08_27_205422_create_delivery_shipments_table',1),(27,'2026_08_27_205423_create_commission_rules_table',1),(28,'2026_08_27_205424_create_settlements_table',1),(29,'2026_08_27_205425_create_settlement_items_table',1),(30,'2026_08_27_205426_add_phase_six_fields_to_orders_tables',1),(31,'2026_08_27_211040_create_patient_profiles_table',1),(32,'2026_08_27_211041_create_doctor_profiles_table',1),(33,'2026_08_27_211042_create_doctor_schedules_table',1),(34,'2026_08_27_211043_create_consultations_table',1),(35,'2026_08_27_211044_create_consultation_messages_table',1),(36,'2026_08_27_211045_create_medical_records_table',1),(37,'2026_08_27_211046_create_digital_prescriptions_table',1),(38,'2026_08_27_211047_create_digital_prescription_items_table',1),(39,'2026_08_27_211048_add_digital_prescription_fields_to_prescriptions_table',1),(40,'2026_08_27_212154_create_tenant_licenses_table',1),(41,'2026_08_27_212155_create_pharmacists_table',1),(42,'2026_08_27_212156_create_medical_device_profiles_table',1),(43,'2026_08_27_212157_create_product_submissions_table',1),(44,'2026_08_27_212158_add_governance_fields_to_products_table',1),(45,'2026_08_27_213045_create_coupon_usages_table',1),(46,'2026_08_27_213423_create_payments_table',1),(47,'2026_08_28_085907_add_unique_consultation_to_digital_prescriptions_table',1),(48,'2026_08_28_090536_create_product_regulatory_histories_table',1),(49,'2026_08_28_091140_add_provider_fields_to_delivery_shipments_table',1),(50,'2026_08_28_091141_add_shipping_fields_to_products_and_outlets_tables',1),(51,'2026_08_28_091727_create_refunds_table',1),(52,'2026_08_28_091728_create_financial_ledger_entries_table',1),(53,'2026_08_28_161920_create_inventory_batches_table',1),(54,'2026_08_28_162545_add_recovery_fields_to_refunds_and_delivery_shipments_tables',1),(55,'2026_08_28_162846_create_settlement_ledger_allocations_table',1),(56,'2026_08_28_222005_create_shipping_quotes_table',1),(57,'2026_08_28_222006_create_tenant_bank_accounts_table',1),(58,'2026_08_28_222007_create_withdrawal_requests_table',1),(59,'2026_08_28_222008_add_shipping_quote_snapshot_to_orders_and_shipments_table',1),(60,'2026_08_28_222009_add_withdrawal_reference_to_financial_ledger_entries_table',1),(61,'2026_08_28_222010_add_upload_first_checkout_fields_to_prescription_review_requests_table',1),(62,'2026_08_29_042033_extend_coupons_for_promotions',1),(63,'2026_08_29_042034_create_coupon_tenant_table',1),(64,'2026_08_29_042035_add_tenant_id_to_products_table',1),(65,'2026_08_29_042036_create_point_wallets_table',1),(66,'2026_08_29_042037_create_point_transactions_table',1),(67,'2026_08_29_042038_create_pharmacy_conversations_table',1),(68,'2026_08_29_042039_create_pharmacy_messages_table',1),(69,'2026_08_29_042040_create_doctor_bank_accounts_table',1),(70,'2026_08_29_042041_create_doctor_earnings_table',1),(71,'2026_08_29_042042_create_doctor_withdrawal_requests_table',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `notifications` ( `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `notifiable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `notifiable_id` bigint unsigned NOT NULL, `data` text COLLATE utf8mb4_unicode_ci NOT NULL, `read_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `notifications` WRITE; /*!40000 ALTER TABLE `notifications` DISABLE KEYS */; /*!40000 ALTER TABLE `notifications` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `order_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `order_items` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `seller_order_id` bigint unsigned NOT NULL, `tenant_id` bigint unsigned NOT NULL, `product_id` bigint unsigned NOT NULL, `product_listing_id` bigint unsigned NOT NULL, `product_name_snapshot` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `sku_snapshot` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `classification_snapshot` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `price` bigint unsigned NOT NULL, `quantity` int unsigned NOT NULL, `subtotal` bigint unsigned NOT NULL, `requires_prescription` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `order_items_seller_order_id_foreign` (`seller_order_id`), KEY `order_items_product_id_foreign` (`product_id`), KEY `order_items_product_listing_id_foreign` (`product_listing_id`), KEY `order_items_tenant_id_seller_order_id_index` (`tenant_id`,`seller_order_id`), CONSTRAINT `order_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`), CONSTRAINT `order_items_product_listing_id_foreign` FOREIGN KEY (`product_listing_id`) REFERENCES `tenant_product_listings` (`id`), CONSTRAINT `order_items_seller_order_id_foreign` FOREIGN KEY (`seller_order_id`) REFERENCES `seller_orders` (`id`) ON DELETE CASCADE, CONSTRAINT `order_items_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `order_items` WRITE; /*!40000 ALTER TABLE `order_items` DISABLE KEYS */; /*!40000 ALTER TABLE `order_items` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `outlet_inventories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `outlet_inventories` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint unsigned NOT NULL, `outlet_id` bigint unsigned NOT NULL, `product_listing_id` bigint unsigned NOT NULL, `quantity_available` int unsigned NOT NULL DEFAULT '0', `quantity_reserved` int unsigned NOT NULL DEFAULT '0', `reorder_level` int unsigned NOT NULL DEFAULT '10', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `inventory_tenant_outlet_listing_unique` (`tenant_id`,`outlet_id`,`product_listing_id`), KEY `outlet_inventories_outlet_id_foreign` (`outlet_id`), KEY `outlet_inventories_product_listing_id_foreign` (`product_listing_id`), CONSTRAINT `outlet_inventories_outlet_id_foreign` FOREIGN KEY (`outlet_id`) REFERENCES `pharmacy_outlets` (`id`) ON DELETE CASCADE, CONSTRAINT `outlet_inventories_product_listing_id_foreign` FOREIGN KEY (`product_listing_id`) REFERENCES `tenant_product_listings` (`id`) ON DELETE CASCADE, CONSTRAINT `outlet_inventories_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=187 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `outlet_inventories` WRITE; /*!40000 ALTER TABLE `outlet_inventories` DISABLE KEYS */; INSERT INTO `outlet_inventories` VALUES (1,1,1,1,24,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(2,1,6,1,12,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(3,1,1,2,25,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(4,1,6,2,13,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(5,1,1,3,26,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(6,1,6,3,14,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(7,1,1,4,27,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(8,1,6,4,15,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(9,1,1,5,28,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(10,1,6,5,16,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(11,1,1,6,29,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(12,1,6,6,17,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(13,1,1,7,30,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(14,1,6,7,18,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(15,1,1,8,31,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(16,1,6,8,19,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(17,1,1,9,32,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(18,1,6,9,20,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(19,1,1,10,33,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(20,1,6,10,21,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(21,1,1,11,34,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(22,1,6,11,22,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(23,1,1,12,35,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(24,1,6,12,23,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(25,1,1,13,36,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(26,1,6,13,24,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(27,1,1,14,37,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(28,1,6,14,25,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(29,1,1,15,38,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(30,1,6,15,26,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(31,1,1,16,39,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(32,1,6,16,27,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(33,1,1,17,40,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(34,1,6,17,28,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(35,1,1,18,41,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(36,1,6,18,29,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(37,1,1,19,42,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(38,1,6,19,30,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(39,1,1,20,43,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(40,1,6,20,31,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(41,1,1,21,44,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(42,1,6,21,32,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(43,1,1,22,45,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(44,1,6,22,33,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(45,1,1,23,46,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(46,1,6,23,34,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(47,1,1,24,47,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(48,1,6,24,35,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(49,1,1,25,48,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(50,1,6,25,36,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(51,1,1,26,49,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(52,1,6,26,37,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(53,1,1,27,50,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(54,1,6,27,38,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(55,1,1,28,51,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(56,1,6,28,39,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(57,1,1,29,52,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(58,1,6,29,40,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(59,1,1,30,53,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(60,1,6,30,41,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(61,1,1,31,54,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(62,1,6,31,42,0,8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(63,2,2,32,24,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(64,2,2,33,25,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(65,2,2,34,26,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(66,2,2,35,27,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(67,2,2,36,28,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(68,2,2,37,29,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(69,2,2,38,30,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(70,2,2,39,31,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(71,2,2,40,32,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(72,2,2,41,33,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(73,2,2,42,34,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(74,2,2,43,35,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(75,2,2,44,36,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(76,2,2,45,37,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(77,2,2,46,38,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(78,2,2,47,39,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(79,2,2,48,40,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(80,2,2,49,41,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(81,2,2,50,42,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(82,2,2,51,43,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(83,2,2,52,44,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(84,2,2,53,45,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(85,2,2,54,46,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(86,2,2,55,47,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(87,2,2,56,48,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(88,2,2,57,49,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(89,2,2,58,50,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(90,2,2,59,51,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(91,2,2,60,52,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(92,2,2,61,53,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(93,2,2,62,54,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(94,3,3,63,24,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(95,3,3,64,25,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(96,3,3,65,26,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(97,3,3,66,27,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(98,3,3,67,28,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(99,3,3,68,29,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(100,3,3,69,30,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(101,3,3,70,31,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(102,3,3,71,32,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(103,3,3,72,33,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(104,3,3,73,34,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(105,3,3,74,35,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(106,3,3,75,36,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(107,3,3,76,37,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(108,3,3,77,38,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(109,3,3,78,39,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(110,3,3,79,40,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(111,3,3,80,41,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(112,3,3,81,42,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(113,3,3,82,43,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(114,3,3,83,44,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(115,3,3,84,45,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(116,3,3,85,46,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(117,3,3,86,47,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(118,3,3,87,48,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(119,3,3,88,49,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(120,3,3,89,50,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(121,3,3,90,51,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(122,3,3,91,52,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(123,3,3,92,53,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(124,3,3,93,54,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(125,4,4,94,24,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(126,4,4,95,25,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(127,4,4,96,26,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(128,4,4,97,27,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(129,4,4,98,28,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(130,4,4,99,29,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(131,4,4,100,30,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(132,4,4,101,31,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(133,4,4,102,32,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(134,4,4,103,33,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(135,4,4,104,34,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(136,4,4,105,35,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(137,4,4,106,36,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(138,4,4,107,37,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(139,4,4,108,38,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(140,4,4,109,39,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(141,4,4,110,40,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(142,4,4,111,41,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(143,4,4,112,42,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(144,4,4,113,43,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(145,4,4,114,44,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(146,4,4,115,45,0,10,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(147,4,4,116,46,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(148,4,4,117,47,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(149,4,4,118,48,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(150,4,4,119,49,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(151,4,4,120,50,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(152,4,4,121,51,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(153,4,4,122,52,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(154,4,4,123,53,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(155,4,4,124,54,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(156,5,5,125,24,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(157,5,5,126,25,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(158,5,5,127,26,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(159,5,5,128,27,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(160,5,5,129,28,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(161,5,5,130,29,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(162,5,5,131,30,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(163,5,5,132,31,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(164,5,5,133,32,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(165,5,5,134,33,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(166,5,5,135,34,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(167,5,5,136,35,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(168,5,5,137,36,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(169,5,5,138,37,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(170,5,5,139,38,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(171,5,5,140,39,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(172,5,5,141,40,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(173,5,5,142,41,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(174,5,5,143,42,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(175,5,5,144,43,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(176,5,5,145,44,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(177,5,5,146,45,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(178,5,5,147,46,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(179,5,5,148,47,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(180,5,5,149,48,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(181,5,5,150,49,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(182,5,5,151,50,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(183,5,5,152,51,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(184,5,5,153,52,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(185,5,5,154,53,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(186,5,5,155,54,0,10,'2026-08-29 00:44:59','2026-08-29 00:44:59'); /*!40000 ALTER TABLE `outlet_inventories` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `password_reset_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `patient_profiles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `patient_profiles` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `date_of_birth` date DEFAULT NULL, `gender` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `blood_type` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `allergies` text COLLATE utf8mb4_unicode_ci, `emergency_contact_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `emergency_contact_phone` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `patient_profiles_user_id_unique` (`user_id`), CONSTRAINT `patient_profiles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `patient_profiles` WRITE; /*!40000 ALTER TABLE `patient_profiles` DISABLE KEYS */; INSERT INTO `patient_profiles` VALUES (1,1,'1994-05-17','male','O+','eyJpdiI6IkpzN1hjZ1NLR2FMcHJZelArZHJtY3c9PSIsInZhbHVlIjoieWVmUWNCaStCOUZqNFhMNS84TEZxSG53OGtDTHd6TkNtS0EyWWo5RnBPNGR1Um5qeGFoM1NzZ2JTWmZxNENiMyIsIm1hYyI6IjBlYTIwYmI3YmU3MDMxOTIzYzBhYTJhZDgyYzc3NjBhMzkwY2RkYmNmMGFhNmRmNWYwMGNiNDEzYmIxYjQ2ZjQiLCJ0YWciOiIifQ==','Keluarga Pelanggan','081200000099','2026-08-29 00:44:55','2026-08-29 00:44:55'); /*!40000 ALTER TABLE `patient_profiles` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `payments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `payments` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `platform_order_id` bigint unsigned NOT NULL, `seller_order_id` bigint unsigned NOT NULL, `provider` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `external_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `amount` bigint unsigned NOT NULL, `currency` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'IDR', `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `provider_response` longtext COLLATE utf8mb4_unicode_ci, `paid_at` timestamp NULL DEFAULT NULL, `failed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `payments_external_id_unique` (`external_id`), KEY `payments_platform_order_id_foreign` (`platform_order_id`), KEY `payments_seller_order_id_status_index` (`seller_order_id`,`status`), CONSTRAINT `payments_platform_order_id_foreign` FOREIGN KEY (`platform_order_id`) REFERENCES `platform_orders` (`id`) ON DELETE CASCADE, CONSTRAINT `payments_seller_order_id_foreign` FOREIGN KEY (`seller_order_id`) REFERENCES `seller_orders` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `payments` WRITE; /*!40000 ALTER TABLE `payments` DISABLE KEYS */; /*!40000 ALTER TABLE `payments` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `pharmacists`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pharmacists` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `tenant_id` bigint unsigned NOT NULL, `outlet_id` bigint unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `professional_registration_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `practice_license_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `license_expired_at` date NOT NULL, `document_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `verification_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `is_active` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `pharmacists_tenant_id_professional_registration_number_unique` (`tenant_id`,`professional_registration_number`), UNIQUE KEY `pharmacists_tenant_id_user_id_unique` (`tenant_id`,`user_id`), KEY `pharmacists_user_id_foreign` (`user_id`), KEY `pharmacists_outlet_id_foreign` (`outlet_id`), KEY `pharmacists_tenant_id_verification_status_is_active_index` (`tenant_id`,`verification_status`,`is_active`), CONSTRAINT `pharmacists_outlet_id_foreign` FOREIGN KEY (`outlet_id`) REFERENCES `pharmacy_outlets` (`id`) ON DELETE CASCADE, CONSTRAINT `pharmacists_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE, CONSTRAINT `pharmacists_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `pharmacists` WRITE; /*!40000 ALTER TABLE `pharmacists` DISABLE KEYS */; INSERT INTO `pharmacists` VALUES (1,2,1,1,'Apt. Naya Laut Sehat','STRA-3171-2026-001','SIPA-3171-2026-001','2031-01-01',NULL,'approved',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(2,2,2,2,'Apt. Naya Laut Sehat','STRA-3171-2026-002','SIPA-3171-2026-002','2031-01-01',NULL,'approved',1,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(3,14,1,1,'Apt. Demo Apotek Laut Sehat','STRA-DEMO-0001','SIPA-DEMO-0001','2031-01-01',NULL,'approved',1,'2026-08-29 00:44:57','2026-08-29 00:44:57'),(4,15,2,2,'Apt. Demo Apotek Bumi Medika','STRA-DEMO-0002','SIPA-DEMO-0002','2031-01-01',NULL,'approved',1,'2026-08-29 00:44:57','2026-08-29 00:44:57'),(5,16,3,3,'Apt. Demo Apotek Nusantara Farma','STRA-DEMO-0003','SIPA-DEMO-0003','2031-01-01',NULL,'approved',1,'2026-08-29 00:44:57','2026-08-29 00:44:57'),(6,17,4,4,'Apt. Demo Klinik Farma Medika','STRA-DEMO-0004','SIPA-DEMO-0004','2031-01-01',NULL,'approved',1,'2026-08-29 00:44:57','2026-08-29 00:44:57'),(7,18,5,5,'Apt. Demo Apotek Srikandi Care','STRA-DEMO-0005','SIPA-DEMO-0005','2031-01-01',NULL,'approved',1,'2026-08-29 00:44:58','2026-08-29 00:44:58'); /*!40000 ALTER TABLE `pharmacists` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `pharmacy_conversations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pharmacy_conversations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint unsigned NOT NULL, `customer_user_id` bigint unsigned NOT NULL, `product_id` bigint unsigned DEFAULT NULL, `product_listing_id` bigint unsigned DEFAULT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open', `last_message_at` timestamp NULL DEFAULT NULL, `closed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `pharmacy_conversations_product_id_foreign` (`product_id`), KEY `pharmacy_conversations_product_listing_id_foreign` (`product_listing_id`), KEY `pharmacy_conversations_tenant_id_status_last_message_at_index` (`tenant_id`,`status`,`last_message_at`), KEY `pharmacy_conversations_customer_user_id_last_message_at_index` (`customer_user_id`,`last_message_at`), CONSTRAINT `pharmacy_conversations_customer_user_id_foreign` FOREIGN KEY (`customer_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, CONSTRAINT `pharmacy_conversations_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL, CONSTRAINT `pharmacy_conversations_product_listing_id_foreign` FOREIGN KEY (`product_listing_id`) REFERENCES `tenant_product_listings` (`id`) ON DELETE SET NULL, CONSTRAINT `pharmacy_conversations_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `pharmacy_conversations` WRITE; /*!40000 ALTER TABLE `pharmacy_conversations` DISABLE KEYS */; /*!40000 ALTER TABLE `pharmacy_conversations` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `pharmacy_messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pharmacy_messages` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `pharmacy_conversation_id` bigint unsigned NOT NULL, `sender_user_id` bigint unsigned NOT NULL, `message` text COLLATE utf8mb4_unicode_ci NOT NULL, `read_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `pharmacy_messages_sender_user_id_foreign` (`sender_user_id`), KEY `pharmacy_messages_pharmacy_conversation_id_created_at_index` (`pharmacy_conversation_id`,`created_at`), CONSTRAINT `pharmacy_messages_pharmacy_conversation_id_foreign` FOREIGN KEY (`pharmacy_conversation_id`) REFERENCES `pharmacy_conversations` (`id`) ON DELETE CASCADE, CONSTRAINT `pharmacy_messages_sender_user_id_foreign` FOREIGN KEY (`sender_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `pharmacy_messages` WRITE; /*!40000 ALTER TABLE `pharmacy_messages` DISABLE KEYS */; /*!40000 ALTER TABLE `pharmacy_messages` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `pharmacy_outlets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pharmacy_outlets` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `address` text COLLATE utf8mb4_unicode_ci NOT NULL, `city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `postal_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `latitude` decimal(10,7) DEFAULT NULL, `longitude` decimal(10,7) DEFAULT NULL, `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `operational_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `pharmacy_outlets_tenant_id_code_unique` (`tenant_id`,`code`), CONSTRAINT `pharmacy_outlets_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `pharmacy_outlets` WRITE; /*!40000 ALTER TABLE `pharmacy_outlets` DISABLE KEYS */; INSERT INTO `pharmacy_outlets` VALUES (1,1,'Apotek Laut Sehat Pusat','JKT-01','Jl. Kemang Raya No. 18, Jakarta Selatan','Jakarta Selatan','12730',-6.2607000,106.8106000,'021-555-0188','open','2026-08-29 00:44:53','2026-08-29 00:44:53'),(2,2,'Apotek Bumi Medika Pusat','JKT-01','Jl. Kemang Raya No. 18, Jakarta Selatan','Jakarta Selatan','12730',-6.2607000,106.8106000,'021-555-0271','open','2026-08-29 00:44:53','2026-08-29 00:44:53'),(3,3,'Apotek Nusantara Farma Pusat','JKT-01','Jl. Kemang Raya No. 18, Jakarta Selatan','Jakarta Selatan','12730',-6.2607000,106.8106000,'021-555-0391','open','2026-08-29 00:44:53','2026-08-29 00:44:53'),(4,4,'Klinik Farma Medika Pusat','JKT-01','Jl. Kemang Raya No. 18, Jakarta Selatan','Jakarta Selatan','12730',-6.2607000,106.8106000,'022-555-0410','open','2026-08-29 00:44:53','2026-08-29 00:44:53'),(5,5,'Apotek Srikandi Care Pusat','JKT-01','Jl. Kemang Raya No. 18, Jakarta Selatan','Jakarta Selatan','12730',-6.2607000,106.8106000,'031-555-0505','open','2026-08-29 00:44:53','2026-08-29 00:44:53'),(6,1,'Apotek Laut Sehat Kuningan','JKT-02','Jl. Prof. Dr. Satrio No. 10, Jakarta Selatan','Jakarta Selatan',NULL,NULL,NULL,'021-555-0188','open','2026-08-29 00:44:58','2026-08-29 00:44:58'); /*!40000 ALTER TABLE `pharmacy_outlets` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `platform_orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `platform_orders` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `order_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint unsigned DEFAULT NULL, `coupon_id` bigint unsigned DEFAULT NULL, `customer_address_id` bigint unsigned DEFAULT NULL, `recipient_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `recipient_phone` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `delivery_address` text COLLATE utf8mb4_unicode_ci, `delivery_notes` text COLLATE utf8mb4_unicode_ci, `subtotal` bigint unsigned NOT NULL, `discount_total` bigint unsigned NOT NULL DEFAULT '0', `shipping_total` bigint unsigned NOT NULL DEFAULT '0', `grand_total` bigint unsigned NOT NULL, `payment_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unpaid', `paid_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `platform_orders_order_number_unique` (`order_number`), KEY `platform_orders_user_id_foreign` (`user_id`), KEY `platform_orders_coupon_id_foreign` (`coupon_id`), KEY `platform_orders_customer_address_id_foreign` (`customer_address_id`), CONSTRAINT `platform_orders_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE SET NULL, CONSTRAINT `platform_orders_customer_address_id_foreign` FOREIGN KEY (`customer_address_id`) REFERENCES `customer_addresses` (`id`) ON DELETE SET NULL, CONSTRAINT `platform_orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `platform_orders` WRITE; /*!40000 ALTER TABLE `platform_orders` DISABLE KEYS */; /*!40000 ALTER TABLE `platform_orders` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `point_transactions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `point_transactions` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `point_wallet_id` bigint unsigned NOT NULL, `user_id` bigint unsigned NOT NULL, `idempotency_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `direction` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `points` bigint unsigned NOT NULL, `balance_after` bigint unsigned NOT NULL, `source_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `source_id` bigint unsigned DEFAULT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `metadata` json DEFAULT NULL, `occurred_at` timestamp NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `point_transactions_idempotency_key_unique` (`idempotency_key`), KEY `point_transactions_point_wallet_id_foreign` (`point_wallet_id`), KEY `point_transactions_source_type_source_id_index` (`source_type`,`source_id`), KEY `point_transactions_user_id_occurred_at_index` (`user_id`,`occurred_at`), CONSTRAINT `point_transactions_point_wallet_id_foreign` FOREIGN KEY (`point_wallet_id`) REFERENCES `point_wallets` (`id`) ON DELETE CASCADE, CONSTRAINT `point_transactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `point_transactions` WRITE; /*!40000 ALTER TABLE `point_transactions` DISABLE KEYS */; /*!40000 ALTER TABLE `point_transactions` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `point_wallets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `point_wallets` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `balance` bigint unsigned NOT NULL DEFAULT '0', `lifetime_earned` bigint unsigned NOT NULL DEFAULT '0', `lifetime_redeemed` bigint unsigned NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `point_wallets_user_id_unique` (`user_id`), CONSTRAINT `point_wallets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `point_wallets` WRITE; /*!40000 ALTER TABLE `point_wallets` DISABLE KEYS */; /*!40000 ALTER TABLE `point_wallets` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `prescription_review_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `prescription_review_logs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `prescription_review_request_id` bigint unsigned NOT NULL, `tenant_id` bigint unsigned NOT NULL, `reviewer_id` bigint unsigned DEFAULT NULL, `previous_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `new_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `reason` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `prescription_review_logs_prescription_review_request_id_foreign` (`prescription_review_request_id`), KEY `prescription_review_logs_reviewer_id_foreign` (`reviewer_id`), KEY `prescription_review_logs_tenant_id_created_at_index` (`tenant_id`,`created_at`), CONSTRAINT `prescription_review_logs_prescription_review_request_id_foreign` FOREIGN KEY (`prescription_review_request_id`) REFERENCES `prescription_review_requests` (`id`) ON DELETE CASCADE, CONSTRAINT `prescription_review_logs_reviewer_id_foreign` FOREIGN KEY (`reviewer_id`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `prescription_review_logs_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `prescription_review_logs` WRITE; /*!40000 ALTER TABLE `prescription_review_logs` DISABLE KEYS */; /*!40000 ALTER TABLE `prescription_review_logs` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `prescription_review_requests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `prescription_review_requests` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `prescription_id` bigint unsigned NOT NULL, `tenant_id` bigint unsigned NOT NULL, `outlet_id` bigint unsigned NOT NULL, `customer_address_id` bigint unsigned DEFAULT NULL, `seller_order_id` bigint unsigned DEFAULT NULL, `matched_items` json DEFAULT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'submitted', `submitted_at` timestamp NOT NULL, `review_started_at` timestamp NULL DEFAULT NULL, `reviewed_by` bigint unsigned DEFAULT NULL, `reviewed_at` timestamp NULL DEFAULT NULL, `rejection_reason` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `prescription_review_requests_prescription_id_foreign` (`prescription_id`), KEY `prescription_review_requests_outlet_id_foreign` (`outlet_id`), KEY `prescription_review_requests_reviewed_by_foreign` (`reviewed_by`), KEY `prescription_review_requests_tenant_id_status_index` (`tenant_id`,`status`), KEY `prescription_review_requests_customer_address_id_foreign` (`customer_address_id`), CONSTRAINT `prescription_review_requests_customer_address_id_foreign` FOREIGN KEY (`customer_address_id`) REFERENCES `customer_addresses` (`id`) ON DELETE SET NULL, CONSTRAINT `prescription_review_requests_outlet_id_foreign` FOREIGN KEY (`outlet_id`) REFERENCES `pharmacy_outlets` (`id`) ON DELETE CASCADE, CONSTRAINT `prescription_review_requests_prescription_id_foreign` FOREIGN KEY (`prescription_id`) REFERENCES `prescriptions` (`id`) ON DELETE CASCADE, CONSTRAINT `prescription_review_requests_reviewed_by_foreign` FOREIGN KEY (`reviewed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `prescription_review_requests_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `prescription_review_requests` WRITE; /*!40000 ALTER TABLE `prescription_review_requests` DISABLE KEYS */; /*!40000 ALTER TABLE `prescription_review_requests` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `prescriptions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `prescriptions` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `ulid` char(26) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint unsigned DEFAULT NULL, `digital_prescription_id` bigint unsigned DEFAULT NULL, `patient_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `patient_age` tinyint unsigned NOT NULL, `source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'external_upload', `file_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `version` int unsigned NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `prescriptions_ulid_unique` (`ulid`), UNIQUE KEY `prescriptions_digital_prescription_id_unique` (`digital_prescription_id`), KEY `prescriptions_user_id_foreign` (`user_id`), CONSTRAINT `prescriptions_digital_prescription_id_foreign` FOREIGN KEY (`digital_prescription_id`) REFERENCES `digital_prescriptions` (`id`) ON DELETE SET NULL, CONSTRAINT `prescriptions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `prescriptions` WRITE; /*!40000 ALTER TABLE `prescriptions` DISABLE KEYS */; /*!40000 ALTER TABLE `prescriptions` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `product_regulatory_histories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `product_regulatory_histories` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `product_id` bigint unsigned NOT NULL, `previous_classification` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `new_classification` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `regulation_reference` text COLLATE utf8mb4_unicode_ci NOT NULL, `changed_by` bigint unsigned DEFAULT NULL, `changed_at` timestamp NOT NULL, PRIMARY KEY (`id`), KEY `product_regulatory_histories_changed_by_foreign` (`changed_by`), KEY `product_regulatory_histories_product_id_changed_at_index` (`product_id`,`changed_at`), CONSTRAINT `product_regulatory_histories_changed_by_foreign` FOREIGN KEY (`changed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `product_regulatory_histories_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE RESTRICT ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `product_regulatory_histories` WRITE; /*!40000 ALTER TABLE `product_regulatory_histories` DISABLE KEYS */; /*!40000 ALTER TABLE `product_regulatory_histories` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `product_submissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `product_submissions` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint unsigned NOT NULL, `submitted_by` bigint unsigned DEFAULT NULL, `product_id` bigint unsigned DEFAULT NULL, `product_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `payload` json NOT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'submitted', `reviewed_by` bigint unsigned DEFAULT NULL, `reviewed_at` timestamp NULL DEFAULT NULL, `review_notes` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `product_submissions_submitted_by_foreign` (`submitted_by`), KEY `product_submissions_product_id_foreign` (`product_id`), KEY `product_submissions_reviewed_by_foreign` (`reviewed_by`), KEY `product_submissions_status_created_at_index` (`status`,`created_at`), KEY `product_submissions_tenant_id_status_index` (`tenant_id`,`status`), CONSTRAINT `product_submissions_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL, CONSTRAINT `product_submissions_reviewed_by_foreign` FOREIGN KEY (`reviewed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `product_submissions_submitted_by_foreign` FOREIGN KEY (`submitted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `product_submissions_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `product_submissions` WRITE; /*!40000 ALTER TABLE `product_submissions` DISABLE KEYS */; /*!40000 ALTER TABLE `product_submissions` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `products`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `products` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint unsigned DEFAULT NULL, `ulid` char(26) COLLATE utf8mb4_unicode_ci NOT NULL, `product_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `brand` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `manufacturer` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `registration_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `image_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `shipping_weight_grams` int unsigned NOT NULL DEFAULT '200', `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `created_by` bigint unsigned DEFAULT NULL, `approved_by` bigint unsigned DEFAULT NULL, `approved_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `products_ulid_unique` (`ulid`), UNIQUE KEY `products_slug_unique` (`slug`), KEY `products_product_type_index` (`product_type`), KEY `products_category_index` (`category`), KEY `products_status_index` (`status`), KEY `products_created_by_foreign` (`created_by`), KEY `products_approved_by_foreign` (`approved_by`), KEY `products_tenant_id_status_index` (`tenant_id`,`status`), CONSTRAINT `products_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `products_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `products_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=156 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `products` WRITE; /*!40000 ALTER TABLE `products` DISABLE KEYS */; INSERT INTO `products` VALUES (1,1,'01M15FM4VW3XZDG1VQCVT0AVNN','medicine','Panadol 500 mg','panadol-500-mg','Panadol','Haleon','BPOM-000001','Membantu meredakan demam, sakit kepala, dan nyeri ringan hingga sedang.','/images/products/panadol.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(2,1,'01M15FM4WGN1RVR60WMF1NNBBM','medicine','Imboost Force Ultimate','imboost-force-ultimate','Imboost','Soho','BPOM-000002','Suplemen untuk membantu memelihara daya tahan tubuh setiap hari.','/images/products/imboost.svg','vitamin',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(3,1,'01M15FM4WS1GXEV59DW46G5NFP','medicine','Betadine Solution 30 ml','betadine-solution-30ml','Betadine','Mundipharma','BPOM-000003','Antiseptik untuk pertolongan pertama pada luka ringan.','/images/products/betadine.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(4,1,'01M15FM4X1GKZRHKNZKP6EH4W8','medicine','Amlodipine 10 mg','amlodipine-10-mg','Generik','Kimia Farma','BPOM-000004','Obat antihipertensi yang hanya dapat dibeli dengan resep dan persetujuan apoteker.','/images/products/amlodipine.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(5,1,'01M15FM4XDWZNBDDHNRBGXNAWH','medical_device','Omron Digital Thermometer','omron-digital-thermometer','Omron','Omron Healthcare','BPOM-000005','Termometer digital cepat dan nyaman untuk seluruh keluarga.','/images/products/thermometer.svg','alat-kesehatan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(6,1,'01M15FM4XT4PE721RXMJYEQ5SZ','medicine','Diazepam 5 mg','diazepam-5-mg','Generik','Indofarma','BPOM-000006','Tersimpan di master produk untuk klasifikasi, tetapi tidak diperjualbelikan secara online.','/images/products/restricted.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(7,1,'01M15FM4Y5GE3YM0FYECECR48T','medicine','Paracetamol Sirup 60 ml','paracetamol-sirup-60ml','Generik','Kimia Farma','BPOM-000007','Sirup penurun demam untuk anak sesuai aturan pakai.','/images/products/panadol.svg','ibu-anak',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(8,1,'01M15FM4YFPNK973T29C6KBCWM','medicine','Sanmol Forte 650 mg','sanmol-forte-650-mg','Sanmol','Sanbe Farma','BPOM-000008','Pereda demam dan nyeri ringan hingga sedang.','/images/products/panadol.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(9,1,'01M15FM4YVA7113T1T67NWDKMT','medicine','Bodrex Extra','bodrex-extra','Bodrex','Tempo Scan','BPOM-000009','Membantu meredakan sakit kepala dan gejala flu ringan.','/images/products/imboost.svg','flu-batuk',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(10,1,'01M15FM4Z5Q9HN4WX25Q968KPF','medicine','OBH Combi Batuk Flu 60 ml','obh-combi-batuk-flu-60ml','OBH Combi','Combiphar','BPOM-000010','Sirup untuk membantu meredakan batuk dan gejala flu.','/images/products/betadine.svg','flu-batuk',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(11,1,'01M15FM4ZE21TC1GT3E4W6BZE4','medicine','Tolak Angin Cair 12 Sachet','tolak-angin-cair-12-sachet','Tolak Angin','Sido Muncul','BPOM-000011','Herbal untuk membantu menjaga kondisi tubuh saat masuk angin.','/images/products/imboost.svg','herbal',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(12,1,'01M15FM4ZRPHGDF2ZTSE3PHCQH','medicine','Blackmores Vitamin C 500 mg','blackmores-vitamin-c-500-mg','Blackmores','Blackmores','BPOM-000012','Vitamin C untuk membantu memenuhi kebutuhan harian.','/images/products/imboost.svg','vitamin',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(13,1,'01M15FM501V7XHDPSN9TREGHR3','medicine','Enervon-C Multivitamin','enervon-c-multivitamin','Enervon-C','Darya-Varia','BPOM-000013','Multivitamin untuk membantu menjaga stamina.','/images/products/imboost.svg','vitamin',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(14,1,'01M15FM50CEJ2NEKPE9JA6WKWQ','medicine','Promag Tablet','promag-tablet','Promag','Kalbe','BPOM-000014','Antasida untuk membantu meredakan gejala maag.','/images/products/betadine.svg','pencernaan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(15,1,'01M15FM50PR14VQMKPHPBBPA2Z','medicine','Lansoprazole 30 mg','lansoprazole-30-mg','Generik','Hexpharm','BPOM-000015','Obat lambung yang memerlukan resep dokter.','/images/products/amlodipine.svg','pencernaan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(16,1,'01M15FM511CMC6BBAVV1R3G9ZG','medicine','Metformin 500 mg','metformin-500-mg','Generik','Dexa Medica','BPOM-000016','Obat diabetes oral yang memerlukan resep dokter.','/images/products/amlodipine.svg','diabetes',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(17,1,'01M15FM51DFK40ZP7NAXGNQT8N','medicine','Simvastatin 20 mg','simvastatin-20-mg','Generik','Indofarma','BPOM-000017','Obat penurun kolesterol yang memerlukan resep dokter.','/images/products/amlodipine.svg','kolesterol',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(18,1,'01M15FM51R9YHN97DCPDEAE5RV','medicine','Cetirizine 10 mg','cetirizine-10-mg','Generik','Bernofarm','BPOM-000018','Antihistamin untuk gejala alergi, gunakan sesuai aturan pakai.','/images/products/amlodipine.svg','alergi',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(19,1,'01M15FM522RGS2XDN5EAKHXWSE','medicine','Loratadine 10 mg','loratadine-10-mg','Generik','Novell','BPOM-000019','Antihistamin non-sedatif untuk membantu mengurangi alergi.','/images/products/amlodipine.svg','alergi',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(20,1,'01M15FM52BWWAJZ6Y7DBF133DF','medicine','Hansaplast Roll Kain','hansaplast-roll-kain','Hansaplast','Beiersdorf','BPOM-000020','Plester roll kain untuk kebutuhan pertolongan pertama.','/images/products/betadine.svg','first-aid',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(21,1,'01M15FM52MMTFNN3AQT5830R2V','medicine','Kasa Steril 16x16','kasa-steril-16x16','OneMed','OneMed','BPOM-000021','Kasa steril untuk perawatan luka.','/images/products/betadine.svg','first-aid',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(22,1,'01M15FM52ZSQ8D0MVAWJCCPDMP','medical_device','Masker Medis 3 Ply','masker-medis-3-ply','Sensi','Arista Latindo','BPOM-000022','Masker medis 3 ply untuk perlindungan harian.','/images/products/thermometer.svg','alat-kesehatan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(23,1,'01M15FM536HDH00VDAMVH5PYAR','medical_device','Blood Pressure Monitor Digital','blood-pressure-monitor-digital','Omron','Omron Healthcare','BPOM-000023','Tensimeter digital untuk pemantauan tekanan darah di rumah.','/images/products/thermometer.svg','alat-kesehatan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(24,1,'01M15FM53HESYKXG00BQ0P5CBB','medicine','Accu-Chek Strip 25','accu-chek-strip-25','Accu-Chek','Roche','BPOM-000024','Strip cek gula darah untuk perangkat kompatibel.','/images/products/thermometer.svg','diabetes',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(25,1,'01M15FM53V86X8N6ESWH2MQPTR','medicine','Cetaphil Gentle Skin Cleanser','cetaphil-gentle-skin-cleanser','Cetaphil','Galderma','BPOM-000025','Pembersih wajah lembut untuk kulit sensitif.','/images/products/imboost.svg','skincare',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(26,1,'01M15FM543D1R88GDTWPCH0K89','medicine','Acnes Sealing Jell','acnes-sealing-jell','Acnes','Rohto','BPOM-000026','Gel perawatan kulit berjerawat.','/images/products/betadine.svg','skincare',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(27,1,'01M15FM54CMHM88RQNTYNG3660','medicine','Minyak Kayu Putih 60 ml','minyak-kayu-putih-60ml','Cap Lang','Eagle Indo Pharma','BPOM-000027','Minyak kayu putih untuk membantu menghangatkan tubuh.','/images/products/betadine.svg','ibu-anak',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(28,1,'01M15FM54PJ4YSBKGSC4RKY4XQ','medicine','Oralit Sachet','oralit-sachet','Generik','Kimia Farma','BPOM-000028','Larutan rehidrasi oral untuk membantu mengganti cairan tubuh.','/images/products/imboost.svg','pencernaan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(29,1,'01M15FM54YPM4NXYR29B9RE4HN','medicine','Amoxicillin 500 mg','amoxicillin-500-mg','Generik','Phapros','BPOM-000029','Antibiotik yang hanya dapat ditebus dengan resep dokter.','/images/products/amlodipine.svg','antibiotik',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(30,1,'01M15FM558YVMMGXFXG7RWGV7B','medicine','Cefixime 100 mg','cefixime-100-mg','Generik','Dexa Medica','BPOM-000030','Antibiotik yang membutuhkan resep dokter.','/images/products/amlodipine.svg','antibiotik',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(31,1,'01M15FM55J8SQJDMNAWXD6W81S','medicine','Salbutamol 2 mg','salbutamol-2-mg','Generik','Kimia Farma','BPOM-000031','Obat bronkodilator yang membutuhkan resep dokter.','/images/products/amlodipine.svg','pernapasan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(32,2,'01M15FM55WQSZN3QX8JF1WZPQA','medicine','Panadol 500 mg','panadol-500-mg-apotek-bumi-medika','Panadol','Haleon','BPOM-000001','Membantu meredakan demam, sakit kepala, dan nyeri ringan hingga sedang.','/images/products/panadol.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(33,2,'01M15FM566SZ5GKDX9VFDR21CT','medicine','Imboost Force Ultimate','imboost-force-ultimate-apotek-bumi-medika','Imboost','Soho','BPOM-000002','Suplemen untuk membantu memelihara daya tahan tubuh setiap hari.','/images/products/imboost.svg','vitamin',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(34,2,'01M15FM56F50YB6WPQNVD2BWKD','medicine','Betadine Solution 30 ml','betadine-solution-30ml-apotek-bumi-medika','Betadine','Mundipharma','BPOM-000003','Antiseptik untuk pertolongan pertama pada luka ringan.','/images/products/betadine.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(35,2,'01M15FM57FN726SWSKY6ZP8FDH','medicine','Amlodipine 10 mg','amlodipine-10-mg-apotek-bumi-medika','Generik','Kimia Farma','BPOM-000004','Obat antihipertensi yang hanya dapat dibeli dengan resep dan persetujuan apoteker.','/images/products/amlodipine.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(36,2,'01M15FM57RV3JC5YQ7XDJ44H7Z','medical_device','Omron Digital Thermometer','omron-digital-thermometer-apotek-bumi-medika','Omron','Omron Healthcare','BPOM-000005','Termometer digital cepat dan nyaman untuk seluruh keluarga.','/images/products/thermometer.svg','alat-kesehatan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(37,2,'01M15FM580EQY0M6S38CES5JKD','medicine','Diazepam 5 mg','diazepam-5-mg-apotek-bumi-medika','Generik','Indofarma','BPOM-000006','Tersimpan di master produk untuk klasifikasi, tetapi tidak diperjualbelikan secara online.','/images/products/restricted.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(38,2,'01M15FM58C9RW5X4QSTZ588GSX','medicine','Paracetamol Sirup 60 ml','paracetamol-sirup-60ml-apotek-bumi-medika','Generik','Kimia Farma','BPOM-000007','Sirup penurun demam untuk anak sesuai aturan pakai.','/images/products/panadol.svg','ibu-anak',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(39,2,'01M15FM58RBP21119E85Y7DMJ1','medicine','Sanmol Forte 650 mg','sanmol-forte-650-mg-apotek-bumi-medika','Sanmol','Sanbe Farma','BPOM-000008','Pereda demam dan nyeri ringan hingga sedang.','/images/products/panadol.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(40,2,'01M15FM593X674FAFYQG1T2PAC','medicine','Bodrex Extra','bodrex-extra-apotek-bumi-medika','Bodrex','Tempo Scan','BPOM-000009','Membantu meredakan sakit kepala dan gejala flu ringan.','/images/products/imboost.svg','flu-batuk',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(41,2,'01M15FM59DNTAJWWBWVFK9GG9Y','medicine','OBH Combi Batuk Flu 60 ml','obh-combi-batuk-flu-60ml-apotek-bumi-medika','OBH Combi','Combiphar','BPOM-000010','Sirup untuk membantu meredakan batuk dan gejala flu.','/images/products/betadine.svg','flu-batuk',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(42,2,'01M15FM59SCEF46B5W54ZNG1ZY','medicine','Tolak Angin Cair 12 Sachet','tolak-angin-cair-12-sachet-apotek-bumi-medika','Tolak Angin','Sido Muncul','BPOM-000011','Herbal untuk membantu menjaga kondisi tubuh saat masuk angin.','/images/products/imboost.svg','herbal',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(43,2,'01M15FM5A09WF6S1FPTK11C4Q2','medicine','Blackmores Vitamin C 500 mg','blackmores-vitamin-c-500-mg-apotek-bumi-medika','Blackmores','Blackmores','BPOM-000012','Vitamin C untuk membantu memenuhi kebutuhan harian.','/images/products/imboost.svg','vitamin',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(44,2,'01M15FM5A6R9SM4PPAZTZNCJYJ','medicine','Enervon-C Multivitamin','enervon-c-multivitamin-apotek-bumi-medika','Enervon-C','Darya-Varia','BPOM-000013','Multivitamin untuk membantu menjaga stamina.','/images/products/imboost.svg','vitamin',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(45,2,'01M15FM5ACH9J01M9XKR3RDF4J','medicine','Promag Tablet','promag-tablet-apotek-bumi-medika','Promag','Kalbe','BPOM-000014','Antasida untuk membantu meredakan gejala maag.','/images/products/betadine.svg','pencernaan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(46,2,'01M15FM5AJ59DYC93HKXAN5A7G','medicine','Lansoprazole 30 mg','lansoprazole-30-mg-apotek-bumi-medika','Generik','Hexpharm','BPOM-000015','Obat lambung yang memerlukan resep dokter.','/images/products/amlodipine.svg','pencernaan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(47,2,'01M15FM5ARCRBZXHQZCDKRQJHW','medicine','Metformin 500 mg','metformin-500-mg-apotek-bumi-medika','Generik','Dexa Medica','BPOM-000016','Obat diabetes oral yang memerlukan resep dokter.','/images/products/amlodipine.svg','diabetes',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(48,2,'01M15FM5AYX8CM93NAR2619CH5','medicine','Simvastatin 20 mg','simvastatin-20-mg-apotek-bumi-medika','Generik','Indofarma','BPOM-000017','Obat penurun kolesterol yang memerlukan resep dokter.','/images/products/amlodipine.svg','kolesterol',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(49,2,'01M15FM5B4J75EWSWRAGZE4KSZ','medicine','Cetirizine 10 mg','cetirizine-10-mg-apotek-bumi-medika','Generik','Bernofarm','BPOM-000018','Antihistamin untuk gejala alergi, gunakan sesuai aturan pakai.','/images/products/amlodipine.svg','alergi',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(50,2,'01M15FM5BAASVTX318E8GKJ3PJ','medicine','Loratadine 10 mg','loratadine-10-mg-apotek-bumi-medika','Generik','Novell','BPOM-000019','Antihistamin non-sedatif untuk membantu mengurangi alergi.','/images/products/amlodipine.svg','alergi',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(51,2,'01M15FM5BF9YT5TBBDR2044NR8','medicine','Hansaplast Roll Kain','hansaplast-roll-kain-apotek-bumi-medika','Hansaplast','Beiersdorf','BPOM-000020','Plester roll kain untuk kebutuhan pertolongan pertama.','/images/products/betadine.svg','first-aid',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(52,2,'01M15FM5BPAY94Q2WZRNHZMN55','medicine','Kasa Steril 16x16','kasa-steril-16x16-apotek-bumi-medika','OneMed','OneMed','BPOM-000021','Kasa steril untuk perawatan luka.','/images/products/betadine.svg','first-aid',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(53,2,'01M15FM5BXRJA4C8505Z4VWYWS','medical_device','Masker Medis 3 Ply','masker-medis-3-ply-apotek-bumi-medika','Sensi','Arista Latindo','BPOM-000022','Masker medis 3 ply untuk perlindungan harian.','/images/products/thermometer.svg','alat-kesehatan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(54,2,'01M15FM5C2PEDYVSXW8MV0S46W','medical_device','Blood Pressure Monitor Digital','blood-pressure-monitor-digital-apotek-bumi-medika','Omron','Omron Healthcare','BPOM-000023','Tensimeter digital untuk pemantauan tekanan darah di rumah.','/images/products/thermometer.svg','alat-kesehatan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(55,2,'01M15FM5C9BS98AM2KS5BN8MTD','medicine','Accu-Chek Strip 25','accu-chek-strip-25-apotek-bumi-medika','Accu-Chek','Roche','BPOM-000024','Strip cek gula darah untuk perangkat kompatibel.','/images/products/thermometer.svg','diabetes',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(56,2,'01M15FM5CF34M9F0GZC32AZMJ6','medicine','Cetaphil Gentle Skin Cleanser','cetaphil-gentle-skin-cleanser-apotek-bumi-medika','Cetaphil','Galderma','BPOM-000025','Pembersih wajah lembut untuk kulit sensitif.','/images/products/imboost.svg','skincare',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(57,2,'01M15FM5CPMV5XB7WVNSYSHTBJ','medicine','Acnes Sealing Jell','acnes-sealing-jell-apotek-bumi-medika','Acnes','Rohto','BPOM-000026','Gel perawatan kulit berjerawat.','/images/products/betadine.svg','skincare',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(58,2,'01M15FM5CX10V2Y244PZD0VF6S','medicine','Minyak Kayu Putih 60 ml','minyak-kayu-putih-60ml-apotek-bumi-medika','Cap Lang','Eagle Indo Pharma','BPOM-000027','Minyak kayu putih untuk membantu menghangatkan tubuh.','/images/products/betadine.svg','ibu-anak',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(59,2,'01M15FM5D38ZSK11BDTW1B6G6P','medicine','Oralit Sachet','oralit-sachet-apotek-bumi-medika','Generik','Kimia Farma','BPOM-000028','Larutan rehidrasi oral untuk membantu mengganti cairan tubuh.','/images/products/imboost.svg','pencernaan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(60,2,'01M15FM5D9SM8KKQQ039AY0D24','medicine','Amoxicillin 500 mg','amoxicillin-500-mg-apotek-bumi-medika','Generik','Phapros','BPOM-000029','Antibiotik yang hanya dapat ditebus dengan resep dokter.','/images/products/amlodipine.svg','antibiotik',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(61,2,'01M15FM5DG35TY9X4VB9BBJM87','medicine','Cefixime 100 mg','cefixime-100-mg-apotek-bumi-medika','Generik','Dexa Medica','BPOM-000030','Antibiotik yang membutuhkan resep dokter.','/images/products/amlodipine.svg','antibiotik',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(62,2,'01M15FM5DQ59WN58XBGYTK03Q5','medicine','Salbutamol 2 mg','salbutamol-2-mg-apotek-bumi-medika','Generik','Kimia Farma','BPOM-000031','Obat bronkodilator yang membutuhkan resep dokter.','/images/products/amlodipine.svg','pernapasan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(63,3,'01M15FM5DX9GRYWHBYZG4Y3SGB','medicine','Panadol 500 mg','panadol-500-mg-apotek-nusantara-farma','Panadol','Haleon','BPOM-000001','Membantu meredakan demam, sakit kepala, dan nyeri ringan hingga sedang.','/images/products/panadol.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(64,3,'01M15FM5E3MYZFHD30Z8WSBHX3','medicine','Imboost Force Ultimate','imboost-force-ultimate-apotek-nusantara-farma','Imboost','Soho','BPOM-000002','Suplemen untuk membantu memelihara daya tahan tubuh setiap hari.','/images/products/imboost.svg','vitamin',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(65,3,'01M15FM5E9X4G4RK9GPEZJBZJX','medicine','Betadine Solution 30 ml','betadine-solution-30ml-apotek-nusantara-farma','Betadine','Mundipharma','BPOM-000003','Antiseptik untuk pertolongan pertama pada luka ringan.','/images/products/betadine.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(66,3,'01M15FM5EG0SKMRA0B5AJJZ60P','medicine','Amlodipine 10 mg','amlodipine-10-mg-apotek-nusantara-farma','Generik','Kimia Farma','BPOM-000004','Obat antihipertensi yang hanya dapat dibeli dengan resep dan persetujuan apoteker.','/images/products/amlodipine.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(67,3,'01M15FM5EP656MW1G3PJ9DHRB6','medical_device','Omron Digital Thermometer','omron-digital-thermometer-apotek-nusantara-farma','Omron','Omron Healthcare','BPOM-000005','Termometer digital cepat dan nyaman untuk seluruh keluarga.','/images/products/thermometer.svg','alat-kesehatan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(68,3,'01M15FM5EW713JT6GS624BYK1T','medicine','Diazepam 5 mg','diazepam-5-mg-apotek-nusantara-farma','Generik','Indofarma','BPOM-000006','Tersimpan di master produk untuk klasifikasi, tetapi tidak diperjualbelikan secara online.','/images/products/restricted.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(69,3,'01M15FM5F26H3S3Z502SM3CVCC','medicine','Paracetamol Sirup 60 ml','paracetamol-sirup-60ml-apotek-nusantara-farma','Generik','Kimia Farma','BPOM-000007','Sirup penurun demam untuk anak sesuai aturan pakai.','/images/products/panadol.svg','ibu-anak',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(70,3,'01M15FM5F8SWR7FDQ5638PYWN0','medicine','Sanmol Forte 650 mg','sanmol-forte-650-mg-apotek-nusantara-farma','Sanmol','Sanbe Farma','BPOM-000008','Pereda demam dan nyeri ringan hingga sedang.','/images/products/panadol.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(71,3,'01M15FM5FDX2RAMWD852SQZVNT','medicine','Bodrex Extra','bodrex-extra-apotek-nusantara-farma','Bodrex','Tempo Scan','BPOM-000009','Membantu meredakan sakit kepala dan gejala flu ringan.','/images/products/imboost.svg','flu-batuk',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(72,3,'01M15FM5FKQQQ5A8G8DA6TB550','medicine','OBH Combi Batuk Flu 60 ml','obh-combi-batuk-flu-60ml-apotek-nusantara-farma','OBH Combi','Combiphar','BPOM-000010','Sirup untuk membantu meredakan batuk dan gejala flu.','/images/products/betadine.svg','flu-batuk',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(73,3,'01M15FM5FS9TA8PJHY9X18FVS2','medicine','Tolak Angin Cair 12 Sachet','tolak-angin-cair-12-sachet-apotek-nusantara-farma','Tolak Angin','Sido Muncul','BPOM-000011','Herbal untuk membantu menjaga kondisi tubuh saat masuk angin.','/images/products/imboost.svg','herbal',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(74,3,'01M15FM5FZGHJ6XA08EMH0AB6Z','medicine','Blackmores Vitamin C 500 mg','blackmores-vitamin-c-500-mg-apotek-nusantara-farma','Blackmores','Blackmores','BPOM-000012','Vitamin C untuk membantu memenuhi kebutuhan harian.','/images/products/imboost.svg','vitamin',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(75,3,'01M15FM5G5HDBD12GRSQQYQFPB','medicine','Enervon-C Multivitamin','enervon-c-multivitamin-apotek-nusantara-farma','Enervon-C','Darya-Varia','BPOM-000013','Multivitamin untuk membantu menjaga stamina.','/images/products/imboost.svg','vitamin',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(76,3,'01M15FM5GATKAB3NT1FCY2NTAF','medicine','Promag Tablet','promag-tablet-apotek-nusantara-farma','Promag','Kalbe','BPOM-000014','Antasida untuk membantu meredakan gejala maag.','/images/products/betadine.svg','pencernaan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(77,3,'01M15FM5GG0R9TGK76DDBDKYMW','medicine','Lansoprazole 30 mg','lansoprazole-30-mg-apotek-nusantara-farma','Generik','Hexpharm','BPOM-000015','Obat lambung yang memerlukan resep dokter.','/images/products/amlodipine.svg','pencernaan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(78,3,'01M15FM5GN6K2981P2M7ENPZA6','medicine','Metformin 500 mg','metformin-500-mg-apotek-nusantara-farma','Generik','Dexa Medica','BPOM-000016','Obat diabetes oral yang memerlukan resep dokter.','/images/products/amlodipine.svg','diabetes',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(79,3,'01M15FM5GW6AK2S62FXYK33EAP','medicine','Simvastatin 20 mg','simvastatin-20-mg-apotek-nusantara-farma','Generik','Indofarma','BPOM-000017','Obat penurun kolesterol yang memerlukan resep dokter.','/images/products/amlodipine.svg','kolesterol',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(80,3,'01M15FM5H2XM19MDG7SHX0G72N','medicine','Cetirizine 10 mg','cetirizine-10-mg-apotek-nusantara-farma','Generik','Bernofarm','BPOM-000018','Antihistamin untuk gejala alergi, gunakan sesuai aturan pakai.','/images/products/amlodipine.svg','alergi',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(81,3,'01M15FM5H8GF6E67GKXSX8FK67','medicine','Loratadine 10 mg','loratadine-10-mg-apotek-nusantara-farma','Generik','Novell','BPOM-000019','Antihistamin non-sedatif untuk membantu mengurangi alergi.','/images/products/amlodipine.svg','alergi',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(82,3,'01M15FM5HEBB2KTN9WAMZE70YP','medicine','Hansaplast Roll Kain','hansaplast-roll-kain-apotek-nusantara-farma','Hansaplast','Beiersdorf','BPOM-000020','Plester roll kain untuk kebutuhan pertolongan pertama.','/images/products/betadine.svg','first-aid',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(83,3,'01M15FM5HMVBBX55RNC2W5X7R6','medicine','Kasa Steril 16x16','kasa-steril-16x16-apotek-nusantara-farma','OneMed','OneMed','BPOM-000021','Kasa steril untuk perawatan luka.','/images/products/betadine.svg','first-aid',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(84,3,'01M15FM5HTV7HYPXNTEFFN2HEZ','medical_device','Masker Medis 3 Ply','masker-medis-3-ply-apotek-nusantara-farma','Sensi','Arista Latindo','BPOM-000022','Masker medis 3 ply untuk perlindungan harian.','/images/products/thermometer.svg','alat-kesehatan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(85,3,'01M15FM5J1AA0JQGC7HQ5Z6K8M','medical_device','Blood Pressure Monitor Digital','blood-pressure-monitor-digital-apotek-nusantara-farma','Omron','Omron Healthcare','BPOM-000023','Tensimeter digital untuk pemantauan tekanan darah di rumah.','/images/products/thermometer.svg','alat-kesehatan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(86,3,'01M15FM5J7EZCAH2QW5Q0FD7WA','medicine','Accu-Chek Strip 25','accu-chek-strip-25-apotek-nusantara-farma','Accu-Chek','Roche','BPOM-000024','Strip cek gula darah untuk perangkat kompatibel.','/images/products/thermometer.svg','diabetes',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(87,3,'01M15FM5JC9D199SA2VCJ36JB9','medicine','Cetaphil Gentle Skin Cleanser','cetaphil-gentle-skin-cleanser-apotek-nusantara-farma','Cetaphil','Galderma','BPOM-000025','Pembersih wajah lembut untuk kulit sensitif.','/images/products/imboost.svg','skincare',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(88,3,'01M15FM5JJWWJA7TGE7HNMHR4G','medicine','Acnes Sealing Jell','acnes-sealing-jell-apotek-nusantara-farma','Acnes','Rohto','BPOM-000026','Gel perawatan kulit berjerawat.','/images/products/betadine.svg','skincare',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(89,3,'01M15FM5JQMBTF31P6HN3S2C9T','medicine','Minyak Kayu Putih 60 ml','minyak-kayu-putih-60ml-apotek-nusantara-farma','Cap Lang','Eagle Indo Pharma','BPOM-000027','Minyak kayu putih untuk membantu menghangatkan tubuh.','/images/products/betadine.svg','ibu-anak',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(90,3,'01M15FM5JXDZZ5GP8J38RPCT63','medicine','Oralit Sachet','oralit-sachet-apotek-nusantara-farma','Generik','Kimia Farma','BPOM-000028','Larutan rehidrasi oral untuk membantu mengganti cairan tubuh.','/images/products/imboost.svg','pencernaan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(91,3,'01M15FM5K4Q9XR7KB86062RAZ5','medicine','Amoxicillin 500 mg','amoxicillin-500-mg-apotek-nusantara-farma','Generik','Phapros','BPOM-000029','Antibiotik yang hanya dapat ditebus dengan resep dokter.','/images/products/amlodipine.svg','antibiotik',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(92,3,'01M15FM5K9QQ3W6MYERS87HMGQ','medicine','Cefixime 100 mg','cefixime-100-mg-apotek-nusantara-farma','Generik','Dexa Medica','BPOM-000030','Antibiotik yang membutuhkan resep dokter.','/images/products/amlodipine.svg','antibiotik',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(93,3,'01M15FM5KEKH2VKP8PEX0TPF0R','medicine','Salbutamol 2 mg','salbutamol-2-mg-apotek-nusantara-farma','Generik','Kimia Farma','BPOM-000031','Obat bronkodilator yang membutuhkan resep dokter.','/images/products/amlodipine.svg','pernapasan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(94,4,'01M15FM5KMASSW1TFW4FWE0SH7','medicine','Panadol 500 mg','panadol-500-mg-klinik-farma-medika','Panadol','Haleon','BPOM-000001','Membantu meredakan demam, sakit kepala, dan nyeri ringan hingga sedang.','/images/products/panadol.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(95,4,'01M15FM5KSKFQ989YZE19Z596F','medicine','Imboost Force Ultimate','imboost-force-ultimate-klinik-farma-medika','Imboost','Soho','BPOM-000002','Suplemen untuk membantu memelihara daya tahan tubuh setiap hari.','/images/products/imboost.svg','vitamin',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(96,4,'01M15FM5KZB6J6F8GYXBEX46G4','medicine','Betadine Solution 30 ml','betadine-solution-30ml-klinik-farma-medika','Betadine','Mundipharma','BPOM-000003','Antiseptik untuk pertolongan pertama pada luka ringan.','/images/products/betadine.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(97,4,'01M15FM5M5YH8QA1AWCS374G1H','medicine','Amlodipine 10 mg','amlodipine-10-mg-klinik-farma-medika','Generik','Kimia Farma','BPOM-000004','Obat antihipertensi yang hanya dapat dibeli dengan resep dan persetujuan apoteker.','/images/products/amlodipine.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(98,4,'01M15FM5MA5X45SVCJPT6NFN8T','medical_device','Omron Digital Thermometer','omron-digital-thermometer-klinik-farma-medika','Omron','Omron Healthcare','BPOM-000005','Termometer digital cepat dan nyaman untuk seluruh keluarga.','/images/products/thermometer.svg','alat-kesehatan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(99,4,'01M15FM5MGR7Y2XC9KXA2F6J1Y','medicine','Diazepam 5 mg','diazepam-5-mg-klinik-farma-medika','Generik','Indofarma','BPOM-000006','Tersimpan di master produk untuk klasifikasi, tetapi tidak diperjualbelikan secara online.','/images/products/restricted.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(100,4,'01M15FM5MPTR8XPGQ1780A9YVA','medicine','Paracetamol Sirup 60 ml','paracetamol-sirup-60ml-klinik-farma-medika','Generik','Kimia Farma','BPOM-000007','Sirup penurun demam untuk anak sesuai aturan pakai.','/images/products/panadol.svg','ibu-anak',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(101,4,'01M15FM5MV3QEZTNSRP0EN5NJD','medicine','Sanmol Forte 650 mg','sanmol-forte-650-mg-klinik-farma-medika','Sanmol','Sanbe Farma','BPOM-000008','Pereda demam dan nyeri ringan hingga sedang.','/images/products/panadol.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(102,4,'01M15FM5N23RCAEKHM50JXPBRY','medicine','Bodrex Extra','bodrex-extra-klinik-farma-medika','Bodrex','Tempo Scan','BPOM-000009','Membantu meredakan sakit kepala dan gejala flu ringan.','/images/products/imboost.svg','flu-batuk',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(103,4,'01M15FM5N8F3FMBVP8VY6KNX06','medicine','OBH Combi Batuk Flu 60 ml','obh-combi-batuk-flu-60ml-klinik-farma-medika','OBH Combi','Combiphar','BPOM-000010','Sirup untuk membantu meredakan batuk dan gejala flu.','/images/products/betadine.svg','flu-batuk',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(104,4,'01M15FM5NDCHT9NTJNHTTGXAS0','medicine','Tolak Angin Cair 12 Sachet','tolak-angin-cair-12-sachet-klinik-farma-medika','Tolak Angin','Sido Muncul','BPOM-000011','Herbal untuk membantu menjaga kondisi tubuh saat masuk angin.','/images/products/imboost.svg','herbal',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(105,4,'01M15FM5NKGVNBNJ05A44XQ5AK','medicine','Blackmores Vitamin C 500 mg','blackmores-vitamin-c-500-mg-klinik-farma-medika','Blackmores','Blackmores','BPOM-000012','Vitamin C untuk membantu memenuhi kebutuhan harian.','/images/products/imboost.svg','vitamin',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(106,4,'01M15FM5NT5BJ9MHKCTHE9E822','medicine','Enervon-C Multivitamin','enervon-c-multivitamin-klinik-farma-medika','Enervon-C','Darya-Varia','BPOM-000013','Multivitamin untuk membantu menjaga stamina.','/images/products/imboost.svg','vitamin',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(107,4,'01M15FM5P0K281GWFSFXKCDNF6','medicine','Promag Tablet','promag-tablet-klinik-farma-medika','Promag','Kalbe','BPOM-000014','Antasida untuk membantu meredakan gejala maag.','/images/products/betadine.svg','pencernaan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(108,4,'01M15FM5P7J4KDA4NZ1BK68NFA','medicine','Lansoprazole 30 mg','lansoprazole-30-mg-klinik-farma-medika','Generik','Hexpharm','BPOM-000015','Obat lambung yang memerlukan resep dokter.','/images/products/amlodipine.svg','pencernaan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(109,4,'01M15FM5PD40BYRTEZ5MVFR271','medicine','Metformin 500 mg','metformin-500-mg-klinik-farma-medika','Generik','Dexa Medica','BPOM-000016','Obat diabetes oral yang memerlukan resep dokter.','/images/products/amlodipine.svg','diabetes',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(110,4,'01M15FM5PJNS2T2RQYZWKVCB66','medicine','Simvastatin 20 mg','simvastatin-20-mg-klinik-farma-medika','Generik','Indofarma','BPOM-000017','Obat penurun kolesterol yang memerlukan resep dokter.','/images/products/amlodipine.svg','kolesterol',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(111,4,'01M15FM5PRCMBMNX4Z7RXC714C','medicine','Cetirizine 10 mg','cetirizine-10-mg-klinik-farma-medika','Generik','Bernofarm','BPOM-000018','Antihistamin untuk gejala alergi, gunakan sesuai aturan pakai.','/images/products/amlodipine.svg','alergi',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(112,4,'01M15FM5PY0FVTMKADKPDDDRPD','medicine','Loratadine 10 mg','loratadine-10-mg-klinik-farma-medika','Generik','Novell','BPOM-000019','Antihistamin non-sedatif untuk membantu mengurangi alergi.','/images/products/amlodipine.svg','alergi',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(113,4,'01M15FM5Q4KTMGH7JJK7GXB5A2','medicine','Hansaplast Roll Kain','hansaplast-roll-kain-klinik-farma-medika','Hansaplast','Beiersdorf','BPOM-000020','Plester roll kain untuk kebutuhan pertolongan pertama.','/images/products/betadine.svg','first-aid',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(114,4,'01M15FM5QAVZXQZG6VRWMV31FJ','medicine','Kasa Steril 16x16','kasa-steril-16x16-klinik-farma-medika','OneMed','OneMed','BPOM-000021','Kasa steril untuk perawatan luka.','/images/products/betadine.svg','first-aid',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(115,4,'01M15FM5QF38TE2MC5MTQKMSR9','medical_device','Masker Medis 3 Ply','masker-medis-3-ply-klinik-farma-medika','Sensi','Arista Latindo','BPOM-000022','Masker medis 3 ply untuk perlindungan harian.','/images/products/thermometer.svg','alat-kesehatan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(116,4,'01M15FM5QNE7YKHQY5EVBFJH3F','medical_device','Blood Pressure Monitor Digital','blood-pressure-monitor-digital-klinik-farma-medika','Omron','Omron Healthcare','BPOM-000023','Tensimeter digital untuk pemantauan tekanan darah di rumah.','/images/products/thermometer.svg','alat-kesehatan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(117,4,'01M15FM5QTTR1XX102BXSSDHZB','medicine','Accu-Chek Strip 25','accu-chek-strip-25-klinik-farma-medika','Accu-Chek','Roche','BPOM-000024','Strip cek gula darah untuk perangkat kompatibel.','/images/products/thermometer.svg','diabetes',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(118,4,'01M15FM5R0MWVE1NC868FNFMPZ','medicine','Cetaphil Gentle Skin Cleanser','cetaphil-gentle-skin-cleanser-klinik-farma-medika','Cetaphil','Galderma','BPOM-000025','Pembersih wajah lembut untuk kulit sensitif.','/images/products/imboost.svg','skincare',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(119,4,'01M15FM5R6SADZ95PGDRW6EE0M','medicine','Acnes Sealing Jell','acnes-sealing-jell-klinik-farma-medika','Acnes','Rohto','BPOM-000026','Gel perawatan kulit berjerawat.','/images/products/betadine.svg','skincare',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(120,4,'01M15FM5RBHSC659CZ4G6HV3PJ','medicine','Minyak Kayu Putih 60 ml','minyak-kayu-putih-60ml-klinik-farma-medika','Cap Lang','Eagle Indo Pharma','BPOM-000027','Minyak kayu putih untuk membantu menghangatkan tubuh.','/images/products/betadine.svg','ibu-anak',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(121,4,'01M15FM5RHAX7PJK16G7SKDV5K','medicine','Oralit Sachet','oralit-sachet-klinik-farma-medika','Generik','Kimia Farma','BPOM-000028','Larutan rehidrasi oral untuk membantu mengganti cairan tubuh.','/images/products/imboost.svg','pencernaan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(122,4,'01M15FM5RP28S9G7JSMP44G9F4','medicine','Amoxicillin 500 mg','amoxicillin-500-mg-klinik-farma-medika','Generik','Phapros','BPOM-000029','Antibiotik yang hanya dapat ditebus dengan resep dokter.','/images/products/amlodipine.svg','antibiotik',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(123,4,'01M15FM5RWFE2ZQTF66H0FXDTW','medicine','Cefixime 100 mg','cefixime-100-mg-klinik-farma-medika','Generik','Dexa Medica','BPOM-000030','Antibiotik yang membutuhkan resep dokter.','/images/products/amlodipine.svg','antibiotik',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(124,4,'01M15FM5S1GQAJDG7XDHV2ZXA0','medicine','Salbutamol 2 mg','salbutamol-2-mg-klinik-farma-medika','Generik','Kimia Farma','BPOM-000031','Obat bronkodilator yang membutuhkan resep dokter.','/images/products/amlodipine.svg','pernapasan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(125,5,'01M15FM5S7PN2DADG6VJXX1JHE','medicine','Panadol 500 mg','panadol-500-mg-apotek-srikandi-care','Panadol','Haleon','BPOM-000001','Membantu meredakan demam, sakit kepala, dan nyeri ringan hingga sedang.','/images/products/panadol.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(126,5,'01M15FM5SEZ0R9HHW9PCB0SQ9P','medicine','Imboost Force Ultimate','imboost-force-ultimate-apotek-srikandi-care','Imboost','Soho','BPOM-000002','Suplemen untuk membantu memelihara daya tahan tubuh setiap hari.','/images/products/imboost.svg','vitamin',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(127,5,'01M15FM5SKTBYNRGBP8QETNSF6','medicine','Betadine Solution 30 ml','betadine-solution-30ml-apotek-srikandi-care','Betadine','Mundipharma','BPOM-000003','Antiseptik untuk pertolongan pertama pada luka ringan.','/images/products/betadine.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(128,5,'01M15FM5ST57E0F0KHXX4B1WDE','medicine','Amlodipine 10 mg','amlodipine-10-mg-apotek-srikandi-care','Generik','Kimia Farma','BPOM-000004','Obat antihipertensi yang hanya dapat dibeli dengan resep dan persetujuan apoteker.','/images/products/amlodipine.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(129,5,'01M15FM5SZB43A0G6KF971PJP4','medical_device','Omron Digital Thermometer','omron-digital-thermometer-apotek-srikandi-care','Omron','Omron Healthcare','BPOM-000005','Termometer digital cepat dan nyaman untuk seluruh keluarga.','/images/products/thermometer.svg','alat-kesehatan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(130,5,'01M15FM5T5KH47P1TS3A5FYRZN','medicine','Diazepam 5 mg','diazepam-5-mg-apotek-srikandi-care','Generik','Indofarma','BPOM-000006','Tersimpan di master produk untuk klasifikasi, tetapi tidak diperjualbelikan secara online.','/images/products/restricted.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(131,5,'01M15FM5TBW4151JHWK6YK7BVH','medicine','Paracetamol Sirup 60 ml','paracetamol-sirup-60ml-apotek-srikandi-care','Generik','Kimia Farma','BPOM-000007','Sirup penurun demam untuk anak sesuai aturan pakai.','/images/products/panadol.svg','ibu-anak',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(132,5,'01M15FM5THDP5EGBG8H49DKA33','medicine','Sanmol Forte 650 mg','sanmol-forte-650-mg-apotek-srikandi-care','Sanmol','Sanbe Farma','BPOM-000008','Pereda demam dan nyeri ringan hingga sedang.','/images/products/panadol.svg','obat',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(133,5,'01M15FM5TP78SBBV1GHNS8ZHNP','medicine','Bodrex Extra','bodrex-extra-apotek-srikandi-care','Bodrex','Tempo Scan','BPOM-000009','Membantu meredakan sakit kepala dan gejala flu ringan.','/images/products/imboost.svg','flu-batuk',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(134,5,'01M15FM5TV3TB30BN8R36RW1BF','medicine','OBH Combi Batuk Flu 60 ml','obh-combi-batuk-flu-60ml-apotek-srikandi-care','OBH Combi','Combiphar','BPOM-000010','Sirup untuk membantu meredakan batuk dan gejala flu.','/images/products/betadine.svg','flu-batuk',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(135,5,'01M15FM5V1A057V66J6MX1MBYT','medicine','Tolak Angin Cair 12 Sachet','tolak-angin-cair-12-sachet-apotek-srikandi-care','Tolak Angin','Sido Muncul','BPOM-000011','Herbal untuk membantu menjaga kondisi tubuh saat masuk angin.','/images/products/imboost.svg','herbal',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(136,5,'01M15FM5V7P3GPNBEPXNX0AG1A','medicine','Blackmores Vitamin C 500 mg','blackmores-vitamin-c-500-mg-apotek-srikandi-care','Blackmores','Blackmores','BPOM-000012','Vitamin C untuk membantu memenuhi kebutuhan harian.','/images/products/imboost.svg','vitamin',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(137,5,'01M15FM5VDD63EZJSVQB4ENQQ6','medicine','Enervon-C Multivitamin','enervon-c-multivitamin-apotek-srikandi-care','Enervon-C','Darya-Varia','BPOM-000013','Multivitamin untuk membantu menjaga stamina.','/images/products/imboost.svg','vitamin',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(138,5,'01M15FM5VK6Y0ZHB3HFTMSW0JZ','medicine','Promag Tablet','promag-tablet-apotek-srikandi-care','Promag','Kalbe','BPOM-000014','Antasida untuk membantu meredakan gejala maag.','/images/products/betadine.svg','pencernaan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(139,5,'01M15FM5VSVDJG9HEZ489Y1FQN','medicine','Lansoprazole 30 mg','lansoprazole-30-mg-apotek-srikandi-care','Generik','Hexpharm','BPOM-000015','Obat lambung yang memerlukan resep dokter.','/images/products/amlodipine.svg','pencernaan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(140,5,'01M15FM5VZE62TCQ2KY51NP7ZT','medicine','Metformin 500 mg','metformin-500-mg-apotek-srikandi-care','Generik','Dexa Medica','BPOM-000016','Obat diabetes oral yang memerlukan resep dokter.','/images/products/amlodipine.svg','diabetes',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(141,5,'01M15FM5W4FSH69JJA420M0RA2','medicine','Simvastatin 20 mg','simvastatin-20-mg-apotek-srikandi-care','Generik','Indofarma','BPOM-000017','Obat penurun kolesterol yang memerlukan resep dokter.','/images/products/amlodipine.svg','kolesterol',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(142,5,'01M15FM5WKX54QXXV2K959FD8Q','medicine','Cetirizine 10 mg','cetirizine-10-mg-apotek-srikandi-care','Generik','Bernofarm','BPOM-000018','Antihistamin untuk gejala alergi, gunakan sesuai aturan pakai.','/images/products/amlodipine.svg','alergi',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(143,5,'01M15FM5WSER56A2SZT7N1253X','medicine','Loratadine 10 mg','loratadine-10-mg-apotek-srikandi-care','Generik','Novell','BPOM-000019','Antihistamin non-sedatif untuk membantu mengurangi alergi.','/images/products/amlodipine.svg','alergi',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(144,5,'01M15FM5WYQPW2S2TBRM72D1Q4','medicine','Hansaplast Roll Kain','hansaplast-roll-kain-apotek-srikandi-care','Hansaplast','Beiersdorf','BPOM-000020','Plester roll kain untuk kebutuhan pertolongan pertama.','/images/products/betadine.svg','first-aid',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(145,5,'01M15FM5X48X23ZHYAN3GW8FX1','medicine','Kasa Steril 16x16','kasa-steril-16x16-apotek-srikandi-care','OneMed','OneMed','BPOM-000021','Kasa steril untuk perawatan luka.','/images/products/betadine.svg','first-aid',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(146,5,'01M15FM5XAA7MG034J8VCPEPJH','medical_device','Masker Medis 3 Ply','masker-medis-3-ply-apotek-srikandi-care','Sensi','Arista Latindo','BPOM-000022','Masker medis 3 ply untuk perlindungan harian.','/images/products/thermometer.svg','alat-kesehatan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(147,5,'01M15FM5XG3163E0BZD4DVS6RK','medical_device','Blood Pressure Monitor Digital','blood-pressure-monitor-digital-apotek-srikandi-care','Omron','Omron Healthcare','BPOM-000023','Tensimeter digital untuk pemantauan tekanan darah di rumah.','/images/products/thermometer.svg','alat-kesehatan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(148,5,'01M15FM5XN5PQH7W6QT3T5XRK9','medicine','Accu-Chek Strip 25','accu-chek-strip-25-apotek-srikandi-care','Accu-Chek','Roche','BPOM-000024','Strip cek gula darah untuk perangkat kompatibel.','/images/products/thermometer.svg','diabetes',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(149,5,'01M15FM5XTS67E0SRXXAWDKBTR','medicine','Cetaphil Gentle Skin Cleanser','cetaphil-gentle-skin-cleanser-apotek-srikandi-care','Cetaphil','Galderma','BPOM-000025','Pembersih wajah lembut untuk kulit sensitif.','/images/products/imboost.svg','skincare',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(150,5,'01M15FM5Y05N279XR5VWYNDYER','medicine','Acnes Sealing Jell','acnes-sealing-jell-apotek-srikandi-care','Acnes','Rohto','BPOM-000026','Gel perawatan kulit berjerawat.','/images/products/betadine.svg','skincare',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(151,5,'01M15FM5Y5MFZ4GW72ZF71N3QJ','medicine','Minyak Kayu Putih 60 ml','minyak-kayu-putih-60ml-apotek-srikandi-care','Cap Lang','Eagle Indo Pharma','BPOM-000027','Minyak kayu putih untuk membantu menghangatkan tubuh.','/images/products/betadine.svg','ibu-anak',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(152,5,'01M15FM5YEA50H8CNPK5EE56P8','medicine','Oralit Sachet','oralit-sachet-apotek-srikandi-care','Generik','Kimia Farma','BPOM-000028','Larutan rehidrasi oral untuk membantu mengganti cairan tubuh.','/images/products/imboost.svg','pencernaan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(153,5,'01M15FM5YQCQPRES6STM8JCYG8','medicine','Amoxicillin 500 mg','amoxicillin-500-mg-apotek-srikandi-care','Generik','Phapros','BPOM-000029','Antibiotik yang hanya dapat ditebus dengan resep dokter.','/images/products/amlodipine.svg','antibiotik',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(154,5,'01M15FM5YXH13ZSJEZ7SDNX1N8','medicine','Cefixime 100 mg','cefixime-100-mg-apotek-srikandi-care','Generik','Dexa Medica','BPOM-000030','Antibiotik yang membutuhkan resep dokter.','/images/products/amlodipine.svg','antibiotik',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(155,5,'01M15FM5Z4S2MQ4VXRKJ1SRAQT','medicine','Salbutamol 2 mg','salbutamol-2-mg-apotek-srikandi-care','Generik','Kimia Farma','BPOM-000031','Obat bronkodilator yang membutuhkan resep dokter.','/images/products/amlodipine.svg','pernapasan',200,'active',NULL,NULL,NULL,'2026-08-29 00:44:59','2026-08-29 00:44:59'); /*!40000 ALTER TABLE `products` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `referral_attributions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `referral_attributions` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `referrer_user_id` bigint unsigned NOT NULL, `referred_user_id` bigint unsigned NOT NULL, `eligible_seller_order_id` bigint unsigned DEFAULT NULL, `referral_code_snapshot` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'registered', `fraud_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'clear', `fraud_flags` json DEFAULT NULL, `fraud_reviewed_by` bigint unsigned DEFAULT NULL, `fraud_reviewed_at` timestamp NULL DEFAULT NULL, `fraud_review_reason` text COLLATE utf8mb4_unicode_ci, `registration_ip_hash` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `device_hash` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `registered_at` timestamp NOT NULL, `qualified_at` timestamp NULL DEFAULT NULL, `rejection_reason` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `referral_attributions_referred_user_id_unique` (`referred_user_id`), KEY `referral_attributions_eligible_seller_order_id_foreign` (`eligible_seller_order_id`), KEY `referral_attributions_fraud_reviewed_by_foreign` (`fraud_reviewed_by`), KEY `referral_referrer_status_registered_idx` (`referrer_user_id`,`status`,`registered_at`), KEY `referral_attributions_device_hash_registered_at_index` (`device_hash`,`registered_at`), KEY `referral_ip_registered_idx` (`registration_ip_hash`,`registered_at`), CONSTRAINT `referral_attributions_eligible_seller_order_id_foreign` FOREIGN KEY (`eligible_seller_order_id`) REFERENCES `seller_orders` (`id`) ON DELETE SET NULL, CONSTRAINT `referral_attributions_fraud_reviewed_by_foreign` FOREIGN KEY (`fraud_reviewed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `referral_attributions_referred_user_id_foreign` FOREIGN KEY (`referred_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, CONSTRAINT `referral_attributions_referrer_user_id_foreign` FOREIGN KEY (`referrer_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `referral_attributions` WRITE; /*!40000 ALTER TABLE `referral_attributions` DISABLE KEYS */; /*!40000 ALTER TABLE `referral_attributions` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `referral_rewards`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `referral_rewards` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `referral_attribution_id` bigint unsigned NOT NULL, `user_id` bigint unsigned NOT NULL, `coupon_id` bigint unsigned NOT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'issued', `issued_at` timestamp NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `referral_rewards_referral_attribution_id_unique` (`referral_attribution_id`), UNIQUE KEY `referral_rewards_coupon_id_unique` (`coupon_id`), KEY `referral_rewards_user_id_status_issued_at_index` (`user_id`,`status`,`issued_at`), CONSTRAINT `referral_rewards_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE, CONSTRAINT `referral_rewards_referral_attribution_id_foreign` FOREIGN KEY (`referral_attribution_id`) REFERENCES `referral_attributions` (`id`) ON DELETE CASCADE, CONSTRAINT `referral_rewards_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `referral_rewards` WRITE; /*!40000 ALTER TABLE `referral_rewards` DISABLE KEYS */; /*!40000 ALTER TABLE `referral_rewards` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `refunds`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `refunds` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `seller_order_id` bigint unsigned NOT NULL, `platform_order_id` bigint unsigned NOT NULL, `payment_id` bigint unsigned NOT NULL, `requested_by` bigint unsigned DEFAULT NULL, `processed_by` bigint unsigned DEFAULT NULL, `refund_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `amount` bigint unsigned NOT NULL, `currency` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'IDR', `reason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `order_status_before` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `provider` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `provider_refund_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'requested', `provider_response` longtext COLLATE utf8mb4_unicode_ci, `failure_reason` text COLLATE utf8mb4_unicode_ci, `requested_at` timestamp NOT NULL, `processing_started_at` timestamp NULL DEFAULT NULL, `processed_at` timestamp NULL DEFAULT NULL, `failed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `refunds_refund_key_unique` (`refund_key`), UNIQUE KEY `refunds_provider_refund_id_unique` (`provider_refund_id`), KEY `refunds_payment_id_foreign` (`payment_id`), KEY `refunds_requested_by_foreign` (`requested_by`), KEY `refunds_processed_by_foreign` (`processed_by`), KEY `refunds_seller_order_id_status_index` (`seller_order_id`,`status`), KEY `refunds_platform_order_id_status_index` (`platform_order_id`,`status`), KEY `refunds_processing_started_at_index` (`processing_started_at`), CONSTRAINT `refunds_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE RESTRICT, CONSTRAINT `refunds_platform_order_id_foreign` FOREIGN KEY (`platform_order_id`) REFERENCES `platform_orders` (`id`) ON DELETE RESTRICT, CONSTRAINT `refunds_processed_by_foreign` FOREIGN KEY (`processed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `refunds_requested_by_foreign` FOREIGN KEY (`requested_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `refunds_seller_order_id_foreign` FOREIGN KEY (`seller_order_id`) REFERENCES `seller_orders` (`id`) ON DELETE RESTRICT ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `refunds` WRITE; /*!40000 ALTER TABLE `refunds` DISABLE KEYS */; /*!40000 ALTER TABLE `refunds` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `regulatory_rules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `regulatory_rules` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `product_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `medicine_class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `rule_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `requires_prescription` tinyint(1) NOT NULL DEFAULT '0', `requires_pharmacist_review` tinyint(1) NOT NULL DEFAULT '0', `can_sell_online` tinyint(1) NOT NULL DEFAULT '1', `max_quantity` int unsigned DEFAULT NULL, `effective_from` date NOT NULL, `effective_until` date DEFAULT NULL, `regulation_reference` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `regulatory_rules_rule_code_unique` (`rule_code`), KEY `regulatory_rule_lookup` (`product_type`,`medicine_class`,`is_active`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `regulatory_rules` WRITE; /*!40000 ALTER TABLE `regulatory_rules` DISABLE KEYS */; INSERT INTO `regulatory_rules` VALUES (1,'medicine','otc','MED-OTC-2026',0,0,1,10,'2026-01-01',NULL,'Baseline compliance PRD v1.2',1,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(2,'medicine','limited_otc','MED-LOT-2026',0,0,1,4,'2026-01-01',NULL,'Baseline compliance PRD v1.2',1,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(3,'medicine','hard_drug','MED-HARD-2026',1,1,1,3,'2026-01-01',NULL,'Baseline compliance PRD v1.2',1,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(4,'medicine','narcotic','MED-NAR-2026',1,1,0,NULL,'2026-01-01',NULL,'Baseline compliance PRD v1.2',1,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(5,'medicine','psychotropic','MED-PSY-2026',1,1,0,NULL,'2026-01-01',NULL,'Baseline compliance PRD v1.2',1,'2026-08-29 00:44:58','2026-08-29 00:44:58'); /*!40000 ALTER TABLE `regulatory_rules` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `seller_orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `seller_orders` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `platform_order_id` bigint unsigned NOT NULL, `tenant_id` bigint unsigned NOT NULL, `outlet_id` bigint unsigned NOT NULL, `shipping_quote_id` bigint unsigned DEFAULT NULL, `outlet_selection_reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `outlet_selection_strategy_version` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `outlet_candidate_count` int unsigned NOT NULL DEFAULT '0', `prescription_review_request_id` bigint unsigned DEFAULT NULL, `seller_order_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `subtotal` bigint unsigned NOT NULL, `discount` bigint unsigned NOT NULL DEFAULT '0', `discount_platform` bigint unsigned NOT NULL DEFAULT '0', `discount_tenant` bigint unsigned NOT NULL DEFAULT '0', `shipping` bigint unsigned NOT NULL DEFAULT '0', `shipping_provider` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `quoted_service` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `quoted_cost` bigint unsigned DEFAULT NULL, `quoted_eta` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `quote_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `quoted_at` timestamp NULL DEFAULT NULL, `shipping_revalidated_at` timestamp NULL DEFAULT NULL, `commission_rate` decimal(5,2) NOT NULL DEFAULT '0.00', `platform_fee` bigint unsigned NOT NULL DEFAULT '0', `payment_gateway_fee` bigint unsigned NOT NULL DEFAULT '0', `refund_total` bigint unsigned NOT NULL DEFAULT '0', `seller_net_amount` bigint unsigned NOT NULL DEFAULT '0', `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft', `completed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `seller_orders_seller_order_number_unique` (`seller_order_number`), KEY `seller_orders_platform_order_id_foreign` (`platform_order_id`), KEY `seller_orders_outlet_id_foreign` (`outlet_id`), KEY `seller_orders_tenant_id_status_index` (`tenant_id`,`status`), KEY `seller_orders_shipping_quote_id_foreign` (`shipping_quote_id`), CONSTRAINT `seller_orders_outlet_id_foreign` FOREIGN KEY (`outlet_id`) REFERENCES `pharmacy_outlets` (`id`), CONSTRAINT `seller_orders_platform_order_id_foreign` FOREIGN KEY (`platform_order_id`) REFERENCES `platform_orders` (`id`) ON DELETE CASCADE, CONSTRAINT `seller_orders_shipping_quote_id_foreign` FOREIGN KEY (`shipping_quote_id`) REFERENCES `shipping_quotes` (`id`) ON DELETE SET NULL, CONSTRAINT `seller_orders_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `seller_orders` WRITE; /*!40000 ALTER TABLE `seller_orders` DISABLE KEYS */; /*!40000 ALTER TABLE `seller_orders` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sessions` ( `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint unsigned DEFAULT NULL, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `last_activity` int NOT NULL, 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 */; LOCK TABLES `sessions` WRITE; /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `settlement_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `settlement_items` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `settlement_id` bigint unsigned NOT NULL, `seller_order_id` bigint unsigned NOT NULL, `gross_sales` bigint unsigned NOT NULL, `discount_tenant` bigint unsigned NOT NULL DEFAULT '0', `discount_platform` bigint unsigned NOT NULL DEFAULT '0', `platform_commission` bigint unsigned NOT NULL DEFAULT '0', `payment_gateway_fee` bigint unsigned NOT NULL DEFAULT '0', `refund_total` bigint unsigned NOT NULL DEFAULT '0', `seller_net` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `settlement_items_seller_order_id_unique` (`seller_order_id`), KEY `settlement_items_settlement_id_foreign` (`settlement_id`), CONSTRAINT `settlement_items_seller_order_id_foreign` FOREIGN KEY (`seller_order_id`) REFERENCES `seller_orders` (`id`) ON DELETE RESTRICT, CONSTRAINT `settlement_items_settlement_id_foreign` FOREIGN KEY (`settlement_id`) REFERENCES `settlements` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `settlement_items` WRITE; /*!40000 ALTER TABLE `settlement_items` DISABLE KEYS */; /*!40000 ALTER TABLE `settlement_items` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `settlement_ledger_allocations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `settlement_ledger_allocations` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `settlement_id` bigint unsigned NOT NULL, `financial_ledger_entry_id` bigint unsigned NOT NULL, `allocation_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `amount` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `settlement_ledger_allocation_unique` (`settlement_id`,`financial_ledger_entry_id`), KEY `ledger_allocation_amount_index` (`financial_ledger_entry_id`,`amount`), CONSTRAINT `settlement_ledger_allocations_financial_ledger_entry_id_foreign` FOREIGN KEY (`financial_ledger_entry_id`) REFERENCES `financial_ledger_entries` (`id`) ON DELETE RESTRICT, CONSTRAINT `settlement_ledger_allocations_settlement_id_foreign` FOREIGN KEY (`settlement_id`) REFERENCES `settlements` (`id`) ON DELETE RESTRICT ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `settlement_ledger_allocations` WRITE; /*!40000 ALTER TABLE `settlement_ledger_allocations` DISABLE KEYS */; /*!40000 ALTER TABLE `settlement_ledger_allocations` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `settlements`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `settlements` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `settlement_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tenant_id` bigint unsigned NOT NULL, `period_start` date NOT NULL, `period_end` date NOT NULL, `gross_sales` bigint unsigned NOT NULL DEFAULT '0', `discount_tenant` bigint unsigned NOT NULL DEFAULT '0', `discount_platform` bigint unsigned NOT NULL DEFAULT '0', `platform_commission` bigint unsigned NOT NULL DEFAULT '0', `payment_gateway_fee` bigint unsigned NOT NULL DEFAULT '0', `refund_total` bigint unsigned NOT NULL DEFAULT '0', `adjustment_total` bigint unsigned NOT NULL DEFAULT '0', `seller_net` bigint unsigned NOT NULL DEFAULT '0', `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft', `generated_by` bigint unsigned DEFAULT NULL, `paid_by` bigint unsigned DEFAULT NULL, `approved_at` timestamp NULL DEFAULT NULL, `paid_at` timestamp NULL DEFAULT NULL, `payment_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `settlements_tenant_id_period_start_period_end_unique` (`tenant_id`,`period_start`,`period_end`), UNIQUE KEY `settlements_settlement_number_unique` (`settlement_number`), KEY `settlements_generated_by_foreign` (`generated_by`), KEY `settlements_paid_by_foreign` (`paid_by`), KEY `settlements_status_period_end_index` (`status`,`period_end`), CONSTRAINT `settlements_generated_by_foreign` FOREIGN KEY (`generated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `settlements_paid_by_foreign` FOREIGN KEY (`paid_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `settlements_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `settlements` WRITE; /*!40000 ALTER TABLE `settlements` DISABLE KEYS */; /*!40000 ALTER TABLE `settlements` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `shipping_quotes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `shipping_quotes` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `tenant_id` bigint unsigned NOT NULL, `outlet_id` bigint unsigned NOT NULL, `customer_address_id` bigint unsigned NOT NULL, `platform_order_id` bigint unsigned DEFAULT NULL, `seller_order_id` bigint unsigned DEFAULT NULL, `provider` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'demo', `reference` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `courier_company` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `courier_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `courier_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `service_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `service_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `price` bigint unsigned NOT NULL, `currency` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'IDR', `eta` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `duration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'quoted', `provider_payload` json DEFAULT NULL, `selection_strategy_version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'v1.3-distance-stock-price', `candidate_count` int unsigned NOT NULL DEFAULT '0', `selection_reason` text COLLATE utf8mb4_unicode_ci, `quoted_at` timestamp NOT NULL, `expires_at` timestamp NOT NULL, `revalidated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `shipping_quotes_reference_unique` (`reference`), KEY `shipping_quotes_outlet_id_foreign` (`outlet_id`), KEY `shipping_quotes_customer_address_id_foreign` (`customer_address_id`), KEY `shipping_quotes_platform_order_id_foreign` (`platform_order_id`), KEY `shipping_quotes_seller_order_id_foreign` (`seller_order_id`), KEY `shipping_quotes_user_id_status_expires_at_index` (`user_id`,`status`,`expires_at`), KEY `shipping_quotes_tenant_id_outlet_id_status_index` (`tenant_id`,`outlet_id`,`status`), CONSTRAINT `shipping_quotes_customer_address_id_foreign` FOREIGN KEY (`customer_address_id`) REFERENCES `customer_addresses` (`id`) ON DELETE CASCADE, CONSTRAINT `shipping_quotes_outlet_id_foreign` FOREIGN KEY (`outlet_id`) REFERENCES `pharmacy_outlets` (`id`) ON DELETE RESTRICT, CONSTRAINT `shipping_quotes_platform_order_id_foreign` FOREIGN KEY (`platform_order_id`) REFERENCES `platform_orders` (`id`) ON DELETE SET NULL, CONSTRAINT `shipping_quotes_seller_order_id_foreign` FOREIGN KEY (`seller_order_id`) REFERENCES `seller_orders` (`id`) ON DELETE SET NULL, CONSTRAINT `shipping_quotes_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE, CONSTRAINT `shipping_quotes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `shipping_quotes` WRITE; /*!40000 ALTER TABLE `shipping_quotes` DISABLE KEYS */; /*!40000 ALTER TABLE `shipping_quotes` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `tenant_bank_accounts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tenant_bank_accounts` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint unsigned NOT NULL, `bank_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `account_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `account_holder_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `verification_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `verified_by` bigint unsigned DEFAULT NULL, `verified_at` timestamp NULL DEFAULT NULL, `rejection_reason` text COLLATE utf8mb4_unicode_ci, `withdrawal_cooldown_until` timestamp NULL DEFAULT NULL, `is_primary` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `tenant_bank_accounts_verified_by_foreign` (`verified_by`), KEY `tenant_bank_accounts_tenant_id_verification_status_index` (`tenant_id`,`verification_status`), CONSTRAINT `tenant_bank_accounts_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE, CONSTRAINT `tenant_bank_accounts_verified_by_foreign` FOREIGN KEY (`verified_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `tenant_bank_accounts` WRITE; /*!40000 ALTER TABLE `tenant_bank_accounts` DISABLE KEYS */; INSERT INTO `tenant_bank_accounts` VALUES (1,1,'BCA','eyJpdiI6ImNONituUFF2YnYyVXJURkQzeERMV1E9PSIsInZhbHVlIjoiRGlpcEl2NUY2TVlUeEd6aHN0T3RWZz09IiwibWFjIjoiMGE3NTc2MDUzZTFiNWYyYjQwODA1NzY3ZWJhYmNkZTRhMGQ4MjMzYzE4NWIzNTFiZGY3YTlkZjVmZDk0OTFjZSIsInRhZyI6IiJ9','PT Laut Sehat Indonesia','approved',3,'2026-08-29 00:44:54',NULL,NULL,1,'2026-08-29 00:44:54','2026-08-29 00:44:54'),(2,2,'BCA','eyJpdiI6IjJLSS9YOGhZRzNvdEFGbHQzc0ExRVE9PSIsInZhbHVlIjoiMHNIRlQ5VExLUmVtV2N3ck0wRjZlQT09IiwibWFjIjoiNzk1MTQ5NDQ4M2MzYzcwMGE4MmE1MDczNzUwMTdhMWI3OTU5NzA1MWRhYzEzZjRiNzE0OGNlYzg4YjUwNjUxNCIsInRhZyI6IiJ9','PT Bumi Medika Nusantara','approved',3,'2026-08-29 00:44:54',NULL,NULL,1,'2026-08-29 00:44:54','2026-08-29 00:44:54'),(3,3,'BCA','eyJpdiI6IkV5V0QxMWRiV2grTXpTZS8yeTN2Z3c9PSIsInZhbHVlIjoiNkhuZ1Y5VFZhTk9SWDEyZllreG9Wdz09IiwibWFjIjoiNWVhZjRjOGI2MGQxNDlmYzhlZmMzZjI5MTg5ODFkMTBiOTM4N2YxNWQ2OTJhYjBiZDRmNDEwMzBkMzBlOGRiMyIsInRhZyI6IiJ9','PT Nusantara Farma Sejahtera','approved',3,'2026-08-29 00:44:55',NULL,NULL,1,'2026-08-29 00:44:55','2026-08-29 00:44:55'),(4,4,'BCA','eyJpdiI6IjhhSWlvZkx4dHdZN24zODh1SjRuV2c9PSIsInZhbHVlIjoiVUQ3dk8ybnowM2lsMkVEYmNEdloyUT09IiwibWFjIjoiYTk1OTljMzE1YjFkMDkzMmM5Njg3NjAxMGEzYTlkMzQyNzBmNDAxZTE4YTVmNjMwYjUxOWUxZjMzNzUzZWNiNyIsInRhZyI6IiJ9','CV Klinik Farma Medika','approved',3,'2026-08-29 00:44:55',NULL,NULL,1,'2026-08-29 00:44:55','2026-08-29 00:44:55'),(5,5,'BCA','eyJpdiI6Ii9KamhNaVJSM2FZTkdtNXIyWEtNcGc9PSIsInZhbHVlIjoiaW5MejhiNDY2cnlHcjdwVVh3czVvZz09IiwibWFjIjoiNzJlNTc0ZjEyYWIxZDViMmVlMTc3ZjViOWViNjllNDdkNzIyM2ZmMTIxZmNkYmYwOWNlZjBiZGFjOWY3MGE4OCIsInRhZyI6IiJ9','PT Srikandi Care Indonesia','approved',3,'2026-08-29 00:44:55',NULL,NULL,1,'2026-08-29 00:44:55','2026-08-29 00:44:55'); /*!40000 ALTER TABLE `tenant_bank_accounts` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `tenant_licenses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tenant_licenses` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint unsigned NOT NULL, `outlet_id` bigint unsigned DEFAULT NULL, `license_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `license_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `issued_at` date NOT NULL, `expired_at` date NOT NULL, `document_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `verification_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `verified_by` bigint unsigned DEFAULT NULL, `verified_at` timestamp NULL DEFAULT NULL, `rejection_reason` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `tenant_licenses_tenant_id_license_type_license_number_unique` (`tenant_id`,`license_type`,`license_number`), KEY `tenant_licenses_outlet_id_foreign` (`outlet_id`), KEY `tenant_licenses_verified_by_foreign` (`verified_by`), KEY `tenant_licenses_verification_status_expired_at_index` (`verification_status`,`expired_at`), CONSTRAINT `tenant_licenses_outlet_id_foreign` FOREIGN KEY (`outlet_id`) REFERENCES `pharmacy_outlets` (`id`) ON DELETE CASCADE, CONSTRAINT `tenant_licenses_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE, CONSTRAINT `tenant_licenses_verified_by_foreign` FOREIGN KEY (`verified_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `tenant_licenses` WRITE; /*!40000 ALTER TABLE `tenant_licenses` DISABLE KEYS */; INSERT INTO `tenant_licenses` VALUES (1,1,1,'Izin Apotek','SIA-JKT-2026-001','2026-01-01','2031-01-01','seed/tenant-license-demo.pdf','approved',NULL,'2026-08-29 00:44:56',NULL,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(2,2,2,'Izin Apotek','SIA-JKT-2026-002','2026-01-01','2031-01-01','seed/tenant-license-demo-2.pdf','approved',NULL,'2026-08-29 00:44:56',NULL,'2026-08-29 00:44:56','2026-08-29 00:44:56'); /*!40000 ALTER TABLE `tenant_licenses` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `tenant_product_listings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tenant_product_listings` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint unsigned NOT NULL, `product_id` bigint unsigned NOT NULL, `tenant_sku` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `selling_price` bigint unsigned NOT NULL, `compare_price` bigint unsigned DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `is_available` tinyint(1) NOT NULL DEFAULT '1', `rating` decimal(2,1) NOT NULL DEFAULT '4.8', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `tenant_product_listings_tenant_id_product_id_unique` (`tenant_id`,`product_id`), UNIQUE KEY `tenant_product_listings_tenant_id_tenant_sku_unique` (`tenant_id`,`tenant_sku`), KEY `tenant_product_listings_product_id_is_active_index` (`product_id`,`is_active`), CONSTRAINT `tenant_product_listings_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE, CONSTRAINT `tenant_product_listings_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=156 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `tenant_product_listings` WRITE; /*!40000 ALTER TABLE `tenant_product_listings` DISABLE KEYS */; INSERT INTO `tenant_product_listings` VALUES (1,1,1,'SKU-1-1',12500,14800,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(2,1,2,'SKU-1-2',44700,52900,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(3,1,3,'SKU-1-3',19800,23000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(4,1,4,'SKU-1-4',18400,NULL,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(5,1,5,'SKU-1-5',89900,110000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(6,1,6,'SKU-1-6',22000,NULL,0,0,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(7,1,7,'SKU-1-7',18500,21000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(8,1,8,'SKU-1-8',9200,12000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(9,1,9,'SKU-1-9',7800,9800,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(10,1,10,'SKU-1-10',17600,21900,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(11,1,11,'SKU-1-11',39500,45000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(12,1,12,'SKU-1-12',129000,155000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(13,1,13,'SKU-1-13',36800,42000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(14,1,14,'SKU-1-14',9800,12000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(15,1,15,'SKU-1-15',22000,50000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(16,1,16,'SKU-1-16',15500,NULL,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(17,1,17,'SKU-1-17',17200,NULL,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(18,1,18,'SKU-1-18',13500,16000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(19,1,19,'SKU-1-19',14600,17500,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(20,1,20,'SKU-1-20',14800,18000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(21,1,21,'SKU-1-21',12500,15000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(22,1,22,'SKU-1-22',32000,42000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(23,1,23,'SKU-1-23',489000,565000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(24,1,24,'SKU-1-24',126000,145000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(25,1,25,'SKU-1-25',93500,110000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(26,1,26,'SKU-1-26',28500,35000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(27,1,27,'SKU-1-27',24800,29000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(28,1,28,'SKU-1-28',8200,10000,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(29,1,29,'SKU-1-29',25500,NULL,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(30,1,30,'SKU-1-30',46500,NULL,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(31,1,31,'SKU-1-31',12000,NULL,1,1,4.9,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(32,2,32,'SKU-2-32',13700,14800,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(33,2,33,'SKU-2-33',45900,52900,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(34,2,34,'SKU-2-34',21000,23000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(35,2,35,'SKU-2-35',19600,NULL,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(36,2,36,'SKU-2-36',91100,110000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(37,2,37,'SKU-2-37',23200,NULL,0,0,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(38,2,38,'SKU-2-38',19700,21000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(39,2,39,'SKU-2-39',10400,12000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(40,2,40,'SKU-2-40',9000,9800,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(41,2,41,'SKU-2-41',18800,21900,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(42,2,42,'SKU-2-42',40700,45000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(43,2,43,'SKU-2-43',130200,155000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(44,2,44,'SKU-2-44',38000,42000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(45,2,45,'SKU-2-45',11000,12000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(46,2,46,'SKU-2-46',23200,50000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(47,2,47,'SKU-2-47',16700,NULL,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(48,2,48,'SKU-2-48',18400,NULL,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(49,2,49,'SKU-2-49',14700,16000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(50,2,50,'SKU-2-50',15800,17500,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(51,2,51,'SKU-2-51',16000,18000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(52,2,52,'SKU-2-52',13700,15000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(53,2,53,'SKU-2-53',33200,42000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(54,2,54,'SKU-2-54',490200,565000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(55,2,55,'SKU-2-55',127200,145000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(56,2,56,'SKU-2-56',94700,110000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(57,2,57,'SKU-2-57',29700,35000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(58,2,58,'SKU-2-58',26000,29000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(59,2,59,'SKU-2-59',9400,10000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(60,2,60,'SKU-2-60',26700,NULL,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(61,2,61,'SKU-2-61',47700,NULL,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(62,2,62,'SKU-2-62',13200,NULL,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(63,3,63,'SKU-3-63',14900,14800,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(64,3,64,'SKU-3-64',47100,52900,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(65,3,65,'SKU-3-65',22200,23000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(66,3,66,'SKU-3-66',20800,NULL,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(67,3,67,'SKU-3-67',92300,110000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(68,3,68,'SKU-3-68',24400,NULL,0,0,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(69,3,69,'SKU-3-69',20900,21000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(70,3,70,'SKU-3-70',11600,12000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(71,3,71,'SKU-3-71',10200,9800,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(72,3,72,'SKU-3-72',20000,21900,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(73,3,73,'SKU-3-73',41900,45000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(74,3,74,'SKU-3-74',131400,155000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(75,3,75,'SKU-3-75',39200,42000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(76,3,76,'SKU-3-76',12200,12000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(77,3,77,'SKU-3-77',24400,50000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(78,3,78,'SKU-3-78',17900,NULL,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(79,3,79,'SKU-3-79',19600,NULL,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(80,3,80,'SKU-3-80',15900,16000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(81,3,81,'SKU-3-81',17000,17500,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(82,3,82,'SKU-3-82',17200,18000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(83,3,83,'SKU-3-83',14900,15000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(84,3,84,'SKU-3-84',34400,42000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(85,3,85,'SKU-3-85',491400,565000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(86,3,86,'SKU-3-86',128400,145000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(87,3,87,'SKU-3-87',95900,110000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(88,3,88,'SKU-3-88',30900,35000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(89,3,89,'SKU-3-89',27200,29000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(90,3,90,'SKU-3-90',10600,10000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(91,3,91,'SKU-3-91',27900,NULL,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(92,3,92,'SKU-3-92',48900,NULL,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(93,3,93,'SKU-3-93',14400,NULL,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(94,4,94,'SKU-4-94',16100,14800,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(95,4,95,'SKU-4-95',48300,52900,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(96,4,96,'SKU-4-96',23400,23000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(97,4,97,'SKU-4-97',22000,NULL,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(98,4,98,'SKU-4-98',93500,110000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(99,4,99,'SKU-4-99',25600,NULL,0,0,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(100,4,100,'SKU-4-100',22100,21000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(101,4,101,'SKU-4-101',12800,12000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(102,4,102,'SKU-4-102',11400,9800,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(103,4,103,'SKU-4-103',21200,21900,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(104,4,104,'SKU-4-104',43100,45000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(105,4,105,'SKU-4-105',132600,155000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(106,4,106,'SKU-4-106',40400,42000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(107,4,107,'SKU-4-107',13400,12000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(108,4,108,'SKU-4-108',25600,50000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(109,4,109,'SKU-4-109',19100,NULL,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(110,4,110,'SKU-4-110',20800,NULL,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(111,4,111,'SKU-4-111',17100,16000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(112,4,112,'SKU-4-112',18200,17500,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(113,4,113,'SKU-4-113',18400,18000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(114,4,114,'SKU-4-114',16100,15000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(115,4,115,'SKU-4-115',35600,42000,1,1,4.8,'2026-08-29 00:44:58','2026-08-29 00:44:58'),(116,4,116,'SKU-4-116',492600,565000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(117,4,117,'SKU-4-117',129600,145000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(118,4,118,'SKU-4-118',97100,110000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(119,4,119,'SKU-4-119',32100,35000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(120,4,120,'SKU-4-120',28400,29000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(121,4,121,'SKU-4-121',11800,10000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(122,4,122,'SKU-4-122',29100,NULL,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(123,4,123,'SKU-4-123',50100,NULL,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(124,4,124,'SKU-4-124',15600,NULL,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(125,5,125,'SKU-5-125',17300,14800,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(126,5,126,'SKU-5-126',49500,52900,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(127,5,127,'SKU-5-127',24600,23000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(128,5,128,'SKU-5-128',23200,NULL,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(129,5,129,'SKU-5-129',94700,110000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(130,5,130,'SKU-5-130',26800,NULL,0,0,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(131,5,131,'SKU-5-131',23300,21000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(132,5,132,'SKU-5-132',14000,12000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(133,5,133,'SKU-5-133',12600,9800,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(134,5,134,'SKU-5-134',22400,21900,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(135,5,135,'SKU-5-135',44300,45000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(136,5,136,'SKU-5-136',133800,155000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(137,5,137,'SKU-5-137',41600,42000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(138,5,138,'SKU-5-138',14600,12000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(139,5,139,'SKU-5-139',26800,50000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(140,5,140,'SKU-5-140',20300,NULL,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(141,5,141,'SKU-5-141',22000,NULL,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(142,5,142,'SKU-5-142',18300,16000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(143,5,143,'SKU-5-143',19400,17500,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(144,5,144,'SKU-5-144',19600,18000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(145,5,145,'SKU-5-145',17300,15000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(146,5,146,'SKU-5-146',36800,42000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(147,5,147,'SKU-5-147',493800,565000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(148,5,148,'SKU-5-148',130800,145000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(149,5,149,'SKU-5-149',98300,110000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(150,5,150,'SKU-5-150',33300,35000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(151,5,151,'SKU-5-151',29600,29000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(152,5,152,'SKU-5-152',13000,10000,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(153,5,153,'SKU-5-153',30300,NULL,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(154,5,154,'SKU-5-154',51300,NULL,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'),(155,5,155,'SKU-5-155',16800,NULL,1,1,4.8,'2026-08-29 00:44:59','2026-08-29 00:44:59'); /*!40000 ALTER TABLE `tenant_product_listings` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `tenant_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tenant_users` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint unsigned NOT NULL, `user_id` bigint unsigned NOT NULL, `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `tenant_users_tenant_id_user_id_unique` (`tenant_id`,`user_id`), KEY `tenant_users_user_id_foreign` (`user_id`), KEY `tenant_users_tenant_id_role_status_index` (`tenant_id`,`role`,`status`), CONSTRAINT `tenant_users_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE, CONSTRAINT `tenant_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `tenant_users` WRITE; /*!40000 ALTER TABLE `tenant_users` DISABLE KEYS */; INSERT INTO `tenant_users` VALUES (1,1,4,'tenant_owner','active','2026-08-29 00:44:54','2026-08-29 00:44:54'),(2,2,5,'tenant_owner','active','2026-08-29 00:44:54','2026-08-29 00:44:54'),(3,3,6,'tenant_owner','active','2026-08-29 00:44:55','2026-08-29 00:44:55'),(4,4,7,'tenant_owner','active','2026-08-29 00:44:55','2026-08-29 00:44:55'),(5,5,8,'tenant_owner','active','2026-08-29 00:44:55','2026-08-29 00:44:55'),(6,1,2,'pharmacist','active','2026-08-29 00:44:56','2026-08-29 00:44:56'),(7,2,2,'pharmacist','active','2026-08-29 00:44:56','2026-08-29 00:44:56'),(8,1,14,'pharmacist','active','2026-08-29 00:44:57','2026-08-29 00:44:57'),(9,2,15,'pharmacist','active','2026-08-29 00:44:57','2026-08-29 00:44:57'),(10,3,16,'pharmacist','active','2026-08-29 00:44:57','2026-08-29 00:44:57'),(11,4,17,'pharmacist','active','2026-08-29 00:44:57','2026-08-29 00:44:57'),(12,5,18,'pharmacist','active','2026-08-29 00:44:58','2026-08-29 00:44:58'); /*!40000 ALTER TABLE `tenant_users` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `tenants`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tenants` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `ulid` char(26) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `business_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `verification_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `commission_rate` decimal(5,2) NOT NULL DEFAULT '10.00', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `tenants_ulid_unique` (`ulid`), UNIQUE KEY `tenants_slug_unique` (`slug`), KEY `tenants_status_index` (`status`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `tenants` WRITE; /*!40000 ALTER TABLE `tenants` DISABLE KEYS */; INSERT INTO `tenants` VALUES (1,'01M15FM0B0CSVPQEQABV4NS177','Apotek Laut Sehat','apotek-laut-sehat','PT Laut Sehat Indonesia','active','approved','halo@lautsehat.id','021-555-0188',NULL,10.00,'2026-08-29 00:44:53','2026-08-29 00:44:53'),(2,'01M15FM0BSJ706B981V8QFTZGA','Apotek Bumi Medika','apotek-bumi-medika','PT Bumi Medika Nusantara','active','approved','care@bumimedika.id','021-555-0271',NULL,10.00,'2026-08-29 00:44:53','2026-08-29 00:44:53'),(3,'01M15FM0BVNX3M3R589XCVC597','Apotek Nusantara Farma','apotek-nusantara-farma','PT Nusantara Farma Sejahtera','active','approved','halo@nusantarafarma.id','021-555-0391',NULL,10.00,'2026-08-29 00:44:53','2026-08-29 00:44:53'),(4,'01M15FM0BX9QJ7VB5KTXCKWAPN','Klinik Farma Medika','klinik-farma-medika','CV Klinik Farma Medika','active','approved','support@klinikfarma.id','022-555-0410',NULL,10.00,'2026-08-29 00:44:53','2026-08-29 00:44:53'),(5,'01M15FM0BYSCG2EYWQHR3BY4BT','Apotek Srikandi Care','apotek-srikandi-care','PT Srikandi Care Indonesia','active','approved','care@srikandicare.id','031-555-0505',NULL,10.00,'2026-08-29 00:44:53','2026-08-29 00:44:53'); /*!40000 ALTER TABLE `tenants` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `phone` varchar(24) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `platform_role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'customer', `referral_code` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT 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, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`), UNIQUE KEY `users_phone_unique` (`phone`), UNIQUE KEY `users_referral_code_unique` (`referral_code`), KEY `users_platform_role_index` (`platform_role`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'Pelanggan MeyaHealth','customer@meyahealth.test','081200000001','customer','MEYASEHAT','2026-08-29 00:44:53','$2y$12$u5p4j/Xj8A3cf8Z8qFvHiuLBRC.WynCIP4RNL2VxuKn1Qdj9s1ln2',NULL,'2026-08-29 00:44:53','2026-08-29 00:44:53'),(2,'Apt. Naya Laut Sehat','apoteker@lautsehat.test','081200000002','customer','NAYASEHAT','2026-08-29 00:44:53','$2y$12$4NQEHxu1j8H85igEEA91suzVp3p7eCDQqsvTl6giQN1We4r4UB7/6',NULL,'2026-08-29 00:44:54','2026-08-29 00:44:54'),(3,'Admin MeyaHealth','admin@meyahealth.test','081200000003','platform_admin','ADMINMEYA','2026-08-29 00:44:54','$2y$12$CSXZkzspXGSv6MtjLEDhpeCsdQU3W1dZhABojYSqugh.sAiOUEDbm',NULL,'2026-08-29 00:44:54','2026-08-29 00:44:54'),(4,'Owner Laut Sehat','owner.lautsehat@meyahealth.test','081210000001','customer','OWNERLAUT','2026-08-29 00:44:54','$2y$12$GVQ2e644pE2wqzeMSFDGBO.0mB0LMbmk39q.lJV.g8Nka209cYe3q',NULL,'2026-08-29 00:44:54','2026-08-29 00:44:54'),(5,'Owner Bumi Medika','owner.bumimedika@meyahealth.test','081210000002','customer','OWNERBUMI','2026-08-29 00:44:54','$2y$12$rwjWy.kKfBiHtta78.65pOfBxvK5TQRiKf3Cx3mpJm6ORddlEo8iC',NULL,'2026-08-29 00:44:54','2026-08-29 00:44:54'),(6,'Owner Nusantara Farma','owner.nusantarafarma@meyahealth.test','081210000003','customer','OWNERNUSA','2026-08-29 00:44:54','$2y$12$cAtbOeVW.TfLE9x8pgFg1.f19B1w5ceUUqXAOePpVZv8rrDAFACXy',NULL,'2026-08-29 00:44:55','2026-08-29 00:44:55'),(7,'Owner Klinik Farma','owner.klinikfarma@meyahealth.test','081210000004','customer','OWNERKLINIK','2026-08-29 00:44:55','$2y$12$jE9WzmhtzQN5n3G2KZ8peeZMEfNqC7m7U8onmHWWd/ZDmVe04FlLG',NULL,'2026-08-29 00:44:55','2026-08-29 00:44:55'),(8,'Owner Srikandi Care','owner.srikandi@meyahealth.test','081210000005','customer','OWNERSRIKANDI','2026-08-29 00:44:55','$2y$12$fVbmB4QwE3JFosSt4Qd3/Oyr1lkvJZ4j6s/HJGI2gIOJFUwIHY1te',NULL,'2026-08-29 00:44:55','2026-08-29 00:44:55'),(9,'dr. Nadia Samudra, Sp.PD','dokter@meyahealth.test','081200000004','doctor','DRNADIA','2026-08-29 00:44:55','$2y$12$9sp23H3CCTrZED.GF.WUNu/jyXcYCNqqPOqzU7HbKqm/DbE67Ltf.',NULL,'2026-08-29 00:44:55','2026-08-29 00:44:55'),(10,'dr. Raka Pratama, Sp.A','dokter.anak@meyahealth.test','081200000005','doctor','DOKTERANAK','2026-08-29 00:44:55','$2y$12$6nVaHBVX.L6Bx6.aCdCRg.SqyJbCdGyhFa8IIoXaEEB0zdYN0.rdG',NULL,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(11,'dr. Maya Kirana, Sp.DV','dokter.kulit@meyahealth.test','081200000006','doctor','DOKTERKULIT','2026-08-29 00:44:56','$2y$12$bdv/7jMjlUvQCDw1uH7ohu47lXQWusS3MiBP88IIhq68foJGoP9b2',NULL,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(12,'dr. Satria Wijaya, M.Gizi','dokter.gizi@meyahealth.test','081200000007','doctor','DOKTERGIZI','2026-08-29 00:44:56','$2y$12$nI6nuCjFUvzzCQpNEYXgiOMNPKIGVVPeCFneGa2qfpgG43yp1HhIi',NULL,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(13,'dr. Lestari Amalia','dokter.umum@meyahealth.test','081200000008','doctor','DOKTERUMUM','2026-08-29 00:44:56','$2y$12$Ra8c/EqeQ60ayIxsSDvIP.Flzmo6dCY7zX5LAMKiXIa7wDrA258p.',NULL,'2026-08-29 00:44:56','2026-08-29 00:44:56'),(14,'Apt. Demo Apotek Laut Sehat','apoteker.apoteklautsehat@meyahealth.test','081220000001','customer','APT0001','2026-08-29 00:44:56','$2y$12$xqMCM/8j4utKmALmDlTuY.rI7mupl0qObngb4l/BsGCNfc2BKTif.',NULL,'2026-08-29 00:44:57','2026-08-29 00:44:57'),(15,'Apt. Demo Apotek Bumi Medika','apoteker.apotekbumimedika@meyahealth.test','081220000002','customer','APT0002','2026-08-29 00:44:57','$2y$12$n12vJh5mD0sS9L/OEPf5A.9F2QxmO/SdfRpvmZt1C7RX4ZI2juUIy',NULL,'2026-08-29 00:44:57','2026-08-29 00:44:57'),(16,'Apt. Demo Apotek Nusantara Farma','apoteker.apoteknusantarafarma@meyahealth.test','081220000003','customer','APT0003','2026-08-29 00:44:57','$2y$12$OvstxEnlXdKpyyCDGj9FgOfXhhu67QCOl8TYnb/Vg9UBHgQnr7zBK',NULL,'2026-08-29 00:44:57','2026-08-29 00:44:57'),(17,'Apt. Demo Klinik Farma Medika','apoteker.klinikfarmamedika@meyahealth.test','081220000004','customer','APT0004','2026-08-29 00:44:57','$2y$12$L/AC2exa0giF5bRCioFB9OLTvzI/wv2lmo.W3W4GZa/zvB/NkJdXm',NULL,'2026-08-29 00:44:57','2026-08-29 00:44:57'),(18,'Apt. Demo Apotek Srikandi Care','apoteker.apoteksrikandicare@meyahealth.test','081220000005','customer','APT0005','2026-08-29 00:44:57','$2y$12$I.CAApQoJ348uorxPO4Soe6M/4EGQI7o60r5/FcHQiVG.sJy/rrfa',NULL,'2026-08-29 00:44:58','2026-08-29 00:44:58'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; DROP TABLE IF EXISTS `withdrawal_requests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `withdrawal_requests` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tenant_id` bigint unsigned NOT NULL, `tenant_bank_account_id` bigint unsigned NOT NULL, `requested_by` bigint unsigned NOT NULL, `reviewed_by` bigint unsigned DEFAULT NULL, `processed_by` bigint unsigned DEFAULT NULL, `reserve_ledger_entry_id` bigint unsigned DEFAULT NULL, `withdrawal_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `idempotency_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `amount` bigint unsigned NOT NULL, `currency` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'IDR', `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `payout_provider` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'manual', `payout_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `proof_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `request_note` text COLLATE utf8mb4_unicode_ci, `review_note` text COLLATE utf8mb4_unicode_ci, `failure_reason` text COLLATE utf8mb4_unicode_ci, `requested_at` timestamp NOT NULL, `reviewed_at` timestamp NULL DEFAULT NULL, `processing_started_at` timestamp NULL DEFAULT NULL, `paid_at` timestamp NULL DEFAULT NULL, `reversed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `withdrawal_requests_withdrawal_number_unique` (`withdrawal_number`), UNIQUE KEY `withdrawal_requests_idempotency_key_unique` (`idempotency_key`), KEY `withdrawal_requests_tenant_bank_account_id_foreign` (`tenant_bank_account_id`), KEY `withdrawal_requests_requested_by_foreign` (`requested_by`), KEY `withdrawal_requests_reviewed_by_foreign` (`reviewed_by`), KEY `withdrawal_requests_processed_by_foreign` (`processed_by`), KEY `withdrawal_requests_reserve_ledger_entry_id_foreign` (`reserve_ledger_entry_id`), KEY `withdrawal_requests_tenant_id_status_requested_at_index` (`tenant_id`,`status`,`requested_at`), CONSTRAINT `withdrawal_requests_processed_by_foreign` FOREIGN KEY (`processed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `withdrawal_requests_requested_by_foreign` FOREIGN KEY (`requested_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT, CONSTRAINT `withdrawal_requests_reserve_ledger_entry_id_foreign` FOREIGN KEY (`reserve_ledger_entry_id`) REFERENCES `financial_ledger_entries` (`id`) ON DELETE SET NULL, CONSTRAINT `withdrawal_requests_reviewed_by_foreign` FOREIGN KEY (`reviewed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `withdrawal_requests_tenant_bank_account_id_foreign` FOREIGN KEY (`tenant_bank_account_id`) REFERENCES `tenant_bank_accounts` (`id`) ON DELETE RESTRICT, CONSTRAINT `withdrawal_requests_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `withdrawal_requests` WRITE; /*!40000 ALTER TABLE `withdrawal_requests` DISABLE KEYS */; /*!40000 ALTER TABLE `withdrawal_requests` ENABLE KEYS */; UNLOCK TABLES; SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN; /*!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 */;