This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
997 | 997 | 466b8 | 3007 3007 |
5679 | 5679 | 466b8 | 3002 3002 |
6004 | 6004 | 466b8 | 3006 3006 |
16463 | 16463 | 466b8 | 3000 3000 |
36236 | 36236 | 466b8 | 2999 2999 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )