fix(db): close four silent data-correctness gaps in the DB layer (#332, #335, #336, #339)

fix(db): close four silent data-correctness gaps in the DB layer (#332, #335, #336, #339) #400