This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
13204 | 13204 | 810be | 564 564 |
13205 | 13205 | 2ed9b | 564 564 |
13206 | 13206 | f5b9e | 564 564 |
13207 | 13207 | eed19 | 564 564 |
13208 | 13208 | 0524b | 564 564 |
13209 | 13209 | f5427 | 564 564 |
13210 | 13210 | e6200 | 564 564 |
13211 | 13211 | b1201 | 564 564 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )