This data as JSON, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36014 | 36014 | bbd8e | 3513 3513 |
| 36028 | 36028 | bbd8e | 3509 3509 |
| 36051 | 36051 | bbd8e | 3508 3508 |
| 36072 | 36072 | bbd8e | 3510 3510 |
| 36095 | 36095 | bbd8e | 3514 3514 |
| 36155 | 36155 | bbd8e | 3512 3512 |
| 36169 | 36169 | bbd8e | 3506 3506 |
| 36297 | 36297 | bbd8e | 3507 3507 |
| 36311 | 36311 | bbd8e | 3511 3511 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)