Salesforce object schema, field names, and relationships. Use when building SOQL queries to understand object structures and field types.
This skill provides reference information for Salesforce standard objects.
| Object | Key Fields | Relationships |
|---|---|---|
| Account | Id, Name, BillingCity, Industry, Type | Contacts, Opportunities, Cases |
| Contact | Id, FirstName, LastName, Email, AccountId | Account, Cases, Opportunities |
| Opportunity | Id, Name, Amount, CloseDate, StageName, AccountId | Account, OpportunityLineItems |
| Lead | Id, FirstName, LastName, Email, Company, Status | ConvertedAccount, ConvertedContact |
| Case | Id, Subject, Status, Priority, AccountId, ContactId | Account, Contact |
| Contract | Id, ContractNumber, Status, StartDate, AccountId | Account |
| Task |
| Id, Subject, Status, Priority, WhoId, WhatId |
| Who (Contact/Lead), What (any object) |
| Event | Id, Subject, StartDateTime, EndDateTime, WhoId | Who, What |
For complete field lists, see:
Id - 18-character unique identifierName - Record name (auto-generated or editable)CreatedDate, LastModifiedDate - TimestampsCreatedById, LastModifiedById - User referencesOwnerId - Record ownerIsDeleted - Soft delete flag (use --all-rows to include)RecordTypeId - Record type reference__c (e.g., Custom_Field__c)__r (e.g., Custom_Object__r.Name)Id (e.g., Account.Name not AccountId.Name)__c with __r (e.g., Custom_Lookup__r.Name)Contacts, Opportunities)For org-specific custom objects and fields, check org-schemas/<org-name>/ directory.