Does anyone know what table in SQL stores the files or attachments in Salesforce?
2 answers
Actual binary files stores in ContentVersion object in salesforce.
When you insert a ContentVersion, a ContentDocument record is also created automatically which is parent of ContentVersion, and using the parent ContentDocument salesforce creates a record for ContentDocumentLink which holds info with how many users a file has been shared.
ContentDocument - Parent - DML not allowed salesforce managed itself
ContentVersion - Child of CD - All DMLs are allowed
ContentDocumentLink - Child of CD - All DMLs are allowed
I hope it helps
