DROP TABLE IF EXISTS `cari`;
CREATE TABLE `cari` (
                        `id` int NOT NULL AUTO_INCREMENT,
                        `type` varchar(10) NOT NULL,
                        `cari_type` varchar(50) NOT NULL COMMENT 'sale,other',
                        `invoice_number` varchar(150) NOT NULL,
                        `price` decimal(15,6) NOT NULL,
                        `note` text NOT NULL,
                        `image` varchar(250) NOT NULL,
                        `user_id` int NOT NULL,
                        `staff_id` int NOT NULL,
                        `cari_user_id` int NOT NULL,
                        `insert_date` datetime NOT NULL,
                        `income_id` int NOT NULL,
                        `expense_id` int NOT NULL,
                        PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;