This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
2311 | 2311 | ec3ac | 561 561 |
2312 | 2312 | 371f0 | 561 561 |
2313 | 2313 | e6200 | 561 561 |
2314 | 2314 | b1201 | 561 561 |
2315 | 2315 | 022da | 561 561 |
2316 | 2316 | 4e13d | 561 561 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )