# event_assets

One row per event-and-asset pair, connecting events to their associated assets. An event associated with several assets has one row for each pair.

Metadata table, so no `dataset_rid` predicate is required. The table has no `dataset_rid` column.

## Columns

| Column | Type | Nullable | Notes |
| --- | --- | --- | --- |
| `event_rid` | `VARCHAR` | No | The event. Joins to [`events.event_rid`](https://dev.nominal.io/sql-reference/schema/events.md). |
| `asset_rid` | `VARCHAR` | No | The asset. Joins to [`assets.asset_rid`](https://dev.nominal.io/sql-reference/schema/assets.md). |

This join table has no event or asset details. Read names, times, and properties from `events` and `assets`.

## Examples

Events associated with an asset, most recent first:

```sql
SELECT e.name, e.type, e.start_time
FROM event_assets AS ea
JOIN events AS e ON ea.event_rid = e.event_rid
WHERE ea.asset_rid = '<asset-rid>'
ORDER BY e.start_time DESC
LIMIT 20
```

Assets associated with an event:

```sql
SELECT a.title
FROM event_assets AS ea
JOIN assets AS a ON ea.asset_rid = a.asset_rid
WHERE ea.event_rid = '<event-rid>'
ORDER BY a.title
```

## Next steps

- [events](https://dev.nominal.io/sql-reference/schema/events.md): event names, types, and times.
- [assets](https://dev.nominal.io/sql-reference/schema/assets.md): asset titles and properties.