This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 31514 | 31514 | cc5ed | 1810 1810 |
| 31515 | 31515 | 0771c | 1810 1810 |
| 31516 | 31516 | cf58f | 1810 1810 |
| 31517 | 31517 | c3e59 | 1810 1810 |
| 31518 | 31518 | 46069 | 1810 1810 |
| 31519 | 31519 | 5e998 | 1810 1810 |
| 31520 | 31520 | e6200 | 1810 1810 |
| 31521 | 31521 | b1201 | 1810 1810 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)