-- Schema for inventory_tally table
CREATE TABLE IF NOT EXISTS `inventory_tally` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `member_id` VARCHAR(255) NOT NULL,
  `inventory_item` VARCHAR(255) NOT NULL,
  `quantity` INT NOT NULL,
  `denomination` DECIMAL(10,2) NOT NULL,
  `total_value` DECIMAL(10,2) NOT NULL,
  `submit_date` DATETIME NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;