This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
14226 | 14226 | e092b | 67 67 |
14227 | 14227 | 62d50 | 67 67 |
14228 | 14228 | 5e075 | 67 67 |
14229 | 14229 | 59d75 | 67 67 |
14230 | 14230 | e6200 | 67 67 |
14231 | 14231 | b1201 | 67 67 |
14232 | 14232 | 49139 | 67 67 |
14233 | 14233 | 40b91 | 67 67 |
14234 | 14234 | d75c0 | 67 67 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )