Database Schema¶
This schema description is for illustrative purposes only and should not be used to update or replace an existing production database.
Entity-Relationship Diagram¶
↪ docs.photoprism.app/developer-guide/database/schema/
Mermaid Markup¶
With Mermaid.js you can generate visual diagrams from this markup file:
MariaDB SQL Dump¶
An SQL schema dump can be created using the command shown below, for example:
If you need an updated dump, you can run this command in your development environment:
mariadb-dump --no-data --skip-add-locks --skip-comments \
--skip-opt --skip-set-charset photoprism > mariadb.sql
Please note that the dump we provide is only updated at irregular intervals and should therefore not be used to update or replace an existing production database.
Schema Migrations¶
↪ docs.photoprism.app/developer-guide/database/migrations/
↪ github.com/photoprism/photoprism/tree/develop/internal/migrate