DROP TABLE IF EXISTS `expense`;
CREATE TABLE `expense` (
                           `id` int NOT NULL AUTO_INCREMENT,
                           `expense_item_id` int NOT NULL,
                           `document_date` datetime NOT NULL,
                           `document_number` varchar(50) NOT NULL,
                           `description` text NOT NULL,
                           `document_image` varchar(150) NOT NULL,
                           `payment_status` tinyint(1) NOT NULL,
                           `payment_date` datetime NOT NULL,
                           `payment_amount` decimal(15,6) NOT NULL,
                           `payment_safes` int NOT NULL,
                           `image` varchar(155) NOT NULL,
                           `tax_id` int NOT NULL,
                           `user_id` int NOT NULL,
                           `shop_id` int NOT NULL,
                           `cron_status` tinyint(1) NOT NULL DEFAULT '0',
                           PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;