-- EcomDrive Multi Business schema | MySQL 8.0.16+

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS=0;

CREATE TABLE IF NOT EXISTS `businesses` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(191) NULL,
  `slug` VARCHAR(191) NULL,
  `currency_code` VARCHAR(191) NULL,
  `timezone` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_businesses_status_id` (`status_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `business_profiles` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `logo` VARCHAR(191) NULL,
  `contact` VARCHAR(191) NULL,
  `address` TEXT NULL,
  `tax_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_business_profiles_business_id` (`business_id`),
  KEY `idx_business_profiles_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `business_settings` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `group_key` VARCHAR(191) NULL,
  `key` VARCHAR(191) NULL,
  `value_json` JSON NULL,
  `value_type` VARCHAR(191) NULL,
  `is_public` TINYINT(1) NULL DEFAULT 0,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_business_settings_business_id` (`business_id`),
  KEY `idx_business_settings_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `branches` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `code` VARCHAR(191) NULL,
  `name` VARCHAR(191) NULL,
  `address` TEXT NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_branches_business_id` (`business_id`),
  KEY `idx_branches_status_id` (`status_id`),
  KEY `idx_branches_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `warehouses` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `branch_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_warehouses_business_id` (`business_id`),
  KEY `idx_warehouses_branch_id` (`branch_id`),
  KEY `idx_warehouses_status_id` (`status_id`),
  KEY `idx_warehouses_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `business_memberships` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `user_id` BIGINT UNSIGNED NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_business_memberships_business_id` (`business_id`),
  KEY `idx_business_memberships_user_id` (`user_id`),
  KEY `idx_business_memberships_status_id` (`status_id`),
  KEY `idx_business_memberships_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `users` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(191) NULL,
  `email` VARCHAR(191) NULL,
  `phone` VARCHAR(191) NULL,
  `password` TEXT NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_users_status_id` (`status_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `roles` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_roles_business_id` (`business_id`),
  KEY `idx_roles_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `permissions` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `code` VARCHAR(191) NULL,
  `module` VARCHAR(191) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `role_permissions` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `role_id` BIGINT UNSIGNED NULL,
  `permission_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_role_permissions_business_id` (`business_id`),
  KEY `idx_role_permissions_role_id` (`role_id`),
  KEY `idx_role_permissions_permission_id` (`permission_id`),
  KEY `idx_role_permissions_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `user_roles` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` BIGINT UNSIGNED NULL,
  `role_id` BIGINT UNSIGNED NULL,
  `business_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_user_roles_user_id` (`user_id`),
  KEY `idx_user_roles_role_id` (`role_id`),
  KEY `idx_user_roles_business_id` (`business_id`),
  KEY `idx_user_roles_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `user_branch_access` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `user_id` BIGINT UNSIGNED NULL,
  `branch_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_user_branch_access_business_id` (`business_id`),
  KEY `idx_user_branch_access_user_id` (`user_id`),
  KEY `idx_user_branch_access_branch_id` (`branch_id`),
  KEY `idx_user_branch_access_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `user_permissions` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` BIGINT UNSIGNED NULL,
  `permission_id` BIGINT UNSIGNED NULL,
  `business_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_user_permissions_user_id` (`user_id`),
  KEY `idx_user_permissions_permission_id` (`permission_id`),
  KEY `idx_user_permissions_business_id` (`business_id`),
  KEY `idx_user_permissions_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `modules` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `code` VARCHAR(191) NULL,
  `name` VARCHAR(191) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `navigation_items` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `module_id` BIGINT UNSIGNED NULL,
  `parent_id` BIGINT UNSIGNED NULL,
  `route_key` VARCHAR(191) NULL,
  `label` VARCHAR(191) NULL,
  `icon` VARCHAR(191) NULL,
  `sort_order` BIGINT NULL,
  `is_visible` TINYINT(1) NULL DEFAULT 0,
  `permission_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_navigation_items_business_id` (`business_id`),
  KEY `idx_navigation_items_module_id` (`module_id`),
  KEY `idx_navigation_items_permission_id` (`permission_id`),
  KEY `idx_navigation_items_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `feature_flags` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `code` VARCHAR(191) NULL,
  `is_enabled` TINYINT(1) NULL DEFAULT 0,
  `config_json` JSON NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_feature_flags_business_id` (`business_id`),
  KEY `idx_feature_flags_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `integration_connections` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `provider` VARCHAR(191) NULL,
  `account_ref` VARCHAR(191) NULL,
  `encrypted_credentials` JSON NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `connected_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_integration_connections_business_id` (`business_id`),
  KEY `idx_integration_connections_status_id` (`status_id`),
  KEY `idx_integration_connections_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `webhook_events` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `connection_id` BIGINT UNSIGNED NULL,
  `event_key` VARCHAR(191) NULL,
  `payload_json` JSON NULL,
  `processing_status_id` BIGINT UNSIGNED NULL,
  `received_at` DATETIME NULL,
  `processed_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_webhook_events_business_id` (`business_id`),
  KEY `idx_webhook_events_connection_id` (`connection_id`),
  KEY `idx_webhook_events_processing_status_id` (`processing_status_id`),
  KEY `idx_webhook_events_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `external_id_maps` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `provider` VARCHAR(191) NULL,
  `entity_type` VARCHAR(191) NULL,
  `entity_id` BIGINT UNSIGNED NULL,
  `external_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_external_id_maps_business_id` (`business_id`),
  KEY `idx_external_id_maps_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `statuses` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `module` VARCHAR(191) NULL,
  `code` VARCHAR(191) NULL,
  `label` VARCHAR(191) NULL,
  `color` VARCHAR(191) NULL,
  `sort_order` BIGINT NULL,
  `is_default` TINYINT(1) NULL DEFAULT 0,
  `is_terminal` TINYINT(1) NULL DEFAULT 0,
  `is_active` TINYINT(1) NULL DEFAULT 1,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_statuses_business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `status_transitions` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `module` VARCHAR(191) NULL,
  `from_status_id` BIGINT UNSIGNED NULL,
  `to_status_id` BIGINT UNSIGNED NULL,
  `permission_id` BIGINT UNSIGNED NULL,
  `requires_reason` TINYINT(1) NULL DEFAULT 0,
  `is_active` TINYINT(1) NULL DEFAULT 1,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_status_transitions_business_id` (`business_id`),
  KEY `idx_status_transitions_from_status_id` (`from_status_id`),
  KEY `idx_status_transitions_to_status_id` (`to_status_id`),
  KEY `idx_status_transitions_permission_id` (`permission_id`),
  KEY `idx_status_transitions_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `status_history` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `entity_type` VARCHAR(191) NULL,
  `entity_id` BIGINT UNSIGNED NULL,
  `from_status_id` BIGINT UNSIGNED NULL,
  `to_status_id` BIGINT UNSIGNED NULL,
  `changed_by` VARCHAR(191) NULL,
  `reason` TEXT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_status_history_business_id` (`business_id`),
  KEY `idx_status_history_from_status_id` (`from_status_id`),
  KEY `idx_status_history_to_status_id` (`to_status_id`),
  KEY `idx_status_history_changed_by` (`changed_by`),
  KEY `idx_status_history_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `audit_logs` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `actor_id` BIGINT UNSIGNED NULL,
  `entity_type` VARCHAR(191) NULL,
  `entity_id` BIGINT UNSIGNED NULL,
  `action` VARCHAR(191) NULL,
  `before_json` JSON NULL,
  `after_json` JSON NULL,
  `ip_address` VARCHAR(191) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_audit_logs_business_id` (`business_id`),
  KEY `idx_audit_logs_actor_id` (`actor_id`),
  KEY `idx_audit_logs_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `deletion_logs` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `entity_type` VARCHAR(191) NULL,
  `entity_id` BIGINT UNSIGNED NULL,
  `deleted_by` VARCHAR(191) NULL,
  `reason` TEXT NULL,
  `snapshot_json` JSON NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_deletion_logs_business_id` (`business_id`),
  KEY `idx_deletion_logs_deleted_by` (`deleted_by`),
  KEY `idx_deletion_logs_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `media_files` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `storage_disk` VARCHAR(191) NULL,
  `path` VARCHAR(191) NULL,
  `mime_type` VARCHAR(191) NULL,
  `size_bytes` BIGINT NULL,
  `uploaded_by` VARCHAR(191) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_media_files_business_id` (`business_id`),
  KEY `idx_media_files_uploaded_by` (`uploaded_by`),
  KEY `idx_media_files_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `media_links` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `media_file_id` BIGINT UNSIGNED NULL,
  `entity_type` VARCHAR(191) NULL,
  `entity_id` BIGINT UNSIGNED NULL,
  `purpose` VARCHAR(191) NULL,
  `sort_order` BIGINT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_media_links_business_id` (`business_id`),
  KEY `idx_media_links_media_file_id` (`media_file_id`),
  KEY `idx_media_links_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `notifications` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `user_id` BIGINT UNSIGNED NULL,
  `payload_json` JSON NULL,
  `read_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_notifications_business_id` (`business_id`),
  KEY `idx_notifications_user_id` (`user_id`),
  KEY `idx_notifications_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `customers` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `code` VARCHAR(191) NULL,
  `name` VARCHAR(191) NULL,
  `phone` VARCHAR(191) NULL,
  `email` VARCHAR(191) NULL,
  `address` TEXT NULL,
  `city` VARCHAR(191) NULL,
  `district` VARCHAR(191) NULL,
  `source_id` BIGINT UNSIGNED NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `assigned_user_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_customers_business_id` (`business_id`),
  KEY `idx_customers_source_id` (`source_id`),
  KEY `idx_customers_status_id` (`status_id`),
  KEY `idx_customers_assigned_user_id` (`assigned_user_id`),
  KEY `idx_customers_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `customer_addresses` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `customer_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `phone` VARCHAR(191) NULL,
  `address` TEXT NULL,
  `area` VARCHAR(191) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_customer_addresses_business_id` (`business_id`),
  KEY `idx_customer_addresses_customer_id` (`customer_id`),
  KEY `idx_customer_addresses_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `customer_contacts` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `customer_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `phone` VARCHAR(191) NULL,
  `relationship` VARCHAR(191) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_customer_contacts_business_id` (`business_id`),
  KEY `idx_customer_contacts_customer_id` (`customer_id`),
  KEY `idx_customer_contacts_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `customer_segments` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `rule_json` JSON NULL,
  `is_dynamic` TINYINT(1) NULL DEFAULT 0,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_customer_segments_business_id` (`business_id`),
  KEY `idx_customer_segments_status_id` (`status_id`),
  KEY `idx_customer_segments_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `customer_segment_members` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `segment_id` BIGINT UNSIGNED NULL,
  `customer_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_customer_segment_members_business_id` (`business_id`),
  KEY `idx_customer_segment_members_segment_id` (`segment_id`),
  KEY `idx_customer_segment_members_customer_id` (`customer_id`),
  KEY `idx_customer_segment_members_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `customer_tags` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_customer_tags_business_id` (`business_id`),
  KEY `idx_customer_tags_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `customer_tag_links` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `customer_id` BIGINT UNSIGNED NULL,
  `tag_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_customer_tag_links_business_id` (`business_id`),
  KEY `idx_customer_tag_links_customer_id` (`customer_id`),
  KEY `idx_customer_tag_links_tag_id` (`tag_id`),
  KEY `idx_customer_tag_links_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `customer_import_batches` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `file_id` BIGINT UNSIGNED NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_by` VARCHAR(191) NULL,
  `processed_rows` BIGINT NULL,
  `error_rows` BIGINT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_customer_import_batches_business_id` (`business_id`),
  KEY `idx_customer_import_batches_file_id` (`file_id`),
  KEY `idx_customer_import_batches_status_id` (`status_id`),
  KEY `idx_customer_import_batches_created_by` (`created_by`),
  KEY `idx_customer_import_batches_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `leads` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `customer_id` BIGINT UNSIGNED NULL,
  `source_id` BIGINT UNSIGNED NULL,
  `owner_id` BIGINT UNSIGNED NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `notes` TEXT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_leads_business_id` (`business_id`),
  KEY `idx_leads_customer_id` (`customer_id`),
  KEY `idx_leads_source_id` (`source_id`),
  KEY `idx_leads_owner_id` (`owner_id`),
  KEY `idx_leads_status_id` (`status_id`),
  KEY `idx_leads_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `customer_interactions` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `customer_id` BIGINT UNSIGNED NULL,
  `order_id` BIGINT UNSIGNED NULL,
  `user_id` BIGINT UNSIGNED NULL,
  `channel` VARCHAR(191) NULL,
  `notes` TEXT NULL,
  `occurred_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_customer_interactions_business_id` (`business_id`),
  KEY `idx_customer_interactions_customer_id` (`customer_id`),
  KEY `idx_customer_interactions_order_id` (`order_id`),
  KEY `idx_customer_interactions_user_id` (`user_id`),
  KEY `idx_customer_interactions_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `followups` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `customer_id` BIGINT UNSIGNED NULL,
  `order_id` BIGINT UNSIGNED NULL,
  `assigned_to` VARCHAR(191) NULL,
  `due_at` DATETIME NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `outcome` TEXT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_followups_business_id` (`business_id`),
  KEY `idx_followups_customer_id` (`customer_id`),
  KEY `idx_followups_order_id` (`order_id`),
  KEY `idx_followups_assigned_to` (`assigned_to`),
  KEY `idx_followups_status_id` (`status_id`),
  KEY `idx_followups_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `tasks` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `title` VARCHAR(191) NULL,
  `description` TEXT NULL,
  `assigned_to` VARCHAR(191) NULL,
  `created_by` VARCHAR(191) NULL,
  `related_type` VARCHAR(191) NULL,
  `related_id` BIGINT UNSIGNED NULL,
  `due_at` DATETIME NULL,
  `priority` BIGINT NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_tasks_business_id` (`business_id`),
  KEY `idx_tasks_assigned_to` (`assigned_to`),
  KEY `idx_tasks_created_by` (`created_by`),
  KEY `idx_tasks_status_id` (`status_id`),
  KEY `idx_tasks_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `task_comments` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `task_id` BIGINT UNSIGNED NULL,
  `user_id` BIGINT UNSIGNED NULL,
  `body` TEXT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_task_comments_business_id` (`business_id`),
  KEY `idx_task_comments_task_id` (`task_id`),
  KEY `idx_task_comments_user_id` (`user_id`),
  KEY `idx_task_comments_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `categories` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `parent_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `slug` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_categories_business_id` (`business_id`),
  KEY `idx_categories_status_id` (`status_id`),
  KEY `idx_categories_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `brands` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_brands_business_id` (`business_id`),
  KEY `idx_brands_status_id` (`status_id`),
  KEY `idx_brands_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `units` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `symbol` VARCHAR(191) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_units_business_id` (`business_id`),
  KEY `idx_units_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `products` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `sku` VARCHAR(191) NULL,
  `name` VARCHAR(191) NULL,
  `category_id` BIGINT UNSIGNED NULL,
  `brand_id` BIGINT UNSIGNED NULL,
  `unit_id` BIGINT UNSIGNED NULL,
  `description` TEXT NULL,
  `product_type` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `track_stock` TINYINT(1) NULL DEFAULT 0,
  `low_stock_threshold` DECIMAL(18,3) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_products_business_id` (`business_id`),
  KEY `idx_products_category_id` (`category_id`),
  KEY `idx_products_brand_id` (`brand_id`),
  KEY `idx_products_unit_id` (`unit_id`),
  KEY `idx_products_status_id` (`status_id`),
  KEY `idx_products_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `product_variants` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `product_id` BIGINT UNSIGNED NULL,
  `sku` VARCHAR(191) NULL,
  `barcode` VARCHAR(191) NULL,
  `attributes_json` JSON NULL,
  `cost_price` DECIMAL(18,2) NULL,
  `sale_price` DECIMAL(18,2) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_product_variants_business_id` (`business_id`),
  KEY `idx_product_variants_product_id` (`product_id`),
  KEY `idx_product_variants_status_id` (`status_id`),
  KEY `idx_product_variants_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `product_images` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `product_id` BIGINT UNSIGNED NULL,
  `variant_id` BIGINT UNSIGNED NULL,
  `media_file_id` BIGINT UNSIGNED NULL,
  `sort_order` BIGINT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_product_images_business_id` (`business_id`),
  KEY `idx_product_images_product_id` (`product_id`),
  KEY `idx_product_images_variant_id` (`variant_id`),
  KEY `idx_product_images_media_file_id` (`media_file_id`),
  KEY `idx_product_images_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `price_lists` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_price_lists_business_id` (`business_id`),
  KEY `idx_price_lists_status_id` (`status_id`),
  KEY `idx_price_lists_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `price_list_items` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `price_list_id` BIGINT UNSIGNED NULL,
  `variant_id` BIGINT UNSIGNED NULL,
  `price` DECIMAL(18,2) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_price_list_items_business_id` (`business_id`),
  KEY `idx_price_list_items_price_list_id` (`price_list_id`),
  KEY `idx_price_list_items_variant_id` (`variant_id`),
  KEY `idx_price_list_items_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `inventory_balances` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `warehouse_id` BIGINT UNSIGNED NULL,
  `variant_id` BIGINT UNSIGNED NULL,
  `on_hand` DECIMAL(18,3) NULL,
  `reserved` DECIMAL(18,3) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_inventory_balances_business_id` (`business_id`),
  KEY `idx_inventory_balances_warehouse_id` (`warehouse_id`),
  KEY `idx_inventory_balances_variant_id` (`variant_id`),
  KEY `idx_inventory_balances_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `inventory_movements` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `warehouse_id` BIGINT UNSIGNED NULL,
  `variant_id` BIGINT UNSIGNED NULL,
  `movement_type` VARCHAR(191) NULL,
  `quantity_delta` DECIMAL(18,3) NULL,
  `unit_cost` DECIMAL(18,2) NULL,
  `reference_type` VARCHAR(191) NULL,
  `reference_id` BIGINT UNSIGNED NULL,
  `performed_by` VARCHAR(191) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_inventory_movements_business_id` (`business_id`),
  KEY `idx_inventory_movements_warehouse_id` (`warehouse_id`),
  KEY `idx_inventory_movements_variant_id` (`variant_id`),
  KEY `idx_inventory_movements_performed_by` (`performed_by`),
  KEY `idx_inventory_movements_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `stock_reservations` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `order_item_id` BIGINT UNSIGNED NULL,
  `warehouse_id` BIGINT UNSIGNED NULL,
  `variant_id` BIGINT UNSIGNED NULL,
  `quantity` DECIMAL(18,3) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_stock_reservations_business_id` (`business_id`),
  KEY `idx_stock_reservations_order_item_id` (`order_item_id`),
  KEY `idx_stock_reservations_warehouse_id` (`warehouse_id`),
  KEY `idx_stock_reservations_variant_id` (`variant_id`),
  KEY `idx_stock_reservations_status_id` (`status_id`),
  KEY `idx_stock_reservations_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `stock_transfers` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `from_warehouse_id` BIGINT UNSIGNED NULL,
  `to_warehouse_id` BIGINT UNSIGNED NULL,
  `reference` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_by` VARCHAR(191) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_stock_transfers_business_id` (`business_id`),
  KEY `idx_stock_transfers_from_warehouse_id` (`from_warehouse_id`),
  KEY `idx_stock_transfers_to_warehouse_id` (`to_warehouse_id`),
  KEY `idx_stock_transfers_status_id` (`status_id`),
  KEY `idx_stock_transfers_created_by` (`created_by`),
  KEY `idx_stock_transfers_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `stock_transfer_items` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `transfer_id` BIGINT UNSIGNED NULL,
  `variant_id` BIGINT UNSIGNED NULL,
  `quantity` DECIMAL(18,3) NULL,
  `received_quantity` DECIMAL(18,3) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_stock_transfer_items_business_id` (`business_id`),
  KEY `idx_stock_transfer_items_transfer_id` (`transfer_id`),
  KEY `idx_stock_transfer_items_variant_id` (`variant_id`),
  KEY `idx_stock_transfer_items_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `stock_adjustments` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `warehouse_id` BIGINT UNSIGNED NULL,
  `reason` TEXT NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_stock_adjustments_business_id` (`business_id`),
  KEY `idx_stock_adjustments_warehouse_id` (`warehouse_id`),
  KEY `idx_stock_adjustments_status_id` (`status_id`),
  KEY `idx_stock_adjustments_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `stock_adjustment_items` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `adjustment_id` BIGINT UNSIGNED NULL,
  `variant_id` BIGINT UNSIGNED NULL,
  `quantity_delta` DECIMAL(18,3) NULL,
  `unit_cost` DECIMAL(18,2) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_stock_adjustment_items_business_id` (`business_id`),
  KEY `idx_stock_adjustment_items_adjustment_id` (`adjustment_id`),
  KEY `idx_stock_adjustment_items_variant_id` (`variant_id`),
  KEY `idx_stock_adjustment_items_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `warranties` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `variant_id` BIGINT UNSIGNED NULL,
  `term_days` BIGINT NULL,
  `terms` TEXT NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_warranties_business_id` (`business_id`),
  KEY `idx_warranties_variant_id` (`variant_id`),
  KEY `idx_warranties_status_id` (`status_id`),
  KEY `idx_warranties_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `warranty_claims` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `customer_id` BIGINT UNSIGNED NULL,
  `order_item_id` BIGINT UNSIGNED NULL,
  `serial_number` VARCHAR(191) NULL,
  `issue` TEXT NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `opened_at` DATETIME NULL,
  `closed_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_warranty_claims_business_id` (`business_id`),
  KEY `idx_warranty_claims_customer_id` (`customer_id`),
  KEY `idx_warranty_claims_order_item_id` (`order_item_id`),
  KEY `idx_warranty_claims_status_id` (`status_id`),
  KEY `idx_warranty_claims_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `warranty_claim_events` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `claim_id` BIGINT UNSIGNED NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `note` TEXT NULL,
  `actor_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_warranty_claim_events_business_id` (`business_id`),
  KEY `idx_warranty_claim_events_claim_id` (`claim_id`),
  KEY `idx_warranty_claim_events_status_id` (`status_id`),
  KEY `idx_warranty_claim_events_actor_id` (`actor_id`),
  KEY `idx_warranty_claim_events_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `suppliers` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `code` VARCHAR(191) NULL,
  `name` VARCHAR(191) NULL,
  `phone` VARCHAR(191) NULL,
  `email` VARCHAR(191) NULL,
  `address` TEXT NULL,
  `opening_balance` DECIMAL(18,2) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_suppliers_business_id` (`business_id`),
  KEY `idx_suppliers_status_id` (`status_id`),
  KEY `idx_suppliers_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `supplier_contacts` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `supplier_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `phone` VARCHAR(191) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_supplier_contacts_business_id` (`business_id`),
  KEY `idx_supplier_contacts_supplier_id` (`supplier_id`),
  KEY `idx_supplier_contacts_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `quotations` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `supplier_id` BIGINT UNSIGNED NULL,
  `quote_no` VARCHAR(191) NULL,
  `requested_at` DATETIME NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_quotations_business_id` (`business_id`),
  KEY `idx_quotations_supplier_id` (`supplier_id`),
  KEY `idx_quotations_status_id` (`status_id`),
  KEY `idx_quotations_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `quotation_items` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `quotation_id` BIGINT UNSIGNED NULL,
  `variant_id` BIGINT UNSIGNED NULL,
  `quantity` DECIMAL(18,3) NULL,
  `quoted_price` DECIMAL(18,2) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_quotation_items_business_id` (`business_id`),
  KEY `idx_quotation_items_quotation_id` (`quotation_id`),
  KEY `idx_quotation_items_variant_id` (`variant_id`),
  KEY `idx_quotation_items_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `purchases` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `supplier_id` BIGINT UNSIGNED NULL,
  `branch_id` BIGINT UNSIGNED NULL,
  `warehouse_id` BIGINT UNSIGNED NULL,
  `reference_no` VARCHAR(191) NULL,
  `purchased_at` DATETIME NULL,
  `subtotal` DECIMAL(18,2) NULL,
  `discount` DECIMAL(18,2) NULL,
  `tax` DECIMAL(18,2) NULL,
  `shipping` DECIMAL(18,2) NULL,
  `total` DECIMAL(18,2) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_by` VARCHAR(191) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_purchases_business_id` (`business_id`),
  KEY `idx_purchases_supplier_id` (`supplier_id`),
  KEY `idx_purchases_branch_id` (`branch_id`),
  KEY `idx_purchases_warehouse_id` (`warehouse_id`),
  KEY `idx_purchases_status_id` (`status_id`),
  KEY `idx_purchases_created_by` (`created_by`),
  KEY `idx_purchases_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `purchase_items` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `purchase_id` BIGINT UNSIGNED NULL,
  `variant_id` BIGINT UNSIGNED NULL,
  `quantity` DECIMAL(18,3) NULL,
  `unit_cost` DECIMAL(18,2) NULL,
  `discount` DECIMAL(18,2) NULL,
  `tax` DECIMAL(18,2) NULL,
  `line_total` DECIMAL(18,2) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_purchase_items_business_id` (`business_id`),
  KEY `idx_purchase_items_purchase_id` (`purchase_id`),
  KEY `idx_purchase_items_variant_id` (`variant_id`),
  KEY `idx_purchase_items_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `purchase_receipts` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `purchase_id` BIGINT UNSIGNED NULL,
  `warehouse_id` BIGINT UNSIGNED NULL,
  `received_by` VARCHAR(191) NULL,
  `received_at` DATETIME NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_purchase_receipts_business_id` (`business_id`),
  KEY `idx_purchase_receipts_purchase_id` (`purchase_id`),
  KEY `idx_purchase_receipts_warehouse_id` (`warehouse_id`),
  KEY `idx_purchase_receipts_received_by` (`received_by`),
  KEY `idx_purchase_receipts_status_id` (`status_id`),
  KEY `idx_purchase_receipts_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `purchase_receipt_items` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `receipt_id` BIGINT UNSIGNED NULL,
  `purchase_item_id` BIGINT UNSIGNED NULL,
  `received_qty` DECIMAL(18,3) NULL,
  `rejected_qty` DECIMAL(18,3) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_purchase_receipt_items_business_id` (`business_id`),
  KEY `idx_purchase_receipt_items_receipt_id` (`receipt_id`),
  KEY `idx_purchase_receipt_items_purchase_item_id` (`purchase_item_id`),
  KEY `idx_purchase_receipt_items_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `purchase_returns` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `purchase_id` BIGINT UNSIGNED NULL,
  `supplier_id` BIGINT UNSIGNED NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `total` DECIMAL(18,2) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_purchase_returns_business_id` (`business_id`),
  KEY `idx_purchase_returns_purchase_id` (`purchase_id`),
  KEY `idx_purchase_returns_supplier_id` (`supplier_id`),
  KEY `idx_purchase_returns_status_id` (`status_id`),
  KEY `idx_purchase_returns_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `purchase_return_items` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `return_id` BIGINT UNSIGNED NULL,
  `purchase_item_id` BIGINT UNSIGNED NULL,
  `quantity` DECIMAL(18,3) NULL,
  `amount` DECIMAL(18,2) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_purchase_return_items_business_id` (`business_id`),
  KEY `idx_purchase_return_items_return_id` (`return_id`),
  KEY `idx_purchase_return_items_purchase_item_id` (`purchase_item_id`),
  KEY `idx_purchase_return_items_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `supplier_ledger_entries` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `supplier_id` BIGINT UNSIGNED NULL,
  `source_type` VARCHAR(191) NULL,
  `source_id` BIGINT UNSIGNED NULL,
  `debit` DECIMAL(18,2) NULL,
  `credit` DECIMAL(18,2) NULL,
  `occurred_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_supplier_ledger_entries_business_id` (`business_id`),
  KEY `idx_supplier_ledger_entries_supplier_id` (`supplier_id`),
  KEY `idx_supplier_ledger_entries_source_id` (`source_id`),
  KEY `idx_supplier_ledger_entries_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `order_sources` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `code` VARCHAR(191) NULL,
  `name` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_order_sources_business_id` (`business_id`),
  KEY `idx_order_sources_status_id` (`status_id`),
  KEY `idx_order_sources_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `sales_channels` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `code` VARCHAR(191) NULL,
  `name` VARCHAR(191) NULL,
  `connection_id` BIGINT UNSIGNED NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_sales_channels_business_id` (`business_id`),
  KEY `idx_sales_channels_connection_id` (`connection_id`),
  KEY `idx_sales_channels_status_id` (`status_id`),
  KEY `idx_sales_channels_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `orders` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `order_no` VARCHAR(191) NULL,
  `customer_id` BIGINT UNSIGNED NULL,
  `branch_id` BIGINT UNSIGNED NULL,
  `warehouse_id` BIGINT UNSIGNED NULL,
  `source_id` BIGINT UNSIGNED NULL,
  `channel_id` BIGINT UNSIGNED NULL,
  `assigned_to` VARCHAR(191) NULL,
  `order_status_id` BIGINT UNSIGNED NULL,
  `payment_status_id` BIGINT UNSIGNED NULL,
  `fulfillment_status_id` BIGINT UNSIGNED NULL,
  `ordered_at` DATETIME NULL,
  `subtotal` DECIMAL(18,2) NULL,
  `discount` DECIMAL(18,2) NULL,
  `shipping_fee` DECIMAL(18,2) NULL,
  `tax` DECIMAL(18,2) NULL,
  `total` DECIMAL(18,2) NULL,
  `customer_name_snapshot` VARCHAR(191) NULL,
  `phone_snapshot` VARCHAR(191) NULL,
  `address_snapshot` VARCHAR(191) NULL,
  `notes` TEXT NULL,
  `created_by` VARCHAR(191) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_orders_business_id` (`business_id`),
  KEY `idx_orders_customer_id` (`customer_id`),
  KEY `idx_orders_branch_id` (`branch_id`),
  KEY `idx_orders_warehouse_id` (`warehouse_id`),
  KEY `idx_orders_source_id` (`source_id`),
  KEY `idx_orders_channel_id` (`channel_id`),
  KEY `idx_orders_assigned_to` (`assigned_to`),
  KEY `idx_orders_order_status_id` (`order_status_id`),
  KEY `idx_orders_payment_status_id` (`payment_status_id`),
  KEY `idx_orders_fulfillment_status_i` (`fulfillment_status_id`),
  KEY `idx_orders_created_by` (`created_by`),
  KEY `idx_orders_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `order_items` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `order_id` BIGINT UNSIGNED NULL,
  `variant_id` BIGINT UNSIGNED NULL,
  `product_name_snapshot` VARCHAR(191) NULL,
  `sku_snapshot` VARCHAR(191) NULL,
  `quantity` DECIMAL(18,3) NULL,
  `unit_price` DECIMAL(18,2) NULL,
  `discount` DECIMAL(18,2) NULL,
  `tax` DECIMAL(18,2) NULL,
  `line_total` DECIMAL(18,2) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_order_items_business_id` (`business_id`),
  KEY `idx_order_items_order_id` (`order_id`),
  KEY `idx_order_items_variant_id` (`variant_id`),
  KEY `idx_order_items_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `order_discounts` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `order_id` BIGINT UNSIGNED NULL,
  `discount_rule_id` BIGINT UNSIGNED NULL,
  `title` VARCHAR(191) NULL,
  `discount_type` VARCHAR(191) NULL,
  `discount_value` DECIMAL(18,2) NULL,
  `amount` DECIMAL(18,2) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_order_discounts_business_id` (`business_id`),
  KEY `idx_order_discounts_order_id` (`order_id`),
  KEY `idx_order_discounts_discount_rule_id` (`discount_rule_id`),
  KEY `idx_order_discounts_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `discount_rules` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `code` VARCHAR(191) NULL,
  `kind` VARCHAR(191) NULL,
  `value` DECIMAL(18,2) NULL,
  `starts_at` DATETIME NULL,
  `ends_at` DATETIME NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `conditions_json` JSON NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_discount_rules_business_id` (`business_id`),
  KEY `idx_discount_rules_status_id` (`status_id`),
  KEY `idx_discount_rules_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `order_notes` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `order_id` BIGINT UNSIGNED NULL,
  `user_id` BIGINT UNSIGNED NULL,
  `note` TEXT NULL,
  `is_internal` TINYINT(1) NULL DEFAULT 0,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_order_notes_business_id` (`business_id`),
  KEY `idx_order_notes_order_id` (`order_id`),
  KEY `idx_order_notes_user_id` (`user_id`),
  KEY `idx_order_notes_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `order_assignments` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `order_id` BIGINT UNSIGNED NULL,
  `user_id` BIGINT UNSIGNED NULL,
  `assigned_by` VARCHAR(191) NULL,
  `assigned_at` DATETIME NULL,
  `unassigned_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_order_assignments_business_id` (`business_id`),
  KEY `idx_order_assignments_order_id` (`order_id`),
  KEY `idx_order_assignments_user_id` (`user_id`),
  KEY `idx_order_assignments_assigned_by` (`assigned_by`),
  KEY `idx_order_assignments_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `order_edits` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `order_id` BIGINT UNSIGNED NULL,
  `actor_id` BIGINT UNSIGNED NULL,
  `reason` TEXT NULL,
  `before_json` JSON NULL,
  `after_json` JSON NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_order_edits_business_id` (`business_id`),
  KEY `idx_order_edits_order_id` (`order_id`),
  KEY `idx_order_edits_actor_id` (`actor_id`),
  KEY `idx_order_edits_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `order_returns` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `order_id` BIGINT UNSIGNED NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `refund_amount` DECIMAL(18,2) NULL,
  `reason` TEXT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_order_returns_business_id` (`business_id`),
  KEY `idx_order_returns_order_id` (`order_id`),
  KEY `idx_order_returns_status_id` (`status_id`),
  KEY `idx_order_returns_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `order_return_items` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `return_id` BIGINT UNSIGNED NULL,
  `order_item_id` BIGINT UNSIGNED NULL,
  `quantity` DECIMAL(18,3) NULL,
  `amount` DECIMAL(18,2) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_order_return_items_business_id` (`business_id`),
  KEY `idx_order_return_items_return_id` (`return_id`),
  KEY `idx_order_return_items_order_item_id` (`order_item_id`),
  KEY `idx_order_return_items_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `preorder_requests` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `customer_id` BIGINT UNSIGNED NULL,
  `variant_id` BIGINT UNSIGNED NULL,
  `quantity` DECIMAL(18,3) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `expected_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_preorder_requests_business_id` (`business_id`),
  KEY `idx_preorder_requests_customer_id` (`customer_id`),
  KEY `idx_preorder_requests_variant_id` (`variant_id`),
  KEY `idx_preorder_requests_status_id` (`status_id`),
  KEY `idx_preorder_requests_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `website_order_imports` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `channel_id` BIGINT UNSIGNED NULL,
  `external_order_id` BIGINT UNSIGNED NULL,
  `order_id` BIGINT UNSIGNED NULL,
  `payload_json` JSON NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_website_order_imports_business_id` (`business_id`),
  KEY `idx_website_order_imports_channel_id` (`channel_id`),
  KEY `idx_website_order_imports_order_id` (`order_id`),
  KEY `idx_website_order_imports_status_id` (`status_id`),
  KEY `idx_website_order_imports_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `couriers` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `code` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_couriers_business_id` (`business_id`),
  KEY `idx_couriers_status_id` (`status_id`),
  KEY `idx_couriers_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `courier_accounts` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `courier_id` BIGINT UNSIGNED NULL,
  `merchant_ref` VARCHAR(191) NULL,
  `encrypted_token` JSON NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_courier_accounts_business_id` (`business_id`),
  KEY `idx_courier_accounts_courier_id` (`courier_id`),
  KEY `idx_courier_accounts_status_id` (`status_id`),
  KEY `idx_courier_accounts_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `shipments` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `order_id` BIGINT UNSIGNED NULL,
  `courier_id` BIGINT UNSIGNED NULL,
  `courier_account_id` BIGINT UNSIGNED NULL,
  `tracking_no` VARCHAR(191) NULL,
  `external_consignment_id` BIGINT UNSIGNED NULL,
  `delivery_status_id` BIGINT UNSIGNED NULL,
  `cod_amount` DECIMAL(18,2) NULL,
  `delivery_charge` DECIMAL(18,2) NULL,
  `dispatched_at` DATETIME NULL,
  `delivered_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_shipments_business_id` (`business_id`),
  KEY `idx_shipments_order_id` (`order_id`),
  KEY `idx_shipments_courier_id` (`courier_id`),
  KEY `idx_shipments_courier_account_id` (`courier_account_id`),
  KEY `idx_shipments_delivery_status_id` (`delivery_status_id`),
  KEY `idx_shipments_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `shipment_events` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `shipment_id` BIGINT UNSIGNED NULL,
  `event_code` VARCHAR(191) NULL,
  `description` TEXT NULL,
  `event_at` DATETIME NULL,
  `raw_json` JSON NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_shipment_events_business_id` (`business_id`),
  KEY `idx_shipment_events_shipment_id` (`shipment_id`),
  KEY `idx_shipment_events_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `delivery_methods` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `fee` DECIMAL(18,2) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_delivery_methods_business_id` (`business_id`),
  KEY `idx_delivery_methods_status_id` (`status_id`),
  KEY `idx_delivery_methods_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `delivery_attempts` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `shipment_id` BIGINT UNSIGNED NULL,
  `attempt_at` DATETIME NULL,
  `outcome` TEXT NULL,
  `note` TEXT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_delivery_attempts_business_id` (`business_id`),
  KEY `idx_delivery_attempts_shipment_id` (`shipment_id`),
  KEY `idx_delivery_attempts_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `courier_settlements` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `courier_id` BIGINT UNSIGNED NULL,
  `reference` VARCHAR(191) NULL,
  `period_start` DATETIME NULL,
  `period_end` DATETIME NULL,
  `total_cod` DECIMAL(18,2) NULL,
  `total_fees` DECIMAL(18,2) NULL,
  `net_receivable` DECIMAL(18,2) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_courier_settlements_business_id` (`business_id`),
  KEY `idx_courier_settlements_courier_id` (`courier_id`),
  KEY `idx_courier_settlements_status_id` (`status_id`),
  KEY `idx_courier_settlements_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `courier_settlement_lines` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `settlement_id` BIGINT UNSIGNED NULL,
  `shipment_id` BIGINT UNSIGNED NULL,
  `cod_collected` DECIMAL(18,2) NULL,
  `fees` DECIMAL(18,2) NULL,
  `adjustment` DECIMAL(18,2) NULL,
  `net_amount` DECIMAL(18,2) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_courier_settlement_lines_business_id` (`business_id`),
  KEY `idx_courier_settlement_lines_settlement_id` (`settlement_id`),
  KEY `idx_courier_settlement_lines_shipment_id` (`shipment_id`),
  KEY `idx_courier_settlement_lines_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `scan_events` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `order_id` BIGINT UNSIGNED NULL,
  `shipment_id` BIGINT UNSIGNED NULL,
  `scanned_by` VARCHAR(191) NULL,
  `scan_type` VARCHAR(191) NULL,
  `scanned_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_scan_events_business_id` (`business_id`),
  KEY `idx_scan_events_order_id` (`order_id`),
  KEY `idx_scan_events_shipment_id` (`shipment_id`),
  KEY `idx_scan_events_scanned_by` (`scanned_by`),
  KEY `idx_scan_events_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `ip_block_rules` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `ip_or_cidr` TEXT NULL,
  `reason` TEXT NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ip_block_rules_business_id` (`business_id`),
  KEY `idx_ip_block_rules_status_id` (`status_id`),
  KEY `idx_ip_block_rules_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `accounts` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `code` VARCHAR(191) NULL,
  `name` VARCHAR(191) NULL,
  `parent_id` BIGINT UNSIGNED NULL,
  `is_active` TINYINT(1) NULL DEFAULT 1,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_accounts_business_id` (`business_id`),
  KEY `idx_accounts_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `financial_transactions` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `reference_no` VARCHAR(191) NULL,
  `transaction_date` DATETIME NULL,
  `description` TEXT NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `posted_by` VARCHAR(191) NULL,
  `posted_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_financial_transactions_business_id` (`business_id`),
  KEY `idx_financial_transactions_status_id` (`status_id`),
  KEY `idx_financial_transactions_posted_by` (`posted_by`),
  KEY `idx_financial_transactions_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `financial_transaction_lines` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `transaction_id` BIGINT UNSIGNED NULL,
  `account_id` BIGINT UNSIGNED NULL,
  `branch_id` BIGINT UNSIGNED NULL,
  `debit` DECIMAL(18,2) NULL,
  `credit` DECIMAL(18,2) NULL,
  `reference_type` VARCHAR(191) NULL,
  `reference_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_financial_transaction_lin_business_id` (`business_id`),
  KEY `idx_financial_transaction_lin_transaction_id` (`transaction_id`),
  KEY `idx_financial_transaction_lin_account_id` (`account_id`),
  KEY `idx_financial_transaction_lin_branch_id` (`branch_id`),
  KEY `idx_financial_transaction_lines_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `payment_methods` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `provider` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_payment_methods_business_id` (`business_id`),
  KEY `idx_payment_methods_status_id` (`status_id`),
  KEY `idx_payment_methods_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `payments` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `direction` VARCHAR(191) NULL,
  `party_type` VARCHAR(191) NULL,
  `party_id` BIGINT UNSIGNED NULL,
  `order_id` BIGINT UNSIGNED NULL,
  `purchase_id` BIGINT UNSIGNED NULL,
  `method_id` BIGINT UNSIGNED NULL,
  `account_id` BIGINT UNSIGNED NULL,
  `amount` DECIMAL(18,2) NULL,
  `reference` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `paid_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_payments_business_id` (`business_id`),
  KEY `idx_payments_order_id` (`order_id`),
  KEY `idx_payments_purchase_id` (`purchase_id`),
  KEY `idx_payments_method_id` (`method_id`),
  KEY `idx_payments_account_id` (`account_id`),
  KEY `idx_payments_status_id` (`status_id`),
  KEY `idx_payments_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `payment_allocations` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `payment_id` BIGINT UNSIGNED NULL,
  `document_type` VARCHAR(191) NULL,
  `document_id` BIGINT UNSIGNED NULL,
  `amount` DECIMAL(18,2) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_payment_allocations_business_id` (`business_id`),
  KEY `idx_payment_allocations_payment_id` (`payment_id`),
  KEY `idx_payment_allocations_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `refunds` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `order_return_id` BIGINT UNSIGNED NULL,
  `payment_id` BIGINT UNSIGNED NULL,
  `amount` DECIMAL(18,2) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `processed_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_refunds_business_id` (`business_id`),
  KEY `idx_refunds_order_return_id` (`order_return_id`),
  KEY `idx_refunds_payment_id` (`payment_id`),
  KEY `idx_refunds_status_id` (`status_id`),
  KEY `idx_refunds_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `expense_categories` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `parent_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_expense_categories_business_id` (`business_id`),
  KEY `idx_expense_categories_status_id` (`status_id`),
  KEY `idx_expense_categories_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `expenses` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `category_id` BIGINT UNSIGNED NULL,
  `branch_id` BIGINT UNSIGNED NULL,
  `account_id` BIGINT UNSIGNED NULL,
  `amount` DECIMAL(18,2) NULL,
  `expense_date` DATETIME NULL,
  `description` TEXT NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `approved_by` VARCHAR(191) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_expenses_business_id` (`business_id`),
  KEY `idx_expenses_category_id` (`category_id`),
  KEY `idx_expenses_branch_id` (`branch_id`),
  KEY `idx_expenses_account_id` (`account_id`),
  KEY `idx_expenses_status_id` (`status_id`),
  KEY `idx_expenses_approved_by` (`approved_by`),
  KEY `idx_expenses_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `ad_expenses` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `expense_id` BIGINT UNSIGNED NULL,
  `campaign_id` BIGINT UNSIGNED NULL,
  `platform` VARCHAR(191) NULL,
  `spend_date` VARCHAR(191) NULL,
  `amount` DECIMAL(18,2) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ad_expenses_business_id` (`business_id`),
  KEY `idx_ad_expenses_expense_id` (`expense_id`),
  KEY `idx_ad_expenses_campaign_id` (`campaign_id`),
  KEY `idx_ad_expenses_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `income_records` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `category` VARCHAR(191) NULL,
  `amount` DECIMAL(18,2) NULL,
  `account_id` BIGINT UNSIGNED NULL,
  `received_at` DATETIME NULL,
  `reference_type` VARCHAR(191) NULL,
  `reference_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_income_records_business_id` (`business_id`),
  KEY `idx_income_records_account_id` (`account_id`),
  KEY `idx_income_records_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `assets` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `branch_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `category` VARCHAR(191) NULL,
  `acquired_at` DATETIME NULL,
  `purchase_cost` DECIMAL(18,2) NULL,
  `current_value` DECIMAL(18,2) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_assets_business_id` (`business_id`),
  KEY `idx_assets_branch_id` (`branch_id`),
  KEY `idx_assets_status_id` (`status_id`),
  KEY `idx_assets_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `asset_depreciations` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `asset_id` BIGINT UNSIGNED NULL,
  `period` DATETIME NULL,
  `amount` DECIMAL(18,2) NULL,
  `transaction_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_asset_depreciations_business_id` (`business_id`),
  KEY `idx_asset_depreciations_asset_id` (`asset_id`),
  KEY `idx_asset_depreciations_transaction_id` (`transaction_id`),
  KEY `idx_asset_depreciations_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `ad_accounts` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `provider` VARCHAR(191) NULL,
  `external_account_id` BIGINT UNSIGNED NULL,
  `connection_id` BIGINT UNSIGNED NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ad_accounts_business_id` (`business_id`),
  KEY `idx_ad_accounts_connection_id` (`connection_id`),
  KEY `idx_ad_accounts_status_id` (`status_id`),
  KEY `idx_ad_accounts_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `ad_campaigns` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `ad_account_id` BIGINT UNSIGNED NULL,
  `external_campaign_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `start_at` DATETIME NULL,
  `end_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ad_campaigns_business_id` (`business_id`),
  KEY `idx_ad_campaigns_ad_account_id` (`ad_account_id`),
  KEY `idx_ad_campaigns_status_id` (`status_id`),
  KEY `idx_ad_campaigns_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `ad_sets` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `campaign_id` BIGINT UNSIGNED NULL,
  `external_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ad_sets_business_id` (`business_id`),
  KEY `idx_ad_sets_campaign_id` (`campaign_id`),
  KEY `idx_ad_sets_status_id` (`status_id`),
  KEY `idx_ad_sets_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `ads` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `ad_set_id` BIGINT UNSIGNED NULL,
  `external_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ads_business_id` (`business_id`),
  KEY `idx_ads_ad_set_id` (`ad_set_id`),
  KEY `idx_ads_status_id` (`status_id`),
  KEY `idx_ads_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `ad_daily_metrics` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `ad_id` BIGINT UNSIGNED NULL,
  `metric_date` DATETIME NULL,
  `spend` DECIMAL(18,2) NULL,
  `impressions` BIGINT NULL,
  `clicks` BIGINT NULL,
  `leads` BIGINT NULL,
  `orders` BIGINT NULL,
  `revenue` DECIMAL(18,2) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ad_daily_metrics_business_id` (`business_id`),
  KEY `idx_ad_daily_metrics_ad_id` (`ad_id`),
  KEY `idx_ad_daily_metrics_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `conversations` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `customer_id` BIGINT UNSIGNED NULL,
  `channel_id` BIGINT UNSIGNED NULL,
  `assigned_to` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `last_message_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_conversations_business_id` (`business_id`),
  KEY `idx_conversations_customer_id` (`customer_id`),
  KEY `idx_conversations_channel_id` (`channel_id`),
  KEY `idx_conversations_assigned_to` (`assigned_to`),
  KEY `idx_conversations_status_id` (`status_id`),
  KEY `idx_conversations_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `messages` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `conversation_id` BIGINT UNSIGNED NULL,
  `external_message_id` BIGINT UNSIGNED NULL,
  `direction` VARCHAR(191) NULL,
  `sender_ref` VARCHAR(191) NULL,
  `message_type` VARCHAR(191) NULL,
  `body` TEXT NULL,
  `media_file_id` BIGINT UNSIGNED NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `sent_at` DATETIME NULL,
  `received_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_messages_business_id` (`business_id`),
  KEY `idx_messages_conversation_id` (`conversation_id`),
  KEY `idx_messages_media_file_id` (`media_file_id`),
  KEY `idx_messages_status_id` (`status_id`),
  KEY `idx_messages_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `message_templates` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `channel_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `language` VARCHAR(191) NULL,
  `body` TEXT NULL,
  `approval_status_id` BIGINT UNSIGNED NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_message_templates_business_id` (`business_id`),
  KEY `idx_message_templates_channel_id` (`channel_id`),
  KEY `idx_message_templates_approval_status_id` (`approval_status_id`),
  KEY `idx_message_templates_status_id` (`status_id`),
  KEY `idx_message_templates_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `auto_reply_rules` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `channel_id` BIGINT UNSIGNED NULL,
  `trigger_type` VARCHAR(191) NULL,
  `conditions_json` JSON NULL,
  `reply_template_id` BIGINT UNSIGNED NULL,
  `priority` BIGINT NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_auto_reply_rules_business_id` (`business_id`),
  KEY `idx_auto_reply_rules_channel_id` (`channel_id`),
  KEY `idx_auto_reply_rules_reply_template_id` (`reply_template_id`),
  KEY `idx_auto_reply_rules_status_id` (`status_id`),
  KEY `idx_auto_reply_rules_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `ai_reply_settings` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `channel_id` BIGINT UNSIGNED NULL,
  `model` VARCHAR(191) NULL,
  `config_json` JSON NULL,
  `is_enabled` TINYINT(1) NULL DEFAULT 0,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ai_reply_settings_business_id` (`business_id`),
  KEY `idx_ai_reply_settings_channel_id` (`channel_id`),
  KEY `idx_ai_reply_settings_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `message_delivery_events` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `message_id` BIGINT UNSIGNED NULL,
  `event_type` VARCHAR(191) NULL,
  `occurred_at` DATETIME NULL,
  `payload_json` JSON NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_message_delivery_events_business_id` (`business_id`),
  KEY `idx_message_delivery_events_message_id` (`message_id`),
  KEY `idx_message_delivery_events_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `comments` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `channel_id` BIGINT UNSIGNED NULL,
  `external_comment_id` BIGINT UNSIGNED NULL,
  `customer_id` BIGINT UNSIGNED NULL,
  `body` TEXT NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_comments_business_id` (`business_id`),
  KEY `idx_comments_channel_id` (`channel_id`),
  KEY `idx_comments_customer_id` (`customer_id`),
  KEY `idx_comments_status_id` (`status_id`),
  KEY `idx_comments_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `comment_replies` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `comment_id` BIGINT UNSIGNED NULL,
  `message_id` BIGINT UNSIGNED NULL,
  `reply_body` TEXT NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_comment_replies_business_id` (`business_id`),
  KEY `idx_comment_replies_comment_id` (`comment_id`),
  KEY `idx_comment_replies_message_id` (`message_id`),
  KEY `idx_comment_replies_status_id` (`status_id`),
  KEY `idx_comment_replies_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `pbx_contacts` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `customer_id` BIGINT UNSIGNED NULL,
  `phone` VARCHAR(191) NULL,
  `name` VARCHAR(191) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_pbx_contacts_business_id` (`business_id`),
  KEY `idx_pbx_contacts_customer_id` (`customer_id`),
  KEY `idx_pbx_contacts_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `pbx_calls` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `customer_id` BIGINT UNSIGNED NULL,
  `agent_id` BIGINT UNSIGNED NULL,
  `external_call_id` BIGINT UNSIGNED NULL,
  `from_number` VARCHAR(191) NULL,
  `to_number` VARCHAR(191) NULL,
  `direction` VARCHAR(191) NULL,
  `started_at` DATETIME NULL,
  `ended_at` DATETIME NULL,
  `duration_seconds` BIGINT NULL,
  `recording_file_id` BIGINT UNSIGNED NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_pbx_calls_business_id` (`business_id`),
  KEY `idx_pbx_calls_customer_id` (`customer_id`),
  KEY `idx_pbx_calls_agent_id` (`agent_id`),
  KEY `idx_pbx_calls_status_id` (`status_id`),
  KEY `idx_pbx_calls_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `pbx_settings` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `connection_id` BIGINT UNSIGNED NULL,
  `config_json` JSON NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_pbx_settings_business_id` (`business_id`),
  KEY `idx_pbx_settings_connection_id` (`connection_id`),
  KEY `idx_pbx_settings_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `sms_campaigns` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `template_id` BIGINT UNSIGNED NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_sms_campaigns_business_id` (`business_id`),
  KEY `idx_sms_campaigns_template_id` (`template_id`),
  KEY `idx_sms_campaigns_status_id` (`status_id`),
  KEY `idx_sms_campaigns_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `sms_messages` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `campaign_id` BIGINT UNSIGNED NULL,
  `customer_id` BIGINT UNSIGNED NULL,
  `phone` VARCHAR(191) NULL,
  `body` TEXT NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `sent_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_sms_messages_business_id` (`business_id`),
  KEY `idx_sms_messages_campaign_id` (`campaign_id`),
  KEY `idx_sms_messages_customer_id` (`customer_id`),
  KEY `idx_sms_messages_status_id` (`status_id`),
  KEY `idx_sms_messages_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `automations` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `trigger_event` VARCHAR(191) NULL,
  `conditions_json` JSON NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_automations_business_id` (`business_id`),
  KEY `idx_automations_status_id` (`status_id`),
  KEY `idx_automations_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `automation_actions` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `automation_id` BIGINT UNSIGNED NULL,
  `action_type` VARCHAR(191) NULL,
  `config_json` JSON NULL,
  `sort_order` BIGINT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_automation_actions_business_id` (`business_id`),
  KEY `idx_automation_actions_automation_id` (`automation_id`),
  KEY `idx_automation_actions_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `automation_runs` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `automation_id` BIGINT UNSIGNED NULL,
  `trigger_entity_type` VARCHAR(191) NULL,
  `trigger_entity_id` BIGINT UNSIGNED NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `started_at` DATETIME NULL,
  `completed_at` DATETIME NULL,
  `error` TEXT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_automation_runs_business_id` (`business_id`),
  KEY `idx_automation_runs_automation_id` (`automation_id`),
  KEY `idx_automation_runs_status_id` (`status_id`),
  KEY `idx_automation_runs_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `departments` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_departments_business_id` (`business_id`),
  KEY `idx_departments_status_id` (`status_id`),
  KEY `idx_departments_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `designations` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_designations_business_id` (`business_id`),
  KEY `idx_designations_status_id` (`status_id`),
  KEY `idx_designations_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `employees` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `user_id` BIGINT UNSIGNED NULL,
  `employee_no` VARCHAR(191) NULL,
  `department_id` BIGINT UNSIGNED NULL,
  `designation_id` BIGINT UNSIGNED NULL,
  `branch_id` BIGINT UNSIGNED NULL,
  `join_date` DATETIME NULL,
  `employment_status_id` BIGINT UNSIGNED NULL,
  `basic_salary` DECIMAL(18,2) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_employees_business_id` (`business_id`),
  KEY `idx_employees_user_id` (`user_id`),
  KEY `idx_employees_department_id` (`department_id`),
  KEY `idx_employees_designation_id` (`designation_id`),
  KEY `idx_employees_branch_id` (`branch_id`),
  KEY `idx_employees_employment_status_id` (`employment_status_id`),
  KEY `idx_employees_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `shifts` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `start_time` VARCHAR(191) NULL,
  `end_time` VARCHAR(191) NULL,
  `grace_minutes` BIGINT NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_shifts_business_id` (`business_id`),
  KEY `idx_shifts_status_id` (`status_id`),
  KEY `idx_shifts_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `employee_shift_assignments` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `employee_id` BIGINT UNSIGNED NULL,
  `shift_id` BIGINT UNSIGNED NULL,
  `effective_from` DATETIME NULL,
  `effective_to` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_employee_shift_assignment_business_id` (`business_id`),
  KEY `idx_employee_shift_assignment_employee_id` (`employee_id`),
  KEY `idx_employee_shift_assignment_shift_id` (`shift_id`),
  KEY `idx_employee_shift_assignments_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `attendance_records` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `employee_id` BIGINT UNSIGNED NULL,
  `shift_id` BIGINT UNSIGNED NULL,
  `work_date` DATETIME NULL,
  `clock_in` DATETIME NULL,
  `clock_out` DATETIME NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_attendance_records_business_id` (`business_id`),
  KEY `idx_attendance_records_employee_id` (`employee_id`),
  KEY `idx_attendance_records_shift_id` (`shift_id`),
  KEY `idx_attendance_records_status_id` (`status_id`),
  KEY `idx_attendance_records_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `attendance_adjustments` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `attendance_id` BIGINT UNSIGNED NULL,
  `requested_by` VARCHAR(191) NULL,
  `approved_by` VARCHAR(191) NULL,
  `reason` TEXT NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_attendance_adjustments_business_id` (`business_id`),
  KEY `idx_attendance_adjustments_attendance_id` (`attendance_id`),
  KEY `idx_attendance_adjustments_requested_by` (`requested_by`),
  KEY `idx_attendance_adjustments_approved_by` (`approved_by`),
  KEY `idx_attendance_adjustments_status_id` (`status_id`),
  KEY `idx_attendance_adjustments_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `leave_types` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `name` VARCHAR(191) NULL,
  `is_paid` TINYINT(1) NULL DEFAULT 0,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_leave_types_business_id` (`business_id`),
  KEY `idx_leave_types_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `leave_requests` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `employee_id` BIGINT UNSIGNED NULL,
  `leave_type_id` BIGINT UNSIGNED NULL,
  `starts_on` DATETIME NULL,
  `ends_on` DATETIME NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_leave_requests_business_id` (`business_id`),
  KEY `idx_leave_requests_employee_id` (`employee_id`),
  KEY `idx_leave_requests_leave_type_id` (`leave_type_id`),
  KEY `idx_leave_requests_status_id` (`status_id`),
  KEY `idx_leave_requests_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `sop_documents` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `department_id` BIGINT UNSIGNED NULL,
  `title` VARCHAR(191) NULL,
  `body` TEXT NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_sop_documents_business_id` (`business_id`),
  KEY `idx_sop_documents_department_id` (`department_id`),
  KEY `idx_sop_documents_status_id` (`status_id`),
  KEY `idx_sop_documents_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `payroll_periods` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `starts_on` DATETIME NULL,
  `ends_on` DATETIME NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_payroll_periods_business_id` (`business_id`),
  KEY `idx_payroll_periods_status_id` (`status_id`),
  KEY `idx_payroll_periods_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `payroll_entries` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `period_id` BIGINT UNSIGNED NULL,
  `employee_id` BIGINT UNSIGNED NULL,
  `basic` DECIMAL(18,2) NULL,
  `allowances` DECIMAL(18,2) NULL,
  `deductions` DECIMAL(18,2) NULL,
  `net_pay` DECIMAL(18,2) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_payroll_entries_business_id` (`business_id`),
  KEY `idx_payroll_entries_period_id` (`period_id`),
  KEY `idx_payroll_entries_employee_id` (`employee_id`),
  KEY `idx_payroll_entries_status_id` (`status_id`),
  KEY `idx_payroll_entries_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `payroll_entry_components` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `payroll_entry_id` BIGINT UNSIGNED NULL,
  `component_type` VARCHAR(191) NULL,
  `name` VARCHAR(191) NULL,
  `amount` DECIMAL(18,2) NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_payroll_entry_components_business_id` (`business_id`),
  KEY `idx_payroll_entry_components_payroll_entry_id` (`payroll_entry_id`),
  KEY `idx_payroll_entry_components_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `employee_targets` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `employee_id` BIGINT UNSIGNED NULL,
  `metric` BIGINT NULL,
  `period_start` DATETIME NULL,
  `period_end` DATETIME NULL,
  `target_value` BIGINT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_employee_targets_business_id` (`business_id`),
  KEY `idx_employee_targets_employee_id` (`employee_id`),
  KEY `idx_employee_targets_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `report_definitions` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `code` VARCHAR(191) NULL,
  `name` VARCHAR(191) NULL,
  `query_key` VARCHAR(191) NULL,
  `config_json` JSON NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_report_definitions_business_id` (`business_id`),
  KEY `idx_report_definitions_status_id` (`status_id`),
  KEY `idx_report_definitions_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `saved_report_filters` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `report_id` BIGINT UNSIGNED NULL,
  `user_id` BIGINT UNSIGNED NULL,
  `filter_json` JSON NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_saved_report_filters_business_id` (`business_id`),
  KEY `idx_saved_report_filters_report_id` (`report_id`),
  KEY `idx_saved_report_filters_user_id` (`user_id`),
  KEY `idx_saved_report_filters_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `report_exports` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `report_id` BIGINT UNSIGNED NULL,
  `requested_by` VARCHAR(191) NULL,
  `file_id` BIGINT UNSIGNED NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_report_exports_business_id` (`business_id`),
  KEY `idx_report_exports_report_id` (`report_id`),
  KEY `idx_report_exports_requested_by` (`requested_by`),
  KEY `idx_report_exports_file_id` (`file_id`),
  KEY `idx_report_exports_status_id` (`status_id`),
  KEY `idx_report_exports_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `dashboard_widgets` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `user_id` BIGINT UNSIGNED NULL,
  `widget_key` VARCHAR(191) NULL,
  `config_json` JSON NULL,
  `sort_order` BIGINT NULL,
  `is_visible` TINYINT(1) NULL DEFAULT 0,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_dashboard_widgets_business_id` (`business_id`),
  KEY `idx_dashboard_widgets_user_id` (`user_id`),
  KEY `idx_dashboard_widgets_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `user_limits` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `user_id` BIGINT UNSIGNED NULL,
  `limit_type` VARCHAR(191) NULL,
  `limit_value` VARCHAR(191) NULL,
  `period` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_user_limits_business_id` (`business_id`),
  KEY `idx_user_limits_user_id` (`user_id`),
  KEY `idx_user_limits_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `support_tickets` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `created_by` VARCHAR(191) NULL,
  `subject` VARCHAR(191) NULL,
  `description` TEXT NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `priority` BIGINT NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_support_tickets_business_id` (`business_id`),
  KEY `idx_support_tickets_created_by` (`created_by`),
  KEY `idx_support_tickets_status_id` (`status_id`),
  KEY `idx_support_tickets_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `support_ticket_messages` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `ticket_id` BIGINT UNSIGNED NULL,
  `user_id` BIGINT UNSIGNED NULL,
  `body` TEXT NULL,
  `file_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_support_ticket_messages_business_id` (`business_id`),
  KEY `idx_support_ticket_messages_ticket_id` (`ticket_id`),
  KEY `idx_support_ticket_messages_user_id` (`user_id`),
  KEY `idx_support_ticket_messages_file_id` (`file_id`),
  KEY `idx_support_ticket_messages_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `system_events` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `category` VARCHAR(191) NULL,
  `severity` VARCHAR(191) NULL,
  `message` TEXT NULL,
  `details_json` JSON NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_system_events_business_id` (`business_id`),
  KEY `idx_system_events_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `device_registrations` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `user_id` BIGINT UNSIGNED NULL,
  `device_hash` VARCHAR(191) NULL,
  `label` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `last_seen_at` DATETIME NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_device_registrations_business_id` (`business_id`),
  KEY `idx_device_registrations_user_id` (`user_id`),
  KEY `idx_device_registrations_status_id` (`status_id`),
  KEY `idx_device_registrations_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `business_links` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `business_id` BIGINT UNSIGNED NULL,
  `parent_business_id` BIGINT UNSIGNED NULL,
  `child_business_id` BIGINT UNSIGNED NULL,
  `relationship_type` VARCHAR(191) NULL,
  `status_id` BIGINT UNSIGNED NULL,
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  `deleted_at` DATETIME NULL,
  PRIMARY KEY (`id`),
  KEY `idx_business_links_business_id` (`business_id`),
  KEY `idx_business_links_parent_business_id` (`parent_business_id`),
  KEY `idx_business_links_child_business_id` (`child_business_id`),
  KEY `idx_business_links_status_id` (`status_id`),
  KEY `idx_business_links_tenant` (`business_id`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `businesses` ADD CONSTRAINT `fk_businesses_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `business_profiles` ADD CONSTRAINT `fk_business_profiles_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `business_settings` ADD CONSTRAINT `fk_business_settings_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `branches` ADD CONSTRAINT `fk_branches_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `branches` ADD CONSTRAINT `fk_branches_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `warehouses` ADD CONSTRAINT `fk_warehouses_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `warehouses` ADD CONSTRAINT `fk_warehouses_branch_id` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `warehouses` ADD CONSTRAINT `fk_warehouses_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `business_memberships` ADD CONSTRAINT `fk_business_memberships_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `business_memberships` ADD CONSTRAINT `fk_business_memberships_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `business_memberships` ADD CONSTRAINT `fk_business_memberships_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `users` ADD CONSTRAINT `fk_users_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `roles` ADD CONSTRAINT `fk_roles_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `role_permissions` ADD CONSTRAINT `fk_role_permissions_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `role_permissions` ADD CONSTRAINT `fk_role_permissions_role_id` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `role_permissions` ADD CONSTRAINT `fk_role_permissions_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `user_roles` ADD CONSTRAINT `fk_user_roles_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `user_roles` ADD CONSTRAINT `fk_user_roles_role_id` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `user_roles` ADD CONSTRAINT `fk_user_roles_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `user_branch_access` ADD CONSTRAINT `fk_user_branch_access_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `user_branch_access` ADD CONSTRAINT `fk_user_branch_access_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `user_branch_access` ADD CONSTRAINT `fk_user_branch_access_branch_id` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `user_permissions` ADD CONSTRAINT `fk_user_permissions_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `user_permissions` ADD CONSTRAINT `fk_user_permissions_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `user_permissions` ADD CONSTRAINT `fk_user_permissions_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `navigation_items` ADD CONSTRAINT `fk_navigation_items_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `navigation_items` ADD CONSTRAINT `fk_navigation_items_module_id` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `navigation_items` ADD CONSTRAINT `fk_navigation_items_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `feature_flags` ADD CONSTRAINT `fk_feature_flags_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `integration_connections` ADD CONSTRAINT `fk_integration_connections_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `integration_connections` ADD CONSTRAINT `fk_integration_connections_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `webhook_events` ADD CONSTRAINT `fk_webhook_events_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `webhook_events` ADD CONSTRAINT `fk_webhook_events_connection_id` FOREIGN KEY (`connection_id`) REFERENCES `integration_connections` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `webhook_events` ADD CONSTRAINT `fk_webhook_events_processing_status_id` FOREIGN KEY (`processing_status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `external_id_maps` ADD CONSTRAINT `fk_external_id_maps_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `statuses` ADD CONSTRAINT `fk_statuses_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `status_transitions` ADD CONSTRAINT `fk_status_transitions_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `status_transitions` ADD CONSTRAINT `fk_status_transitions_from_status_id` FOREIGN KEY (`from_status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `status_transitions` ADD CONSTRAINT `fk_status_transitions_to_status_id` FOREIGN KEY (`to_status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `status_transitions` ADD CONSTRAINT `fk_status_transitions_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `status_history` ADD CONSTRAINT `fk_status_history_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `status_history` ADD CONSTRAINT `fk_status_history_from_status_id` FOREIGN KEY (`from_status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `status_history` ADD CONSTRAINT `fk_status_history_to_status_id` FOREIGN KEY (`to_status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `status_history` ADD CONSTRAINT `fk_status_history_changed_by` FOREIGN KEY (`changed_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `audit_logs` ADD CONSTRAINT `fk_audit_logs_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `audit_logs` ADD CONSTRAINT `fk_audit_logs_actor_id` FOREIGN KEY (`actor_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `deletion_logs` ADD CONSTRAINT `fk_deletion_logs_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `deletion_logs` ADD CONSTRAINT `fk_deletion_logs_deleted_by` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `media_files` ADD CONSTRAINT `fk_media_files_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `media_files` ADD CONSTRAINT `fk_media_files_uploaded_by` FOREIGN KEY (`uploaded_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `media_links` ADD CONSTRAINT `fk_media_links_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `media_links` ADD CONSTRAINT `fk_media_links_media_file_id` FOREIGN KEY (`media_file_id`) REFERENCES `media_files` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `notifications` ADD CONSTRAINT `fk_notifications_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `notifications` ADD CONSTRAINT `fk_notifications_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customers` ADD CONSTRAINT `fk_customers_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customers` ADD CONSTRAINT `fk_customers_source_id` FOREIGN KEY (`source_id`) REFERENCES `order_sources` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customers` ADD CONSTRAINT `fk_customers_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customers` ADD CONSTRAINT `fk_customers_assigned_user_id` FOREIGN KEY (`assigned_user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_addresses` ADD CONSTRAINT `fk_customer_addresses_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_addresses` ADD CONSTRAINT `fk_customer_addresses_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_contacts` ADD CONSTRAINT `fk_customer_contacts_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_contacts` ADD CONSTRAINT `fk_customer_contacts_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_segments` ADD CONSTRAINT `fk_customer_segments_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_segments` ADD CONSTRAINT `fk_customer_segments_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_segment_members` ADD CONSTRAINT `fk_customer_segment_members_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_segment_members` ADD CONSTRAINT `fk_customer_segment_members_segment_id` FOREIGN KEY (`segment_id`) REFERENCES `customer_segments` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_segment_members` ADD CONSTRAINT `fk_customer_segment_members_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_tags` ADD CONSTRAINT `fk_customer_tags_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_tag_links` ADD CONSTRAINT `fk_customer_tag_links_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_tag_links` ADD CONSTRAINT `fk_customer_tag_links_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_tag_links` ADD CONSTRAINT `fk_customer_tag_links_tag_id` FOREIGN KEY (`tag_id`) REFERENCES `customer_tags` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_import_batches` ADD CONSTRAINT `fk_customer_import_batches_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_import_batches` ADD CONSTRAINT `fk_customer_import_batches_file_id` FOREIGN KEY (`file_id`) REFERENCES `media_files` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_import_batches` ADD CONSTRAINT `fk_customer_import_batches_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_import_batches` ADD CONSTRAINT `fk_customer_import_batches_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `leads` ADD CONSTRAINT `fk_leads_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `leads` ADD CONSTRAINT `fk_leads_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `leads` ADD CONSTRAINT `fk_leads_source_id` FOREIGN KEY (`source_id`) REFERENCES `order_sources` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `leads` ADD CONSTRAINT `fk_leads_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `leads` ADD CONSTRAINT `fk_leads_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_interactions` ADD CONSTRAINT `fk_customer_interactions_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_interactions` ADD CONSTRAINT `fk_customer_interactions_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_interactions` ADD CONSTRAINT `fk_customer_interactions_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `customer_interactions` ADD CONSTRAINT `fk_customer_interactions_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `followups` ADD CONSTRAINT `fk_followups_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `followups` ADD CONSTRAINT `fk_followups_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `followups` ADD CONSTRAINT `fk_followups_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `followups` ADD CONSTRAINT `fk_followups_assigned_to` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `followups` ADD CONSTRAINT `fk_followups_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `tasks` ADD CONSTRAINT `fk_tasks_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `tasks` ADD CONSTRAINT `fk_tasks_assigned_to` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `tasks` ADD CONSTRAINT `fk_tasks_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `tasks` ADD CONSTRAINT `fk_tasks_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `task_comments` ADD CONSTRAINT `fk_task_comments_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `task_comments` ADD CONSTRAINT `fk_task_comments_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `task_comments` ADD CONSTRAINT `fk_task_comments_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `categories` ADD CONSTRAINT `fk_categories_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `categories` ADD CONSTRAINT `fk_categories_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `brands` ADD CONSTRAINT `fk_brands_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `brands` ADD CONSTRAINT `fk_brands_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `units` ADD CONSTRAINT `fk_units_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `products` ADD CONSTRAINT `fk_products_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `products` ADD CONSTRAINT `fk_products_category_id` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `products` ADD CONSTRAINT `fk_products_brand_id` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `products` ADD CONSTRAINT `fk_products_unit_id` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `products` ADD CONSTRAINT `fk_products_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `product_variants` ADD CONSTRAINT `fk_product_variants_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `product_variants` ADD CONSTRAINT `fk_product_variants_product_id` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `product_variants` ADD CONSTRAINT `fk_product_variants_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `product_images` ADD CONSTRAINT `fk_product_images_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `product_images` ADD CONSTRAINT `fk_product_images_product_id` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `product_images` ADD CONSTRAINT `fk_product_images_variant_id` FOREIGN KEY (`variant_id`) REFERENCES `product_variants` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `product_images` ADD CONSTRAINT `fk_product_images_media_file_id` FOREIGN KEY (`media_file_id`) REFERENCES `media_files` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `price_lists` ADD CONSTRAINT `fk_price_lists_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `price_lists` ADD CONSTRAINT `fk_price_lists_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `price_list_items` ADD CONSTRAINT `fk_price_list_items_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `price_list_items` ADD CONSTRAINT `fk_price_list_items_price_list_id` FOREIGN KEY (`price_list_id`) REFERENCES `price_lists` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `price_list_items` ADD CONSTRAINT `fk_price_list_items_variant_id` FOREIGN KEY (`variant_id`) REFERENCES `product_variants` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `inventory_balances` ADD CONSTRAINT `fk_inventory_balances_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `inventory_balances` ADD CONSTRAINT `fk_inventory_balances_warehouse_id` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `inventory_balances` ADD CONSTRAINT `fk_inventory_balances_variant_id` FOREIGN KEY (`variant_id`) REFERENCES `product_variants` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `inventory_movements` ADD CONSTRAINT `fk_inventory_movements_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `inventory_movements` ADD CONSTRAINT `fk_inventory_movements_warehouse_id` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `inventory_movements` ADD CONSTRAINT `fk_inventory_movements_variant_id` FOREIGN KEY (`variant_id`) REFERENCES `product_variants` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `inventory_movements` ADD CONSTRAINT `fk_inventory_movements_performed_by` FOREIGN KEY (`performed_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_reservations` ADD CONSTRAINT `fk_stock_reservations_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_reservations` ADD CONSTRAINT `fk_stock_reservations_order_item_id` FOREIGN KEY (`order_item_id`) REFERENCES `order_items` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_reservations` ADD CONSTRAINT `fk_stock_reservations_warehouse_id` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_reservations` ADD CONSTRAINT `fk_stock_reservations_variant_id` FOREIGN KEY (`variant_id`) REFERENCES `product_variants` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_reservations` ADD CONSTRAINT `fk_stock_reservations_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_transfers` ADD CONSTRAINT `fk_stock_transfers_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_transfers` ADD CONSTRAINT `fk_stock_transfers_from_warehouse_id` FOREIGN KEY (`from_warehouse_id`) REFERENCES `warehouses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_transfers` ADD CONSTRAINT `fk_stock_transfers_to_warehouse_id` FOREIGN KEY (`to_warehouse_id`) REFERENCES `warehouses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_transfers` ADD CONSTRAINT `fk_stock_transfers_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_transfers` ADD CONSTRAINT `fk_stock_transfers_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_transfer_items` ADD CONSTRAINT `fk_stock_transfer_items_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_transfer_items` ADD CONSTRAINT `fk_stock_transfer_items_transfer_id` FOREIGN KEY (`transfer_id`) REFERENCES `stock_transfers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_transfer_items` ADD CONSTRAINT `fk_stock_transfer_items_variant_id` FOREIGN KEY (`variant_id`) REFERENCES `product_variants` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_adjustments` ADD CONSTRAINT `fk_stock_adjustments_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_adjustments` ADD CONSTRAINT `fk_stock_adjustments_warehouse_id` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_adjustments` ADD CONSTRAINT `fk_stock_adjustments_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_adjustment_items` ADD CONSTRAINT `fk_stock_adjustment_items_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_adjustment_items` ADD CONSTRAINT `fk_stock_adjustment_items_adjustment_id` FOREIGN KEY (`adjustment_id`) REFERENCES `stock_adjustments` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `stock_adjustment_items` ADD CONSTRAINT `fk_stock_adjustment_items_variant_id` FOREIGN KEY (`variant_id`) REFERENCES `product_variants` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `warranties` ADD CONSTRAINT `fk_warranties_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `warranties` ADD CONSTRAINT `fk_warranties_variant_id` FOREIGN KEY (`variant_id`) REFERENCES `product_variants` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `warranties` ADD CONSTRAINT `fk_warranties_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `warranty_claims` ADD CONSTRAINT `fk_warranty_claims_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `warranty_claims` ADD CONSTRAINT `fk_warranty_claims_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `warranty_claims` ADD CONSTRAINT `fk_warranty_claims_order_item_id` FOREIGN KEY (`order_item_id`) REFERENCES `order_items` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `warranty_claims` ADD CONSTRAINT `fk_warranty_claims_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `warranty_claim_events` ADD CONSTRAINT `fk_warranty_claim_events_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `warranty_claim_events` ADD CONSTRAINT `fk_warranty_claim_events_claim_id` FOREIGN KEY (`claim_id`) REFERENCES `warranty_claims` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `warranty_claim_events` ADD CONSTRAINT `fk_warranty_claim_events_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `warranty_claim_events` ADD CONSTRAINT `fk_warranty_claim_events_actor_id` FOREIGN KEY (`actor_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `suppliers` ADD CONSTRAINT `fk_suppliers_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `suppliers` ADD CONSTRAINT `fk_suppliers_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `supplier_contacts` ADD CONSTRAINT `fk_supplier_contacts_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `supplier_contacts` ADD CONSTRAINT `fk_supplier_contacts_supplier_id` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `quotations` ADD CONSTRAINT `fk_quotations_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `quotations` ADD CONSTRAINT `fk_quotations_supplier_id` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `quotations` ADD CONSTRAINT `fk_quotations_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `quotation_items` ADD CONSTRAINT `fk_quotation_items_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `quotation_items` ADD CONSTRAINT `fk_quotation_items_quotation_id` FOREIGN KEY (`quotation_id`) REFERENCES `quotations` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `quotation_items` ADD CONSTRAINT `fk_quotation_items_variant_id` FOREIGN KEY (`variant_id`) REFERENCES `product_variants` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchases` ADD CONSTRAINT `fk_purchases_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchases` ADD CONSTRAINT `fk_purchases_supplier_id` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchases` ADD CONSTRAINT `fk_purchases_branch_id` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchases` ADD CONSTRAINT `fk_purchases_warehouse_id` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchases` ADD CONSTRAINT `fk_purchases_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchases` ADD CONSTRAINT `fk_purchases_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_items` ADD CONSTRAINT `fk_purchase_items_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_items` ADD CONSTRAINT `fk_purchase_items_purchase_id` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_items` ADD CONSTRAINT `fk_purchase_items_variant_id` FOREIGN KEY (`variant_id`) REFERENCES `product_variants` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_receipts` ADD CONSTRAINT `fk_purchase_receipts_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_receipts` ADD CONSTRAINT `fk_purchase_receipts_purchase_id` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_receipts` ADD CONSTRAINT `fk_purchase_receipts_warehouse_id` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_receipts` ADD CONSTRAINT `fk_purchase_receipts_received_by` FOREIGN KEY (`received_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_receipts` ADD CONSTRAINT `fk_purchase_receipts_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_receipt_items` ADD CONSTRAINT `fk_purchase_receipt_items_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_receipt_items` ADD CONSTRAINT `fk_purchase_receipt_items_receipt_id` FOREIGN KEY (`receipt_id`) REFERENCES `purchase_receipts` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_receipt_items` ADD CONSTRAINT `fk_purchase_receipt_items_purchase_item_id` FOREIGN KEY (`purchase_item_id`) REFERENCES `purchase_items` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_returns` ADD CONSTRAINT `fk_purchase_returns_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_returns` ADD CONSTRAINT `fk_purchase_returns_purchase_id` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_returns` ADD CONSTRAINT `fk_purchase_returns_supplier_id` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_returns` ADD CONSTRAINT `fk_purchase_returns_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_return_items` ADD CONSTRAINT `fk_purchase_return_items_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_return_items` ADD CONSTRAINT `fk_purchase_return_items_return_id` FOREIGN KEY (`return_id`) REFERENCES `purchase_returns` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `purchase_return_items` ADD CONSTRAINT `fk_purchase_return_items_purchase_item_id` FOREIGN KEY (`purchase_item_id`) REFERENCES `purchase_items` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `supplier_ledger_entries` ADD CONSTRAINT `fk_supplier_ledger_entries_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `supplier_ledger_entries` ADD CONSTRAINT `fk_supplier_ledger_entries_supplier_id` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `supplier_ledger_entries` ADD CONSTRAINT `fk_supplier_ledger_entries_source_id` FOREIGN KEY (`source_id`) REFERENCES `order_sources` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_sources` ADD CONSTRAINT `fk_order_sources_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_sources` ADD CONSTRAINT `fk_order_sources_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `sales_channels` ADD CONSTRAINT `fk_sales_channels_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `sales_channels` ADD CONSTRAINT `fk_sales_channels_connection_id` FOREIGN KEY (`connection_id`) REFERENCES `integration_connections` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `sales_channels` ADD CONSTRAINT `fk_sales_channels_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `orders` ADD CONSTRAINT `fk_orders_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `orders` ADD CONSTRAINT `fk_orders_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `orders` ADD CONSTRAINT `fk_orders_branch_id` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `orders` ADD CONSTRAINT `fk_orders_warehouse_id` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `orders` ADD CONSTRAINT `fk_orders_source_id` FOREIGN KEY (`source_id`) REFERENCES `order_sources` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `orders` ADD CONSTRAINT `fk_orders_channel_id` FOREIGN KEY (`channel_id`) REFERENCES `sales_channels` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `orders` ADD CONSTRAINT `fk_orders_assigned_to` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `orders` ADD CONSTRAINT `fk_orders_order_status_id` FOREIGN KEY (`order_status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `orders` ADD CONSTRAINT `fk_orders_payment_status_id` FOREIGN KEY (`payment_status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `orders` ADD CONSTRAINT `fk_orders_fulfillment_status_i` FOREIGN KEY (`fulfillment_status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `orders` ADD CONSTRAINT `fk_orders_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_items` ADD CONSTRAINT `fk_order_items_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_items` ADD CONSTRAINT `fk_order_items_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_items` ADD CONSTRAINT `fk_order_items_variant_id` FOREIGN KEY (`variant_id`) REFERENCES `product_variants` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_discounts` ADD CONSTRAINT `fk_order_discounts_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_discounts` ADD CONSTRAINT `fk_order_discounts_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_discounts` ADD CONSTRAINT `fk_order_discounts_discount_rule_id` FOREIGN KEY (`discount_rule_id`) REFERENCES `discount_rules` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `discount_rules` ADD CONSTRAINT `fk_discount_rules_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `discount_rules` ADD CONSTRAINT `fk_discount_rules_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_notes` ADD CONSTRAINT `fk_order_notes_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_notes` ADD CONSTRAINT `fk_order_notes_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_notes` ADD CONSTRAINT `fk_order_notes_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_assignments` ADD CONSTRAINT `fk_order_assignments_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_assignments` ADD CONSTRAINT `fk_order_assignments_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_assignments` ADD CONSTRAINT `fk_order_assignments_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_assignments` ADD CONSTRAINT `fk_order_assignments_assigned_by` FOREIGN KEY (`assigned_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_edits` ADD CONSTRAINT `fk_order_edits_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_edits` ADD CONSTRAINT `fk_order_edits_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_edits` ADD CONSTRAINT `fk_order_edits_actor_id` FOREIGN KEY (`actor_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_returns` ADD CONSTRAINT `fk_order_returns_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_returns` ADD CONSTRAINT `fk_order_returns_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_returns` ADD CONSTRAINT `fk_order_returns_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_return_items` ADD CONSTRAINT `fk_order_return_items_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_return_items` ADD CONSTRAINT `fk_order_return_items_return_id` FOREIGN KEY (`return_id`) REFERENCES `order_returns` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `order_return_items` ADD CONSTRAINT `fk_order_return_items_order_item_id` FOREIGN KEY (`order_item_id`) REFERENCES `order_items` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `preorder_requests` ADD CONSTRAINT `fk_preorder_requests_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `preorder_requests` ADD CONSTRAINT `fk_preorder_requests_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `preorder_requests` ADD CONSTRAINT `fk_preorder_requests_variant_id` FOREIGN KEY (`variant_id`) REFERENCES `product_variants` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `preorder_requests` ADD CONSTRAINT `fk_preorder_requests_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `website_order_imports` ADD CONSTRAINT `fk_website_order_imports_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `website_order_imports` ADD CONSTRAINT `fk_website_order_imports_channel_id` FOREIGN KEY (`channel_id`) REFERENCES `sales_channels` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `website_order_imports` ADD CONSTRAINT `fk_website_order_imports_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `website_order_imports` ADD CONSTRAINT `fk_website_order_imports_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `couriers` ADD CONSTRAINT `fk_couriers_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `couriers` ADD CONSTRAINT `fk_couriers_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `courier_accounts` ADD CONSTRAINT `fk_courier_accounts_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `courier_accounts` ADD CONSTRAINT `fk_courier_accounts_courier_id` FOREIGN KEY (`courier_id`) REFERENCES `couriers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `courier_accounts` ADD CONSTRAINT `fk_courier_accounts_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `shipments` ADD CONSTRAINT `fk_shipments_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `shipments` ADD CONSTRAINT `fk_shipments_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `shipments` ADD CONSTRAINT `fk_shipments_courier_id` FOREIGN KEY (`courier_id`) REFERENCES `couriers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `shipments` ADD CONSTRAINT `fk_shipments_courier_account_id` FOREIGN KEY (`courier_account_id`) REFERENCES `courier_accounts` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `shipments` ADD CONSTRAINT `fk_shipments_delivery_status_id` FOREIGN KEY (`delivery_status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `shipment_events` ADD CONSTRAINT `fk_shipment_events_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `shipment_events` ADD CONSTRAINT `fk_shipment_events_shipment_id` FOREIGN KEY (`shipment_id`) REFERENCES `shipments` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `delivery_methods` ADD CONSTRAINT `fk_delivery_methods_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `delivery_methods` ADD CONSTRAINT `fk_delivery_methods_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `delivery_attempts` ADD CONSTRAINT `fk_delivery_attempts_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `delivery_attempts` ADD CONSTRAINT `fk_delivery_attempts_shipment_id` FOREIGN KEY (`shipment_id`) REFERENCES `shipments` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `courier_settlements` ADD CONSTRAINT `fk_courier_settlements_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `courier_settlements` ADD CONSTRAINT `fk_courier_settlements_courier_id` FOREIGN KEY (`courier_id`) REFERENCES `couriers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `courier_settlements` ADD CONSTRAINT `fk_courier_settlements_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `courier_settlement_lines` ADD CONSTRAINT `fk_courier_settlement_lines_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `courier_settlement_lines` ADD CONSTRAINT `fk_courier_settlement_lines_settlement_id` FOREIGN KEY (`settlement_id`) REFERENCES `courier_settlements` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `courier_settlement_lines` ADD CONSTRAINT `fk_courier_settlement_lines_shipment_id` FOREIGN KEY (`shipment_id`) REFERENCES `shipments` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `scan_events` ADD CONSTRAINT `fk_scan_events_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `scan_events` ADD CONSTRAINT `fk_scan_events_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `scan_events` ADD CONSTRAINT `fk_scan_events_shipment_id` FOREIGN KEY (`shipment_id`) REFERENCES `shipments` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `scan_events` ADD CONSTRAINT `fk_scan_events_scanned_by` FOREIGN KEY (`scanned_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ip_block_rules` ADD CONSTRAINT `fk_ip_block_rules_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ip_block_rules` ADD CONSTRAINT `fk_ip_block_rules_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `accounts` ADD CONSTRAINT `fk_accounts_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `financial_transactions` ADD CONSTRAINT `fk_financial_transactions_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `financial_transactions` ADD CONSTRAINT `fk_financial_transactions_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `financial_transactions` ADD CONSTRAINT `fk_financial_transactions_posted_by` FOREIGN KEY (`posted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `financial_transaction_lines` ADD CONSTRAINT `fk_financial_transaction_lines_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `financial_transaction_lines` ADD CONSTRAINT `fk_financial_transaction_lines_transaction_id` FOREIGN KEY (`transaction_id`) REFERENCES `financial_transactions` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `financial_transaction_lines` ADD CONSTRAINT `fk_financial_transaction_lines_account_id` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `financial_transaction_lines` ADD CONSTRAINT `fk_financial_transaction_lines_branch_id` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payment_methods` ADD CONSTRAINT `fk_payment_methods_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payment_methods` ADD CONSTRAINT `fk_payment_methods_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payments` ADD CONSTRAINT `fk_payments_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payments` ADD CONSTRAINT `fk_payments_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payments` ADD CONSTRAINT `fk_payments_purchase_id` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payments` ADD CONSTRAINT `fk_payments_method_id` FOREIGN KEY (`method_id`) REFERENCES `payment_methods` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payments` ADD CONSTRAINT `fk_payments_account_id` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payments` ADD CONSTRAINT `fk_payments_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payment_allocations` ADD CONSTRAINT `fk_payment_allocations_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payment_allocations` ADD CONSTRAINT `fk_payment_allocations_payment_id` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `refunds` ADD CONSTRAINT `fk_refunds_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `refunds` ADD CONSTRAINT `fk_refunds_order_return_id` FOREIGN KEY (`order_return_id`) REFERENCES `order_returns` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `refunds` ADD CONSTRAINT `fk_refunds_payment_id` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `refunds` ADD CONSTRAINT `fk_refunds_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `expense_categories` ADD CONSTRAINT `fk_expense_categories_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `expense_categories` ADD CONSTRAINT `fk_expense_categories_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `expenses` ADD CONSTRAINT `fk_expenses_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `expenses` ADD CONSTRAINT `fk_expenses_category_id` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `expenses` ADD CONSTRAINT `fk_expenses_branch_id` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `expenses` ADD CONSTRAINT `fk_expenses_account_id` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `expenses` ADD CONSTRAINT `fk_expenses_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `expenses` ADD CONSTRAINT `fk_expenses_approved_by` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ad_expenses` ADD CONSTRAINT `fk_ad_expenses_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ad_expenses` ADD CONSTRAINT `fk_ad_expenses_expense_id` FOREIGN KEY (`expense_id`) REFERENCES `expenses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ad_expenses` ADD CONSTRAINT `fk_ad_expenses_campaign_id` FOREIGN KEY (`campaign_id`) REFERENCES `ad_campaigns` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `income_records` ADD CONSTRAINT `fk_income_records_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `income_records` ADD CONSTRAINT `fk_income_records_account_id` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `assets` ADD CONSTRAINT `fk_assets_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `assets` ADD CONSTRAINT `fk_assets_branch_id` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `assets` ADD CONSTRAINT `fk_assets_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `asset_depreciations` ADD CONSTRAINT `fk_asset_depreciations_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `asset_depreciations` ADD CONSTRAINT `fk_asset_depreciations_asset_id` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `asset_depreciations` ADD CONSTRAINT `fk_asset_depreciations_transaction_id` FOREIGN KEY (`transaction_id`) REFERENCES `financial_transactions` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ad_accounts` ADD CONSTRAINT `fk_ad_accounts_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ad_accounts` ADD CONSTRAINT `fk_ad_accounts_connection_id` FOREIGN KEY (`connection_id`) REFERENCES `integration_connections` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ad_accounts` ADD CONSTRAINT `fk_ad_accounts_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ad_campaigns` ADD CONSTRAINT `fk_ad_campaigns_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ad_campaigns` ADD CONSTRAINT `fk_ad_campaigns_ad_account_id` FOREIGN KEY (`ad_account_id`) REFERENCES `ad_accounts` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ad_campaigns` ADD CONSTRAINT `fk_ad_campaigns_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ad_sets` ADD CONSTRAINT `fk_ad_sets_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ad_sets` ADD CONSTRAINT `fk_ad_sets_campaign_id` FOREIGN KEY (`campaign_id`) REFERENCES `ad_campaigns` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ad_sets` ADD CONSTRAINT `fk_ad_sets_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ads` ADD CONSTRAINT `fk_ads_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ads` ADD CONSTRAINT `fk_ads_ad_set_id` FOREIGN KEY (`ad_set_id`) REFERENCES `ad_sets` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ads` ADD CONSTRAINT `fk_ads_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ad_daily_metrics` ADD CONSTRAINT `fk_ad_daily_metrics_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ad_daily_metrics` ADD CONSTRAINT `fk_ad_daily_metrics_ad_id` FOREIGN KEY (`ad_id`) REFERENCES `ads` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `conversations` ADD CONSTRAINT `fk_conversations_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `conversations` ADD CONSTRAINT `fk_conversations_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `conversations` ADD CONSTRAINT `fk_conversations_channel_id` FOREIGN KEY (`channel_id`) REFERENCES `sales_channels` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `conversations` ADD CONSTRAINT `fk_conversations_assigned_to` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `conversations` ADD CONSTRAINT `fk_conversations_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `messages` ADD CONSTRAINT `fk_messages_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `messages` ADD CONSTRAINT `fk_messages_conversation_id` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `messages` ADD CONSTRAINT `fk_messages_media_file_id` FOREIGN KEY (`media_file_id`) REFERENCES `media_files` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `messages` ADD CONSTRAINT `fk_messages_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `message_templates` ADD CONSTRAINT `fk_message_templates_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `message_templates` ADD CONSTRAINT `fk_message_templates_channel_id` FOREIGN KEY (`channel_id`) REFERENCES `sales_channels` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `message_templates` ADD CONSTRAINT `fk_message_templates_approval_status_id` FOREIGN KEY (`approval_status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `message_templates` ADD CONSTRAINT `fk_message_templates_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `auto_reply_rules` ADD CONSTRAINT `fk_auto_reply_rules_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `auto_reply_rules` ADD CONSTRAINT `fk_auto_reply_rules_channel_id` FOREIGN KEY (`channel_id`) REFERENCES `sales_channels` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `auto_reply_rules` ADD CONSTRAINT `fk_auto_reply_rules_reply_template_id` FOREIGN KEY (`reply_template_id`) REFERENCES `message_templates` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `auto_reply_rules` ADD CONSTRAINT `fk_auto_reply_rules_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ai_reply_settings` ADD CONSTRAINT `fk_ai_reply_settings_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ai_reply_settings` ADD CONSTRAINT `fk_ai_reply_settings_channel_id` FOREIGN KEY (`channel_id`) REFERENCES `sales_channels` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `message_delivery_events` ADD CONSTRAINT `fk_message_delivery_events_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `message_delivery_events` ADD CONSTRAINT `fk_message_delivery_events_message_id` FOREIGN KEY (`message_id`) REFERENCES `messages` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `comments` ADD CONSTRAINT `fk_comments_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `comments` ADD CONSTRAINT `fk_comments_channel_id` FOREIGN KEY (`channel_id`) REFERENCES `sales_channels` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `comments` ADD CONSTRAINT `fk_comments_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `comments` ADD CONSTRAINT `fk_comments_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `comment_replies` ADD CONSTRAINT `fk_comment_replies_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `comment_replies` ADD CONSTRAINT `fk_comment_replies_comment_id` FOREIGN KEY (`comment_id`) REFERENCES `comments` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `comment_replies` ADD CONSTRAINT `fk_comment_replies_message_id` FOREIGN KEY (`message_id`) REFERENCES `messages` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `comment_replies` ADD CONSTRAINT `fk_comment_replies_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `pbx_contacts` ADD CONSTRAINT `fk_pbx_contacts_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `pbx_contacts` ADD CONSTRAINT `fk_pbx_contacts_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `pbx_calls` ADD CONSTRAINT `fk_pbx_calls_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `pbx_calls` ADD CONSTRAINT `fk_pbx_calls_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `pbx_calls` ADD CONSTRAINT `fk_pbx_calls_agent_id` FOREIGN KEY (`agent_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `pbx_calls` ADD CONSTRAINT `fk_pbx_calls_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `pbx_settings` ADD CONSTRAINT `fk_pbx_settings_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `pbx_settings` ADD CONSTRAINT `fk_pbx_settings_connection_id` FOREIGN KEY (`connection_id`) REFERENCES `integration_connections` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `sms_campaigns` ADD CONSTRAINT `fk_sms_campaigns_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `sms_campaigns` ADD CONSTRAINT `fk_sms_campaigns_template_id` FOREIGN KEY (`template_id`) REFERENCES `message_templates` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `sms_campaigns` ADD CONSTRAINT `fk_sms_campaigns_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `sms_messages` ADD CONSTRAINT `fk_sms_messages_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `sms_messages` ADD CONSTRAINT `fk_sms_messages_campaign_id` FOREIGN KEY (`campaign_id`) REFERENCES `sms_campaigns` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `sms_messages` ADD CONSTRAINT `fk_sms_messages_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `sms_messages` ADD CONSTRAINT `fk_sms_messages_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `automations` ADD CONSTRAINT `fk_automations_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `automations` ADD CONSTRAINT `fk_automations_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `automation_actions` ADD CONSTRAINT `fk_automation_actions_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `automation_actions` ADD CONSTRAINT `fk_automation_actions_automation_id` FOREIGN KEY (`automation_id`) REFERENCES `automations` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `automation_runs` ADD CONSTRAINT `fk_automation_runs_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `automation_runs` ADD CONSTRAINT `fk_automation_runs_automation_id` FOREIGN KEY (`automation_id`) REFERENCES `automations` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `automation_runs` ADD CONSTRAINT `fk_automation_runs_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `departments` ADD CONSTRAINT `fk_departments_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `departments` ADD CONSTRAINT `fk_departments_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `designations` ADD CONSTRAINT `fk_designations_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `designations` ADD CONSTRAINT `fk_designations_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `employees` ADD CONSTRAINT `fk_employees_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `employees` ADD CONSTRAINT `fk_employees_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `employees` ADD CONSTRAINT `fk_employees_department_id` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `employees` ADD CONSTRAINT `fk_employees_designation_id` FOREIGN KEY (`designation_id`) REFERENCES `designations` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `employees` ADD CONSTRAINT `fk_employees_branch_id` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `employees` ADD CONSTRAINT `fk_employees_employment_status_id` FOREIGN KEY (`employment_status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `shifts` ADD CONSTRAINT `fk_shifts_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `shifts` ADD CONSTRAINT `fk_shifts_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `employee_shift_assignments` ADD CONSTRAINT `fk_employee_shift_assignments_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `employee_shift_assignments` ADD CONSTRAINT `fk_employee_shift_assignments_employee_id` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `employee_shift_assignments` ADD CONSTRAINT `fk_employee_shift_assignments_shift_id` FOREIGN KEY (`shift_id`) REFERENCES `shifts` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `attendance_records` ADD CONSTRAINT `fk_attendance_records_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `attendance_records` ADD CONSTRAINT `fk_attendance_records_employee_id` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `attendance_records` ADD CONSTRAINT `fk_attendance_records_shift_id` FOREIGN KEY (`shift_id`) REFERENCES `shifts` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `attendance_records` ADD CONSTRAINT `fk_attendance_records_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `attendance_adjustments` ADD CONSTRAINT `fk_attendance_adjustments_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `attendance_adjustments` ADD CONSTRAINT `fk_attendance_adjustments_attendance_id` FOREIGN KEY (`attendance_id`) REFERENCES `attendance_records` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `attendance_adjustments` ADD CONSTRAINT `fk_attendance_adjustments_requested_by` FOREIGN KEY (`requested_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `attendance_adjustments` ADD CONSTRAINT `fk_attendance_adjustments_approved_by` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `attendance_adjustments` ADD CONSTRAINT `fk_attendance_adjustments_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `leave_types` ADD CONSTRAINT `fk_leave_types_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `leave_requests` ADD CONSTRAINT `fk_leave_requests_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `leave_requests` ADD CONSTRAINT `fk_leave_requests_employee_id` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `leave_requests` ADD CONSTRAINT `fk_leave_requests_leave_type_id` FOREIGN KEY (`leave_type_id`) REFERENCES `leave_types` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `leave_requests` ADD CONSTRAINT `fk_leave_requests_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `sop_documents` ADD CONSTRAINT `fk_sop_documents_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `sop_documents` ADD CONSTRAINT `fk_sop_documents_department_id` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `sop_documents` ADD CONSTRAINT `fk_sop_documents_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payroll_periods` ADD CONSTRAINT `fk_payroll_periods_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payroll_periods` ADD CONSTRAINT `fk_payroll_periods_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payroll_entries` ADD CONSTRAINT `fk_payroll_entries_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payroll_entries` ADD CONSTRAINT `fk_payroll_entries_period_id` FOREIGN KEY (`period_id`) REFERENCES `payroll_periods` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payroll_entries` ADD CONSTRAINT `fk_payroll_entries_employee_id` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payroll_entries` ADD CONSTRAINT `fk_payroll_entries_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payroll_entry_components` ADD CONSTRAINT `fk_payroll_entry_components_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `payroll_entry_components` ADD CONSTRAINT `fk_payroll_entry_components_payroll_entry_id` FOREIGN KEY (`payroll_entry_id`) REFERENCES `payroll_entries` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `employee_targets` ADD CONSTRAINT `fk_employee_targets_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `employee_targets` ADD CONSTRAINT `fk_employee_targets_employee_id` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `report_definitions` ADD CONSTRAINT `fk_report_definitions_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `report_definitions` ADD CONSTRAINT `fk_report_definitions_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `saved_report_filters` ADD CONSTRAINT `fk_saved_report_filters_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `saved_report_filters` ADD CONSTRAINT `fk_saved_report_filters_report_id` FOREIGN KEY (`report_id`) REFERENCES `report_definitions` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `saved_report_filters` ADD CONSTRAINT `fk_saved_report_filters_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `report_exports` ADD CONSTRAINT `fk_report_exports_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `report_exports` ADD CONSTRAINT `fk_report_exports_report_id` FOREIGN KEY (`report_id`) REFERENCES `report_definitions` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `report_exports` ADD CONSTRAINT `fk_report_exports_requested_by` FOREIGN KEY (`requested_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `report_exports` ADD CONSTRAINT `fk_report_exports_file_id` FOREIGN KEY (`file_id`) REFERENCES `media_files` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `report_exports` ADD CONSTRAINT `fk_report_exports_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `dashboard_widgets` ADD CONSTRAINT `fk_dashboard_widgets_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `dashboard_widgets` ADD CONSTRAINT `fk_dashboard_widgets_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `user_limits` ADD CONSTRAINT `fk_user_limits_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `user_limits` ADD CONSTRAINT `fk_user_limits_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `support_tickets` ADD CONSTRAINT `fk_support_tickets_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `support_tickets` ADD CONSTRAINT `fk_support_tickets_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `support_tickets` ADD CONSTRAINT `fk_support_tickets_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `support_ticket_messages` ADD CONSTRAINT `fk_support_ticket_messages_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `support_ticket_messages` ADD CONSTRAINT `fk_support_ticket_messages_ticket_id` FOREIGN KEY (`ticket_id`) REFERENCES `support_tickets` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `support_ticket_messages` ADD CONSTRAINT `fk_support_ticket_messages_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `support_ticket_messages` ADD CONSTRAINT `fk_support_ticket_messages_file_id` FOREIGN KEY (`file_id`) REFERENCES `media_files` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `system_events` ADD CONSTRAINT `fk_system_events_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `device_registrations` ADD CONSTRAINT `fk_device_registrations_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `device_registrations` ADD CONSTRAINT `fk_device_registrations_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `device_registrations` ADD CONSTRAINT `fk_device_registrations_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `business_links` ADD CONSTRAINT `fk_business_links_business_id` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `business_links` ADD CONSTRAINT `fk_business_links_parent_business_id` FOREIGN KEY (`parent_business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `business_links` ADD CONSTRAINT `fk_business_links_child_business_id` FOREIGN KEY (`child_business_id`) REFERENCES `businesses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `business_links` ADD CONSTRAINT `fk_business_links_status_id` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `businesses` ADD UNIQUE KEY `uq_businesses` (`slug`);

ALTER TABLE `users` ADD UNIQUE KEY `uq_users` (`email`);

ALTER TABLE `statuses` ADD UNIQUE KEY `uq_statuses` (`business_id`, `module`, `code`);

ALTER TABLE `permissions` ADD UNIQUE KEY `uq_permissions` (`code`);

ALTER TABLE `modules` ADD UNIQUE KEY `uq_modules` (`code`);

ALTER TABLE `business_memberships` ADD UNIQUE KEY `uq_business_memberships` (`business_id`, `user_id`);

ALTER TABLE `roles` ADD UNIQUE KEY `uq_roles` (`business_id`, `name`);

ALTER TABLE `business_settings` ADD UNIQUE KEY `uq_business_settings` (`business_id`, `group_key`, `key`);

ALTER TABLE `branches` ADD UNIQUE KEY `uq_branches` (`business_id`, `code`);

ALTER TABLE `products` ADD UNIQUE KEY `uq_products` (`business_id`, `sku`);

ALTER TABLE `product_variants` ADD UNIQUE KEY `uq_product_variants` (`product_id`, `sku`);

ALTER TABLE `inventory_balances` ADD UNIQUE KEY `uq_inventory_balances` (`warehouse_id`, `variant_id`);

ALTER TABLE `orders` ADD UNIQUE KEY `uq_orders` (`business_id`, `order_no`);

ALTER TABLE `suppliers` ADD UNIQUE KEY `uq_suppliers` (`business_id`, `code`);

ALTER TABLE `customers` ADD UNIQUE KEY `uq_customers` (`business_id`, `code`);

ALTER TABLE `purchases` ADD UNIQUE KEY `uq_purchases` (`business_id`, `reference_no`);

ALTER TABLE `ad_daily_metrics` ADD UNIQUE KEY `uq_ad_daily_metrics` (`ad_id`, `metric_date`);

ALTER TABLE `attendance_records` ADD UNIQUE KEY `uq_attendance_records` (`employee_id`, `work_date`);

ALTER TABLE `payment_methods` ADD UNIQUE KEY `uq_payment_methods` (`business_id`, `name`);

ALTER TABLE `order_sources` ADD UNIQUE KEY `uq_order_sources` (`business_id`, `code`);

ALTER TABLE `sales_channels` ADD UNIQUE KEY `uq_sales_channels` (`business_id`, `code`);

ALTER TABLE `accounts` ADD UNIQUE KEY `uq_accounts` (`business_id`, `code`);

ALTER TABLE `feature_flags` ADD UNIQUE KEY `uq_feature_flags` (`business_id`, `code`);

SET FOREIGN_KEY_CHECKS=1;