This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
13003 | 13003 | a8add | 1331 1331 |
14080 | 14080 | a8add | 1312 1312 |
15116 | 15116 | a8add | 1289 1289 |
15243 | 15243 | a8add | 1274 1274 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )