This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 30311 | 30311 | ec3ac | 1089 1089 |
| 30312 | 30312 | 4801f | 1089 1089 |
| 30313 | 30313 | 5e075 | 1089 1089 |
| 30314 | 30314 | 59d75 | 1089 1089 |
| 30315 | 30315 | e6200 | 1089 1089 |
| 30316 | 30316 | b1201 | 1089 1089 |
| 30317 | 30317 | b322d | 1089 1089 |
| 30318 | 30318 | 487f2 | 1089 1089 |
| 30319 | 30319 | 3fbed | 1089 1089 |
| 30320 | 30320 | e128e | 1089 1089 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)