Tables


SchemaSpy Analysis of pharmalite

Generated on Tue Dec 03 09:51 CST 2019

XML Representation
Insertion Order Deletion Order
TABLES 186
VIEWS 0
COLUMNS 2932
Constraints 251
Anomalies 1
Routines 0

Database Properties

Database Type: Force.com - 21

Tables

Table / View Children Parents Columns Rows Type Comments
SiteDomain 0 1 4 -1 Table

Labels: Site Domain | Site Domains

LoginIp 0 0 6 -1 Table

Labels: Login IP | Login IP

EmailTemplate 1 2 24 -1 Table

Labels: Email Template | Email Templates

SiteHistory 0 1 8 -1 Table

Labels: Site History | Site History

DashboardFeed 0 2 20 -1 Table

Labels: Dashboard Feed | Dashboard Feed

ProcessInstance 3 2 10 -1 Table

Labels: Process Instance | Process Instance

SolutionStatus 0 0 10 -1 Table

Labels: Solution Status Value | Solution Status Value

UserRole 4 2 15 -1 Table

Labels: Role | Role

AccountHistory 0 1 8 -1 Table

Labels: Account History | Account History

UserProfileFeed 0 2 20 -1 Table

Labels: User Profile Feed | User Profile Feed

FeedTrackedChange 0 1 5 -1 Table

Labels: Feed Tracked Change | Feed Tracked Changes

ProcessInstanceHistory 0 4 13 -1 Table

Labels: Process Instance History | Process Instance History

Community 1 0 9 -1 Table

Labels: Zone | Zones

Document 1 1 22 -1 Table

Labels: Document | Documents

ContractContactRole 0 2 11 -1 Table

Labels: Contract Contact Role | Contract Contact Role

NewsFeed 0 2 20 -1 Table

Labels: News Feed | News Feed

Partner 1 4 13 -1 Table

Labels: Partner | Partner

CampaignMemberStatus 0 1 12 -1 Table

Labels: Campaign Member Status | Campaign Member Statuses

CaseTeamTemplate 2 0 8 -1 Table

Labels: Predefined Case Team | Predefined Case Team

ContractFeed 0 2 20 -1 Table

Labels: Contract Feed | Contract Feed

CallCenter 1 0 9 -1 Table

Labels: Call Center | Call Centers

UserFeed 0 1 20 -1 Table

Labels: User Feed | User Feed

ContentDocumentLink 0 2 6 -1 Table

Labels: Content Document Link | Content Document Link

CategoryData 0 2 9 -1 Table

Labels: Category Data | Category Data

CaseHistory 0 1 8 -1 Table

Labels: Case History | Case History

gsdq__DCR__Share 0 1 8 -1 Table

Labels: Share: DCR | Share: DCR

CampaignHistory 0 1 8 -1 Table

Labels: Campaign Field History | Campaign Field History

OpportunityContactRole 0 2 11 -1 Table

Labels: Opportunity Contact Role | Opportunity Contact Role

CaseStatus 0 0 10 -1 Table

Labels: Case Status Value | Case Status Value

ApexLog 0 0 12 -1 Table

Labels: Apex Debug Log | Apex Debug Log

OpportunityLineItem 0 2 16 -1 Table

Labels: Opportunity Product | Opportunity Product

Case 10 4 26 -1 Table

Labels: Case | Cases

AssignmentRule 0 0 9 -1 Table

Labels: Assignment Rule | Assignment Rules

OrgWideEmailAddress 0 0 9 -1 Table

Labels: Organization-wide From Email Address | Organization-wide From Email Addresses

ContentDocumentHistory 0 1 8 -1 Table

Labels: Content Document History | Content Document History

OpportunityShare 0 2 8 -1 Table

Labels: Opportunity Share | Opportunity Share

CaseTeamTemplateMember 1 3 9 -1 Table

Labels: Predefined Case Team Member | Predefined Case Team Member

Pricebook2 3 0 11 -1 Table

Labels: Price Book | Price Books

CaseFeed 0 2 20 -1 Table

Labels: Case Feed | Case Feed

AdditionalNumber 0 1 11 -1 Table

Labels: Additional Directory Number | Additional Directory Numbers

EventAttendee 0 2 12 -1 Table

Labels: Event Attendee | Event Attendee

AccountContactRole 0 2 11 -1 Table

Labels: Account Contact Role | Account Contact Roles

CollaborationInvitation 1 2 13 -1 Table

Labels: Chatter Invitation | Chatter Invitations

