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 |
|---|---|---|---|
|
|
No |
The event. Joins to |
|
|
No |
The asset. Joins to |
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:
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:
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