db_person

Stores resources, contacts, clients and users

ColumnTypeReferencesComments
idInteger Primary key
vdb_idInteger  
guidString  
createdDate  
nameString Name of the user
login_nameString Login name
pwdString Encrypted password
pwd_changed_atDate  
phoneString  
emailString Email Address
keywordsString Keywords related to this user e.g. skills, qualifications
archivedDate Date on which this user was archived
discriminatorInteger 4 = contact, 24 = user, 63 = client
folder_idIntegerdb_folder.idID of the personal document folder of this user
is_publicBoolean (t or f) Is this record viewable by anyone in the company
creator_idInteger Creator Id
in_out_statusString  
in_out_updated_onDate  
is_inBoolean (t or f) If this user is in or out
last_accessDate The last time the user accessed the system
parent_idInteger The parent of this record. In case of client this is the ID of the parent.
pathString Path separated by '/' from root user object.
locale_idString  
time_zone_idString Time zone ID of this user
calendar_idIntegerdb_working_calendar.idThe working calendar of this user