Databases

Digital Asset Management (DAM) Schema

ER Diagrams · made in Skemio

ER diagram of a digital asset manager containing assets, renditions, exif_metadata, tags, and asset_tags join table.
ER diagram of a digital asset manager containing assets, renditions, exif_metadata, tags, and asset_tags join table.
Open it in SkemioMake your own

What it shows

  • Store only object storage keys in the primary asset entity
  • Renditions map responsive derivative images to parent originals
  • 1-to-1 EXIF tables isolate sparse camera and device metadata

The takeaway

Keep binaries in object storage and use normalized tables for renditions, EXIF data, and tags.

More er diagrams