/*!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 */;
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 */;

/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
INSERT INTO `cache` VALUES ('laravel-cache-5c785c036466adea360111aa28563bfd556b5fba','i:1;',1787970622),('laravel-cache-5c785c036466adea360111aa28563bfd556b5fba:timer','i:1787970622;',1787970622);
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
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 */;

/*!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-28 21:38:22','2026-08-28 21:38:22');
/*!40000 ALTER TABLE `commission_rules` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `consultation_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `consultation_messages` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `consultations` DISABLE KEYS */;
/*!40000 ALTER TABLE `consultations` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `coupon_tenant` DISABLE KEYS */;
/*!40000 ALTER TABLE `coupon_tenant` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `coupon_usages` DISABLE KEYS */;
/*!40000 ALTER TABLE `coupon_usages` ENABLE KEYS */;
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 */;

/*!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-28 21:38:22','2027-08-28 21:38:22','active','2026-08-28 21:38:22','2026-08-28 21:38:22'),(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-27 21:38:22','2026-11-28 21:38:22','active','2026-08-28 21:38:22','2026-08-28 21:38:22'),(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-27 21:38:22','2026-11-28 21:38:22','active','2026-08-28 21:38:22','2026-08-28 21:38:22');
/*!40000 ALTER TABLE `coupons` ENABLE KEYS */;
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 */;

/*!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-28 21:38:18','2026-08-28 21:38:18');
/*!40000 ALTER TABLE `customer_addresses` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `delivery_shipments` DISABLE KEYS */;
/*!40000 ALTER TABLE `delivery_shipments` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `digital_prescription_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `digital_prescription_items` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `digital_prescriptions` DISABLE KEYS */;
/*!40000 ALTER TABLE `digital_prescriptions` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `doctor_bank_accounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `doctor_bank_accounts` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `doctor_earnings` DISABLE KEYS */;
/*!40000 ALTER TABLE `doctor_earnings` ENABLE KEYS */;
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 */;

/*!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-28 21:38:18','2026-08-28 21:38:18','2026-08-28 21:38:18'),(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-28 21:38:18','2026-08-28 21:38:18','2026-08-28 21:38:18'),(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-28 21:38:19','2026-08-28 21:38:19','2026-08-28 21:38:19'),(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-28 21:38:19','2026-08-28 21:38:19','2026-08-28 21:38:19'),(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-28 21:38:19','2026-08-28 21:38:19','2026-08-28 21:38:19');
/*!40000 ALTER TABLE `doctor_profiles` ENABLE KEYS */;
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 */;

/*!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-28 21:38:18','2026-08-28 21:38:18'),(2,1,2,'09:00:00','17:00:00','Asia/Jakarta',1,'2026-08-28 21:38:18','2026-08-28 21:38:18'),(3,1,3,'09:00:00','17:00:00','Asia/Jakarta',1,'2026-08-28 21:38:18','2026-08-28 21:38:18'),(4,1,4,'09:00:00','17:00:00','Asia/Jakarta',1,'2026-08-28 21:38:18','2026-08-28 21:38:18'),(5,1,5,'09:00:00','17:00:00','Asia/Jakarta',1,'2026-08-28 21:38:18','2026-08-28 21:38:18'),(6,2,1,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:18','2026-08-28 21:38:18'),(7,2,2,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:18','2026-08-28 21:38:18'),(8,2,3,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:18','2026-08-28 21:38:18'),(9,2,4,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:18','2026-08-28 21:38:18'),(10,2,5,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:18','2026-08-28 21:38:18'),(11,2,6,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:18','2026-08-28 21:38:18'),(12,3,1,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(13,3,2,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(14,3,3,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(15,3,4,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(16,3,5,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(17,3,6,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(18,4,1,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(19,4,2,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(20,4,3,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(21,4,4,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(22,4,5,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(23,4,6,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(24,5,1,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(25,5,2,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(26,5,3,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(27,5,4,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(28,5,5,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(29,5,6,'10:00:00','18:00:00','Asia/Jakarta',1,'2026-08-28 21:38:19','2026-08-28 21:38:19');
/*!40000 ALTER TABLE `doctor_schedules` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `doctor_withdrawal_requests` DISABLE KEYS */;
/*!40000 ALTER TABLE `doctor_withdrawal_requests` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `financial_ledger_entries` DISABLE KEYS */;
/*!40000 ALTER TABLE `financial_ledger_entries` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `inventory_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `inventory_batches` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `inventory_reservations` DISABLE KEYS */;
/*!40000 ALTER TABLE `inventory_reservations` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
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 */;

/*!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-28 21:38:20','2026-08-28 21:38:20'),(2,22,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000022',0,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(3,23,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000023',0,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(4,36,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000005',0,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(5,53,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000022',0,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(6,54,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000023',0,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(7,67,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000005',0,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(8,84,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000022',0,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(9,85,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000023',0,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(10,98,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000005',0,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(11,115,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000022',0,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(12,116,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000023',0,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(13,129,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000005',0,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(14,146,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000022',0,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(15,147,'B','Diagnostic device','Penggunaan alat kesehatan rumah tangga.','BPOM-000023',0,'2026-08-28 21:38:21','2026-08-28 21:38:21');
/*!40000 ALTER TABLE `medical_device_profiles` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `medical_records` DISABLE KEYS */;
/*!40000 ALTER TABLE `medical_records` ENABLE KEYS */;
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 */;

