Description
The table contains information on contacts.
Columns
The table contains the following columns:
ContactId : int, primary key, allows null: no
The unique item identifier of the contact.
AssigneeUserId : int, allows null: yes
The ID of the user to whom the contact is assigned.
CellPhone : varchar (max 25 chars), allows null: yes
The cell phone number of the contact.
CompanyName : varchar (max 50 chars), allows null: yes
The name of the company that relates to the contact.
ContactPerson : varchar (max 50 chars), allows null: no
The name of the contact.
ContactType : varchar (max 100 chars), allows null: yes
The type of the contact based on a choice list. The values of the choice list are stored in the Validation table. They correspond to the items whose values equal ContactType in the ValidationType column.
Custom1..Custom10 : varchar (max 8000 chars), allows null: yes
The values of custom fields 1 - 10.
These columns correspond to fields that can be available for rich editing.
Date1stContact : datetime, allows null: yes
The date when the first contact with the person was made.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateCallBack : datetime, allows null: yes
The date to call the contact again.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateCreated : datetime, allows null: yes, default: Current date and time
The date and time when the item was created.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateUpdated : datetime, allows null: yes, default: Current date and time
The date and time when the item was last updated.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
Description : varchar (max 1000 chars), allows null: yes
The description of the contact.
This column corresponds to a field that can be available for rich editing.
Email : varchar (max 255 chars), allows null: yes
The e-mail address of the contact.
Fax : varchar (max 25 chars), allows null: yes
The fax number of the contact.
FolderId : int, allows null: yes
The ID of the folder where the item is located.
HomePhone : varchar (max 25 chars), allows null: yes
The home phone number of the contact.
ImportId : int, allows null: yes
If the item was imported, it is the ID of the imported batch.
OtherPhone : varchar (max 25 chars), allows null: yes
Other phone number of the contact.
OutlookId : varchar (max 100 chars), allows null: yes
The column is not used.
OwnerUserId : int, allows null: yes
The ID of the user who owns the contact.
Pager : varchar (max 25 chars), allows null: yes
The pager number of the contact.
PrimaryAddress : varchar (max 1000 chars), allows null: yes
The contact’s primary address.
This column corresponds to a field that can be available for rich editing.
ProjId : int, allows null: yes
The ID of the project that contains the item.
Status : varchar (max 100 chars), allows null: yes
The status of the contact based on a choice list. The values of the choice list are stored in the Validation table. They correspond to the items whose values equal ContactStatus in the ValidationType column.
Title : varchar (max 255 chars), allows null: yes
The title of the contact.
UpdateUserId : int, allows null: yes
The ID of the user who last updated the item.
Website : varchar (max 255 chars), allows null: yes
The web site address of the contact.
WorkPhone : varchar (max 25 chars), allows null: yes
The work phone number of the contact.