currency.md 764 B

###币种信息表 currency

currency_code :币种国际代码 如USD ERU CNH ,

currency_name : 币种名称 美元,欧元,人民币等,

currency_type :货币类型

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='币种';