This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
31055 | 31055 | ec3ac | 1884 1884 |
31056 | 31056 | 28d20 | 1884 1884 |
31057 | 31057 | 7ceb1 | 1884 1884 |
31058 | 31058 | 371f0 | 1884 1884 |
31059 | 31059 | 59d75 | 1884 1884 |
31060 | 31060 | 3502d | 1884 1884 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )