This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
12965 | 12965 | f52db | 3498 3498 |
13113 | 13113 | f52db | 3486 3486 |
13248 | 13248 | f52db | 3494 3494 |
13279 | 13279 | f52db | 3490 3490 |
14056 | 14056 | f52db | 3482 3482 |
14397 | 14397 | f52db | 3469 3469 |
14509 | 14509 | f52db | 3473 3473 |
15497 | 15497 | f52db | 3478 3478 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )