Media entity represents media files such as logos, avatars, or uploaded documents in the Well system. It serves as a central repository for all media assets and their metadata.
Table structure
Table name:medias
Main fields
| Name | Type | Required | Constraints | Allowed Values | Description | Example |
|---|---|---|---|---|---|---|
id | string, UUID, 🔒 system | ✅ Yes | Unique identifier (read-only) | – | Unique identifier of the media file | ”media-uuid-123” |
media_type | enum | ✅ Yes | Fixed enum values | avatar, logo, banner | Type of media asset | ”avatar” |
is_primary | boolean | ⚪ No | – | true/false | Marks preferred media (default: true) | true |
url | string (URL) | ✅ Yes | Valid URL format | – | Direct media URL for access | ”https://storage.example.com/media/logo.png” |
uploaded_at | string (ISO 8601) 🔒 system | – | auto timestamp | – | Upload timestamp | ”2023-01-01T12:00:00Z” |
processed_at | string (ISO 8601) 🔒 system | – | auto timestamp | – | Processing completion timestamp | ”2024-01-01T12:00:00Z” |
deleted_at | string | null 🔒 system | ⚪ No | nullable ISO 8601 | – | Deletion timestamp (soft delete) | “2024-01-01T12:00:00Z” |
Relations
The Media entity has relationships with multiple entities:Many-to-Many relations
- MediaPerson: Links with people for avatars and profile images
- MediaCompany: Links with companies for logos and banners
- MediaWorkspace: Links with workspaces for workspace-specific media
- MediaInvoiceItem: Links with invoice items for associated media files