Contacts
The table below describes the Contacts table.
This table contains the following foldable columns:
- Contact_Id
- Account_Id
- Vendor_Id
- Assistant
- Asst_Phone
- Campaign_Source
- Contact_Owner
- Created_Time
- Date_Of_Birth
- Department
- Email_Opt_Out
- Fax
- First_Name
- Home_Phone
- Last_Activity_Time
- Last_Name
- Lead_Source
- Mailing_City
- Mailing_Country
- Mailing_State
- Mailing_Street
- Mailing_Zip
- Mobile
- Modified_Time
- Other_City
- Other_Country
- Other_Phone
- Other_State
- Other_Street
- Other_Zip
- Phone
- Reports_To
- Salutation
- Secondary_Email
- Skype_ID
- Title
This table does not contain Return Primary Key columns.
| Column Name | SQL Type | Updatable | Nullable |
|---|---|---|---|
|
Contact_Id Primary Key |
SQL_VARCHAR(40) | False | False |
|
Account_Id Foreign Key linked to column Account_Id in Accounts table |
SQL_VARCHAR(40) | False | True |
|
Modified_By_Id Foreign Key linked to column User_Id in Users table |
SQL_VARCHAR(40) | False | True |
|
Sm_Creator_Id Foreign Key linked to column User_Id in Users table |
SQL_VARCHAR(40) | False | True |
|
Sm_Owner_Id Foreign Key linked to column User_Id in Users table |
SQL_VARCHAR(40) | False | True |
|
Vendor_Id Foreign Key linked to column Vendor_Id in Vendors table |
SQL_VARCHAR(40) | False | True |
|
Account_Name |
SQL_VARCHAR(100) | True | True |
|
Assistant |
SQL_VARCHAR(50) | True | True |
|
Asst_Phone |
SQL_VARCHAR(30) | True | True |
|
Campaign_Id |
SQL_VARCHAR(40) | False | True |
|
Campaign_Source |
SQL_VARCHAR(255) | True | True |
|
Contact_Image |
SQL_VARCHAR(255) | True | True |
|
Contact_Owner |
SQL_VARCHAR(120) | True | True |
|
Contact_Owner_Email |
SQL_VARCHAR(255) | True | True |
|
Created_By |
SQL_VARCHAR(25) | True | True |
|
Created_Time |
SQL_TIMESTAMP | False | True |
|
Date_Of_Birth |
SQL_VARCHAR(80) | True | True |
|
Department |
SQL_VARCHAR(50) | True | True |
|
Description |
SQL_LONGVARCHAR(10000) | True | True |
|
|
SQL_VARCHAR(100) | True | True |
|
Email_Opt_Out |
SQL_BIT | True | True |
|
Fax |
SQL_VARCHAR(30) | True | True |
|
First_Name |
SQL_VARCHAR(40) | True | True |
|
Home_Phone |
SQL_VARCHAR(30) | True | True |
|
Last_Activity_Time |
SQL_TIMESTAMP | True | True |
|
Last_Name |
SQL_VARCHAR(80) | True | True |
|
Lead_Source |
SQL_VARCHAR(120) | True | True |
|
Mailing_City |
SQL_VARCHAR(30) | True | True |
|
Mailing_Country |
SQL_VARCHAR(30) | True | True |
|
Mailing_State |
SQL_VARCHAR(30) | True | True |
|
Mailing_Street |
SQL_VARCHAR(250) | True | True |
|
Mailing_Zip |
SQL_VARCHAR(30) | True | True |
|
Mobile |
SQL_VARCHAR(30) | True | True |
|
Modified_By |
SQL_VARCHAR(25) | False | True |
|
Modified_Time |
SQL_TIMESTAMP | False | True |
|
Other_City |
SQL_VARCHAR(30) | True | True |
|
Other_Country |
SQL_VARCHAR(30) | True | True |
|
Other_Phone |
SQL_VARCHAR(30) | True | True |
|
Other_State |
SQL_VARCHAR(30) | True | True |
|
Other_Street |
SQL_VARCHAR(250) | True | True |
|
Other_Zip |
SQL_VARCHAR(30) | True | True |
|
Phone |
SQL_VARCHAR(50) | True | True |
|
Reporting_To_Id |
SQL_VARCHAR(255) | False | True |
|
Reporting_To_Name |
SQL_VARCHAR(255) | False | True |
|
Reports_To |
SQL_VARCHAR(50) | True | True |
|
Salutation |
SQL_VARCHAR(25) | True | True |
|
Secondary_Email |
SQL_VARCHAR(100) | True | True |
|
Skype_ID |
SQL_VARCHAR(50) | True | True |
|
Title |
SQL_VARCHAR(100) | True | True |
|
|
SQL_VARCHAR(50) | True | True |
|
Vendor_Name |
SQL_VARCHAR(120) | True | True |