This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
3800 | 3800 | ec3ac | 448 448 |
3801 | 3801 | 371f0 | 448 448 |
3802 | 3802 | e6200 | 448 448 |
3803 | 3803 | b1201 | 448 448 |
3804 | 3804 | 0aa7f | 448 448 |
3805 | 3805 | eb159 | 448 448 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )