> No foreign keys, many things were done in the code itself (filtering, sorting, etc, to make sure the DB only ever uses the most efficient indexes)

This normally is terrible advice. You have to be sure that you really need it. Too often I see developers do this needlessly.