Database and Collections

MongoDB is used as the main database solution for this application. MongoDB stores tables as collections inside databases. Fields in collections are documents and are of the type: JSON.

Database

receipts

Collections

receipt

• _id
• storeName
• amountCurrency
• typeOfCurrency
• date
• typeOfReceipt

type

• _id
• typeName
• typeDesc

users

• _id
• username
• passwd (encrypted)
• valid true/false
• signupDate

user_log

• _id
• user_id
• timestamp
• action (last performed action)