cross-border-payment/doc/model/merchant_struct.md

###商户基本信息表 merchant

CREATE TABLE `merchant` (
       `id` int NOT NULL AUTO_INCREMENT,
       `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
       `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
       `deleted_at` datetime DEFAULT NULL COMMENT '修改时间',
       `username` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用戶名字',
       `phone` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手机号',
       `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '密碼',
       `salt` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '加密盐',
       `state` tinyint NOT NULL DEFAULT '0' COMMENT '状态 0:关停,1:激活,2:待激活,3:待审核',
       `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '头像',
       `email` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '邮箱',
       `pause_transfer` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否暂停转账（0：否，1：是）',
       `pause_login` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否暂停登录（0：否，1：是）',
       `transfer_fee_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '付款手续费收取形式(0:内扣;1:外扣;) ',
       `join_fee` decimal(10,2) NOT NULL COMMENT '开户费',
       `anual_fee` decimal(10,2) NOT NULL COMMENT '年服务费',
       `transfer_fee` decimal(10,2) NOT NULL COMMENT '外币付款手续费(USD)',
       `transfer_fee_cny` decimal(10,2) NOT NULL COMMENT '人民币付款手续费(USD)',
       `confirm_token` varchar(64) NOT NULL COMMENT '开户验证码 （google登陆验证器token）',
       PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='商户基本信息表';