Database

Firestore Collections

registrations

Key: eHRID

Attributes:

• platform (string; android/ ios)
• platformVersion (string; system version, e.g. 10.0.4)
• manufacturer (string; phone manufacturer, e.g. Samsung)
• model (string; phone model, e.g. Galaxy S7)
• locale (string; phone language, e.g. cs_CZ)
• createdAt (timestamp of creation)
• lastNotificationStatus (string)
• lastNotificationUpdatedAt (timestamp)
• pushRegistrationToken (push token from Firebase Cloud Messaging)

notificationCounters

Key: date (YYYYMMDD DATE) and total

Attributes:

• notificationCount (Int)

dailyNotificationAttemptsEhrid

Key: eHRID

Attributes:

• date (DATE)
• attemptCount (Int)

covidDataTotal

Key: date (YYYYMMDD DATE)

Attributes:

• Date (DATE)
• ActiveCasesTotal (Int)
• CuredTotal (Int)
• DeceasedTotal (Int)
• CurrentlyHospitalizedTotal (Int)
• TestsTotal (Int)
• TestsIncrease (Int)
• TestsIncreaseDate (DATE)
• ConfirmedCasesTotal (Int)
• ConfirmedCasesIncrease (Int)
• ConfirmedCasesIncreaseDate (DATE)
• AntigenTestsTotal (Int)
• AntigenTestsIncrease (Int)
• AntigenTestsIncreaseDate (DATE)
• PCRTestsTotal (Int)
• PCRTestsIncrease (Int)
• PCRTestsIncreaseDate (DATE)
• VaccinationsTotal (Int)
• VaccinationsIncrease (Int)
• VaccinationsIncreaseDate (DATE)
• VaccinationsDailyDosesDate (DATE)
• VaccinationsDailyFirstDose (Int)
• VaccinationsDailySecondDose (Int)
• VaccinationsTotalFirstDose (Int)
• VaccinationsTotalSecondDose (Int)

metrics

Key: date (YYYYMMDD DATE - date of today!)

Attributes:

• Modified (Long)
• Date (DATE)
• ActivationsYesterday (Int)
• ActivationsTotal (Int)
• KeyPublishersYesterday (Int)
• KeyPublishersTotal (Int)
• NotificationsYesterday (Int)
• NotificationsTotal (Int)
• EfgsKeysUploadedTotal (Int)
• EfgsKeysUploadedYesterday (Int)
• EfgsKeysDownloadedTotal (Int)
• EfgsKeysDownloadedYesterday (Int)
• EfgsPublishersTotal (Int)
• EfgsPublishersYesterday (Int)
• EfgsImportedCzTotal (Int)
• EfgsImportedCzYesterday (Int)

vaccinations

Key: date (YYYYMMDD DATE)

Attributes

• Date (DATE)
• Vaccine (Int)
• RegionCode (Int)
• Region (Int)
• AgeGroup (Int)
• FirstDose (Int)
• SecondDose (Int)
• TotalDoses (Int)

Realtime DB

userCounters

Key: date (DATE) and total

Attributes:

• usersCount (Int)

efgsCounters

Key: date (DATE) and total

Attributes:

• keysUploaded (Int)
• keysDownloaded (Int)
• keysImportedCZ (Int)
• publishers (Int)

publisherCounters

Key: date (DATE) and total

Attributes:

• publishersCount (Int)
• keysCount (Int)