```mermaid
erDiagram
BRAND ||--o{ LOCATION : has
BRAND ||--o{ SHOWCASE : has
BRAND ||--o{ SHOWCASE_CREATIVE : has
LOCATION ||--o{ SHOWCASE : has
SHOWCASE_CREATIVE ||--o{ SHOWCASE : has
SHOWCASE_CREATIVE ||--|| SHOWCASE_CREATIVE_DETAILS : has
SHOWCASE_CREATIVE_DETAILS ||--|| CONTENTS : has
CONTENTS ||--|{ DESCRIPTION : has
SHOWCASE_CREATIVE_DETAILS ||--|| PHOTO : has
PHOTO ||--o{ CAPTION : has

    SHOWCASE_CREATIVE_DETAILS {
        string callToAction
        string[] appIds
    }

    CONTENTS {
        string placement
    }

    DESCRIPTION {
        string text
        string locale
    }

    PHOTO {
        string id
    }

    CAPTION {
        string altText
        string locale
    }
```