DROP TABLE IF EXISTS `user_bank_accounts`;
CREATE TABLE `user_bank_accounts` (
                                      `id` int NOT NULL AUTO_INCREMENT,
                                      `user_id` int NOT NULL,
                                      `bank_list_id` int NOT NULL,
                                      `department` varchar(100) NOT NULL,
                                      `account_no` int NOT NULL,
                                      `iban` varchar(24) NOT NULL,
                                      `account_holder` varchar(100) NOT NULL,
                                      `insert_date` datetime NOT NULL,
                                      `status` tinyint(1) NOT NULL DEFAULT '0',
                                      PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;