/*!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-28 21:38:20','2026-08-28 21:38:20'),(2,2,'Echinacea & Zinc','otc',NULL,'Kaplet','10 kaplet',NULL,0,'active','2026-08-28 21:38:20','2026-08-28 21:38:20'),(3,3,'Povidone Iodine','limited_otc','10%','Cairan luar','30 ml','Hanya untuk pemakaian luar. Baca aturan pakai sebelum digunakan.',0,'active','2026-08-28 21:38:20','2026-08-28 21:38:20'),(4,4,'Amlodipine Besilate','hard_drug','10 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:20','2026-08-28 21:38:20'),(5,6,'Diazepam','psychotropic','5 mg','Tablet','10 tablet','Tidak tersedia untuk transaksi marketplace online.',1,'active','2026-08-28 21:38:20','2026-08-28 21:38:20'),(6,7,'Paracetamol','otc','120 mg/5 ml','Sirup','60 ml',NULL,0,'active','2026-08-28 21:38:20','2026-08-28 21:38:20'),(7,8,'Paracetamol','otc','650 mg','Kaplet','4 kaplet',NULL,0,'active','2026-08-28 21:38:20','2026-08-28 21:38:20'),(8,9,'Paracetamol + Caffeine','limited_otc','500 mg','Tablet','4 tablet','Perhatikan dosis maksimal harian.',0,'active','2026-08-28 21:38:20','2026-08-28 21:38:20'),(9,10,'Obat Batuk Hitam','limited_otc','60 ml','Sirup','60 ml','Dapat menyebabkan kantuk.',0,'active','2026-08-28 21:38:20','2026-08-28 21:38:20'),(10,11,'Herbal','otc',NULL,'Cair','12 sachet',NULL,0,'active','2026-08-28 21:38:20','2026-08-28 21:38:20'),(11,12,'Ascorbic Acid','otc','500 mg','Tablet','60 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(12,13,'Multivitamin','otc',NULL,'Tablet','30 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(13,14,'Hydrotalcite + Mg Hydroxide','otc',NULL,'Tablet kunyah','10 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(14,15,'Lansoprazole','hard_drug','30 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(15,16,'Metformin HCl','hard_drug','500 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(16,17,'Simvastatin','hard_drug','20 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(17,18,'Cetirizine','limited_otc','10 mg','Tablet','10 tablet','Dapat menyebabkan kantuk.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(18,19,'Loratadine','limited_otc','10 mg','Tablet','10 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(19,20,'Plester','otc',NULL,'Plester','1 roll',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(20,21,'Kasa Steril','otc',NULL,'Kasa','10 pcs',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(21,24,'Medical Device','otc',NULL,'Alat kesehatan','25 strip',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(22,25,'Skin Care','otc',NULL,'Cleanser','125 ml',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(23,26,'Acne Care','otc',NULL,'Gel','18 g',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(24,27,'Cajuput Oil','otc',NULL,'Cairan luar','60 ml','Hanya untuk pemakaian luar.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(25,28,'Oral Rehydration Salt','otc',NULL,'Sachet','10 sachet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(26,29,'Amoxicillin Trihydrate','hard_drug','500 mg','Kapsul','10 kapsul','Antibiotik harus dengan resep dokter dan dihabiskan sesuai aturan.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(27,30,'Cefixime','hard_drug','100 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(28,31,'Salbutamol','hard_drug','2 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(29,32,'Paracetamol','otc','500 mg','Kaplet','10 kaplet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(30,33,'Echinacea & Zinc','otc',NULL,'Kaplet','10 kaplet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(31,34,'Povidone Iodine','limited_otc','10%','Cairan luar','30 ml','Hanya untuk pemakaian luar. Baca aturan pakai sebelum digunakan.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(32,35,'Amlodipine Besilate','hard_drug','10 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(33,37,'Diazepam','psychotropic','5 mg','Tablet','10 tablet','Tidak tersedia untuk transaksi marketplace online.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(34,38,'Paracetamol','otc','120 mg/5 ml','Sirup','60 ml',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(35,39,'Paracetamol','otc','650 mg','Kaplet','4 kaplet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(36,40,'Paracetamol + Caffeine','limited_otc','500 mg','Tablet','4 tablet','Perhatikan dosis maksimal harian.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(37,41,'Obat Batuk Hitam','limited_otc','60 ml','Sirup','60 ml','Dapat menyebabkan kantuk.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(38,42,'Herbal','otc',NULL,'Cair','12 sachet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(39,43,'Ascorbic Acid','otc','500 mg','Tablet','60 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(40,44,'Multivitamin','otc',NULL,'Tablet','30 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(41,45,'Hydrotalcite + Mg Hydroxide','otc',NULL,'Tablet kunyah','10 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(42,46,'Lansoprazole','hard_drug','30 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(43,47,'Metformin HCl','hard_drug','500 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(44,48,'Simvastatin','hard_drug','20 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(45,49,'Cetirizine','limited_otc','10 mg','Tablet','10 tablet','Dapat menyebabkan kantuk.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(46,50,'Loratadine','limited_otc','10 mg','Tablet','10 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(47,51,'Plester','otc',NULL,'Plester','1 roll',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(48,52,'Kasa Steril','otc',NULL,'Kasa','10 pcs',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(49,55,'Medical Device','otc',NULL,'Alat kesehatan','25 strip',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(50,56,'Skin Care','otc',NULL,'Cleanser','125 ml',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(51,57,'Acne Care','otc',NULL,'Gel','18 g',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(52,58,'Cajuput Oil','otc',NULL,'Cairan luar','60 ml','Hanya untuk pemakaian luar.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(53,59,'Oral Rehydration Salt','otc',NULL,'Sachet','10 sachet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(54,60,'Amoxicillin Trihydrate','hard_drug','500 mg','Kapsul','10 kapsul','Antibiotik harus dengan resep dokter dan dihabiskan sesuai aturan.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(55,61,'Cefixime','hard_drug','100 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(56,62,'Salbutamol','hard_drug','2 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(57,63,'Paracetamol','otc','500 mg','Kaplet','10 kaplet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(58,64,'Echinacea & Zinc','otc',NULL,'Kaplet','10 kaplet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(59,65,'Povidone Iodine','limited_otc','10%','Cairan luar','30 ml','Hanya untuk pemakaian luar. Baca aturan pakai sebelum digunakan.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(60,66,'Amlodipine Besilate','hard_drug','10 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(61,68,'Diazepam','psychotropic','5 mg','Tablet','10 tablet','Tidak tersedia untuk transaksi marketplace online.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(62,69,'Paracetamol','otc','120 mg/5 ml','Sirup','60 ml',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(63,70,'Paracetamol','otc','650 mg','Kaplet','4 kaplet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(64,71,'Paracetamol + Caffeine','limited_otc','500 mg','Tablet','4 tablet','Perhatikan dosis maksimal harian.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(65,72,'Obat Batuk Hitam','limited_otc','60 ml','Sirup','60 ml','Dapat menyebabkan kantuk.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(66,73,'Herbal','otc',NULL,'Cair','12 sachet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(67,74,'Ascorbic Acid','otc','500 mg','Tablet','60 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(68,75,'Multivitamin','otc',NULL,'Tablet','30 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(69,76,'Hydrotalcite + Mg Hydroxide','otc',NULL,'Tablet kunyah','10 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(70,77,'Lansoprazole','hard_drug','30 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(71,78,'Metformin HCl','hard_drug','500 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(72,79,'Simvastatin','hard_drug','20 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(73,80,'Cetirizine','limited_otc','10 mg','Tablet','10 tablet','Dapat menyebabkan kantuk.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(74,81,'Loratadine','limited_otc','10 mg','Tablet','10 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(75,82,'Plester','otc',NULL,'Plester','1 roll',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(76,83,'Kasa Steril','otc',NULL,'Kasa','10 pcs',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(77,86,'Medical Device','otc',NULL,'Alat kesehatan','25 strip',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(78,87,'Skin Care','otc',NULL,'Cleanser','125 ml',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(79,88,'Acne Care','otc',NULL,'Gel','18 g',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(80,89,'Cajuput Oil','otc',NULL,'Cairan luar','60 ml','Hanya untuk pemakaian luar.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(81,90,'Oral Rehydration Salt','otc',NULL,'Sachet','10 sachet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(82,91,'Amoxicillin Trihydrate','hard_drug','500 mg','Kapsul','10 kapsul','Antibiotik harus dengan resep dokter dan dihabiskan sesuai aturan.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(83,92,'Cefixime','hard_drug','100 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(84,93,'Salbutamol','hard_drug','2 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(85,94,'Paracetamol','otc','500 mg','Kaplet','10 kaplet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(86,95,'Echinacea & Zinc','otc',NULL,'Kaplet','10 kaplet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(87,96,'Povidone Iodine','limited_otc','10%','Cairan luar','30 ml','Hanya untuk pemakaian luar. Baca aturan pakai sebelum digunakan.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(88,97,'Amlodipine Besilate','hard_drug','10 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(89,99,'Diazepam','psychotropic','5 mg','Tablet','10 tablet','Tidak tersedia untuk transaksi marketplace online.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(90,100,'Paracetamol','otc','120 mg/5 ml','Sirup','60 ml',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(91,101,'Paracetamol','otc','650 mg','Kaplet','4 kaplet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(92,102,'Paracetamol + Caffeine','limited_otc','500 mg','Tablet','4 tablet','Perhatikan dosis maksimal harian.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(93,103,'Obat Batuk Hitam','limited_otc','60 ml','Sirup','60 ml','Dapat menyebabkan kantuk.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(94,104,'Herbal','otc',NULL,'Cair','12 sachet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(95,105,'Ascorbic Acid','otc','500 mg','Tablet','60 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(96,106,'Multivitamin','otc',NULL,'Tablet','30 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(97,107,'Hydrotalcite + Mg Hydroxide','otc',NULL,'Tablet kunyah','10 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(98,108,'Lansoprazole','hard_drug','30 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(99,109,'Metformin HCl','hard_drug','500 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(100,110,'Simvastatin','hard_drug','20 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(101,111,'Cetirizine','limited_otc','10 mg','Tablet','10 tablet','Dapat menyebabkan kantuk.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(102,112,'Loratadine','limited_otc','10 mg','Tablet','10 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(103,113,'Plester','otc',NULL,'Plester','1 roll',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(104,114,'Kasa Steril','otc',NULL,'Kasa','10 pcs',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(105,117,'Medical Device','otc',NULL,'Alat kesehatan','25 strip',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(106,118,'Skin Care','otc',NULL,'Cleanser','125 ml',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(107,119,'Acne Care','otc',NULL,'Gel','18 g',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(108,120,'Cajuput Oil','otc',NULL,'Cairan luar','60 ml','Hanya untuk pemakaian luar.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(109,121,'Oral Rehydration Salt','otc',NULL,'Sachet','10 sachet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(110,122,'Amoxicillin Trihydrate','hard_drug','500 mg','Kapsul','10 kapsul','Antibiotik harus dengan resep dokter dan dihabiskan sesuai aturan.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(111,123,'Cefixime','hard_drug','100 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(112,124,'Salbutamol','hard_drug','2 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(113,125,'Paracetamol','otc','500 mg','Kaplet','10 kaplet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(114,126,'Echinacea & Zinc','otc',NULL,'Kaplet','10 kaplet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(115,127,'Povidone Iodine','limited_otc','10%','Cairan luar','30 ml','Hanya untuk pemakaian luar. Baca aturan pakai sebelum digunakan.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(116,128,'Amlodipine Besilate','hard_drug','10 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(117,130,'Diazepam','psychotropic','5 mg','Tablet','10 tablet','Tidak tersedia untuk transaksi marketplace online.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(118,131,'Paracetamol','otc','120 mg/5 ml','Sirup','60 ml',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(119,132,'Paracetamol','otc','650 mg','Kaplet','4 kaplet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(120,133,'Paracetamol + Caffeine','limited_otc','500 mg','Tablet','4 tablet','Perhatikan dosis maksimal harian.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(121,134,'Obat Batuk Hitam','limited_otc','60 ml','Sirup','60 ml','Dapat menyebabkan kantuk.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(122,135,'Herbal','otc',NULL,'Cair','12 sachet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(123,136,'Ascorbic Acid','otc','500 mg','Tablet','60 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(124,137,'Multivitamin','otc',NULL,'Tablet','30 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(125,138,'Hydrotalcite + Mg Hydroxide','otc',NULL,'Tablet kunyah','10 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(126,139,'Lansoprazole','hard_drug','30 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(127,140,'Metformin HCl','hard_drug','500 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(128,141,'Simvastatin','hard_drug','20 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(129,142,'Cetirizine','limited_otc','10 mg','Tablet','10 tablet','Dapat menyebabkan kantuk.',0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(130,143,'Loratadine','limited_otc','10 mg','Tablet','10 tablet',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(131,144,'Plester','otc',NULL,'Plester','1 roll',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(132,145,'Kasa Steril','otc',NULL,'Kasa','10 pcs',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(133,148,'Medical Device','otc',NULL,'Alat kesehatan','25 strip',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(134,149,'Skin Care','otc',NULL,'Cleanser','125 ml',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(135,150,'Acne Care','otc',NULL,'Gel','18 g',NULL,0,'active','2026-08-28 21:38:21','2026-08-28 21:38:21'),(136,151,'Cajuput Oil','otc',NULL,'Cairan luar','60 ml','Hanya untuk pemakaian luar.',0,'active','2026-08-28 21:38:22','2026-08-28 21:38:22'),(137,152,'Oral Rehydration Salt','otc',NULL,'Sachet','10 sachet',NULL,0,'active','2026-08-28 21:38:22','2026-08-28 21:38:22'),(138,153,'Amoxicillin Trihydrate','hard_drug','500 mg','Kapsul','10 kapsul','Antibiotik harus dengan resep dokter dan dihabiskan sesuai aturan.',1,'active','2026-08-28 21:38:22','2026-08-28 21:38:22'),(139,154,'Cefixime','hard_drug','100 mg','Kapsul','10 kapsul','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:22','2026-08-28 21:38:22'),(140,155,'Salbutamol','hard_drug','2 mg','Tablet','10 tablet','Harus dengan resep dokter.',1,'active','2026-08-28 21:38:22','2026-08-28 21:38:22');
/*!40000 ALTER TABLE `medicine_profiles` ENABLE KEYS */;
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=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!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),(72,'2026_08_29_103304_add_customer_preferences_to_users_table',2);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `order_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `order_items` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `outlet_inventories` DISABLE KEYS */;
INSERT INTO `outlet_inventories` VALUES (1,1,1,1,24,0,10,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(2,1,6,1,12,0,8,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(3,1,1,2,25,0,10,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(4,1,6,2,13,0,8,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(5,1,1,3,26,0,10,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(6,1,6,3,14,0,8,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(7,1,1,4,27,0,10,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(8,1,6,4,15,0,8,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(9,1,1,5,28,0,10,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(10,1,6,5,16,0,8,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(11,1,1,6,29,0,10,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(12,1,6,6,17,0,8,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(13,1,1,7,30,0,10,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(14,1,6,7,18,0,8,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(15,1,1,8,31,0,10,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(16,1,6,8,19,0,8,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(17,1,1,9,32,0,10,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(18,1,6,9,20,0,8,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(19,1,1,10,33,0,10,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(20,1,6,10,21,0,8,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(21,1,1,11,34,0,10,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(22,1,6,11,22,0,8,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(23,1,1,12,35,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(24,1,6,12,23,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(25,1,1,13,36,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(26,1,6,13,24,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(27,1,1,14,37,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(28,1,6,14,25,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(29,1,1,15,38,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(30,1,6,15,26,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(31,1,1,16,39,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(32,1,6,16,27,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(33,1,1,17,40,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(34,1,6,17,28,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(35,1,1,18,41,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(36,1,6,18,29,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(37,1,1,19,42,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(38,1,6,19,30,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(39,1,1,20,43,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(40,1,6,20,31,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(41,1,1,21,44,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(42,1,6,21,32,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(43,1,1,22,45,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(44,1,6,22,33,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(45,1,1,23,46,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(46,1,6,23,34,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(47,1,1,24,47,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(48,1,6,24,35,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(49,1,1,25,48,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(50,1,6,25,36,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(51,1,1,26,49,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(52,1,6,26,37,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(53,1,1,27,50,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(54,1,6,27,38,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(55,1,1,28,51,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(56,1,6,28,39,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(57,1,1,29,52,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(58,1,6,29,40,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(59,1,1,30,53,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(60,1,6,30,41,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(61,1,1,31,54,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(62,1,6,31,42,0,8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(63,2,2,32,24,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(64,2,2,33,25,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(65,2,2,34,26,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(66,2,2,35,27,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(67,2,2,36,28,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(68,2,2,37,29,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(69,2,2,38,30,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(70,2,2,39,31,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(71,2,2,40,32,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(72,2,2,41,33,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(73,2,2,42,34,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(74,2,2,43,35,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(75,2,2,44,36,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(76,2,2,45,37,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(77,2,2,46,38,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(78,2,2,47,39,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(79,2,2,48,40,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(80,2,2,49,41,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(81,2,2,50,42,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(82,2,2,51,43,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(83,2,2,52,44,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(84,2,2,53,45,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(85,2,2,54,46,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(86,2,2,55,47,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(87,2,2,56,48,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(88,2,2,57,49,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(89,2,2,58,50,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(90,2,2,59,51,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(91,2,2,60,52,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(92,2,2,61,53,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(93,2,2,62,54,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(94,3,3,63,24,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(95,3,3,64,25,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(96,3,3,65,26,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(97,3,3,66,27,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(98,3,3,67,28,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(99,3,3,68,29,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(100,3,3,69,30,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(101,3,3,70,31,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(102,3,3,71,32,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(103,3,3,72,33,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(104,3,3,73,34,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(105,3,3,74,35,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(106,3,3,75,36,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(107,3,3,76,37,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(108,3,3,77,38,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(109,3,3,78,39,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(110,3,3,79,40,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(111,3,3,80,41,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(112,3,3,81,42,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(113,3,3,82,43,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(114,3,3,83,44,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(115,3,3,84,45,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(116,3,3,85,46,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(117,3,3,86,47,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(118,3,3,87,48,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(119,3,3,88,49,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(120,3,3,89,50,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(121,3,3,90,51,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(122,3,3,91,52,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(123,3,3,92,53,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(124,3,3,93,54,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(125,4,4,94,24,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(126,4,4,95,25,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(127,4,4,96,26,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(128,4,4,97,27,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(129,4,4,98,28,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(130,4,4,99,29,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(131,4,4,100,30,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(132,4,4,101,31,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(133,4,4,102,32,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(134,4,4,103,33,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(135,4,4,104,34,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(136,4,4,105,35,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(137,4,4,106,36,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(138,4,4,107,37,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(139,4,4,108,38,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(140,4,4,109,39,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(141,4,4,110,40,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(142,4,4,111,41,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(143,4,4,112,42,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(144,4,4,113,43,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(145,4,4,114,44,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(146,4,4,115,45,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(147,4,4,116,46,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(148,4,4,117,47,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(149,4,4,118,48,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(150,4,4,119,49,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(151,4,4,120,50,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(152,4,4,121,51,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(153,4,4,122,52,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(154,4,4,123,53,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(155,4,4,124,54,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(156,5,5,125,24,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(157,5,5,126,25,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(158,5,5,127,26,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(159,5,5,128,27,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(160,5,5,129,28,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(161,5,5,130,29,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(162,5,5,131,30,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(163,5,5,132,31,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(164,5,5,133,32,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(165,5,5,134,33,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(166,5,5,135,34,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(167,5,5,136,35,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(168,5,5,137,36,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(169,5,5,138,37,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(170,5,5,139,38,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(171,5,5,140,39,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(172,5,5,141,40,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(173,5,5,142,41,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(174,5,5,143,42,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(175,5,5,144,43,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(176,5,5,145,44,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(177,5,5,146,45,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(178,5,5,147,46,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(179,5,5,148,47,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(180,5,5,149,48,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(181,5,5,150,49,0,10,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(182,5,5,151,50,0,10,'2026-08-28 21:38:22','2026-08-28 21:38:22'),(183,5,5,152,51,0,10,'2026-08-28 21:38:22','2026-08-28 21:38:22'),(184,5,5,153,52,0,10,'2026-08-28 21:38:22','2026-08-28 21:38:22'),(185,5,5,154,53,0,10,'2026-08-28 21:38:22','2026-08-28 21:38:22'),(186,5,5,155,54,0,10,'2026-08-28 21:38:22','2026-08-28 21:38:22');
/*!40000 ALTER TABLE `outlet_inventories` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `patient_profiles` DISABLE KEYS */;
INSERT INTO `patient_profiles` VALUES (1,1,'1994-05-17','male','O+','eyJpdiI6InV0SG9zTGZocDVVUHNDZ0pjR2JqWEE9PSIsInZhbHVlIjoiczJSdEJSYVJlV3lCUHhCQys5NVp5U1lOMGJQZW42aWUwd3FtT2xlWTNCeWJsVE1jbGgwRWlFVEdwUFVPSm16ciIsIm1hYyI6ImQxNGU1M2NkMjM4M2RiYzJlYmFjMWYzMmVhNDNmYmY3Y2Y1OTFjOGFlZWFjNmVmMWUwYThjODBkOGNhMGFjNDciLCJ0YWciOiIifQ==','Keluarga Pelanggan','081200000099','2026-08-28 21:38:18','2026-08-28 21:38:18');
/*!40000 ALTER TABLE `patient_profiles` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
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 */;

/*!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-28 21:38:19','2026-08-28 21:38:19'),(2,2,2,2,'Apt. Naya Laut Sehat','STRA-3171-2026-002','SIPA-3171-2026-002','2031-01-01',NULL,'approved',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(3,14,1,1,'Apt. Demo Apotek Laut Sehat','STRA-DEMO-0001','SIPA-DEMO-0001','2031-01-01',NULL,'approved',1,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(4,15,2,2,'Apt. Demo Apotek Bumi Medika','STRA-DEMO-0002','SIPA-DEMO-0002','2031-01-01',NULL,'approved',1,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(5,16,3,3,'Apt. Demo Apotek Nusantara Farma','STRA-DEMO-0003','SIPA-DEMO-0003','2031-01-01',NULL,'approved',1,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(6,17,4,4,'Apt. Demo Klinik Farma Medika','STRA-DEMO-0004','SIPA-DEMO-0004','2031-01-01',NULL,'approved',1,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(7,18,5,5,'Apt. Demo Apotek Srikandi Care','STRA-DEMO-0005','SIPA-DEMO-0005','2031-01-01',NULL,'approved',1,'2026-08-28 21:38:20','2026-08-28 21:38:20');
/*!40000 ALTER TABLE `pharmacists` ENABLE KEYS */;
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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40000 ALTER TABLE `pharmacy_conversations` DISABLE KEYS */;
INSERT INTO `pharmacy_conversations` VALUES (1,1,1,1,1,'open',NULL,NULL,'2026-08-29 03:00:21','2026-08-29 03:00:21');
/*!40000 ALTER TABLE `pharmacy_conversations` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `pharmacy_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `pharmacy_messages` ENABLE KEYS */;
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 */;

