This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
2416 | 2416 | 6d4d3 | 1584 1584 |
2439 | 2439 | 6d4d3 | 1576 1576 |
2675 | 2675 | 6d4d3 | 1600 1600 |
2840 | 2840 | 6d4d3 | 1604 1604 |
2969 | 2969 | 6d4d3 | 1588 1588 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )