This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
994 | 994 | 4d5c2 | 3007 3007 |
5676 | 5676 | 4d5c2 | 3002 3002 |
6003 | 6003 | 4d5c2 | 3006 3006 |
16461 | 16461 | 4d5c2 | 3000 3000 |
36234 | 36234 | 4d5c2 | 2999 2999 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )