Contact.md

Home / Contact

Contact

Description

Columns

Name	Type	Default	Nullable	Extra Definition	Children	Parents	Comment
AccountId	Lookup(Account)		true	Relation=; List=		Account
AssistantName	_		true
AssistantPhone	_		true
Birthdate	_		true
BuyerAttributes	Picklist		true
CleanStatus	_		true
ContactSource	_		true
Department	_		true
Description	_		true
DoNotCall	_		true
Email	_		true
Fax	_		true
GenderIdentity	Picklist		true
HasOptedOutOfEmail	_		true
HasOptedOutOfFax	_		true
HomePhone	_		true
Id	Id		false				Id
IndividualId	Lookup		true
Jigsaw	_		true
Languages__c	Text(100)		true				Languages
LastCURequestDate	_		true
LastCUUpdateDate	_		true
LeadSource	Picklist		true
Level__c	Picklist		true	Secondary; Tertiary; Primary			Level
MailingAddress	_		true
MobilePhone	_		true
Name	Name		false
OtherAddress	_		true
OtherPhone	_		true
OwnerId	Lookup		true
Phone	_		true
Pronouns	Picklist		true
ReportsToId	Lookup		true
Title	_		true

Viewpoints

Name	Definition
Foobar	Foo and bar.

Constraints

Name	Type	Definition	Comment
Id	Primary Key	Primary Key
Standard Rule for Contacts with Duplicate Leads	DuplicateRule	[Inactive] {FirstName, LastName, Phone, Email, MailingCity, MailingStreet, MailingPostalCode, Title, AccountId} (Lead) Standard_Lead_Match_Rule_v1_0	Identify contacts with duplicate leads.

Indexes

Name	Definition
Id	Primary Key
Name	Name

Relations

erDiagram

"Contact" }o--|| "Account" : "Lookup
(Contact.AccountId)
(Account.)"

"Contact" {
  Lookup_Account_ AccountId FK
}
"Account" {
  Id Id
}

Loading

---

Generated by tbls