🎨 3D Rendering & VFX · Database ERD
3D Digital Asset Management Schema
A schema for managing 3D assets in a studio: projects, assets, versions, dependencies (textures, rigs), shots and reviews.
Drawing diagram…
What this diagram shows
- Every published file is a new version, never overwritten
- Assets depend on other assets (a character uses textures and a rig)
- Shots list which asset versions they use
Prompt used
ERD for 3D asset management: Project has Assets (character, prop, environment) and Shots; AssetVersion records each publish with file path, artist and status; AssetDependency links a version to versions it uses; ShotAsset records which asset versions a shot uses; Review records notes and approval on a version.
Mermaid code
erDiagram
PROJECT ||--o{ ASSET : owns
PROJECT ||--o{ SHOT : contains
ASSET ||--|{ ASSET_VERSION : "published as"
ASSET_VERSION ||--o{ ASSET_DEPENDENCY : uses
ASSET_VERSION ||--o{ SHOT_ASSET : "used in"
SHOT ||--o{ SHOT_ASSET : includes
ASSET_VERSION ||--o{ REVIEW : receives
ASSET {
int id PK
int project_id FK
string name
string type
}
ASSET_VERSION {
int id PK
int asset_id FK
int version
string file_path
string artist
string status
}
REVIEW {
int id PK
int version_id FK
string reviewer
string decision
string notes
}Related templates
Cloud Render Farm Deployment
Where each part of a cloud render farm runs: artists' workstations, the render queue manager, autoscaling GPU render nodes and shared storage.
3D Production Pipeline Data Flow
How assets move through a 3D animation or VFX pipeline: modelling, texturing, rigging, animation, lighting, rendering and compositing, with review in between.
Render Job Lifecycle
The states of a render job on a render farm: submitted, queued, rendering frame by frame, failures and retries, and completion.
VFX Shot Review and Approval
How a VFX shot is reviewed: the artist submits a version, the supervisor reviews in dailies, the client approves, and notes flow back.
VFX Studio Pipeline Platform
The studio systems that tie a VFX pipeline together: production tracking, asset management, render farm, storage and client review.
VFX Shot Production Workflow
The steps a VFX shot goes through from plates to final delivery: matchmove, modelling, animation, FX, lighting and comp.