This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
2297 | 2297 | ec3ac | 436 436 |
2298 | 2298 | 371f0 | 436 436 |
2299 | 2299 | e6200 | 436 436 |
2300 | 2300 | b1201 | 436 436 |
2301 | 2301 | 0aa7f | 436 436 |
2302 | 2302 | eb159 | 436 436 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )