ContactHistory

-1 rows


Description

Labels: Contact History | Contact History

Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id id 18 null

Label: Contact History ID
IsDeleted boolean 0 null

Label: Deleted
ContactId reference 18 null
Contact.Id FakeFK268C

Label: Contact ID
Referenced: Histories (cascade delete)
CreatedById reference 18 null

Label: Created By ID
CreatedDate datetime 0 null

Label: Created Date
Field picklist 255 null

Label: Changed Field
Picklist: Account | AssistantName | AssistantPhone | Birthdate | contactMerged | Owner | created | contactCreatedFromLead | Jigsaw | Department | Description | DoNotCall | Email | EmailBouncedDate | EmailBouncedReason | HasOptedOutOfEmail | Fax | HasOptedOutOfFax | feedEvent | FirstName | HomePhone | Individual | individualMerged | LastName | contactUpdatedByLead | LeadSource | MailingAddress | MailingCity | MailingCountry | MailingGeocodeAccuracy | MailingLatitude | MailingLongitude | MailingState | MailingStreet | MailingPostalCode | MiddleName | MobilePhone | Name | OtherAddress | OtherCity | OtherCountry | OtherGeocodeAccuracy | OtherLatitude | OtherLongitude | OtherPhone | OtherState | OtherStreet | OtherPostalCode | ownerAccepted | ownerAssignment | Phone | locked | unlocked | ReportsTo | Salutation | Suffix | Title
OldValue anyType 255 null

Label: Old Value
NewValue anyType 255 null

Label: New Value

Indexes

Constraint Name Type Sort Column(s)
FakeIndex50 Must be unique Asc Id

Relationships

Close relationships within degrees of separation