Lead

-1 rows


Description

Labels: Lead | Leads

Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id id 18 null
ActivityHistory.WhoId FakeFK282C
CampaignMember.LeadId FakeFK415C
EmailStatus.WhoId FakeFK275C
Event.WhoId FakeFK307C
EventAttendee.AttendeeId FakeFK242C
Lead.MasterRecordId FakeFK294C
LeadFeed.ParentId FakeFK251C
LeadHistory.LeadId FakeFK286C
LeadShare.LeadId FakeFK382C
OpenActivity.WhoId FakeFK357C
SocialPersona.ParentId FakeFK386C
Task.WhoId FakeFK332C

Label: Lead ID
IsDeleted boolean 0 null

Label: Deleted
MasterRecordId reference 18 null
Lead.Id FakeFK294C

Label: Master Record ID
LastName string 80 null

Label: Last Name
FirstName string 40 null

Label: First Name
Salutation picklist 40 null

Label: Salutation
Picklist: Mr. | Ms. | Mrs. | Dr. | Prof.
Name string 121 null

Label: Full Name
Title string 128 null

Label: Title
Company string 255 null

Label: Company
Street textarea 255 null

Label: Street
City string 40 null

Label: City
State string 80 null

Label: State/Province
PostalCode string 20 null

Label: Zip/Postal Code
Country string 80 null

Label: Country
Phone phone 40 null

Label: Phone
Email email 80 null

Label: Email
Website url 255 null

Label: Website
Description textarea 32000 null

Label: Description
LeadSource picklist 40 null

Label: Lead Source
Picklist: Advertisement | Employee Referral | External Referral | Partner | Public Relations | Seminar - Internal | Seminar - Partner | Trade Show | Web | Word of mouth | Other
Status picklist 40 null

Label: Status
Picklist: New | Contacted | Nurturing | Qualified | Unqualified
Industry picklist 40 null

Label: Industry
Picklist: Agriculture | Apparel | Banking | Biotechnology | Chemicals | Communications | Construction | Consulting | Education | Electronics | Energy | Engineering | Entertainment | Environmental | Finance | Food & Beverage | Government | Healthcare | Hospitality | Insurance | Machinery | Manufacturing | Media | Not For Profit | Other | Recreation | Retail | Shipping | Technology | Telecommunications | Transportation | Utilities
Rating picklist 40 null

Label: Rating
Picklist: Hot | Warm | Cold
AnnualRevenue currency 18 null

Label: Annual Revenue
NumberOfEmployees int 8 null

Label: Employees
OwnerId reference 18 null
Group.Id FakeFK295C

Label: Owner ID
IsConverted boolean 0 null

Label: Converted
ConvertedDate date 0 null

Label: Converted Date
ConvertedAccountId reference 18 null
Account.Id FakeFK296C

Label: Converted Account ID
ConvertedContactId reference 18 null
Contact.Id FakeFK297C

Label: Converted Contact ID
ConvertedOpportunityId reference 18 null
Opportunity.Id FakeFK298C

Label: Converted Opportunity ID
IsUnreadByOwner boolean 0 null

Label: Unread By Owner
CreatedDate datetime 0 null

Label: Created Date
CreatedById reference 18 null

Label: Created By ID
LastModifiedDate datetime 0 null

Label: Last Modified Date
LastModifiedById reference 18 null

Label: Last Modified By ID
SystemModstamp datetime 0 null

Label: System Modstamp
LastActivityDate date 0 null

Label: Last Activity
Jigsaw string 20 null

Label: Data.com Key
EmailBouncedReason string 255 null

Label: Email Bounced Reason
EmailBouncedDate datetime 0 null

Label: Email Bounced Date

Indexes

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

Relationships

Close relationships within degrees of separation