StaticResource 0 0 13 -1 Table

Labels: Static Resource | Static Resources

ProcessInstanceWorkitem 0 3 8 -1 Table

Labels: Approval Request | Approval Requests

ApexTrigger 0 0 23 -1 Table

Labels: Apex Trigger | Apex Triggers

OpportunityFieldHistory 0 1 8 -1 Table

Labels: Opportunity Field History | Opportunity Field History

LeadFeed 0 2 20 -1 Table

Labels: Lead Feed | Lead Feed

ClientBrowser 0 0 6 -1 Table

Labels: Client Browser | Client Browser

Pricebook2History 0 1 8 -1 Table

Labels: Price Book History | Price Book History

CollaborationGroupMember 0 1 9 -1 Table

Labels: Group Member | Group Members

TaskPriority 0 0 10 -1 Table

Labels: Task Priority Value | Task Priority Value

Organization 3 0 40 -1 Table

Labels: Organization | Organizations

Group 25 2 13 -1 Table

Labels: Group | Group

Order 2 3 31 -1 Table

Labels: Order | Orders

gsdm__Email_Template__Share 0 1 8 -1 Table

Labels: Share: Email Template | Share: Email Template

pharmalite__HCP_Rep_Request__Share 0 1 8 -1 Table

Labels: Share: HCP Rep Requests | Share: HCP Rep Requests

OpportunityCompetitor 0 1 11 -1 Table

Labels: Opportunity: Competitor | Opportunity: Competitor

ContactFeed 0 2 20 -1 Table

Labels: Contact Feed | Contact Feed

ContentDocumentFeed 0 2 20 -1 Table

Labels: ContentDocument Feed | ContentDocument Feed

WebLinkLocalization 0 1 10 -1 Table

Labels: Custom Link Localization | Custom Link Localization

ContactHistory 0 1 8 -1 Table

Labels: Contact History | Contact History

PushTopic 0 0 11 -1 Table

Labels: Push Topic | Push Topics

gsdq__Subscribe_Job__Feed 3 1 20 -1 Table

Labels: Feed: Subscribe Job | Feed: Subscribe Job

Campaign 7 2 31 -1 Table

Labels: Campaign | Campaigns

Site 3 0 26 -1 Table

Labels: Site | Sites

CollaborationGroupFeed 0 2 20 -1 Table

Labels: Group Feed | Group Feed

PartnerRole 0 0 9 -1 Table

Labels: Partner Role Value | Partner Role Value

EmailStatus 0 2 11 -1 Table

Labels: Email Status | Email Status

SetupAuditTrail 0 0 6 -1 Table

Labels: Setup Audit Trail Entry | Setup Audit Trail Entries

Asset 2 3 20 -1 Table

Labels: Asset | Assets

ApexPage 1 0 14 -1 Table

Labels: Visualforce Page | Visualforce Pages

DocumentAttachmentMap 0 2 6 -1 Table

Labels: Document Entity Map | Document Entity Map

ActivityHistory 0 3 29 -1 Table

Labels: Activity History | Activity History

ContentWorkspace 1 1 12 -1 Table

Labels: Library | Libraries

RecordTypeLocalization 0 1 10 -1 Table

Labels: Translation | Translation

gsdm__Email_Template__History 0 0 8 -1 Table

Labels: History: Email Template | History: Email Template

LeadHistory 0 1 8 -1 Table

Labels: Lead History | Lead History

FeedLike 0 1 6 -1 Table

Labels: Feed Like | Feed Likes

PermissionSet 1 1 94 -1 Table

Labels: Permission Set | Permission Sets

ContentWorkspaceDoc 0 2 7 -1 Table

Labels: Library Document | Library Documents

DashboardComponentFeed 0 2 20 -1 Table

Labels: Dashboard Component Feed | Dashboard Component Feed

FiscalYearSettings 1 1 15 -1 Table

Labels: Fiscal Year Settings | Fiscal Year Settings

Lead 12 5 40 -1 Table

Labels: Lead | Leads

Contact 18 3 46 -1 Table

Labels: Contact | Contacts

TrialTemplate 0 0 9 -1 Table

Labels: Trial Template | Trial Template

SiteFeed 0 2 20 -1 Table

Labels: Site | Site

OrderItem 1 3 18 -1 Table

Labels: Order Product | Order Products

Event 3 4 39 -1 Table

Labels: Event | Events

FeedItem 0 2 20 -1 Table

Labels: Feed Item | Feed Items

EmailMessage 0 2 22 -1 Table

