Certain fields have been expanded out but not others. It's probably worth re-doing the database structure from scratch.