开放平台品牌合作商配置表

CREATE TABLE cooperation_config ( id bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID', operator_id varchar(64) NOT NULL COMMENT '品牌合作商ID/品牌合作商组织机构代码', operator_name varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '品牌合作商名称', source_type_key varchar(16) NOT NULL COMMENT '配置的订单渠道编码(内部确定)',

access_url varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '回调品牌合作商的url', operator_secret varchar(64) NOT NULL COMMENT '品牌合作商秘钥 (OperatorSecret)', sig_secret varchar(64) NOT NULL COMMENT '签名秘钥 (SigSecret)', data_secret varchar(64) NOT NULL COMMENT '消息密钥 (DataSecret)', data_secret_iv varchar(64) NOT NULL COMMENT '消息初始化向量 (DataSecretIV)',

status tinyint NOT NULL DEFAULT '0' COMMENT '合作商状态：0=正常', bank varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '开户银行', bank_address varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '开户行地址',

contact_person varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '联系人', contact_tel varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '联系电话', contact_mail varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '联系邮箱', contact_address varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '联系地址', create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', update_by varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, PRIMARY KEY (id) USING BTREE, UNIQUE KEY idx_operator_id (operator_id) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COMMENT='开放平台品牌合作商配置';

import java.sql.Timestamp;

public class CooperationConfig { private Long id; private String operatorId; private String operatorName; private String sourceTypeKey; private String accessUrl; private String operatorSecret; private String sigSecret; private String dataSecret; private String dataSecretIv; private Integer status; private String bank; private String bankAddress; private String contactPerson; private String contactTel; private String contactMail; private String contactAddress; private Timestamp createTime; private Timestamp updateTime; private String updateBy;

public Long getId() {
    return id;
}

public void setId(Long id) {
    this.id = id;
}

public String getOperatorId() {
    return operatorId;
}

public void setOperatorId(String operatorId) {
    this.operatorId = operatorId;
}

public String getOperatorName() {
    return operatorName;
}

public void setOperatorName(String operatorName) {
    this.operatorName = operatorName;
}

public String getSourceTypeKey() {
    return sourceTypeKey;
}

public void setSourceTypeKey(String sourceTypeKey) {
    this.sourceTypeKey = sourceTypeKey;
}

public String getAccessUrl() {
    return accessUrl;
}

public void setAccessUrl(String accessUrl) {
    this.accessUrl = accessUrl;
}

public String getOperatorSecret() {
    return operatorSecret;
}

public void setOperatorSecret(String operatorSecret) {
    this.operatorSecret = operatorSecret;
}

public String getSigSecret() {
    return sigSecret;
}

public void setSigSecret(String sigSecret) {
    this.sigSecret = sigSecret;
}

public String getDataSecret() {
    return dataSecret;
}

public void setDataSecret(String dataSecret) {
    this.dataSecret = dataSecret;
}

public String getDataSecretIv() {
    return dataSecretIv;
}

public void setDataSecretIv(String dataSecretIv) {
    this.dataSecretIv = dataSecretIv;
}

public Integer getStatus() {
    return status;
}

public void setStatus(Integer status) {
    this.status = status;
}

public String getBank() {
    return bank;
}

public void setBank(String bank) {
    this.bank = bank;
}

public String getBankAddress() {
    return bankAddress;
}

public void setBankAddress(String bankAddress) {
    this.bankAddress = bankAddress;
}

public String getContactPerson() {
    return contactPerson;
}

public void setContactPerson(String contactPerson) {
    this.contactPerson = contactPerson;
}

public String getContactTel() {
    return contactTel;
}

public void setContactTel(String contactTel) {
    this.contactTel = contactTel;
}

public String getContactMail() {
    return contactMail;
}

public void setContactMail(String contactMail) {
    this.contactMail = contactMail;
}

public String getContactAddress() {
    return contactAddress;
}

public void setContactAddress(String contactAddress) {
    this.contactAddress = contactAddress;
}

public Timestamp getCreateTime() {
    return createTime;
}

public void setCreateTime(Timestamp createTime) {
    this.createTime = createTime;
}

public Timestamp getUpdateTime() {
    return updateTime;
}

public void setUpdateTime(Timestamp updateTime) {
    this.updateTime = updateTime;
}

public String getUpdateBy() {
    return updateBy;
}

public void setUpdateBy(String updateBy) {
    this.updateBy = updateBy;
}

}