CREATE TABLE `product_inventory` (
  `id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `product_variation_id` int(11) NOT NULL,
  `subsidiary_id` int(11) DEFAULT NULL,
  `issue_date` date DEFAULT NULL,
  `quantity_cost` double DEFAULT NULL,
  `unit_cost` double DEFAULT NULL,
  `total` double DEFAULT NULL,
  `month_01` double(11,8) DEFAULT NULL,
  `month_02` double(11,8) DEFAULT NULL,
  `month_03` double(11,8) DEFAULT NULL,
  `month_04` double(11,8) DEFAULT NULL,
  `month_05` double(11,8) DEFAULT NULL,
  `month_06` double(11,8) DEFAULT NULL,
  `month_07` double(11,8) DEFAULT NULL,
  `month_08` double(11,8) DEFAULT NULL,
  `month_09` double(11,8) DEFAULT NULL,
  `month_10` double(11,8) DEFAULT NULL,
  `month_11` double(11,8) DEFAULT NULL,
  `month_12` double(11,8) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `edit_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;