
CREATE TABLE IF NOT EXISTS `purchase_return_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_return_id` int(10) unsigned NOT NULL,
  `purchase_item_id` int(10) unsigned NOT NULL,
  `quantity` int(11) NOT NULL,
  `unit_price` bigint(20) unsigned NOT NULL DEFAULT 0,
  `total_price` bigint(20) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `fk_pri_return` (`purchase_return_id`),
  KEY `fk_pri_item` (`purchase_item_id`),
  CONSTRAINT `fk_pri_item` FOREIGN KEY (`purchase_item_id`) REFERENCES `purchase_items` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_pri_return` FOREIGN KEY (`purchase_return_id`) REFERENCES `purchase_returns` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
