audiobookshelf/server/models/MediaFile.js

const { DataTypes, Model } = require('sequelize')

module.exports = (sequelize) => {
  class MediaFile extends Model { }

  MediaFile.init({
    id: {
      type: DataTypes.UUID,
      defaultValue: DataTypes.UUIDV4,
      primaryKey: true
    },
    formatName: DataTypes.STRING,
    formatNameLong: DataTypes.STRING,
    duration: DataTypes.FLOAT,
    bitrate: DataTypes.INTEGER,
    size: DataTypes.BIGINT,
    tags: DataTypes.JSON
  }, {
    sequelize,
    modelName: 'mediaFile'
  })

  const { fileMetadata } = sequelize.models

  fileMetadata.hasOne(MediaFile, { foreignKey: 'fileMetadataId' })
  MediaFile.belongsTo(fileMetadata, { as: 'fileMetadata', foreignKey: 'fileMetadataId' })

  return MediaFile
}