###币种信息表 `currency` > currency_code :币种国际代码 如USD ERU CNH , > > currency_name : 币种名称 美元,欧元,人民币等, > > currency_type :货币类型 ```mysql CREATE TABLE `currency` ( `id` int NOT NULL AUTO_INCREMENT, `currency_code` bigint DEFAULT NULL, `currency_name` varchar(255) DEFAULT NULL, `currency_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '币种类型', `state` int DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='币种'; ```