User Settings save location

I’m having problems trying to locate where a Users settings are saved, I wrongly assumed all were saved to the following tables:

  • user
  • user_cstm
  • user_preferences

I can find some of the fields, but for lots are missing i.e. timezone. I have noticed user_preferences has a content field, can someone confirm if this is a hashed value based on user settings?

TIA

John