/*!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-28 21:38:16','2026-08-28 21:38:16'),(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-28 21:38:16','2026-08-28 21:38:16'),(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-28 21:38:16','2026-08-28 21:38:16'),(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-28 21:38:16','2026-08-28 21:38:16'),(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-28 21:38:16','2026-08-28 21:38:16'),(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-28 21:38:20','2026-08-28 21:38:20');
/*!40000 ALTER TABLE `pharmacy_outlets` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `platform_orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `platform_orders` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `point_transactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `point_transactions` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `point_wallets` DISABLE KEYS */;
/*!40000 ALTER TABLE `point_wallets` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `prescription_review_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `prescription_review_logs` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `prescription_review_requests` DISABLE KEYS */;
/*!40000 ALTER TABLE `prescription_review_requests` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `prescriptions` DISABLE KEYS */;
/*!40000 ALTER TABLE `prescriptions` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `product_regulatory_histories` DISABLE KEYS */;
/*!40000 ALTER TABLE `product_regulatory_histories` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `product_submissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `product_submissions` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES (1,1,'01M154YE39JNA30BMS7CV34Y8R','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-28 21:38:20','2026-08-28 21:38:20'),(2,1,'01M154YE3MBWQ5HBQGWPRWG4PE','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-28 21:38:20','2026-08-28 21:38:20'),(3,1,'01M154YE3W64JDBXXK9RNZPAXF','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-28 21:38:20','2026-08-28 21:38:20'),(4,1,'01M154YE448ZSSM63B522VZS7R','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-28 21:38:20','2026-08-28 21:38:20'),(5,1,'01M154YE4DC0X3PWEW9TJGBRPF','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-28 21:38:20','2026-08-28 21:38:20'),(6,1,'01M154YE4NHQ9BWXAQP677205G','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-28 21:38:20','2026-08-28 21:38:20'),(7,1,'01M154YE4X0370WZ90TW694R3V','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-28 21:38:20','2026-08-28 21:38:20'),(8,1,'01M154YE5577WAC87B8FM8TE99','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-28 21:38:20','2026-08-28 21:38:20'),(9,1,'01M154YE5C0CPQN3FZJMAQ4XHJ','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-28 21:38:20','2026-08-28 21:38:20'),(10,1,'01M154YE5MHAHXH1K176WC627C','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-28 21:38:20','2026-08-28 21:38:20'),(11,1,'01M154YE5X60Z4ARMRRCYEFYRF','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-28 21:38:20','2026-08-28 21:38:20'),(12,1,'01M154YE664EBW1T885SQVS687','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-28 21:38:20','2026-08-28 21:38:20'),(13,1,'01M154YE6ECGK31YPWT1J5FV9C','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-28 21:38:21','2026-08-28 21:38:21'),(14,1,'01M154YE6Q5KYQQWC1TBNEAT0Y','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-28 21:38:21','2026-08-28 21:38:21'),(15,1,'01M154YE6YS5C8852N7B4JC37V','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-28 21:38:21','2026-08-28 21:38:21'),(16,1,'01M154YE77JY07E4CRWR8DGDNT','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-28 21:38:21','2026-08-28 21:38:21'),(17,1,'01M154YE7FYHWY45HB4JDJ5M8J','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-28 21:38:21','2026-08-28 21:38:21'),(18,1,'01M154YE7R2GS618WTFWV1H0Q2','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-28 21:38:21','2026-08-28 21:38:21'),(19,1,'01M154YE80C4BEEDC1C4A0WFH6','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-28 21:38:21','2026-08-28 21:38:21'),(20,1,'01M154YE88Q1PM3JG27MK3NRSS','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-28 21:38:21','2026-08-28 21:38:21'),(21,1,'01M154YE8H7WR75ZQRQJEP2HK0','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-28 21:38:21','2026-08-28 21:38:21'),(22,1,'01M154YE8SQD2KDRBBE5C99RG6','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-28 21:38:21','2026-08-28 21:38:21'),(23,1,'01M154YE91MYQZ8YRR5TNA476X','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-28 21:38:21','2026-08-28 21:38:21'),(24,1,'01M154YE9AM24TGTM6KCPNV20Y','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-28 21:38:21','2026-08-28 21:38:21'),(25,1,'01M154YE9J89FZB7KK3X4S0Q4T','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-28 21:38:21','2026-08-28 21:38:21'),(26,1,'01M154YE9V3YFX8EWAARZXVRGE','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-28 21:38:21','2026-08-28 21:38:21'),(27,1,'01M154YEA4BFSR5BT6RXF1JBHP','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-28 21:38:21','2026-08-28 21:38:21'),(28,1,'01M154YEADRVX24STSDWJ6NAHY','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-28 21:38:21','2026-08-28 21:38:21'),(29,1,'01M154YEANGVPNHEM3F1QSW8Q1','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-28 21:38:21','2026-08-28 21:38:21'),(30,1,'01M154YEAWE3TGVHD9636R0AE6','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-28 21:38:21','2026-08-28 21:38:21'),(31,1,'01M154YEB4AH93RPZB6C77PPBG','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-28 21:38:21','2026-08-28 21:38:21'),(32,2,'01M154YEBC79KJQER81HFNE4ZM','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-28 21:38:21','2026-08-28 21:38:21'),(33,2,'01M154YEBJ5Y7AN2CWRPRYPNME','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-28 21:38:21','2026-08-28 21:38:21'),(34,2,'01M154YEBRKRK4TY5NEY4B9757','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-28 21:38:21','2026-08-28 21:38:21'),(35,2,'01M154YEBZ9MTPFSM0T63F7X0P','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-28 21:38:21','2026-08-28 21:38:21'),(36,2,'01M154YEC5X2R0ZZSB2B3A55K1','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-28 21:38:21','2026-08-28 21:38:21'),(37,2,'01M154YECCW8VBJYZKBGBT7KP6','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-28 21:38:21','2026-08-28 21:38:21'),(38,2,'01M154YECKKWMQEZKFEJV67GET','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-28 21:38:21','2026-08-28 21:38:21'),(39,2,'01M154YECTA3MKZ5Y88SKNKXZX','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-28 21:38:21','2026-08-28 21:38:21'),(40,2,'01M154YED2SJXWAPB7JGPS32CT','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-28 21:38:21','2026-08-28 21:38:21'),(41,2,'01M154YEDB7ZXZMVE30ZMPWNJE','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-28 21:38:21','2026-08-28 21:38:21'),(42,2,'01M154YEDKJHM4P893QTKG0C0H','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-28 21:38:21','2026-08-28 21:38:21'),(43,2,'01M154YEDT7MJGT8KCPH736T9R','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-28 21:38:21','2026-08-28 21:38:21'),(44,2,'01M154YEE0HVK6FE5XZFFQDA7G','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-28 21:38:21','2026-08-28 21:38:21'),(45,2,'01M154YEE7N5XRTRFCMQ5X7SX4','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-28 21:38:21','2026-08-28 21:38:21'),(46,2,'01M154YEEGFFYSRFPVQNSQ13FT','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-28 21:38:21','2026-08-28 21:38:21'),(47,2,'01M154YEERWAS8KFSVSNFT1BB7','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-28 21:38:21','2026-08-28 21:38:21'),(48,2,'01M154YEF055B8V9GC7VRPJKPB','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-28 21:38:21','2026-08-28 21:38:21'),(49,2,'01M154YEF7RBA5H9HEQNHGPAFM','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-28 21:38:21','2026-08-28 21:38:21'),(50,2,'01M154YEFE712ZJ7QAD09TQ8X7','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-28 21:38:21','2026-08-28 21:38:21'),(51,2,'01M154YEFMZF7Y2VGVBKGA6ECE','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-28 21:38:21','2026-08-28 21:38:21'),(52,2,'01M154YEFT56Q843A7CMRWF62V','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-28 21:38:21','2026-08-28 21:38:21'),(53,2,'01M154YEG1MRGAF6HC4CXCE9GX','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-28 21:38:21','2026-08-28 21:38:21'),(54,2,'01M154YEG8VJ84MBM5E4C1MWC5','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-28 21:38:21','2026-08-28 21:38:21'),(55,2,'01M154YEGF8Z6J726WRKVSA32P','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-28 21:38:21','2026-08-28 21:38:21'),(56,2,'01M154YEGNGQPX1XHEXRV4Q6J2','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-28 21:38:21','2026-08-28 21:38:21'),(57,2,'01M154YEGW90S76Q64ZZD7JR56','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-28 21:38:21','2026-08-28 21:38:21'),(58,2,'01M154YEH25VVHFQM79FAG04YN','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-28 21:38:21','2026-08-28 21:38:21'),(59,2,'01M154YEH87SAQEGT0MR4S24V7','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-28 21:38:21','2026-08-28 21:38:21'),(60,2,'01M154YEHF5E3A7DFXD2DF62D5','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-28 21:38:21','2026-08-28 21:38:21'),(61,2,'01M154YEHPB9F1EVV9X4K66136','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-28 21:38:21','2026-08-28 21:38:21'),(62,2,'01M154YEHYAJTSWTYY4AHPCMAF','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-28 21:38:21','2026-08-28 21:38:21'),(63,3,'01M154YEJ5SSZ1KZ4QFZ2M5GJ7','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-28 21:38:21','2026-08-28 21:38:21'),(64,3,'01M154YEJC8SQYX5AJK09JK685','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-28 21:38:21','2026-08-28 21:38:21'),(65,3,'01M154YEJKTEV6KMRB5EPHMDE5','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-28 21:38:21','2026-08-28 21:38:21'),(66,3,'01M154YEJYYZWJ14MJ082EG9F1','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-28 21:38:21','2026-08-28 21:38:21'),(67,3,'01M154YEK5090QV9H0QDJY4QVM','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-28 21:38:21','2026-08-28 21:38:21'),(68,3,'01M154YEKDB20RE3ESS52Y45EZ','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-28 21:38:21','2026-08-28 21:38:21'),(69,3,'01M154YEKM9S6ZRJPZJ29HBNN8','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-28 21:38:21','2026-08-28 21:38:21'),(70,3,'01M154YEKWMJVR89WR4Y23X0EK','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-28 21:38:21','2026-08-28 21:38:21'),(71,3,'01M154YEM3ZP7RF3X5B5W55WVE','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-28 21:38:21','2026-08-28 21:38:21'),(72,3,'01M154YEMCC0VHV9ZKGMDAV7XM','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-28 21:38:21','2026-08-28 21:38:21'),(73,3,'01M154YEMK32RAK1ECA5J33PGJ','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-28 21:38:21','2026-08-28 21:38:21'),(74,3,'01M154YEMVYHAZCA34X7T0YSH1','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-28 21:38:21','2026-08-28 21:38:21'),(75,3,'01M154YEN1TRV0R0ND2ZRAJE2F','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-28 21:38:21','2026-08-28 21:38:21'),(76,3,'01M154YEN7A6SAJ9Z4CMC0RTRY','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-28 21:38:21','2026-08-28 21:38:21'),(77,3,'01M154YENGAC73VYF35MVCEHJR','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-28 21:38:21','2026-08-28 21:38:21'),(78,3,'01M154YENP1DSE82F9PSATKD9R','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-28 21:38:21','2026-08-28 21:38:21'),(79,3,'01M154YENZ2A0VP5YY0W22CE5N','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-28 21:38:21','2026-08-28 21:38:21'),(80,3,'01M154YEP67N9XW5CMDHVNPS72','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-28 21:38:21','2026-08-28 21:38:21'),(81,3,'01M154YEPDXKB3D4Z3PNAFY987','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-28 21:38:21','2026-08-28 21:38:21'),(82,3,'01M154YEPN1RNNPPZ836096M6H','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-28 21:38:21','2026-08-28 21:38:21'),(83,3,'01M154YEPWN71RDDBHQGE7C63R','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-28 21:38:21','2026-08-28 21:38:21'),(84,3,'01M154YEQ2J0MDRD0M0B3MPNTN','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-28 21:38:21','2026-08-28 21:38:21'),(85,3,'01M154YEQ9ZE4FKQ8V0EE5Q0D7','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-28 21:38:21','2026-08-28 21:38:21'),(86,3,'01M154YEQJWE508HSE5C3J3PPZ','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-28 21:38:21','2026-08-28 21:38:21'),(87,3,'01M154YEQRTHNYDAG1RXMCZRP7','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-28 21:38:21','2026-08-28 21:38:21'),(88,3,'01M154YEQZD36W989EDX4PJ8XQ','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-28 21:38:21','2026-08-28 21:38:21'),(89,3,'01M154YER6S7S2VQMYK0ZR0C7N','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-28 21:38:21','2026-08-28 21:38:21'),(90,3,'01M154YERD2M2HRBDVXRS7HES6','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-28 21:38:21','2026-08-28 21:38:21'),(91,3,'01M154YERKKVFXYJE3SFW4D2AW','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-28 21:38:21','2026-08-28 21:38:21'),(92,3,'01M154YERT6WNMJZXWEHGHNQTG','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-28 21:38:21','2026-08-28 21:38:21'),(93,3,'01M154YES1YYXNGSEX56AJ34RW','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-28 21:38:21','2026-08-28 21:38:21'),(94,4,'01M154YES8DJ03D0FS80R1PJZV','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-28 21:38:21','2026-08-28 21:38:21'),(95,4,'01M154YESFQ9Y34GGA0X3WSV2G','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-28 21:38:21','2026-08-28 21:38:21'),(96,4,'01M154YESP5GF5YZB7MCZ55BZ1','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-28 21:38:21','2026-08-28 21:38:21'),(97,4,'01M154YESWBCZGCKXS4VVS51W0','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-28 21:38:21','2026-08-28 21:38:21'),(98,4,'01M154YET33C4AEJMAKAF1G24T','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-28 21:38:21','2026-08-28 21:38:21'),(99,4,'01M154YET9Z8YH73PE4TDCB5EF','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-28 21:38:21','2026-08-28 21:38:21'),(100,4,'01M154YETFKRZ67Y6VTAKEYTA4','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-28 21:38:21','2026-08-28 21:38:21'),(101,4,'01M154YETQAJVTEGQJ2QN1J6ET','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-28 21:38:21','2026-08-28 21:38:21'),(102,4,'01M154YETY2681GV3PSG2HZRMN','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-28 21:38:21','2026-08-28 21:38:21'),(103,4,'01M154YEV5E0G9HS8CMXJ5KE12','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-28 21:38:21','2026-08-28 21:38:21'),(104,4,'01M154YEVE0F8JJRA0WNFR1TY9','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-28 21:38:21','2026-08-28 21:38:21'),(105,4,'01M154YEVQA243TCK0P37RNW44','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-28 21:38:21','2026-08-28 21:38:21'),(106,4,'01M154YEVYA8QMDQG33J2C61XM','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-28 21:38:21','2026-08-28 21:38:21'),(107,4,'01M154YEW648G1NBYJ4NK1V6RS','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-28 21:38:21','2026-08-28 21:38:21'),(108,4,'01M154YEWD0F0A0DXZF08CZB6A','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-28 21:38:21','2026-08-28 21:38:21'),(109,4,'01M154YEWMVGPQ0BAF75610CJC','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-28 21:38:21','2026-08-28 21:38:21'),(110,4,'01M154YEWW61HNSNRVNMMAWHH9','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-28 21:38:21','2026-08-28 21:38:21'),(111,4,'01M154YEX3JB2ACPG3Q5KP44WQ','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-28 21:38:21','2026-08-28 21:38:21'),(112,4,'01M154YEXAWC3PV7JQXD427R6V','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-28 21:38:21','2026-08-28 21:38:21'),(113,4,'01M154YEXGEFP45A7Z25DG9PC7','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-28 21:38:21','2026-08-28 21:38:21'),(114,4,'01M154YEXQA2GY917XR82C6GGW','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-28 21:38:21','2026-08-28 21:38:21'),(115,4,'01M154YEXY4E72XGC85CH774ZG','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-28 21:38:21','2026-08-28 21:38:21'),(116,4,'01M154YEY45FX800Y52PPWD1ZM','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-28 21:38:21','2026-08-28 21:38:21'),(117,4,'01M154YEYBQ1BECS62EDT7356F','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-28 21:38:21','2026-08-28 21:38:21'),(118,4,'01M154YEYHZTGJGWCS1SJ5NYDG','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-28 21:38:21','2026-08-28 21:38:21'),(119,4,'01M154YEYRNTAQ5KRX1JJV8ACF','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-28 21:38:21','2026-08-28 21:38:21'),(120,4,'01M154YEYYY70ARKQNE3K00XX8','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-28 21:38:21','2026-08-28 21:38:21'),(121,4,'01M154YEZ4Y2GQ9FY3A3XJWNJM','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-28 21:38:21','2026-08-28 21:38:21'),(122,4,'01M154YEZB0J86504PT5MWA2J8','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-28 21:38:21','2026-08-28 21:38:21'),(123,4,'01M154YEZJQMWRQZ2Z7P61X5W9','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-28 21:38:21','2026-08-28 21:38:21'),(124,4,'01M154YEZSB0WTB5VJQJTG46TD','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-28 21:38:21','2026-08-28 21:38:21'),(125,5,'01M154YF003Y7DW36Q35316CY1','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-28 21:38:21','2026-08-28 21:38:21'),(126,5,'01M154YF05DPJDC92X1MRQR5V8','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-28 21:38:21','2026-08-28 21:38:21'),(127,5,'01M154YF0C910D3FY5CQXVJQQR','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-28 21:38:21','2026-08-28 21:38:21'),(128,5,'01M154YF0KP1SAAJKRD0DQC8BA','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-28 21:38:21','2026-08-28 21:38:21'),(129,5,'01M154YF0TEWNW9SA2SAQTD7V5','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-28 21:38:21','2026-08-28 21:38:21'),(130,5,'01M154YF11NZK5Q1FFJX5XATFP','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-28 21:38:21','2026-08-28 21:38:21'),(131,5,'01M154YF1819NVJ8768B3Z8PER','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-28 21:38:21','2026-08-28 21:38:21'),(132,5,'01M154YF1F35R0XY7VBDA9T53T','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-28 21:38:21','2026-08-28 21:38:21'),(133,5,'01M154YF1PAFNJEPZBPN9VA9Z1','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-28 21:38:21','2026-08-28 21:38:21'),(134,5,'01M154YF1X15N5785AKBSP1TPW','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-28 21:38:21','2026-08-28 21:38:21'),(135,5,'01M154YF2326RSMB7GDZ5DT57Q','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-28 21:38:21','2026-08-28 21:38:21'),(136,5,'01M154YF2AZPSRVAZFV2H3HNYM','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-28 21:38:21','2026-08-28 21:38:21'),(137,5,'01M154YF2GFD9DDENQ2QJKWV3Z','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-28 21:38:21','2026-08-28 21:38:21'),(138,5,'01M154YF2Q7SW04Q8YK0FWQNJ1','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-28 21:38:21','2026-08-28 21:38:21'),(139,5,'01M154YF2XG1EFBBZE84A88540','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-28 21:38:21','2026-08-28 21:38:21'),(140,5,'01M154YF34N10ECTTX97YXB27C','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-28 21:38:21','2026-08-28 21:38:21'),(141,5,'01M154YF3ADVNSCGBT5P426NNB','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-28 21:38:21','2026-08-28 21:38:21'),(142,5,'01M154YF3G44P01M27HN3B2RJQ','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-28 21:38:21','2026-08-28 21:38:21'),(143,5,'01M154YF3PACWTA7SE9YRK2EEK','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-28 21:38:21','2026-08-28 21:38:21'),(144,5,'01M154YF3YEQYEBARC1AAF8T44','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-28 21:38:21','2026-08-28 21:38:21'),(145,5,'01M154YF45W5907Y6FTW0M660K','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-28 21:38:21','2026-08-28 21:38:21'),(146,5,'01M154YF4DAHVS9DX1CGGAW8ZP','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-28 21:38:21','2026-08-28 21:38:21'),(147,5,'01M154YF4MVHCCGV4AMCECRAGK','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-28 21:38:21','2026-08-28 21:38:21'),(148,5,'01M154YF4TC7RWZSC4P7F33B9X','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-28 21:38:21','2026-08-28 21:38:21'),(149,5,'01M154YF51KSHFQYSGC2NYYWGG','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-28 21:38:21','2026-08-28 21:38:21'),(150,5,'01M154YF59KHS9C4WX1A07MQPM','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-28 21:38:21','2026-08-28 21:38:21'),(151,5,'01M154YF5GCR61RDNCKFAR0EY2','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-28 21:38:22','2026-08-28 21:38:22'),(152,5,'01M154YF5PRK2C59Q6H8W427H2','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-28 21:38:22','2026-08-28 21:38:22'),(153,5,'01M154YF5YCRFPJJPH4GZY1W19','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-28 21:38:22','2026-08-28 21:38:22'),(154,5,'01M154YF64T6XGVTJVRGC6MH00','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-28 21:38:22','2026-08-28 21:38:22'),(155,5,'01M154YF6CHD7Z19WDFZ0H85ZQ','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-28 21:38:22','2026-08-28 21:38:22');
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `referral_attributions` DISABLE KEYS */;
/*!40000 ALTER TABLE `referral_attributions` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `referral_rewards` DISABLE KEYS */;
/*!40000 ALTER TABLE `referral_rewards` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `refunds` DISABLE KEYS */;
/*!40000 ALTER TABLE `refunds` ENABLE KEYS */;
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 */;

