ms_order.ts 2.4 KB
/* jshint indent: 2 */

module.exports = function(sequelize:any, DataTypes:any) {
    return sequelize.define('ms_order', {
      id: {
        type: DataTypes.INTEGER(11),
        allowNull: false,
        primaryKey: true,
        autoIncrement: true
      },
      order_number: {
        type: DataTypes.STRING(50),
        allowNull: false,
        unique: true
      },
      order_status: {
        type: DataTypes.INTEGER(11),
        allowNull: true
      },
      user_id: {
        type: DataTypes.INTEGER(11),
        allowNull: true
      },
      user_nick_name: {
        type: DataTypes.STRING(50),
        allowNull: true
      },
      user_name: {
        type: DataTypes.STRING(50),
        allowNull: true
      },
      type: {
        type: DataTypes.STRING(50),
        allowNull: true
      },
      sub_type: {
        type: DataTypes.STRING(50),
        allowNull: true
      },
      title: {
        type: DataTypes.STRING(200),
        allowNull: true
      },
      pay_time: {
        type: DataTypes.DATE,
        allowNull: true
      },
      order_body: {
        type: DataTypes.JSON,
        allowNull: true
      },
      order_coin: {
        type: DataTypes.DECIMAL,
        allowNull: true
      },
      memo: {
        type: DataTypes.STRING(500),
        allowNull: true
      },
      created_at: {
        type: DataTypes.DATE,
        allowNull: true
      },
      lottery_id: {
        type: DataTypes.INTEGER(11),
        allowNull: true
      },
      platform: {
        type: DataTypes.STRING(50),
        allowNull: true
      },
      seller_user_id: {
        type: DataTypes.INTEGER(11),
        allowNull: true
      },
      seller_user_code: {
        type: DataTypes.STRING(50),
        allowNull: true
      },
      seller_photo: {
        type: DataTypes.STRING(500),
        allowNull: true
      },
      issue_name: {
        type: DataTypes.STRING(30),
        allowNull: true
      },
      pay_number: {
        type: DataTypes.STRING(50),
        allowNull: true
      },
      pay_status: {
        type: DataTypes.INTEGER(11),
        allowNull: true
      },
      last_update_time: {
        type: DataTypes.DATE,
        allowNull: true
      },
      pay_money: {
        type: DataTypes.DECIMAL,
        allowNull: true
      },
      account_coin: {
        type: DataTypes.DECIMAL,
        allowNull: true
      }
    }, {
      tableName: 'ms_order'
    });
  };