🗄️ Database Models

This documentation provides a comprehensive overview of all database models in the application, their properties, relationships, and usage patterns.

📊 Overview

• 📈 Total Models Documented: 37
• 🔧 Common Features:
  • 🆔 All models use UUIDs (except Language, Country, User)
  • 🏷️ All models have internal_name and backward_compatibility fields
  • 🔗 Relationships are defined using Eloquent ORM best practices
  • 🌍 Translations are handled via dedicated translation models
  • 🔄 Many models support polymorphic and many-to-many relationships

🎯 Key Model Categories

🌍 Geographic Models

• 📍 Address, Location, Province: Represent geographical entities, each with translation models

👥 People & Organizations

• 🎨 Artist, Author, Partner: Represent people/entities, with relationships to items and collections

📦 Core Content Models

• 🏛️ Item, Collection, Exhibition, Gallery, Theme: Core content models, supporting translations, partners, and hierarchical relationships

🖼️ Media Models

• 📸 Picture, ImageUpload, AvailableImage: Handle image storage and metadata

🏷️ Classification

• 🔖 Tag: Supports tagging of items

👤 System Models

• 🔐 User: Standard Laravel user model
• 🌐 Language, Country: Use ISO codes as primary keys

🔗 Relationship Types

🌍 Translation System

• 🗣️ Most core models have a corresponding translation model (e.g., ItemTranslation, CollectionTranslation)
• 📝 Translation models include language, context, and extra metadata fields
• 🎯 Supports multi-language and multi-context content delivery

⚙️ Technical Features

📏 Scopes & Filtering

• 🔍 Models use Laravel scopes for filtering (e.g., default, english, forItem)
• ⚡ Optimized query performance through strategic scoping

🛠️ Traits & Patterns

• 🏭 All models use HasFactory and HasUuids traits where appropriate
• 📋 Consistent coding patterns across all models
• 🔒 Built-in security and validation features

📚 Complete Models Index

Click any model name below to view its detailed documentation with properties, relationships, and usage examples.

🔤 Alphabetical Model List

💡 Tip: Use your browser’s search function (Ctrl+F / Cmd+F) to quickly find specific models in this list.

For an overview of model relationships and architecture, see the summary above.