/*!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-28 21:38:20','2026-08-28 21:38:20'),(2,'medicine','limited_otc','MED-LOT-2026',0,0,1,4,'2026-01-01',NULL,'Baseline compliance PRD v1.2',1,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(3,'medicine','hard_drug','MED-HARD-2026',1,1,1,3,'2026-01-01',NULL,'Baseline compliance PRD v1.2',1,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(4,'medicine','narcotic','MED-NAR-2026',1,1,0,NULL,'2026-01-01',NULL,'Baseline compliance PRD v1.2',1,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(5,'medicine','psychotropic','MED-PSY-2026',1,1,0,NULL,'2026-01-01',NULL,'Baseline compliance PRD v1.2',1,'2026-08-28 21:38:20','2026-08-28 21:38:20');
/*!40000 ALTER TABLE `regulatory_rules` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `seller_orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `seller_orders` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
INSERT INTO `sessions` VALUES ('2PSnLdTISSyQTXxnL4EArg0lsywJYp6giuz0oogl',NULL,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJHeWZYeEFjcEdYSHhqQ3NzZ05QazhaaXVJUDFtbUpoVWdvSjBYVVZBIiwidXJsIjp7ImludGVuZGVkIjoiaHR0cDpcL1wvMTI3LjAuMC4xOjgwMDBcL3Byb2ZpbCJ9LCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvMTI3LjAuMC4xOjgwMDBcL21hc3VrIiwicm91dGUiOiJsb2dpbiJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19',1787974914),('E0GGtgj108O9EvjKPch2SOafGJ41yELidFrPIYLp',1,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJXbWJzcldvaWtkT0Zsa05ocEFHQ24yOEx0NUpzV1Fsc2Z1ZmwxRzMyIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdDo4MDAwIiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjEsImNhcnQiOnsidGVuYW50X2lkIjoxLCJpdGVtcyI6eyIxIjoxfX19',1787976734);
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `settlement_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `settlement_items` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `settlement_ledger_allocations` DISABLE KEYS */;
/*!40000 ALTER TABLE `settlement_ledger_allocations` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `settlements` DISABLE KEYS */;
/*!40000 ALTER TABLE `settlements` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `shipping_quotes` DISABLE KEYS */;
/*!40000 ALTER TABLE `shipping_quotes` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `tenant_bank_accounts` DISABLE KEYS */;
INSERT INTO `tenant_bank_accounts` VALUES (1,1,'BCA','eyJpdiI6InNNYm0vNVZXcEc2eVJrVFYvRkQ3V2c9PSIsInZhbHVlIjoiU1M4NUljN01JOU44SGY3bVFGUVBTQT09IiwibWFjIjoiNDRlYTIyOWNkNTdkODJjN2ZiZmNhNzgyNTc0OWY2OWQ0N2Y1NDY0OTA5ZWRkMGE3NTIwZWZkNWViYjc3YmMyZSIsInRhZyI6IiJ9','PT Laut Sehat Indonesia','approved',3,'2026-08-28 21:38:17',NULL,NULL,1,'2026-08-28 21:38:17','2026-08-28 21:38:17'),(2,2,'BCA','eyJpdiI6IllKRUZkVWdoR2d1K1RUNHZTQ0JUeHc9PSIsInZhbHVlIjoiZ3JGR3J2VGI5dmJkTVppNXhXRnVoQT09IiwibWFjIjoiMmRlMzVkN2Q3Y2E5OTY0YmZlOGMxMjQyODA5Mzc0MzcyYThjYWRjODIzYTUwNjA5MWFkZTI0ZDJjNzhlMjk4NyIsInRhZyI6IiJ9','PT Bumi Medika Nusantara','approved',3,'2026-08-28 21:38:17',NULL,NULL,1,'2026-08-28 21:38:17','2026-08-28 21:38:17'),(3,3,'BCA','eyJpdiI6InJoRXE1aXpTcTRJK0tVYTF3WGFTUHc9PSIsInZhbHVlIjoiNXY4WitIL3ZuQWhsL2Fhd2xJdTZEQT09IiwibWFjIjoiNGMyMTRiYzNlODNkZWIwZWEzOGQ0OGNlOTM0MmRjYmQzYjQ5OTlmNzJlZTg3Yjg1Y2E0MmI1OGVjYWU3NjMyMCIsInRhZyI6IiJ9','PT Nusantara Farma Sejahtera','approved',3,'2026-08-28 21:38:17',NULL,NULL,1,'2026-08-28 21:38:17','2026-08-28 21:38:17'),(4,4,'BCA','eyJpdiI6IlRSelRsRjFIRzdpcGcyVXdrMFZKM2c9PSIsInZhbHVlIjoiL2J3ZVNHYmpsSDNEYTJzaFFId2hMUT09IiwibWFjIjoiYjY5YTY4OTFiMzlhMWFiMzQwNWM4MGM4ZDFjNjg2MDNiYTBmNjNjNjU3MzlkZTcxMDI0YTQ3YmViNjQ0MGQzOCIsInRhZyI6IiJ9','CV Klinik Farma Medika','approved',3,'2026-08-28 21:38:18',NULL,NULL,1,'2026-08-28 21:38:18','2026-08-28 21:38:18'),(5,5,'BCA','eyJpdiI6IjhqT1lrNFh0MEs2OWhLdFgzeDdNYUE9PSIsInZhbHVlIjoiNUgvNWp4aHNhL2dOTlBVK2hHV21IQT09IiwibWFjIjoiYzM0MjQ2MjRhYTU1MGM1MjExYzMwZGQ4MWVmNmUwNDhlMWJjZWEyYzNiOTA3NDE5ZjViZDcxM2RmZWUzMTI2MiIsInRhZyI6IiJ9','PT Srikandi Care Indonesia','approved',3,'2026-08-28 21:38:18',NULL,NULL,1,'2026-08-28 21:38:18','2026-08-28 21:38:18');
/*!40000 ALTER TABLE `tenant_bank_accounts` ENABLE KEYS */;
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 */;

