some questions about tables :)

Hi Cem, you know, Einstein says that what led him away was that he could not bear not to understand something.
I believe that to get a better answer, it would be better to explain your idea with an example. What kind of field do you want to add to accounts and why?

Yes you are right :)
Doctors will have their web sites of their medical centers etc. through our portal.

I did some integration to my UNA SITE so that when the doctors  login, they will see in the homepage menu toolbar an icon that links to  a custom page with an iframe.

 I dont want the user to go out of the portal to manage their web page.

This page will tell them their SITEMAGIC CMS usernames and passwords etc. I put these informations inside sys_accounts with additional fields. Cause I was only able to see the ID of the logged in user from sys_accounts table and this doesnt (always) match to the one in persons_data .
For example one of the members:

in sys_accounts table is id, profile_id 52 111

in persons_data id, author 48,110

So in my code I was able to discover the ID from sys_account table. But when I wanted to check this user from persons_data I can not match any field to find the user there with the id of the sys_account. 

I was not able to discover the profile_id of persons_data in my code :(

Ok Baloo may be I was sleepless and I didnt see the bx_get_logged_profile_id () function in profiles.inc.php :)

These functions are very useful indeed.

Now it fixed the problem.
Thanks alot  for your intention to help :)

Now I can see that the table sys_profiles is linking sys_accounts and persons_data with these fields:

 id account_id type content_id  
Now everything is easier :)

OOO Leonid why you didnt tell me last night :)))
Look at the attachment 😅 

Are you sure of being a doctor? it is not normal, I know how to read what you write! :-))))

I did this table today in the morning in between patient visits  :)

As my experience  of php is older I am not very familiar to read the object oriented syntax. But I am getting used to :)

(Now i think that for the other software integrations which are not directly related to UNA functions it is better to create different tables not to mix the things.)