This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
122 | 122 | a94d7 | 475 475 |
31944 | 31944 | a94d7 | 1934 1934 |
34616 | 34616 | a94d7 | 1910 1910 |
35416 | 35416 | a94d7 | 1911 1911 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )