This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
13830 | 13830 | ec3ac | 306 306 |
13831 | 13831 | eaba0 | 306 306 |
13832 | 13832 | 37b6b | 306 306 |
13833 | 13833 | 40ff5 | 306 306 |
13834 | 13834 | 6fba5 | 306 306 |
13835 | 13835 | 1c31d | 306 306 |
13836 | 13836 | 5e075 | 306 306 |
13837 | 13837 | 59d75 | 306 306 |
13838 | 13838 | e6200 | 306 306 |
13839 | 13839 | b1201 | 306 306 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )