This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
12014 | 12014 | e5ea3 | 1310 1310 |
12015 | 12015 | ea4d7 | 1310 1310 |
12016 | 12016 | 13800 | 1310 1310 |
12017 | 12017 | 5e075 | 1310 1310 |
12018 | 12018 | 59d75 | 1310 1310 |
12019 | 12019 | b1201 | 1310 1310 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )