Ensure database record index semantics are clear

[lukevalenta]

After the change of the database data structure from a map to a list, the id is no longer a unique identifier for a record, but an index. We should make sure that this change is clear throughout the project.