This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
31374 | 31374 | ec3ac | 56 56 |
31375 | 31375 | eaba0 | 56 56 |
31376 | 31376 | 37b6b | 56 56 |
31377 | 31377 | 40ff5 | 56 56 |
31378 | 31378 | 6fba5 | 56 56 |
31379 | 31379 | 1c31d | 56 56 |
31380 | 31380 | 5e075 | 56 56 |
31381 | 31381 | 59d75 | 56 56 |
31382 | 31382 | e6200 | 56 56 |
31383 | 31383 | b1201 | 56 56 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )