Salesforce Files Data Model Template

Pre-built data model for Salesforce Files (Content) using flowchart LR format with color coding and relationship indicators.

tools-only Updated Sep 29, 2026 7 repo stars

Install

Press C to copy

$ npx skillmds@latest add tools-only/salesforce-files-data-model-template

Installs into ~/.claude/skills (or .claude/skills inside a project). Restart Claude Code to pick it up.

＋ Add to plugin

README badge

[![SkillMD](https://skillmd.com/badge/tools-only/salesforce-files-data-model-template.svg)](https://skillmd.com/skills/tools-only/salesforce-files-data-model-template)

Trust & safety

2 of 3 audits passed

Last audited Sep 23, 2026 · commit b0e40ef

Works with: Claude Code Claude.ai OpenAI Codex +

File contents

Salesforce Files Data Model Template

Pre-built data model for Salesforce Files (Content) using flowchart LR format with color coding and relationship indicators.

Objects Included

Object	Type	Description
ContentDocument	STD	File container
ContentVersion	STD	File versions
ContentDocumentLink	STD	Links files to records
ContentWorkspace	STD	Content libraries
ContentWorkspaceDoc	STD	Library membership
ContentFolder	STD	Folder structure
ContentAsset	STD	Asset files

Query Org Metadata (Recommended)

Enrich diagram with live org data:

python3 ~/.claude/plugins/marketplaces/sf-skills/sf-diagram-mermaid/scripts/query-org-metadata.py \
    --objects ContentDocument,ContentVersion,ContentDocumentLink,ContentWorkspace \
    --target-org myorg

Mermaid Template (Preferred)

Left-to-right flowchart with color coding.

%%{init: {"flowchart": {"nodeSpacing": 50, "rankSpacing": 80}} }%%
flowchart LR
    %% ═══════════════════════════════════════════════════════════════
    %% SALESFORCE FILES DATA MODEL
    %% LEGEND: LK = Lookup (-->), MD = Master-Detail (==>)
    %% Colors: Blue = Standard, Orange = Custom, Green = External
    %% ═══════════════════════════════════════════════════════════════

    %% Core Content Objects
    ContentDoc["ContentDocument<br/>(count)"]
    ContentVer["ContentVersion<br/>(count)"]
    CDLink["ContentDocumentLink<br/>(count)"]

    %% Library Objects
    Library["ContentWorkspace<br/>(count)"]
    LibDoc["ContentWorkspaceDoc<br/>(count)"]
    Folder["ContentFolder<br/>(count)"]

    %% Asset
    Asset["ContentAsset<br/>(count)"]

    %% Any Salesforce Record
    Record["Any Record<br/>(Account, Case, etc.)"]

    %% Content Structure
    ContentDoc ==>|"MD"| ContentVer
    ContentDoc -->|"LK"| CDLink
    Record -->|"LinkedEntityId"| CDLink

    %% Library Structure
    Library ==>|"MD"| LibDoc
    ContentDoc -->|"LK"| LibDoc
    Library ==>|"MD"| Folder

    %% Asset
    ContentDoc -->|"LK"| Asset

    %% Standard Objects - Sky Blue
    style ContentDoc fill:#bae6fd,stroke:#0369a1,color:#1f2937
    style ContentVer fill:#bae6fd,stroke:#0369a1,color:#1f2937
    style CDLink fill:#bae6fd,stroke:#0369a1,color:#1f2937
    style Library fill:#bae6fd,stroke:#0369a1,color:#1f2937
    style LibDoc fill:#bae6fd,stroke:#0369a1,color:#1f2937
    style Folder fill:#bae6fd,stroke:#0369a1,color:#1f2937
    style Asset fill:#bae6fd,stroke:#0369a1,color:#1f2937
    style Record fill:#ddd6fe,stroke:#6d28d9,color:#1f2937

Key Concepts

Content Architecture

ContentDocument (Container)
    ├── ContentVersion (Current + History)
    ├── ContentDocumentLink (Sharing to Records)
    └── ContentWorkspaceDoc (Library Membership)

ContentDocument vs ContentVersion

Object	Purpose
ContentDocument	File metadata container (one per file)
ContentVersion	Actual file data + versions

Key: Always query ContentVersion for file data. ContentDocument is just the container.

ContentDocumentLink (CDL)

Links ContentDocument to any Salesforce record
LinkedEntityId is polymorphic (Account, Case, User, etc.)
Controls visibility/sharing

ShareType	Visibility
V	Viewer
C	Collaborator
I	Inferred

File Visibility

Visibility	Access
AllUsers	All internal users
InternalUsers	Users with record access
SharedUsers	Explicitly shared users

Simplified Version (Core Objects Only)

For presentations focusing on core file structure:

%%{init: {"flowchart": {"nodeSpacing": 50, "rankSpacing": 80}} }%%
flowchart LR
    ContentDoc["ContentDocument"]
    ContentVer["ContentVersion"]
    CDLink["ContentDocumentLink"]
    Record["Any Record"]

    ContentDoc ==>|"MD"| ContentVer
    ContentDoc -->|"LK"| CDLink
    Record -->|"LinkedEntityId"| CDLink

    style ContentDoc fill:#bae6fd,stroke:#0369a1,color:#1f2937
    style ContentVer fill:#bae6fd,stroke:#0369a1,color:#1f2937
    style CDLink fill:#bae6fd,stroke:#0369a1,color:#1f2937
    style Record fill:#ddd6fe,stroke:#6d28d9,color:#1f2937

Content Libraries Model

For file library organization:

%%{init: {"flowchart": {"nodeSpacing": 50, "rankSpacing": 80}} }%%
flowchart LR
    Library["ContentWorkspace<br/>(Library)"]
    LibDoc["ContentWorkspaceDoc"]
    Folder["ContentFolder"]
    ContentDoc["ContentDocument"]
    Member["ContentWorkspaceMember"]
    User["User"]

    Library ==>|"MD"| LibDoc
    Library ==>|"MD"| Folder
    Library ==>|"MD"| Member
    ContentDoc -->|"LK"| LibDoc
    User -->|"LK"| Member

    style Library fill:#bae6fd,stroke:#0369a1,color:#1f2937
    style LibDoc fill:#bae6fd,stroke:#0369a1,color:#1f2937
    style Folder fill:#bae6fd,stroke:#0369a1,color:#1f2937
    style ContentDoc fill:#bae6fd,stroke:#0369a1,color:#1f2937
    style Member fill:#bae6fd,stroke:#0369a1,color:#1f2937
    style User fill:#bae6fd,stroke:#0369a1,color:#1f2937

ASCII Fallback

┌─────────────────────────────────────────────────────────────────────────────┐
│  SALESFORCE FILES DATA MODEL (L→R)                                           │
│  Legend: LK = Lookup (-->), MD = Master-Detail (==>)                        │
└─────────────────────────────────────────────────────────────────────────────┘

                              FILE STRUCTURE
┌──────────────────┐         ┌──────────────────┐
│ CONTENT_DOCUMENT │═══ MD ═>│ CONTENT_VERSION  │
│     (count)      │         │    (count)       │
└────────┬─────────┘         └──────────────────┘
         │
         │ LK
         ▼
┌──────────────────────┐         ┌──────────────────┐
│CONTENT_DOCUMENT_LINK │<── LK ──│    ANY RECORD    │
│      (count)         │         │ (Account, Case)  │
└──────────────────────┘         └──────────────────┘

                           LIBRARY STRUCTURE
┌──────────────────┐         ┌──────────────────────┐
│ CONTENT_WORKSPACE│═══ MD ═>│CONTENT_WORKSPACE_DOC │
│    (Library)     │         │      (count)         │
└────────┬─────────┘         └──────────┬───────────┘
         │                              │
         │ MD                           │ LK
         ▼                              ▼
┌──────────────────┐         ┌──────────────────────┐
│  CONTENT_FOLDER  │         │   CONTENT_DOCUMENT   │
│     (count)      │         │      (count)         │
└──────────────────┘         └──────────────────────┘

Key Relationships Summary

Parent	Child	Type	Behavior
ContentDocument	ContentVersion	MD	Cascade delete
ContentDocument	ContentDocumentLink	LK	Sharing links
ContentWorkspace	ContentWorkspaceDoc	MD	Library files
ContentWorkspace	ContentFolder	MD	Library folders
ContentWorkspace	ContentWorkspaceMember	MD	Library members
ContentDocument	ContentWorkspaceDoc	LK	File in library
ContentDocument	ContentAsset	LK	Asset reference

Limits & Considerations

Limit	Value
File size	2 GB (max)
Versions per file	20 (default, configurable)
Libraries per org	Varies by edition
CDL per file	No hard limit (LDV)
Files storage	Org storage limit

Common Queries

Files attached to a record

SELECT ContentDocumentId, ContentDocument.Title
FROM ContentDocumentLink
WHERE LinkedEntityId = '001xxx'

Latest version of a file

SELECT Id, Title, VersionData
FROM ContentVersion
WHERE ContentDocumentId = '069xxx'
AND IsLatest = true

Best Practices

Use flowchart LR - Left-to-right flow for readability
Keep objects simple - Name + record count only
Replace (count) placeholders - With actual counts from query
Add LDV indicator - For objects >2M records: LDV[~4M]
Color code object types - Blue=Standard, Orange=Custom, Green=External

---name: salesforce-files-data-model-templatedescription: Pre-built data model for Salesforce Files (Content) using flowchart LR format with color coding and relationship indicators.---# Salesforce Files Data Model TemplatePre-built data model for Salesforce Files (Content) using `flowchart LR` format with color coding and relationship indicators.## Objects Included| Object | Type | Description ||--------|------|-------------|| ContentDocument | STD | File container || ContentVersion | STD | File versions || ContentDocumentLink | STD | Links files to records || ContentWorkspace | STD | Content libraries || ContentWorkspaceDoc | STD | Library membership || ContentFolder | STD | Folder structure || ContentAsset | STD | Asset files |---## Query Org Metadata (Recommended)Enrich diagram with live org data:```bashpython3 ~/.claude/plugins/marketplaces/sf-skills/sf-diagram-mermaid/scripts/query-org-metadata.py \ --objects ContentDocument,ContentVersion,ContentDocumentLink,ContentWorkspace \ --target-org myorg```---## Mermaid Template (Preferred)Left-to-right flowchart with color coding.```mermaid%%{init: {"flowchart": {"nodeSpacing": 50, "rankSpacing": 80}} }%%flowchart LR %% ═══════════════════════════════════════════════════════════════ %% SALESFORCE FILES DATA MODEL %% LEGEND: LK = Lookup (-->), MD = Master-Detail (==>) %% Colors: Blue = Standard, Orange = Custom, Green = External %% ═══════════════════════════════════════════════════════════════ %% Core Content Objects ContentDoc["ContentDocument<br/>(count)"] ContentVer["ContentVersion<br/>(count)"] CDLink["ContentDocumentLink<br/>(count)"] %% Library Objects Library["ContentWorkspace<br/>(count)"] LibDoc["ContentWorkspaceDoc<br/>(count)"] Folder["ContentFolder<br/>(count)"] %% Asset Asset["ContentAsset<br/>(count)"] %% Any Salesforce Record Record["Any Record<br/>(Account, Case, etc.)"] %% Content Structure ContentDoc ==>|"MD"| ContentVer ContentDoc -->|"LK"| CDLink Record -->|"LinkedEntityId"| CDLink %% Library Structure Library ==>|"MD"| LibDoc ContentDoc -->|"LK"| LibDoc Library ==>|"MD"| Folder %% Asset ContentDoc -->|"LK"| Asset %% Standard Objects - Sky Blue style ContentDoc fill:#bae6fd,stroke:#0369a1,color:#1f2937 style ContentVer fill:#bae6fd,stroke:#0369a1,color:#1f2937 style CDLink fill:#bae6fd,stroke:#0369a1,color:#1f2937 style Library fill:#bae6fd,stroke:#0369a1,color:#1f2937 style LibDoc fill:#bae6fd,stroke:#0369a1,color:#1f2937 style Folder fill:#bae6fd,stroke:#0369a1,color:#1f2937 style Asset fill:#bae6fd,stroke:#0369a1,color:#1f2937 style Record fill:#ddd6fe,stroke:#6d28d9,color:#1f2937```---## Key Concepts### Content Architecture```ContentDocument (Container) ├── ContentVersion (Current + History) ├── ContentDocumentLink (Sharing to Records) └── ContentWorkspaceDoc (Library Membership)```### ContentDocument vs ContentVersion| Object | Purpose ||--------|---------|| ContentDocument | File metadata container (one per file) || ContentVersion | Actual file data + versions |**Key**: Always query ContentVersion for file data. ContentDocument is just the container.### ContentDocumentLink (CDL)- Links ContentDocument to **any Salesforce record**- `LinkedEntityId` is polymorphic (Account, Case, User, etc.)- Controls visibility/sharing| ShareType | Visibility ||-----------|------------|| V | Viewer || C | Collaborator || I | Inferred |### File Visibility| Visibility | Access ||------------|--------|| AllUsers | All internal users || InternalUsers | Users with record access || SharedUsers | Explicitly shared users |---## Simplified Version (Core Objects Only)For presentations focusing on core file structure:```mermaid%%{init: {"flowchart": {"nodeSpacing": 50, "rankSpacing": 80}} }%%flowchart LR ContentDoc["ContentDocument"] ContentVer["ContentVersion"] CDLink["ContentDocumentLink"] Record["Any Record"] ContentDoc ==>|"MD"| ContentVer ContentDoc -->|"LK"| CDLink Record -->|"LinkedEntityId"| CDLink style ContentDoc fill:#bae6fd,stroke:#0369a1,color:#1f2937 style ContentVer fill:#bae6fd,stroke:#0369a1,color:#1f2937 style CDLink fill:#bae6fd,stroke:#0369a1,color:#1f2937 style Record fill:#ddd6fe,stroke:#6d28d9,color:#1f2937```---## Content Libraries ModelFor file library organization:```mermaid%%{init: {"flowchart": {"nodeSpacing": 50, "rankSpacing": 80}} }%%flowchart LR Library["ContentWorkspace<br/>(Library)"] LibDoc["ContentWorkspaceDoc"] Folder["ContentFolder"] ContentDoc["ContentDocument"] Member["ContentWorkspaceMember"] User["User"] Library ==>|"MD"| LibDoc Library ==>|"MD"| Folder Library ==>|"MD"| Member ContentDoc -->|"LK"| LibDoc User -->|"LK"| Member style Library fill:#bae6fd,stroke:#0369a1,color:#1f2937 style LibDoc fill:#bae6fd,stroke:#0369a1,color:#1f2937 style Folder fill:#bae6fd,stroke:#0369a1,color:#1f2937 style ContentDoc fill:#bae6fd,stroke:#0369a1,color:#1f2937 style Member fill:#bae6fd,stroke:#0369a1,color:#1f2937 style User fill:#bae6fd,stroke:#0369a1,color:#1f2937```---## ASCII Fallback```┌─────────────────────────────────────────────────────────────────────────────┐│ SALESFORCE FILES DATA MODEL (L→R) ││ Legend: LK = Lookup (-->), MD = Master-Detail (==>) │└─────────────────────────────────────────────────────────────────────────────┘ FILE STRUCTURE┌──────────────────┐ ┌──────────────────┐│ CONTENT_DOCUMENT │═══ MD ═>│ CONTENT_VERSION ││ (count) │ │ (count) │└────────┬─────────┘ └──────────────────┘ │ │ LK ▼┌──────────────────────┐ ┌──────────────────┐│CONTENT_DOCUMENT_LINK │<── LK ──│ ANY RECORD ││ (count) │ │ (Account, Case) │└──────────────────────┘ └──────────────────┘ LIBRARY STRUCTURE┌──────────────────┐ ┌──────────────────────┐│ CONTENT_WORKSPACE│═══ MD ═>│CONTENT_WORKSPACE_DOC ││ (Library) │ │ (count) │└────────┬─────────┘ └──────────┬───────────┘ │ │ │ MD │ LK ▼ ▼┌──────────────────┐ ┌──────────────────────┐│ CONTENT_FOLDER │ │ CONTENT_DOCUMENT ││ (count) │ │ (count) │└──────────────────┘ └──────────────────────┘```---## Key Relationships Summary| Parent | Child | Type | Behavior ||--------|-------|------|----------|| ContentDocument | ContentVersion | MD | Cascade delete || ContentDocument | ContentDocumentLink | LK | Sharing links || ContentWorkspace | ContentWorkspaceDoc | MD | Library files || ContentWorkspace | ContentFolder | MD | Library folders || ContentWorkspace | ContentWorkspaceMember | MD | Library members || ContentDocument | ContentWorkspaceDoc | LK | File in library || ContentDocument | ContentAsset | LK | Asset reference |---## Limits & Considerations| Limit | Value ||-------|-------|| File size | 2 GB (max) || Versions per file | 20 (default, configurable) || Libraries per org | Varies by edition || CDL per file | No hard limit (LDV) || Files storage | Org storage limit |---## Common Queries### Files attached to a record```sqlSELECT ContentDocumentId, ContentDocument.TitleFROM ContentDocumentLinkWHERE LinkedEntityId = '001xxx'```### Latest version of a file```sqlSELECT Id, Title, VersionDataFROM ContentVersionWHERE ContentDocumentId = '069xxx'AND IsLatest = true```---## Best Practices1. **Use `flowchart LR`** - Left-to-right flow for readability2. **Keep objects simple** - Name + record count only3. **Replace `(count)` placeholders** - With actual counts from query4. **Add LDV indicator** - For objects >2M records: `LDV[~4M]`5. **Color code object types** - Blue=Standard, Orange=Custom, Green=External

tools-only/X-Skills/tree/main/development/frontend/377-files-erd_8f5a9412 commit b0e40ef3d6

Frequently asked questions

npx skillmds@latest add tools-only/salesforce-files-data-model-template