const system = require("../../system");
const settings = require("../../../config/settings");
const uiconfig = system.getUiConfig2(settings.wxconfig.appId);
module.exports = (db, DataTypes) => {
  return db.define("copyrightuserinfo", {
    // 版权代理机构信息表引用用户信息
    // this.db.models.workcrsubmit.belongsTo(this.db.models.user, { as: 'createuser', constraints: false, });
    // this.db.models.workcrsubmit.belongsTo(this.db.models.user, { as: 'updateuser', constraints: false, });

    sourceOrderNo: DataTypes.STRING(50),//来源单号--订单号
    name: DataTypes.STRING,
    addrInfo: DataTypes.STRING,
    zipCode: DataTypes.STRING,
    customerContact: DataTypes.STRING,
    tel: DataTypes.STRING,
    email: DataTypes.STRING,
    mobile: DataTypes.STRING,
    fax: DataTypes.STRING,//传真
    entrustDesc: DataTypes.STRING,//申请人委托下述代理人说明信息

  }, {
      paranoid: true,//假的删除
      underscored: true,
      version: true,
      freezeTableName: true,
      //freezeTableName: true,
      // define the table's name
      tableName: 'cr_copyright_userinfo',
      validate: {
      }
    });
}
