models/User.js

const { DataTypes } = require('sequelize');
const { sequelize } = require('../config/database');

const User = sequelize.define('User', {
  id: {
    type: DataTypes.UUID,
    defaultValue: DataTypes.UUIDV4,
    primaryKey: true
  },
  name: {
    type: DataTypes.STRING,
    allowNull: false
  },
  email: {
    type: DataTypes.STRING,
    allowNull: false,
    unique: true,
    validate: {
      isEmail: true
    }
  },
  password: {
    type: DataTypes.STRING,
    allowNull: false
  },
  role: {
    type: DataTypes.ENUM('SUPER_ADMIN', 'TEAM_LEAD', 'TEAM_MEMBER', 'INVENTORY_MANAGER'),
    defaultValue: 'TEAM_MEMBER',
    allowNull: false
  },
  status: {
    type: DataTypes.ENUM('PENDING', 'ACTIVE', 'DEACTIVATED'),
    defaultValue: 'PENDING',
    allowNull: false
  }
});

module.exports = User;