const Sequelize = require('sequelize');

module.exports = {
  name: {
    type: Sequelize.DataTypes.STRING(100),
    allowNull: false,
    unique: true
  },
  shortName: {
    type: Sequelize.DataTypes.STRING(70),
    allowNull: false
  },
  category: {
    type: Sequelize.DataTypes.STRING(100),
    allowNull: false
  },
  sortId: {
    type: Sequelize.DataTypes.INTEGER,
    allowNull: false,
    defaultValue: 0
  },
  imageUrl: {
    type: Sequelize.DataTypes.STRING(240),
    allowNull: true,
    isUrl: true
  },
  createdById: {
    type: Sequelize.DataTypes.INTEGER,
    allowNull: false,
  },
  lastModifiedById: {
    type: Sequelize.DataTypes.INTEGER,
    allowNull: false,
  },
};