Model your Salesforce Data

Introductions are fun, and this time around, we will be scratching the surface a little more to understand how to model your Salesforce Data. In this session, we will learn about the difference between Standard and Custom Object, Different data types in Salesforce, and the Lookup vs Master Details relationship.

What are Objects in Salesforce

  1. Salesforce Objects are like DB tables
  2. We use them to store persistent data
  3. It has additional properties and features.

Standard vs. custom objects

Standard Objects Custom objects
API names of standard objects do not end with __c API names of standard objects do not ends with __c
API names of custom objects end with __cExample of the custom object name is Employee__C or Department__c
Limited CustomizationFully Customizable
Examples of standard objects are Account, Contact & User Standard Objects are out of the box: The objects provided by Salesforce are called standard objects.

Lookup VS Master detail

LookupMaster Detail
This is a parent-child relationship.The detail object is deleted when the Parent is deleted. This links two objects together.
Both linked records have independent sharing and security settings. The detail record inherits the sharing and security settings of its master record.
Roll-up summary fields are not available on lookups.Parents can have Roll-Up Summary fields.
Reference to linked records is optional. The detail record must have a Master record reference.
Up to 40 lookups on a custom object (child can have up to 40 parents)You can have 2 master details on an object.
No Cascade deleteCascade delete

Choosing between Standard & Custom Objects, Relationships in the CTA exam.

Model your Salesforce Data Session

YouTube video

Further Reading

Please try the Trailhead module below for further learning:-

  1. Data Modeling
  2. Build a Data Model for a Recruiting App
  3. Build a Battle Station App

Here is the playlist link for all recordings. Please check Episode 3 to learn about “Customizing the User Interface“.


  1. Sorry About Wrong number on PPT. Here is updated limit for master detail and lookup in salesforce.

    NOTE: Master-Detail Relationship Fields, per Object (Standard or Custom) –> 2

    Total Relationship Fields (Master-Detail + Lookup), per Object (Standard or Custom) –> 40

  2. Hi, I live in a different country where the time difference between India and my place is 12 hours. I got an email regarding the salesforce admin workshop. would it be possible to reschedule the workshops 9PM EST time? This is just a request. I definitely can understand if its not possible.

    Thanks for the recordings.

Leave a Reply

Your email address will not be published. Required fields are marked *