import { model, Schema, ObjectId } from 'mongoose';

/**
 * User schema for MongoDB.
 * @type {module:mongoose.Schema}
 */
export const spendHistorySchema = new Schema(
    {
        venue: {
            type: String,
            required: true,
            immutable: true
        },
        reason: {
            type: String,
            required: true,
            immutable: true
        },
        amount: {
            type: Number,
            required: true,
            immutable: true
        }
    },
    {
        timestamps: {
            createdAt: true,
            updatedAt: false
        },
        timeseries: {
            timeField: 'createdAt'
        }
    }
);

export const DbSpendHistory = model('spendHistory', spendHistorySchema);

console.log('[MONGODB] spendHistory schema initialized successfully!');