CREATE TABLE IF NOT EXISTS `customer_notes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int(10) unsigned NOT NULL,
  `admin_id` int(10) unsigned NOT NULL COMMENT 'کدام ادمین این یادداشت را نوشته',
  `note` text NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `deleted_at` datetime NULL DEFAULT NULL COMMENT 'soft delete',
  PRIMARY KEY (`id`),
  KEY `idx_customer_id` (`customer_id`, `created_at`),
  KEY `idx_admin_id` (`admin_id`),
  CONSTRAINT `fk_customer_notes_customer` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_customer_notes_admin` FOREIGN KEY (`admin_id`) REFERENCES `admin_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