Labels: Email Message | Email Messages

pharmalite__Interaction__Share 0 1 8 -1 Table

Labels: Share: Interaction | Share: Interaction

EmailServicesFunction 1 1 22 -1 Table

Labels: Email Service | Email Services

Account 25 6 233 -1 Table

Labels: Account | Accounts
Record Types: Business Account | HCO (default) | HCP | Person Account

CategoryNode 3 1 10 -1 Table

Labels: Category Node | Category Nodes

Product2 5 0 12 -1 Table

Labels: Product | Products

pharmalite__Medical_Inquiry__Share 0 1 8 -1 Table

Labels: Share: Medical Inquiry | Share: Medical Inquiry

AccountShare 0 2 11 -1 Table

Labels: Account Share | Account Share

CaseTeamRole 2 0 9 -1 Table

Labels: Case Team Member Role | Case Team Member Role

TaskFeed 0 2 20 -1 Table

Labels: Task Feed | Task Feed

gsdm__Email_Tag_Option__History 0 0 8 -1 Table

Labels: History: Email Tag Option | History: Email Tag Option

gsdm__Email_Tag__History 0 0 8 -1 Table

Labels: History: Email Tag | History: Email Tag

Folder 2 0 12 -1 Table

Labels: Folder | Folders

gsdq__Job__Feed 0 1 20 -1 Table

Labels: Feed: Job | Feed: Job

IdeaComment 1 1 8 -1 Table

Labels: Idea Comment | Idea Comments

ProcessNode 0 1 6 -1 Table

Labels: Process Node | Process Node

Task 12 4 35 -1 Table

Labels: Task | Tasks

CaseShare 0 2 8 -1 Table

Labels: Case Share | Case Share

GroupMember 0 2 4 -1 Table

Labels: Group Member | Group Member

AccountPartner 1 4 13 -1 Table

Labels: Account Partner | Account Partner

ApexComponent 0 0 14 -1 Table

Labels: Visualforce Component | Visualforce Components

PermissionSetAssignment 0 1 4 -1 Table

Labels: Permission Set Assignment | Permission Set Assignments

CaseContactRole 0 2 10 -1 Table

Labels: Case Contact Role | Case Contact Role

OpportunityFeed 0 2 20 -1 Table

Labels: Opportunity Feed | Opportunity Feed

Name 0 2 13 -1 Table

Labels: Name | Names

PricebookEntry 2 2 14 -1 Table

Labels: Price Book Entry | Price Book Entries

OpportunityHistory 0 1 12 -1 Table

Labels: Opportunity History | Opportunity History

OrderHistory 0 1 8 -1 Table

Labels: Order History | Order History

Period 1 1 10 -1 Table

Labels: Period | Period

OpenActivity 0 3 29 -1 Table

Labels: Open Activity | Open Activities

LeadStatus 0 0 10 -1 Table

Labels: Lead Status Value | Lead Status Value

Product2Feed 0 2 20 -1 Table

Labels: Product Feed | Product Feed

ApexClass 2 0 14 -1 Table

Labels: Apex Class | Apex Classes

CaseTeamMember 0 4 10 -1 Table

Labels: Case Team Member | Case Team Member

Attachment 0 1 15 -1 Table

Labels: Attachment | Attachments

ReportFeed 0 2 20 -1 Table

Labels: Report Feed | Report Feed

Vote 0 1 7 -1 Table

Labels: Vote | Votes

ContentVersionHistory 0 1 8 -1 Table

Labels: Content Version History | Content Version History

CaseTeamTemplateRecord 0 2 6 -1 Table

Labels: Predefined Case Team Record | Predefined Case Team Record

EmailServicesAddress 0 1 12 -1 Table

Labels: Email Services Address | Email Services Address

Contract 4 2 37 -1 Table

Labels: Contract | Contracts

EntitySubscription 0 1 6 -1 Table

Labels: Entity Subscription | Entity Subscriptions

CaseSolution 0 2 7 -1 Table

Labels: Case Solution | Case Solution

RecordType 5 1 14 -1 Table

Labels: Record Type | Record Types

UserPreference 0 0 5 -1 Table

Labels: User Preference | User Preferences

pharmalite__Focus_Account__Share 0 1 8 -1 Table

Labels: Share: Focus Account | Share: Focus Account

CampaignShare 0 2 8 -1 Table

Labels: Campaign Share | Campaign Share

BrandTemplate 1 0 12 -1 Table

Labels: Letterhead | Letterheads

