| master_id | int(11) | NO | 0 | | | |
| master_guid | varchar(36) | NO | | | | |
| master_opid | varchar(36) | NO | | | | |
| master_enabled | tinyint(1) | YES | 1 | | | |
| master_status | varchar(1) | YES | | | | |
| master_created | datetime | YES | CURRENT_TIMESTAMP | | | |
| master_modified | datetime | NO | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| master_expires | datetime | YES | | | | |
| Id | varchar(18) | NO | | | | |
| IsDeleted | tinyint(1) | YES | | | | |
| MasterRecordId | varchar(0) | YES | | | | |
| AccountId | varchar(18) | YES | | | | |
| LastName | varchar(52) | YES | | | | |
| FirstName | varchar(40) | YES | | | | |
| Salutation | varchar(5) | YES | | | | |
| Name | varchar(87) | YES | | | | |
| RecordTypeId | varchar(18) | YES | | | | |
| OtherStreet | varchar(64) | YES | | | | |
| OtherCity | varchar(16) | YES | | | | |
| OtherState | varchar(2) | YES | | | | |
| OtherPostalCode | varchar(10) | YES | | | | |
| OtherCountry | varchar(13) | YES | | | | |
| OtherLatitude | double | YES | | | | |
| OtherLongitude | double | YES | | | | |
| OtherGeocodeAccuracy | varchar(0) | YES | | | | |
| OtherAddress | varchar(194) | YES | | | | |
| MailingStreet | varchar(141) | YES | | | | |
| MailingCity | varchar(33) | YES | | | | |
| MailingState | varchar(24) | YES | | | | |
| MailingPostalCode | varchar(15) | YES | | | | |
| MailingCountry | varchar(20) | YES | | | | |
| MailingLatitude | double | YES | | | | |
| MailingLongitude | double | YES | | | | |
| MailingGeocodeAccuracy | varchar(0) | YES | | | | |
| MailingAddress | text | YES | | | | |
| Phone | varchar(40) | YES | | | | |
| Fax | varchar(32) | YES | | | | |
| MobilePhone | varchar(34) | YES | | | | |
| OtherPhone | varchar(37) | YES | | | | |
| AssistantPhone | varchar(31) | YES | | | | |
| ReportsToId | varchar(18) | YES | | | | |
| Email | varchar(50) | YES | | | | |
| Title | varchar(128) | YES | | | | |
| Department | varchar(80) | YES | | | | |
| AssistantName | varchar(24) | YES | | | | |
| LeadSource | varchar(39) | YES | | | | |
| Birthdate | datetime(6) | YES | | | | |
| Description | text | YES | | | | |
| OwnerId | varchar(18) | YES | | | | |
| HasOptedOutOfEmail | tinyint(1) | YES | | | | |
| CreatedDate | datetime(6) | YES | | | | |
| CreatedById | varchar(18) | YES | | | | |
| LastModifiedDate | datetime(6) | YES | | | | |
| LastModifiedById | varchar(18) | YES | | | | |
| SystemModstamp | datetime(6) | YES | | | | |
| LastActivityDate | datetime(6) | YES | | | | |
| LastCURequestDate | datetime(6) | YES | | | | |
| LastCUUpdateDate | datetime(6) | YES | | | | |
| LastViewedDate | datetime(6) | YES | | | | |
| LastReferencedDate | datetime(6) | YES | | | | |
| EmailBouncedReason | varchar(254) | YES | | | | |
| EmailBouncedDate | datetime(6) | YES | | | | |
| IsEmailBounced | tinyint(1) | YES | | | | |
| PhotoUrl | varchar(41) | YES | | | | |
| UseSalesforce | varchar(0) | YES | | | | |
| JigsawContactId | varchar(0) | YES | | | | |
| ConnectionReceivedId | varchar(0) | YES | | | | |
| ConnectionSentId | varchar(0) | YES | | | | |
| SFSSDupeCatcher__Override_DupeCatcher__c | tinyint(1) | YES | | | | |
| Direct_Address_Account__c | varchar(28) | YES | | | | |
| Initial_Azalea_Call_Comments__c | text | YES | | | | |
| Initial_Azalea_Call_Date__c | datetime(6) | YES | | | | |
| Initial_Azalea_Call_Temp__c | varchar(4) | YES | | | | |
| iPad_Account__c | tinyint(1) | YES | | | | |
| iPad_Account_Edition__c | varchar(15) | YES | | | | |
| iPad_Account_Password__c | varchar(12) | YES | | | | |
| iPad_Account_User_Name__c | varchar(14) | YES | | | | |
| pi__campaign__c | varchar(41) | YES | | | | |
| pi__comments__c | varchar(179) | YES | | | | |
| pi__conversion_date__c | datetime(6) | YES | | | | |
| pi__conversion_object_name__c | varchar(56) | YES | | | | |
| pi__conversion_object_type__c | varchar(12) | YES | | | | |
| pi__created_date__c | datetime(6) | YES | | | | |
| pi__first_activity__c | datetime(6) | YES | | | | |
| pi__first_search_term__c | varchar(71) | YES | | | | |
| pi__first_search_type__c | varchar(22) | YES | | | | |
| pi__first_touch_url__c | text | YES | | | | |
| pi__grade__c | varchar(0) | YES | | | | |
| pi__last_activity__c | datetime(6) | YES | | | | |
| pi__notes__c | text | YES | | | | |
| pi__score__c | double | YES | | | | |
| pi__url__c | varchar(47) | YES | | | | |
| pi__utm_campaign__c | varchar(16) | YES | | | | |
| pi__utm_content__c | varchar(0) | YES | | | | |
| pi__utm_medium__c | varchar(10) | YES | | | | |
| pi__utm_source__c | varchar(15) | YES | | | | |
| pi__utm_term__c | varchar(0) | YES | | | | |
| X2016_MidSouth_CAH_Conference__c | tinyint(1) | YES | | | | |
| Contact_Role__c | varchar(0) | YES | | | | |
| Phone_Home__c | varchar(25) | YES | | | | |
| Import2_Id__c | varchar(15) | YES | | | | |
| Last_Activity_Date__c | datetime(6) | YES | | | | |
| Days_Since_Last_Activity__c | double | YES | | | | |
| Recent_Campaign_Upload__c | varchar(21) | YES | | | | |
| Contact_Status__c | varchar(10) | YES | | | | |
| Account_Type__c | varchar(28) | YES | | | | |
| Specific_Lead_Source__c | varchar(103) | YES | | | | |
| Practice_Administrator__c | varchar(0) | YES | | | | |
| Renaissance_Created_Date__c | varchar(27) | YES | | | | |
| Renaissance_Enabled__c | tinyint(1) | YES | | | | |
| Renaissance_User_ID__c | double | YES | | | | |
| LID__LinkedIn_Company_Id__c | varchar(0) | YES | | | | |
| LID__LinkedIn_Member_Token__c | varchar(0) | YES | | | | |
| Import2_ID_Contact__c | varchar(18) | YES | | | | |
| Import2_ID_Contact_18__c | varchar(18) | YES | | | | |
| Active_Contact_14_days__c | double | YES | | | | |
| Direct_Phone__c | varchar(29) | YES | | | | |
| Facility_Phone__c | varchar(34) | YES | | | | |
| Conversational_Name__c | varchar(40) | YES | | | | |
| Current_List_Import__c | varchar(10) | YES | | | | |
| Tenure__c | varchar(0) | YES | | | | |
| Type__c | varchar(20) | YES | | | | |
| texcellency__DefHC_ExecutiveID__c | double | YES | | | | |
| texcellency__DefHC_HospitalID__c | double | YES | | | | |
| texcellency__DefHC_Is_Active__c | tinyint(1) | YES | | | | |
| texcellency__DefHC_LinkedInProfile__c | text | YES | | | | |
| texcellency__DefHC_Record_Changed_Date__c | datetime(6) | YES | | | | |
| DHC_Phone__c | varchar(14) | YES | | | | |
| Date_of_SAL__c | datetime(6) | YES | | | | |
| Date_of_SQL__c | datetime(6) | YES | | | | |
| Date_of_MQL__c | datetime(6) | YES | | | | |
| dupcheck__dc3DisableDuplicateCheck__c | tinyint(1) | YES | | | | |
| dupcheck__dc3Index__c | varchar(0) | YES | | | | |
| Date_of_DQL__c | datetime(6) | YES | | | | |
| AM_Main_Contact__c | tinyint(1) | YES | | | | |
| Parent_Account_AM_Main_Contact__c | tinyint(1) | YES | | | | |
| Owner_Active__c | varchar(3) | YES | | | | |
| engagio__Department__c | varchar(63) | YES | | | | |
| engagio__EngagementMinutesLast3Months__c | double | YES | | | | |
| engagio__EngagementMinutesLast7Days__c | double | YES | | | | |
| engagio__FirstEngagementDate__c | datetime(6) | YES | | | | |
| engagio__InPlay__c | tinyint(1) | YES | | | | |
| engagio__LastPlay__c | varchar(0) | YES | | | | |
| engagio__LeftCompany__c | tinyint(1) | YES | | | | |
| engagio__Role__c | varchar(8) | YES | | | | |
| Type_of_Account__c | varchar(28) | YES | | | | |
| Account_Status__c | varchar(10) | YES | | | | |