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

###商户基本信息表 merchant

username :用戶名字,

phone:手机号,

password:密碼,

pause_transfer:是否暂停转账, （0：否，1：是）,

pause_login:是否暂停登录,停用账户，（0：否，1：是）,

transfer_fee_type:付款手续费收取形式(0:内扣;1:外扣;) ,

join_fee:开户费,

annual_fee:年服务费,

transfer_fee:外币付款手续费(USD),

transfer_fee_cny:人民币付款手续费(USD),

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 '开户费',
       `annual_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='商户基本信息表';