Episode 2 - Model your Salesforce Data

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

Agenda

Conventional Database Tables Vs Objects
Standard and Custom Objects
Datatypes
Relational Data Modelling
Schema Builder
Q & A

Here is some key point of our session.

What are Objects in Salesforce:-

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

Standard VS Custom objects

Standard Objects	Custom objects
Standard Objects are out of box: The objects provided by Salesforce is called standard objects	Are user defined : The objects created by us are called custom objects
API names of standard objects does not ends with __c	API names of custom objects ends with __c
Limited Customization	Fully Customizable
Example of standard object are Account, Contact & User	Example of custom object name is Employee__C or Department__c

Lookup VS Master detail

Master Detail	Lookup
This is parent-child relationship	This links two objects together
Detail object is deleted when Parent is deleted	No effect on linked records
Parent can have Roll-Up Summary fields	Roll-Up Summary field are not available on lookups
Detail record must have Master record reference	Reference to linked record is optional
The detail record inherits the sharing and security settings of its master record.	Both linked records have independent sharing and security settings