/*!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-28 21:38:19',NULL,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(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-28 21:38:19',NULL,'2026-08-28 21:38:19','2026-08-28 21:38:19');
/*!40000 ALTER TABLE `tenant_licenses` ENABLE KEYS */;
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 */;

/*!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-28 21:38:20','2026-08-28 21:38:20'),(2,1,2,'SKU-1-2',44700,52900,1,1,4.9,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(3,1,3,'SKU-1-3',19800,23000,1,1,4.9,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(4,1,4,'SKU-1-4',18400,NULL,1,1,4.9,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(5,1,5,'SKU-1-5',89900,110000,1,1,4.9,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(6,1,6,'SKU-1-6',22000,NULL,0,0,4.9,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(7,1,7,'SKU-1-7',18500,21000,1,1,4.9,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(8,1,8,'SKU-1-8',9200,12000,1,1,4.9,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(9,1,9,'SKU-1-9',7800,9800,1,1,4.9,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(10,1,10,'SKU-1-10',17600,21900,1,1,4.9,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(11,1,11,'SKU-1-11',39500,45000,1,1,4.9,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(12,1,12,'SKU-1-12',129000,155000,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(13,1,13,'SKU-1-13',36800,42000,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(14,1,14,'SKU-1-14',9800,12000,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(15,1,15,'SKU-1-15',22000,50000,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(16,1,16,'SKU-1-16',15500,NULL,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(17,1,17,'SKU-1-17',17200,NULL,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(18,1,18,'SKU-1-18',13500,16000,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(19,1,19,'SKU-1-19',14600,17500,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(20,1,20,'SKU-1-20',14800,18000,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(21,1,21,'SKU-1-21',12500,15000,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(22,1,22,'SKU-1-22',32000,42000,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(23,1,23,'SKU-1-23',489000,565000,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(24,1,24,'SKU-1-24',126000,145000,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(25,1,25,'SKU-1-25',93500,110000,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(26,1,26,'SKU-1-26',28500,35000,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(27,1,27,'SKU-1-27',24800,29000,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(28,1,28,'SKU-1-28',8200,10000,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(29,1,29,'SKU-1-29',25500,NULL,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(30,1,30,'SKU-1-30',46500,NULL,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(31,1,31,'SKU-1-31',12000,NULL,1,1,4.9,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(32,2,32,'SKU-2-32',13700,14800,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(33,2,33,'SKU-2-33',45900,52900,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(34,2,34,'SKU-2-34',21000,23000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(35,2,35,'SKU-2-35',19600,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(36,2,36,'SKU-2-36',91100,110000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(37,2,37,'SKU-2-37',23200,NULL,0,0,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(38,2,38,'SKU-2-38',19700,21000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(39,2,39,'SKU-2-39',10400,12000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(40,2,40,'SKU-2-40',9000,9800,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(41,2,41,'SKU-2-41',18800,21900,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(42,2,42,'SKU-2-42',40700,45000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(43,2,43,'SKU-2-43',130200,155000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(44,2,44,'SKU-2-44',38000,42000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(45,2,45,'SKU-2-45',11000,12000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(46,2,46,'SKU-2-46',23200,50000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(47,2,47,'SKU-2-47',16700,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(48,2,48,'SKU-2-48',18400,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(49,2,49,'SKU-2-49',14700,16000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(50,2,50,'SKU-2-50',15800,17500,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(51,2,51,'SKU-2-51',16000,18000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(52,2,52,'SKU-2-52',13700,15000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(53,2,53,'SKU-2-53',33200,42000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(54,2,54,'SKU-2-54',490200,565000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(55,2,55,'SKU-2-55',127200,145000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(56,2,56,'SKU-2-56',94700,110000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(57,2,57,'SKU-2-57',29700,35000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(58,2,58,'SKU-2-58',26000,29000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(59,2,59,'SKU-2-59',9400,10000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(60,2,60,'SKU-2-60',26700,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(61,2,61,'SKU-2-61',47700,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(62,2,62,'SKU-2-62',13200,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(63,3,63,'SKU-3-63',14900,14800,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(64,3,64,'SKU-3-64',47100,52900,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(65,3,65,'SKU-3-65',22200,23000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(66,3,66,'SKU-3-66',20800,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(67,3,67,'SKU-3-67',92300,110000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(68,3,68,'SKU-3-68',24400,NULL,0,0,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(69,3,69,'SKU-3-69',20900,21000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(70,3,70,'SKU-3-70',11600,12000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(71,3,71,'SKU-3-71',10200,9800,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(72,3,72,'SKU-3-72',20000,21900,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(73,3,73,'SKU-3-73',41900,45000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(74,3,74,'SKU-3-74',131400,155000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(75,3,75,'SKU-3-75',39200,42000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(76,3,76,'SKU-3-76',12200,12000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(77,3,77,'SKU-3-77',24400,50000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(78,3,78,'SKU-3-78',17900,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(79,3,79,'SKU-3-79',19600,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(80,3,80,'SKU-3-80',15900,16000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(81,3,81,'SKU-3-81',17000,17500,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(82,3,82,'SKU-3-82',17200,18000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(83,3,83,'SKU-3-83',14900,15000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(84,3,84,'SKU-3-84',34400,42000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(85,3,85,'SKU-3-85',491400,565000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(86,3,86,'SKU-3-86',128400,145000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(87,3,87,'SKU-3-87',95900,110000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(88,3,88,'SKU-3-88',30900,35000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(89,3,89,'SKU-3-89',27200,29000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(90,3,90,'SKU-3-90',10600,10000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(91,3,91,'SKU-3-91',27900,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(92,3,92,'SKU-3-92',48900,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(93,3,93,'SKU-3-93',14400,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(94,4,94,'SKU-4-94',16100,14800,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(95,4,95,'SKU-4-95',48300,52900,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(96,4,96,'SKU-4-96',23400,23000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(97,4,97,'SKU-4-97',22000,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(98,4,98,'SKU-4-98',93500,110000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(99,4,99,'SKU-4-99',25600,NULL,0,0,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(100,4,100,'SKU-4-100',22100,21000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(101,4,101,'SKU-4-101',12800,12000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(102,4,102,'SKU-4-102',11400,9800,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(103,4,103,'SKU-4-103',21200,21900,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(104,4,104,'SKU-4-104',43100,45000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(105,4,105,'SKU-4-105',132600,155000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(106,4,106,'SKU-4-106',40400,42000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(107,4,107,'SKU-4-107',13400,12000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(108,4,108,'SKU-4-108',25600,50000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(109,4,109,'SKU-4-109',19100,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(110,4,110,'SKU-4-110',20800,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(111,4,111,'SKU-4-111',17100,16000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(112,4,112,'SKU-4-112',18200,17500,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(113,4,113,'SKU-4-113',18400,18000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(114,4,114,'SKU-4-114',16100,15000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(115,4,115,'SKU-4-115',35600,42000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(116,4,116,'SKU-4-116',492600,565000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(117,4,117,'SKU-4-117',129600,145000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(118,4,118,'SKU-4-118',97100,110000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(119,4,119,'SKU-4-119',32100,35000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(120,4,120,'SKU-4-120',28400,29000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(121,4,121,'SKU-4-121',11800,10000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(122,4,122,'SKU-4-122',29100,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(123,4,123,'SKU-4-123',50100,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(124,4,124,'SKU-4-124',15600,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(125,5,125,'SKU-5-125',17300,14800,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(126,5,126,'SKU-5-126',49500,52900,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(127,5,127,'SKU-5-127',24600,23000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(128,5,128,'SKU-5-128',23200,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(129,5,129,'SKU-5-129',94700,110000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(130,5,130,'SKU-5-130',26800,NULL,0,0,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(131,5,131,'SKU-5-131',23300,21000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(132,5,132,'SKU-5-132',14000,12000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(133,5,133,'SKU-5-133',12600,9800,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(134,5,134,'SKU-5-134',22400,21900,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(135,5,135,'SKU-5-135',44300,45000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(136,5,136,'SKU-5-136',133800,155000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(137,5,137,'SKU-5-137',41600,42000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(138,5,138,'SKU-5-138',14600,12000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(139,5,139,'SKU-5-139',26800,50000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(140,5,140,'SKU-5-140',20300,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(141,5,141,'SKU-5-141',22000,NULL,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(142,5,142,'SKU-5-142',18300,16000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(143,5,143,'SKU-5-143',19400,17500,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(144,5,144,'SKU-5-144',19600,18000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(145,5,145,'SKU-5-145',17300,15000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(146,5,146,'SKU-5-146',36800,42000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(147,5,147,'SKU-5-147',493800,565000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(148,5,148,'SKU-5-148',130800,145000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(149,5,149,'SKU-5-149',98300,110000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(150,5,150,'SKU-5-150',33300,35000,1,1,4.8,'2026-08-28 21:38:21','2026-08-28 21:38:21'),(151,5,151,'SKU-5-151',29600,29000,1,1,4.8,'2026-08-28 21:38:22','2026-08-28 21:38:22'),(152,5,152,'SKU-5-152',13000,10000,1,1,4.8,'2026-08-28 21:38:22','2026-08-28 21:38:22'),(153,5,153,'SKU-5-153',30300,NULL,1,1,4.8,'2026-08-28 21:38:22','2026-08-28 21:38:22'),(154,5,154,'SKU-5-154',51300,NULL,1,1,4.8,'2026-08-28 21:38:22','2026-08-28 21:38:22'),(155,5,155,'SKU-5-155',16800,NULL,1,1,4.8,'2026-08-28 21:38:22','2026-08-28 21:38:22');
/*!40000 ALTER TABLE `tenant_product_listings` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `tenant_users` DISABLE KEYS */;
INSERT INTO `tenant_users` VALUES (1,1,4,'tenant_owner','active','2026-08-28 21:38:17','2026-08-28 21:38:17'),(2,2,5,'tenant_owner','active','2026-08-28 21:38:17','2026-08-28 21:38:17'),(3,3,6,'tenant_owner','active','2026-08-28 21:38:17','2026-08-28 21:38:17'),(4,4,7,'tenant_owner','active','2026-08-28 21:38:18','2026-08-28 21:38:18'),(5,5,8,'tenant_owner','active','2026-08-28 21:38:18','2026-08-28 21:38:18'),(6,1,2,'pharmacist','active','2026-08-28 21:38:19','2026-08-28 21:38:19'),(7,2,2,'pharmacist','active','2026-08-28 21:38:19','2026-08-28 21:38:19'),(8,1,14,'pharmacist','active','2026-08-28 21:38:19','2026-08-28 21:38:19'),(9,2,15,'pharmacist','active','2026-08-28 21:38:20','2026-08-28 21:38:20'),(10,3,16,'pharmacist','active','2026-08-28 21:38:20','2026-08-28 21:38:20'),(11,4,17,'pharmacist','active','2026-08-28 21:38:20','2026-08-28 21:38:20'),(12,5,18,'pharmacist','active','2026-08-28 21:38:20','2026-08-28 21:38:20');
/*!40000 ALTER TABLE `tenant_users` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `tenants` DISABLE KEYS */;
INSERT INTO `tenants` VALUES (1,'01M154Y9ET8JDMXXR54HGQ2BS2','Apotek Laut Sehat','apotek-laut-sehat','PT Laut Sehat Indonesia','active','approved','halo@lautsehat.id','021-555-0188',NULL,10.00,'2026-08-28 21:38:16','2026-08-28 21:38:16'),(2,'01M154Y9F6XVJHB3J5FAAV1JVV','Apotek Bumi Medika','apotek-bumi-medika','PT Bumi Medika Nusantara','active','approved','care@bumimedika.id','021-555-0271',NULL,10.00,'2026-08-28 21:38:16','2026-08-28 21:38:16'),(3,'01M154Y9F85BYRXYQMJTCACNZN','Apotek Nusantara Farma','apotek-nusantara-farma','PT Nusantara Farma Sejahtera','active','approved','halo@nusantarafarma.id','021-555-0391',NULL,10.00,'2026-08-28 21:38:16','2026-08-28 21:38:16'),(4,'01M154Y9FAAYGBS3SD8K0X758V','Klinik Farma Medika','klinik-farma-medika','CV Klinik Farma Medika','active','approved','support@klinikfarma.id','022-555-0410',NULL,10.00,'2026-08-28 21:38:16','2026-08-28 21:38:16'),(5,'01M154Y9FC4GWGM8EEMYK83KJP','Apotek Srikandi Care','apotek-srikandi-care','PT Srikandi Care Indonesia','active','approved','care@srikandicare.id','031-555-0505',NULL,10.00,'2026-08-28 21:38:16','2026-08-28 21:38:16');
/*!40000 ALTER TABLE `tenants` ENABLE KEYS */;
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,
  `avatar_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notify_in_app` tinyint(1) NOT NULL DEFAULT '1',
  `notify_email` tinyint(1) NOT NULL DEFAULT '1',
  `google_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `google_avatar` varchar(255) 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`),
  UNIQUE KEY `users_google_id_unique` (`google_id`),
  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 */;

