diff --git a/src/db/schemas/spendHistory.js b/src/db/schemas/spendHistory.js
index b12bcc3..b4c3f20 100644
--- a/src/db/schemas/spendHistory.js
+++ b/src/db/schemas/spendHistory.js
@@ -1,29 +1,39 @@
-import { model, Schema } from 'mongoose';
-import { hash, compare } from 'bcrypt';
-import {ref} from "joi";
+import { model, Schema, ObjectId } from 'mongoose';
/**
* User schema for MongoDB.
* @type {module:mongoose.Schema}
*/
-export const spendHistorySchema = new Schema({
- spentBy: {
- type: ObjectId,
- ref: "users"
+export const spendHistorySchema = new Schema(
+ {
+ venue: {
+ type: String,
+ required: true,
+ immutable: true
+ },
+ items: {
+ type: [String],
+ required: true,
+ immutable: true
+ },
+ cost: {
+ type: Number,
+ required: true,
+ immutable: true
+ },
+ createdAt: {
+ type: Date,
+ default: Date.now,
+ immutable: true
+ }
+ },
+ {
+ timeseries: {
+ timeField: 'createdAt'
+ }
}
- createdAt: {
- type: Date,
- default: Date.now,
- immutable: true
- }
-});
-
-export const UserType = Object.freeze({
- USER: 'user',
- MONITOR: 'monitor',
- ADMIN: 'admin'
-});
+);
-export const DbUser = model('user', userSchema);
+export const DbSpendHistory = model('spendHistory', spendHistorySchema);
-console.log('[MONGODB] User schema initialized successfully!');
+console.log('[MONGODB] spendHistory schema initialized successfully!');
|