This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
14735 | 14735 | 9dc02 | 1234 1234 |
14736 | 14736 | 4a08c | 1234 1234 |
14737 | 14737 | 5e075 | 1234 1234 |
14738 | 14738 | 59d75 | 1234 1234 |
14739 | 14739 | e6200 | 1234 1234 |
14740 | 14740 | b1201 | 1234 1234 |
14741 | 14741 | 9faf6 | 1234 1234 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )