src/models/RenewRequest.js

const { mongoose, baseSchemaOptions } = require('./base');

const RenewRequestSchema = new mongoose.Schema({
  gate_pass_id: { type: mongoose.Schema.Types.ObjectId, ref: 'GatePass', required: true },
  employee_id: { type: mongoose.Schema.Types.ObjectId, ref: 'Employee', required: true },
  vendor_id: { type: mongoose.Schema.Types.ObjectId, ref: 'Vendor', required: true },
  requested_issue_date: { type: Date, required: true },
  status: { type: String, enum: ['Requested', 'Approved', 'Rejected', 'Processed'], default: 'Requested' },
  remarks: { type: String, default: null }
}, baseSchemaOptions());

RenewRequestSchema.index({ gate_pass_id: 1 }, { unique: true });

module.exports = mongoose.model('RenewRequest', RenewRequestSchema);