This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
31094 | 31094 | ec3ac | 1875 1875 |
31095 | 31095 | 20c2b | 1875 1875 |
31096 | 31096 | e5c56 | 1875 1875 |
31097 | 31097 | 83532 | 1875 1875 |
31098 | 31098 | 6f57d | 1875 1875 |
31099 | 31099 | 371f0 | 1875 1875 |
31100 | 31100 | 59d75 | 1875 1875 |
31101 | 31101 | 3502d | 1875 1875 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )