Database Design

Jump to bottom

Sylvia Huang [SSW] edited this page May 10, 2023 · 6 revisions

Users

_id (6-digit number string padded with 0)
_openid
name (String)
alias (String)
roles (Array[String])
balance (Number)
wallet (Array)
- card_id
- card_type (String)
- activation_date (Date)
- expiration_date (Date)
- balance (Number)

Visits

user_id
date (Date)
card_id
location (String/GeoPoint)