Skip to content
This repository has been archived by the owner on Sep 21, 2024. It is now read-only.

Database Schema

Garrett Welson edited this page Aug 10, 2019 · 2 revisions
{
  "userID": "UUID",
  "email": "string",
  "firstName": "string",
  "lastName": "string",
  "accounts": [
    {
      "name": "string",
      "transactions": {
        "year (int)": {
          "month (int)": [
            {
              "id": "UUID",
              "amount": "int",
              "category": "string",
              "date": "date",
              "payee": "string",
              "recurring": "bool"
            }
          ]
        }
      },
      "type": "checking"
    }
  ],
  "recurringTransactions": [
    {
      "id": "UUID",
      "amount": "int",
      "category": "string",
      "payee": "string",
      "startDate": "date",
      "frequency": "daily || weekly || monthly || yearly"
    }
  ],
  "budgetCategories": [
    {
      "id": "UUID",
      "name": "string",
      "allotment": {
        "year (int)": {
          "month (int)": "allotment (int)"
        }
      }
    }
  ],
  "notifications": [null]
}
Clone this wiki locally