web/models/request.js

const Sequelize = require('sequelize')

const { DataTypes } = Sequelize

module.exports = (sequelize) => {
  const Request = sequelize.define(
    'Request',
    {
      ip: {
        type: DataTypes.TEXT,
        allowNull: true,
      },
      path: {
        type: DataTypes.TEXT,
        allowNull: false,
      },
      referrer: {
        type: DataTypes.TEXT,
        allowNull: true,
      },
      userAgent: {
        type: DataTypes.TEXT,
        allowNull: true,
      },
    },
    {
      indexes: [
        { fields: ['referrer'] },
        { fields: ['ip'] },
      ]
    }
  )
  return Request
}