| | |
|---|
| | | `role_id` int NULL DEFAULT NULL COMMENT '角色id', |
|---|
| | | `logo_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'logo地址', |
|---|
| | | `rate` double(10, 2) NULL DEFAULT NULL COMMENT '费率', |
|---|
| | | `icbc_partner_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '工行合作商ID', |
|---|
| | | `icbc_sub_mer_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '工行二级商户编号', |
|---|
| | | `icbc_sub_mer_prtcl_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '工行二级商户协议编号', |
|---|
| | | `icbc_mer_acct` varchar(34) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '工行直接分账商户清算账号', |
|---|
| | | `electricity_share_ratio` decimal(5, 2) NULL DEFAULT NULL COMMENT '电费分成比例', |
|---|
| | | `service_share_ratio` decimal(5, 2) NULL DEFAULT NULL COMMENT '服务费分成比例', |
|---|
| | | `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '注册地址', |
|---|
| | | `phone_one` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '合作商电话1', |
|---|
| | | `phone_two` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '合作商电话2', |
|---|
