This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
14391 | 14391 | ec3ac | 3469 3469 |
14392 | 14392 | 371f0 | 3469 3469 |
14393 | 14393 | 5e075 | 3469 3469 |
14394 | 14394 | 59d75 | 3469 3469 |
14395 | 14395 | e6200 | 3469 3469 |
14396 | 14396 | 973a3 | 3469 3469 |
14397 | 14397 | f52db | 3469 3469 |
14398 | 14398 | e91c0 | 3469 3469 |
14399 | 14399 | 016a4 | 3469 3469 |
14400 | 14400 | 15a9f | 3469 3469 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )