TH - Data Modelling

Question 1

How do salesforce think about database tables

Answer 1

Tables are objects
Columns are fields
Rows are records

Question 2

Field Types

Answer 2

Identity - 15 character case sensitive ID automatically generated for every record. Found in the url
System - System related information associated with a record, CreatedDate, LastModifiedById, LastModifiedDate
Name - All records have names, can be assigned manually or automated
Custom

Question 3

Formula fields

Answer 3

Automatically generates a value based on another value

Question 4

how to know a field is custom

Answer 4

–c at end of field name

Question 5

Main types of object relationships

Answer 5

Lookup Relationships - One to one or one to many ( Think of property buying example)
Master-Detail Relationships - parent objects affect child objects
Hierarchical - associated with user objects (management chains)