This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 12241 | 12241 | ec3ac | 1714 1714 |
| 12242 | 12242 | d442d | 1714 1714 |
| 12243 | 12243 | 5e075 | 1714 1714 |
| 12244 | 12244 | 59d75 | 1714 1714 |
| 12245 | 12245 | 3502d | 1714 1714 |
| 12246 | 12246 | babaf | 1714 1714 |
| 12247 | 12247 | 99241 | 1714 1714 |
| 12248 | 12248 | 40ff5 | 1714 1714 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)