Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Stores resources, contacts, clients and users

ColumnTypeReferencesComments
idInteger Primary key
vdb_idInteger  
guidString  
createdDate  
nameString Name of the user
login_name
usernameString Login name
pwd
password_hashString Encrypted password
pwd
password_changed
_at
Date  
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_
access
accessedDate 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
_id
String  
time_zone
_id
String Time zone ID of this user
calendar_idIntegerdb_working_calendar.idThe working calendar of this user