Aggregate Type
Patient
Tables (in sqlite)
Patient
Patient Address
Patient attributes
Indexes (in indexeddb)
?
| Database | Data | Index |
|---|---|---|
| Sqllite | disk | mem (loaded when accessed) |
| Indexeddb |
| mem |
| mem | ||
| Lovefield with indexeddb | mem | mem |
Encryption Strategy
The android sqlite database is encrypted using sqlcipher. A secure random 256 bit aes encryption key is generated on the device on startup of the app and stored in the app private space.
The indexedDb on the chrome app is currently not encrypted. There is no way to securely generate or store encryption keys in javascript so for secure usage of the chrome app the hard disk of the user must be encrypted.
Tables
Patient
Patient Address
Patient attribute
AddressHierarchyLevel
AddressHierarchyEntry
Concept
EventLogMarker
PatientAttributeType
Configs
LoginLocations
Visit
Encounter
Observation
ErrorLog