| Id | Integer | The unique id number of the record |
| Phone1 | VarChar | The first phone number in the record |
| Phone2 | VarChar | The second phone number in the record |
| Phone3 | VarChar | The third number in the record |
| Fax | VarChar | Fax number in the record |
| Phone1Type | VarChar | What type the first phone record is (mobile, landline etc) |
| Phone2Type | VarChar | What type the second phone record is (mobile, landline etc) |
| Phone3Type | VarChar | What type the third phone record is (mobile, landline etc) |
| PrimaryPhone | Integer | Which record is the primary phone number |
| Email1 | VarChar | The first email in the record |
| Email2 | VarChar | The second email in the record |
| PrimaryEmail | Integer | Which record is the primary email |
| Email1Type | VarChar | What type of email the first email record is (business or personal etc) |
| Email2Type | VarChar | What type of email the second email record is (business or personal etc) |
| Im1 | VarChar | The first instant messaging profile account in the record |
| Im2 | VarChar | The second instant messaging profile account in the record |
| Im1Type | VarChar | What type of account the first instant messaging record is |
| Im2Type | VarChar | What type of account the second instant messaging record is |
| Web | VarChar | A website for the contact |
| Notes | Blob | Any notes saved in the contacts record |
| Saved | Boolean True/False | Whether the record is saved or not |
| Creator | Integer | The unique id record of the user that created the record |
| Created | DateTime | The time the record was originally created |
| Modified | DateTime | The last time the record was modified. |
| | |