LeadShare 0 2 8 -1 Table

Labels: Lead Share | Lead Share

ContentVersion 26 2 30 -1 Table

Labels: Content Version | Content Versions

OpportunityStage 0 0 15 -1 Table

Labels: Opportunity Stage | Opportunity Stage

SocialPersona 0 1 12 -1 Table

Labels: Social Persona | Social Personas

LoginHistory 0 0 13 -1 Table

Labels: Login History | Login History

BusinessProcess 1 0 11 -1 Table

Labels: Business Process | Business Process

ForecastShare 0 2 8 -1 Table

Labels: Forecast Share | Forecast Share

QueueSobject 0 1 5 -1 Table

Labels: Queue Sobject | Queue Sobjects

Profile 1 1 95 -1 Table

Labels: Profile | Profile

AssetHistory 0 1 8 -1 Table

Labels: Asset History | Asset History

Idea 2 4 21 -1 Table

Labels: Idea | Ideas
Record Types: Internal Ideas: Idea Record Type

AggregateResult 0 0 1 -1 Table

Labels: Aggregate Result | Aggregate Result

CollaborationGroupMemberRequest 0 1 10 -1 Table

Labels: Group Member Request | Group Member Requests

Dashboard 2 1 23 -1 Table

Labels: Dashboard | Dashboards

Note 0 1 12 -1 Table

Labels: Note | Notes

AccountFeed 0 2 20 -1 Table

Labels: Account Feed | Account Feed

Holiday 0 0 21 -1 Table

Labels: Holiday | Holidays

OpportunityPartner 1 3 12 -1 Table

Labels: Opportunity Partner | Opportunity Partner

CaseComment 0 1 10 -1 Table

Labels: Case Comment | Case Comments

CampaignFeed 0 2 20 -1 Table

Labels: Campaign Feed | Campaign Feed

AsyncApexJob 1 2 15 -1 Table

Labels: Apex Job | Apex Jobs

CollaborationGroup 4 0 17 -1 Table

Labels: Group | Groups

ContactShare 0 2 8 -1 Table

Labels: Contact Share | Contact Share

SolutionFeed 0 2 20 -1 Table

Labels: Solution Feed | Solution Feed

gsdm__Sent_Email__History 0 0 8 -1 Table

Labels: History: Sent Email | History: Sent Email

ContractStatus 0 0 10 -1 Table

Labels: Contract Status Value | Contract Status Value

ContentDocument 5 1 11 -1 Table

Labels: Content Document | Content Documents

CampaignMember 0 3 13 -1 Table

Labels: Campaign Member | Campaign Members

FeedComment 0 2 8 -1 Table

Labels: Feed Comment | Feed Comments

BusinessHours 0 0 24 -1 Table

Labels: Business Hours | Business Hours

EventFeed 0 2 20 -1 Table

Labels: Event Feed | Event Feed

Solution 11 0 17 -1 Table

Labels: Solution | Solutions

AssetFeed 0 2 20 -1 Table

Labels: Asset Feed | Asset Feed

Report 1 1 13 -1 Table

Labels: Report | Reports

CategoryNodeLocalization 0 1 10 -1 Table

Labels: Category Node Localization | Category Node Localization

SolutionHistory 0 1 8 -1 Table

Labels: Solution History | Solution History

WebLink 1 1 28 -1 Table

Labels: Custom Button or Link | Custom Buttons or Links

DashboardComponent 1 1 3 -1 Table

Labels: Dashboard Component | Dashboard Components

ContractHistory 0 1 8 -1 Table

Labels: Contract History | Contract History

ProcessDefinition 2 0 13 -1 Table

Labels: Process Definition | Process Definition

CronTrigger 0 0 13 -1 Table

Labels: Scheduled Jobs | Scheduled Jobs

NoteAndAttachment 0 1 12 -1 Table

Labels: Note and Attachment | Notes and Attachments

TaskStatus 0 0 10 -1 Table

Labels: Task Status Value | Task Status Value

UserLicense 2 0 4 -1 Table

Labels: User License | User Licenses

MailmergeTemplate 0 0 17 -1 Table

Labels: Mail Merge Template | Mail Merge Template

pharmalite__Mobile_Data_Replication__Share 0 1 8 -1 Table

Labels: Share: Mobile Data Replication | Share: Mobile Data Replication

Opportunity 11 3 29 -1 Table

Labels: Opportunity | Opportunities

ProcessInstanceStep 0 3 9 -1 Table

Labels: Process Instance Step | Process Instance Step