This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
32735 | 32735 | 305fb | 42 42 |
32736 | 32736 | 371f0 | 42 42 |
32737 | 32737 | 3502d | 42 42 |
32738 | 32738 | 7a98f | 42 42 |
32739 | 32739 | e1eaa | 42 42 |
32740 | 32740 | 7dde7 | 42 42 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )