db_person
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 | |
| username | String | Login name | |
| password_hash | String | Encrypted password | |
| password_changed | 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_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 | String | ||
| time_zone | String | Time zone ID of this user | |
| calendar_id | Integer | db_working_calendar.id | The working calendar of this user |