Contact (or addressbook entry)
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Primary key | |
| vdb_id | Integer | ||
| creator_id | Integer | db_user.id | Owner |
| folder_id | Integer | db_folder.id | Document folder ID |
| visible_to_company | Boolean (t or f) | Is public? | |
| kind | Integer | ||
| first_name | String | First Name | |
| middle_name | String | ||
| last_name | String | Last Name | |
| category | Integer | ||
| String | |||
| nickname | String | Nickname | |
| company_name | String | Company Name | |
| title | String | Job Title | |
| home_phone | String | ||
| mobile_phone | String | ||
| work_phone | String | ||
| pager_number | String | ||
| fax | String | ||
| other_phone | String | ||
| primary_location | Integer | ||
| work_street | String | ||
| work_city | String | ||
| work_state | String | ||
| work_zip | String | ||
| work_country | String | ||
| home_street | String | ||
| home_city | String | ||
| home_state | String | ||
| home_zip | String | ||
| home_country | String | ||
| alternate_email_1 | String | ||
| alternate_email_2 | String | ||
| personal_website | String | ||
| company_website | String | ||
| birthdate | Date | ||
| anniversary | Date | ||
| cf1 | String | ||
| cf2 | String | ||
| cf3 | String | ||
| cf4 | String | ||
| comments | String | ||
| created | Date | ||
| deleted | Date |