/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'Pelanggan MeyaHealth','customer@meyahealth.test','081200000001',NULL,1,1,NULL,NULL,'customer','MEYASEHAT','2026-08-28 21:38:16','$2y$12$WOpKiM5wlAUTjc3TO6J11uLIi8IVcOISfrAENFQAQr2YA6iu3DIBe',NULL,'2026-08-28 21:38:16','2026-08-28 21:38:16'),(2,'Apt. Naya Laut Sehat','apoteker@lautsehat.test','081200000002',NULL,1,1,NULL,NULL,'customer','NAYASEHAT','2026-08-28 21:38:16','$2y$12$JeCtAgrYvW68uqfr4OTYIuK1ZE2.LAMdn8ddzcZex.Y5b3FjcdrXa',NULL,'2026-08-28 21:38:16','2026-08-28 21:38:16'),(3,'Admin MeyaHealth','admin@meyahealth.test','081200000003',NULL,1,1,NULL,NULL,'platform_admin','ADMINMEYA','2026-08-28 21:38:16','$2y$12$K2tI8ctTm.JhyzQqDoOssu4tpR.fcJiRI2RHeSSkSi05c5w0CqD8S',NULL,'2026-08-28 21:38:17','2026-08-28 21:38:17'),(4,'Owner Laut Sehat','owner.lautsehat@meyahealth.test','081210000001',NULL,1,1,NULL,NULL,'customer','OWNERLAUT','2026-08-28 21:38:17','$2y$12$QaganuuwMikkLwuLuhIdV.JP3.psEgZY0boJJG3Rq.2Akz3Qa8n.S',NULL,'2026-08-28 21:38:17','2026-08-28 21:38:17'),(5,'Owner Bumi Medika','owner.bumimedika@meyahealth.test','081210000002',NULL,1,1,NULL,NULL,'customer','OWNERBUMI','2026-08-28 21:38:17','$2y$12$.v55IYFtv0/8CRvnqSAuYuZbOV47ly3Fjc6ifzfQRG5uDXtNBSk2W',NULL,'2026-08-28 21:38:17','2026-08-28 21:38:17'),(6,'Owner Nusantara Farma','owner.nusantarafarma@meyahealth.test','081210000003',NULL,1,1,NULL,NULL,'customer','OWNERNUSA','2026-08-28 21:38:17','$2y$12$t9DYHLTKZh590IJAnkl5Jec/DpWFuDao1MNWxGZoaXM2Cu90wXZDm',NULL,'2026-08-28 21:38:17','2026-08-28 21:38:17'),(7,'Owner Klinik Farma','owner.klinikfarma@meyahealth.test','081210000004',NULL,1,1,NULL,NULL,'customer','OWNERKLINIK','2026-08-28 21:38:17','$2y$12$lgNyUZEsgaZSbbg4dvbzcOe7wR9xXfWT1cCTL7z63vDzdEDnYv/2.',NULL,'2026-08-28 21:38:18','2026-08-28 21:38:18'),(8,'Owner Srikandi Care','owner.srikandi@meyahealth.test','081210000005',NULL,1,1,NULL,NULL,'customer','OWNERSRIKANDI','2026-08-28 21:38:18','$2y$12$HqlbdIqZ0x4tJK1tOS4OCOezOkOiPAXbWrfqKgIn9qyVvoL.fWAYC',NULL,'2026-08-28 21:38:18','2026-08-28 21:38:18'),(9,'dr. Nadia Samudra, Sp.PD','dokter@meyahealth.test','081200000004',NULL,1,1,NULL,NULL,'doctor','DRNADIA','2026-08-28 21:38:18','$2y$12$umPhhMffFRkvjuVMvGFbUurWXBuZYCtcoqfWEicJybCar75fG8wGS',NULL,'2026-08-28 21:38:18','2026-08-28 21:38:18'),(10,'dr. Raka Pratama, Sp.A','dokter.anak@meyahealth.test','081200000005',NULL,1,1,NULL,NULL,'doctor','DOKTERANAK','2026-08-28 21:38:18','$2y$12$mYRnBnnvW4/5qMkg1KU.iOmP48U.7FXfC0NZq7750EUc7hLO08Mpy',NULL,'2026-08-28 21:38:18','2026-08-28 21:38:18'),(11,'dr. Maya Kirana, Sp.DV','dokter.kulit@meyahealth.test','081200000006',NULL,1,1,NULL,NULL,'doctor','DOKTERKULIT','2026-08-28 21:38:18','$2y$12$kCQi1SjR1xDOJLM9dTqQ1e5A3O2XYNfqmhGYgCUSIvtKKnoa3frme',NULL,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(12,'dr. Satria Wijaya, M.Gizi','dokter.gizi@meyahealth.test','081200000007',NULL,1,1,NULL,NULL,'doctor','DOKTERGIZI','2026-08-28 21:38:19','$2y$12$zbvlJUicj.7mBHz/RqunhO7C4jSTlglYT1P.faoJqqiIOfVTyJO5e',NULL,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(13,'dr. Lestari Amalia','dokter.umum@meyahealth.test','081200000008',NULL,1,1,NULL,NULL,'doctor','DOKTERUMUM','2026-08-28 21:38:19','$2y$12$ib61EST9F8bNuKouQzq5e.YAO5O/Fu/mlK8VH1qefYrSfgCSADWxW',NULL,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(14,'Apt. Demo Apotek Laut Sehat','apoteker.apoteklautsehat@meyahealth.test','081220000001',NULL,1,1,NULL,NULL,'customer','APT0001','2026-08-28 21:38:19','$2y$12$/WM5Qlm964x7nujlK2oaxOs0XG/5ZhNlp7dFlY3YCIEFs749r07oO',NULL,'2026-08-28 21:38:19','2026-08-28 21:38:19'),(15,'Apt. Demo Apotek Bumi Medika','apoteker.apotekbumimedika@meyahealth.test','081220000002',NULL,1,1,NULL,NULL,'customer','APT0002','2026-08-28 21:38:19','$2y$12$.DYgmPlU7A5UZ2qWTPrVc.RmYpm/DztzMTgt6QlHGQWnZ6O7ANWcy',NULL,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(16,'Apt. Demo Apotek Nusantara Farma','apoteker.apoteknusantarafarma@meyahealth.test','081220000003',NULL,1,1,NULL,NULL,'customer','APT0003','2026-08-28 21:38:20','$2y$12$0nAyp/J6SQYym4oL7TPSY.GQg904ZhljxlKhACKFn7dkH0F/DeMaG',NULL,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(17,'Apt. Demo Klinik Farma Medika','apoteker.klinikfarmamedika@meyahealth.test','081220000004',NULL,1,1,NULL,NULL,'customer','APT0004','2026-08-28 21:38:20','$2y$12$BFUc4maEOVrGkp/ZYo9W2ecPaL4.Q1lfxfEL6DI3N9ZGxe3Cj97oG',NULL,'2026-08-28 21:38:20','2026-08-28 21:38:20'),(18,'Apt. Demo Apotek Srikandi Care','apoteker.apoteksrikandicare@meyahealth.test','081220000005',NULL,1,1,NULL,NULL,'customer','APT0005','2026-08-28 21:38:20','$2y$12$sGOch871wYJYp80785uEBe7U6zG6Z9h0qZpOpAGLX464.OsI6jNbe',NULL,'2026-08-28 21:38:20','2026-08-28 21:38:20');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
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 */;

/*!40000 ALTER TABLE `withdrawal_requests` DISABLE KEYS */;
/*!40000 ALTER TABLE `withdrawal_requests` ENABLE KEYS */;
/*!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 */;