Problems with timestamps in the database
All tables should be provided with a created_at and updated_at timestamp.
The timestamp column that exists in some tables is ambiguous and could stand for a created_at, updated_at or deleted_at. This column should be adapted to the convention and should be renamed to one of created_at, updated_at or deleted_at.
The last_login timestamp in the account table does not update when logging in. Furthermore, the possibility of adding a last_active column in addition to the last_login column should be examined.
Edited by Nils Mittler