Stores resources, contacts, clients and users
Column | Type | References | Comments | ||||
id | Integer | Primary key | |||||
vdb_id | Integer | ||||||
guid | String | ||||||
created | Date | ||||||
name | String | Name of the user | |||||
login_name | String | Login name | |||||
pwd | String | Encrypted password | |||||
pwd_changed_at | Date | ||||||
phone | String | ||||||
String | Email Address | ||||||
keywords | String | Keywords related to this user e.g. skills, qualifications | |||||
archived | Date | Date on which this user was archived | |||||
discriminator | Integer | 4 = contact, 24 = user, 63 = client | |||||
folder_id | Integer | db_folder.id | ID of the personal document folder of this user | ||||
is_public | Boolean (t or f) | Is this record viewable by anyone in the company | |||||
creator_id | Integer | Creator Id | |||||
in_out_status | String | ||||||
in_out_updated_on | Date | ||||||
is_in | Boolean (t or f) | If this user is in or out | |||||
last_access | Date | The last time the user accessed the system | |||||
parent_id | Integer | The parent of this record. In case of client this is the ID of the parent. | |||||
path | String | Path separated by '/' from root user object. | |||||
locale_id | String | ||||||
time_zone_id | String | Time zone ID of this user | avatar_src | String | f = facebook, t = twitter, a = anonymous | ||
avatar_id_at_src | String | Facebook profile ID or twitter handle | |||||
calendar_id | Integer | db_working_calendar.id | The working calendar of this user | custom_field_string | String | (New column since v9.1) Includes a JSON formatted string of all custom fields attached to this entity |