한국어
Golang serverless backend for STMT Application
AUTH (Authentication is not required only in this part)
PK SK Inverted GSI
AppID, SK GSI (H: SK, SK: AppID)
all in one table
PK
SK
AppID
nickname
profile
USER#uuid
PROFILE#email
Hashed AppID
Nickname
imgUrl
PK
SK
USER#uuid
OPEN#ACCOUNT#CODE
USER#uuid
OPEN#RECORD#CODE
USER#uuid
OPEN#TASK#CODE
ACCOUNT OPENNESS (SK) (default: 2)
CODE
SEARCH & FOLLOW REQUEST
OPEN FOLLOW
0
X
X
1
O
X
2
O
O
RECORD OPENNESS (SK) (default: 2)
CODE
RANK FRIENDS
CANDIDATE
RANK ALL
CANDIDATE
0
X
X
1
O
X
2
O
O
TASK OPENNESS (SK) (default: 2)
CODE
FRIENDS
ALL
0
X
X
1
O
X
2
O
O
User get only 6 tasks row
PK
SK
todo
memo
where
willStart
estimatedMinutes
completedAt
createdAt
USER#uuid
TASK#index
[]
1604343057363
USER#uuid
TASK#index
[{"content": "todo", "isCompleted":false, "createdAt": 1604343257363}]
MemoString
hanyang univ
1604343297363
300
1604343441719
1604343257363
PK
SK
LockTime
Tasks
Score
InComplete
Complete
Percent
Duration
RecordOpenness
Nickname
USER#uuid
RECORD#YYYY#MM#WeekOfYear#DayOfYear
timestamp
Array<Task>
33.33
1
2
33.33
timestamp
2
string
PK
SK
ProfileUUID
FollowerEmail
FOLLOWER#uuid
PROFILE#email
uuid
email
PK
SK
REQ#FOLLOW#uuid
PROFILE#email