This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
16235 | 16235 | cc5ed | 3265 3265 |
16236 | 16236 | 371f0 | 3265 3265 |
16237 | 16237 | e6200 | 3265 3265 |
16238 | 16238 | b1201 | 3265 3265 |
16239 | 16239 | 6ec75 | 3265 3265 |
16240 | 16240 | a1307 | 3265 3265 |
16241 | 16241 | 77d7e | 3265 3265 |
16242 | 16242 | e5437 | 3265 3265 |
16243 | 16243 | 1fd76 | 3265 3265 |
16244 | 16244 | 4096e | 3265 3265 |
16245 | 16245 | 27369 | 3265 3265 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )