match_inputs.ts 2.5 KB
/* jshint indent: 2 */

module.exports = function(sequelize:any, DataTypes:any) {
  return sequelize.define('match_inputs', {
    id: {
      type: DataTypes.BIGINT,
      allowNull: false,
      primaryKey: true
    },
    infoid: {
      type: DataTypes.BIGINT,
      allowNull: true
    },
    updateflag: {
      type: DataTypes.BIGINT,
      allowNull: true
    },
    gamename: {
      type: DataTypes.STRING(255),
      allowNull: true
    },
    matchstate: {
      type: DataTypes.STRING(255),
      allowNull: true
    },
    matchtime: {
      type: DataTypes.DATE,
      allowNull: false,
      defaultValue: sequelize.literal('CURRENT_TIMESTAMP')
    },
    matchnumber: {
      type: DataTypes.STRING(255),
      allowNull: true
    },
    lotteryid: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    issueid: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    issuename: {
      type: DataTypes.STRING(255),
      allowNull: true
    },
    hostid: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    hostname: {
      type: DataTypes.STRING(255),
      allowNull: true
    },
    guestid: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    guestname: {
      type: DataTypes.STRING(255),
      allowNull: true
    },
    body: {
      type: DataTypes.JSON,
      allowNull: true
    },
    createdAt: {
      type: DataTypes.DATE,
      allowNull: false,
      defaultValue: sequelize.literal('CURRENT_TIMESTAMP')
    },
    updatedAt: {
      type: DataTypes.DATE,
      allowNull: false,
      defaultValue: sequelize.literal('CURRENT_TIMESTAMP')
    },
    content: {
      type: DataTypes.JSON,
      allowNull: true
    },
    letscore: {
      type: DataTypes.STRING(255),
      allowNull: true
    },
    bcbf: {
      type: DataTypes.STRING(255),
      allowNull: true
    },
    qcbf: {
      type: DataTypes.STRING(255),
      allowNull: true
    },
    sportsinfo: {
      type: DataTypes.JSON,
      allowNull: true
    },
    sportslive: {
      type: DataTypes.JSON,
      allowNull: true
    },
    sportslineup: {
      type: DataTypes.JSON,
      allowNull: true
    },
    sportsinjury: {
      type: DataTypes.JSON,
      allowNull: true
    },
    dfcpimgurl: {
      type: DataTypes.STRING(255),
      allowNull: true
    },
    jcinfo: {
      type: DataTypes.JSON,
      allowNull: true
    },
    livedata_status: {
      type: DataTypes.JSON,
      allowNull: true
    },
    livedata: {
      type: DataTypes.JSON,
      allowNull: true
    }
  }, {
    tableName: 'match_inputs'
  });
};