src/models/PriceRecord.js

// src/models/PriceRecord.js
// ---------------------------------------------------------------
// MongoDB schema for storing daily gold & silver prices.
// Used for historical graph data (1M, 3M, 6M, 1Y, 3Y).
// ---------------------------------------------------------------

const mongoose = require('mongoose');

const priceRecordSchema = new mongoose.Schema({
  date:       { type: String, required: true, unique: true, index: true }, // YYYY-MM-DD
  gold24k:    { type: Number, required: true },                           // INR per gram
  silver999:  { type: Number },                                            // INR per gram
  source:     { type: String, default: 'IBJA' }
});

module.exports = mongoose.model('PriceRecord', priceRecordSchema);