This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
34647 | 34647 | 10832 | 1784 1784 |
34751 | 34751 | 10832 | 1840 1840 |
34865 | 34865 | 10832 | 1838 1838 |
34895 | 34895 | 10832 | 1837 1837 |
34908 | 34908 | 10832 | 1839 1839 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )