module.exports = (sequelize, DataTypes) => {
  const meeting = sequelize.define('meeting', {
    id: {
      type: DataTypes.INTEGER(10).UNSIGNED,
      autoIncrement: true,
      allowNull: false,
      primaryKey: true,
    },
    category_id: {
      type: DataTypes.INTEGER(10),
      allowNull: false,
    },
    status_id: {
      type: DataTypes.INTEGER(10),
      allowNull: false,
    },
    user_mask_id: {
      type: DataTypes.STRING(45),
      allowNull: false,
    },
    id_team: {
      type: DataTypes.STRING(45),
      allowNull: false,
    },
    title: {
      type: DataTypes.STRING(200),
      allowNull: true,
    },
    descrip: {
      type: DataTypes.TEXT,
      allowNull: true,
    },
    date: {
      type: DataTypes.DATE,
      allowNull: true,
    },
    created_at: {
      type: 'TIMESTAMP',
      allowNull: true,
    },
    updated_at: {
      type: 'TIMESTAMP',
      allowNull: true,
    },
    deleted_at: {
      type: 'TIMESTAMP',
      allowNull: true,
    },
  },
  {
    tableName: 'meetings',
    createdAt: 'created_at',
    updatedAt: 'updated_at',
    undercored: true,
    deletedAt: 'deleted_at',
    paranoid: true
  });

  meeting.associate = (models) => {
    meeting.belongsTo(models.user_mask, {
      foreignKey: 'user_mask_id',
      targetKey: 'id',
      as: 'meetingOwner'
    });
    meeting.belongsTo(models.category, {
      foreignKey: 'category_id',
      targetKey: 'id',
      as: 'meetingCategory'
    });
    meeting.belongsTo(models.statusV2, {
      foreignKey: 'status_id',
      targetKey: 'id',
      as: 'meetingStatus'
    });
    meeting.belongsToMany(models.user_mask, {
      through: 'meetingMember',
      as: 'users',
      foreignKey: 'meeting_id',
      otherKey: 'user_mask_id'
    });
  };
  return meeting;
};