Building Skill Align – Part 2: Objects, Relationships & Fields in Salesforce

When I started building Skill Align , the first step was to lay down the foundation: defining its core objects, relationships, and key fields . Think of this as creating the blueprint that makes the system actually work. Quick Salesforce Terms for RDBMS Fans If you’re coming from a relational database background, here’s a simple mapping: Objects → store data, like tables Standard Objects – provided by Salesforce Custom Objects – created by you Fields → define what each record contains, like columns Supports data types like Text, Picklist (select a single predefined value from multiple options), Number, Date/Time , and more Records → the actual data, like rows Relationships Connect the Dots Lookup → flexible reference; parent has limited control over child Master-Detail → tightly linked; parent controls ownership of child Both are ideal for one-to-many relationships , but what about many-to-many ? Junction objects → solve M:N relationships by connecting two objects, usually via master-d