const coreModel = require("./../core/models");

module.exports = (sequelize, DataTypes) => {
  const Review = sequelize.define(
    "review",
    {
      id: { type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true },
      notes: DataTypes.STRING,
      movie_id: DataTypes.INTEGER,
    },
    {
      timestamps: true,
      freezeTableName: true,
      tableName: "review",
    }
  );

  coreModel.call(this, Review);

  Review.associate = function (models) {
    Review.belongsTo(models.movie, {
      foreignKey: "movie_id",
      as: "movie",
      constraints: false,
    });
  };

  Review.allowFields = function () {
    return ["id", "notes", "movie_id"];
  };

  return Review;
};