This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
10106 | 10106 | 2095d | 1913 1913 |
11948 | 11948 | 2095d | 1947 1947 |
12334 | 12334 | 2095d | 1937 1937 |
13096 | 13096 | 2095d | 34 34 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )