This file describes the relational data model that represents the system entities in the database.
Some design reasons we considered:
- Since e-mail field is queryable, we include separate table with their hash view, to prevent SQL Injections. We do not include them on the
Usertable directly, because we may include additional hash values in the future. Right now we use theSHA-256cryptographic function, as no collisions have been found yet (and most likely won't ever be). - We define auto-gen keys as primary keys instead of relying on domain identity keys. This is done to reduce database size, as primary keys are almost longer than 8 bytes, but long integer values are always 8 bytes each.
Affected Usersentity will be a view for fast access.
Note: We refer to generating the next available unique integer as autogen in the data model diagram, for primary key definition. Do not confuse with AUTOINCREMENT keyword from SQLite, we don't use it.
