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| username | String | | Login name |
pwd| password_hash | String | | Encrypted password |
| password_changed | Date | | |
| phone | String | | |
| email | 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| accessed | 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_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 handlecustom_field_string | String | | (New column since v9.1) Includes a JSON formatted string of all custom fields attached to this entity.