Stores resources, clients and users
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Primary key | |
| vdb_id | Integer | ||
| first_name | String | First name of the user | |
| middle_name | String | ||
| last_name | String | Last name | |
| login_name | String | Login name | |
| pwd | String | Encrypted password | |
| phone | String | ||
| pager_email | String | ||
| String | Email address | ||
| company_id | Integer | db_company.id | |
| created | Date | ||
| archived | Date | Date on which this user was archived | |
| is_client | Boolean (t or f) | If true, then this user is a client | |
| folder_id | Integer | db_folder.id | ID of the personal document folder of this user |
| contact_id | Integer | db_contact.id | ID of the contact information for this user |
| keywords | String | Keywords related to this user. Skills, affiliations, etc. can be entered in this column | |
| cf1 | String | Custom field 1 | |
| cf2 | String | Custom field 2 | |
| cf3 | String | Custom field 3 | |
| in_out_status | String | ||
| in_out_updated_on | Date | ||
| last_access | Date | The last time the user accessed the system | |
| is_in | Boolean (t or f) | If this user is in or out | |
| 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 | |
| calendar_id | Integer | The working calendar of this user |