This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
15313 | 15313 | ec3ac | 255 255 |
15314 | 15314 | eaba0 | 255 255 |
15315 | 15315 | 37b6b | 255 255 |
15316 | 15316 | 40ff5 | 255 255 |
15317 | 15317 | 6fba5 | 255 255 |
15318 | 15318 | 1c31d | 255 255 |
15319 | 15319 | 5e075 | 255 255 |
15320 | 15320 | 59d75 | 255 255 |
15321 | 15321 | e6200 | 255 255 |
15322 | 15322 | b1201 | 255 255 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )