DROP TABLE IF EXISTS `expense_item`;
CREATE TABLE `expense_item` (
                                `id` int NOT NULL AUTO_INCREMENT,
                                `group_id` int NOT NULL,
                                `name` varchar(100) NOT NULL,
                                `color` varchar(50) NOT NULL,
                                `shop_id` int NOT NULL,
                                `user_id` int NOT NULL,
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;