models/a_ref.js

/* Models different types of references between two sections, e.g.
 * \x from one link to the other. */

const ourbigbook = require('../index');

module.exports = (sequelize) => {
  const { DataTypes } = sequelize.Sequelize
  const ARef = sequelize.define(
    'ARef',
    {
      to: {
        type: DataTypes.TEXT,
        allowNull: false,
      },
      defined_at_line: {
        type: DataTypes.INTEGER,
      },
      defined_at_col: {
        type: DataTypes.INTEGER,
      },
    },
    {
      indexes: [
        { fields: ['from', 'defined_at_line', 'defined_at_col'], unique: true },
        { fields: ['from', 'to'], },
        { fields: ['to', 'from'], },
      ],
    }
  )
  return ARef;
}