This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
995 | 995 | 6a9d7 | 3007 3007 |
5126 | 5126 | 6a9d7 | 3003 3003 |
5677 | 5677 | 6a9d7 | 3002 3002 |
5931 | 5931 | 6a9d7 | 3004 3004 |
6251 | 6251 | 6a9d7 | 3005 3005 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )