This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 710 | 710 | afc04 | 1095 1095 |
| 5524 | 5524 | afc04 | 1140 1140 |
| 6387 | 6387 | afc04 | 1136 1136 |
| 7681 | 7681 | afc04 | 1087 1087 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)