db_person
- Former user (Deleted)
- Rashmi Likhite
- Sanket Pai (Unlicensed)
Owned by Former user (Deleted)
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 |