This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
34646 | 34646 | ac298 | 1784 1784 |
34750 | 34750 | ac298 | 1840 1840 |
34864 | 34864 | ac298 | 1838 1838 |
34894 | 34894 | ac298 | 1837 1837 |
34907 | 34907 | ac298 | 1839 1839 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )