```mermaid
erDiagram
    LOCATION ||--o{ LOCATION_ASSET : has
    LOCATION_ASSET ||--|| ASSET_DETAILS : has
    ASSET_DETAILS ||--o{ CAPTION : has
    ASSET_DETAILS ||--o| COORDINATES : has
    ASSET_DETAILS ||--o{ CLASSIFICATION : has
    ASSET_DETAILS ||--|| PHOTOS : has
    PHOTOS ||--|| PHOTO_VARIANT : contains

    ASSET_DETAILS {
        string partnersAssetId
        string dateAdded
        string capturedBy
        string imageId
        string intent
        string source
    }

    CAPTION {
        string title
        string altText
        string locale
    }

    COORDINATES {
        string longitude
        string latitude
    }

    CLASSIFICATION {
        string value
    }

    PHOTOS {
        PHOTO_VARIANT original
        PHOTO_VARIANT thumbnail
        PHOTO_VARIANT small
        PHOTO_VARIANT medium
        PHOTO_VARIANT large
        PHOTO_VARIANT xlarge
        PHOTO_VARIANT xxlarge
    }

    PHOTO_VARIANT {
        uri url
        int pixelWidth
        int pixelHeight
    }
```