Depends on what version of confluence you're on, what user management system you're using and what data you want from the profile.
Start with the tables named CWD* though, for more recent versions of Confluence
Ok, that's a start. You still need to look at the CWD table if you're using internal users because the keys on it are used to tie data to users.
You'll need to define exactly what you mean by "profile data" though because there's several things you might mean, and data on users is held in many places.
Taking the one item you have named as an example... the file is treated as an attachment, and to find out what profile picture is tied to a user, you get the user's ID, then look in "values" to find out what to look for in "attachments"
Hi my Community friends! For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs