If you are creating a contact, it has actually fields from sys_user table, but with a different view [Case View]. So you are actually creating a record in user table when inserting a record in contact table [customer_contact].
Hi
This was also a question, I got confused with. Let me try to explain:
First, the Contact table is just available, if you installed "Custumer Service Management (CSM).
Contacts are used to be persons of any company, that takes part in your CSM Portal.
As Contacts are stored in a table which is EXTENDED by the sys_user table, you will find all contacts also in sys_user.
You can have a look at the "class" column (see screenshot below), to find out, if a record is a "Contact" or a "User".
Normally, now every Contact will be able to LogIn. You need to fill in the "UserID" field of the Contact record, to allow that user to login.
On the other side, Users are the basic objects and intended to log on to the system, whereas a Contact primarily MAY be a user to log in.
If you want to "CONVERT" a user to a Contact, you just need to UPDATE the "CLASS" column of that particular User Record to a "Contact".
Thats all. Otherwise, like you wrote, you will get duplicates (caused on the table inheritance).
Let me know, if that answered your questions, and mark my answer as correct and helpful, please.
BR
Dirk
