
CREATE TABLE IF NOT EXISTS `sale_return_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sale_return_id` int(10) unsigned NOT NULL,
  `order_item_id` int(10) unsigned NOT NULL,
  `product_id` int(10) unsigned NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `unit_price` bigint(20) unsigned NOT NULL,
  `total_price` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_sri_return` (`sale_return_id`),
  KEY `fk_sri_order_item` (`order_item_id`),
  KEY `fk_sri_product` (`product_id`),
  CONSTRAINT `fk_sri_order_item` FOREIGN KEY (`order_item_id`) REFERENCES `order_items` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_sri_product` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `fk_sri_return` FOREIGN KEY (`sale_return_id`) REFERENCES `sale_returns` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
