-
Notifications
You must be signed in to change notification settings - Fork 0
/
.dbSchema
67 lines (50 loc) · 1.4 KB
/
.dbSchema
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
dataTypes
--------------
string, number, boolean, map, array, null, timestamp, geopoint, reference (document path)
users (external - from Firebase - https://firebase.google.com/docs/reference/js/firebase.User)
--------------
displayName string | null
email string | null
emailVerified boolean
phoneNumber string | null
photoURL string | null
uid string
users (internal) ???
--------------
ext_user_id string
user_id INT
expenses (https://plaid.com/docs/#transactions)
--------------
user_id string
expense_id string
account_id string
category [string] | null
name string
amount number
iso_currency_code string | null
date timestamp
location geopoint | null
pending boolean
income - TODO
--------------
goals
--------------
goal_id string
image string | null
name string
description string | null
price number
time timestamp | null?
priority number (0-4)
categories_expenses
--------------
category_id string
name string
budget - TODO
--------------
budget_id
category_id
time
amount
categories_income - TODO
--------------