This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
358 | 358 | ebcbb | 2313 2313 |
359 | 359 | 4801f | 2313 2313 |
360 | 360 | 5e075 | 2313 2313 |
361 | 361 | 59d75 | 2313 2313 |
362 | 362 | 3502d | 2313 2313 |
363 | 363 | b1201 | 2313 2313 |
364 | 364 | 18a64 | 2313 2313 |
365 | 365 | 9295b | 2313 2313 |
366 | 366 | 31177 | 2313 2313 |
367 | 367 | 7c38f | 2313 2313 |
368 | 368 | 7ee91 | 2313 2313 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )