# <!-- FILL: Partner Name --> Entity Relationships & Mapping

<!-- DELETE THIS FILE if this partner does not have multiple entity types that need joining. -->

## Overview

<!-- FILL: Describe how this partner's entity types relate to each other and which mapping
tables connect them. -->

## Entity Relationship Diagram

<!-- FILL: ASCII or text diagram showing entity relationships and which mapping table connects each pair. -->

## Mapping Tables

<!-- FILL: One subsection per mapping table. Include join keys, cardinality, and use case. -->

### <!-- FILL: TABLE_NAME --> — <!-- FILL: Entity A ↔ Entity B -->
- **Join keys**: `<!-- FILL -->`
- **Cardinality**: <!-- FILL: 1:1, 1:many, many:many -->
- **Use case**: <!-- FILL -->

## Common Join Patterns

<!-- FILL: 2-3 example SQL snippets showing the most common joins analysts will need. -->

## Pitfalls

<!-- FILL: Gotchas related to joining (e.g., many-to-many fan-out, point-in-time mappings,
variant/JSON columns for artist linkage). -->