models/Order.js

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

const Order = sequelize.define('Order', {
  id: {
    type: DataTypes.UUID,
    defaultValue: DataTypes.UUIDV4,
    primaryKey: true
  },
  description: {
    type: DataTypes.TEXT,
    allowNull: false
  },
  totalAmount: {
    type: DataTypes.DECIMAL(10, 2),
    defaultValue: 0.00,
    allowNull: false
  },
  status: {
    type: DataTypes.ENUM('PENDING', 'ORDER_PLACED', 'DELIVERED', 'CANCELLED', 'RETURNED'),
    defaultValue: 'ORDER_PLACED',
    allowNull: false
  }
});

module.exports = Order;