This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
8789 | 8789 | 37701 | 1899 1899 |
8808 | 8808 | 37701 | 1898 1898 |
33514 | 33514 | 37701 | 1918 1918 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )