This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
12416 | 12416 | ec3ac | 72 72 |
12417 | 12417 | 74353 | 72 72 |
12418 | 12418 | 37b6b | 72 72 |
12419 | 12419 | 40ff5 | 72 72 |
12420 | 12420 | 6fba5 | 72 72 |
12421 | 12421 | 1c31d | 72 72 |
12422 | 12422 | 5e075 | 72 72 |
12423 | 12423 | 59d75 | 72 72 |
12424 | 12424 | e6200 | 72 72 |
12425 | 12425 | 5bb13 | 72 72 |
12426 | 12426 | b1201 | 72 72 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )