This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
9839 | 9839 | 9181f | 1081 1081 |
9840 | 9840 | e69ef | 1081 1081 |
9841 | 9841 | 5e075 | 1081 1081 |
9842 | 9842 | 59d75 | 1081 1081 |
9843 | 9843 | b1201 | 1081 1081 |
9844 | 9844 | c9d7f | 1081 1081 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )