This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
12034 | 12034 | cd0d0 | 694 694 |
13253 | 13253 | cd0d0 | 696 696 |
14061 | 14061 | cd0d0 | 695 695 |
14869 | 14869 | cd0d0 | 697 697 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )