This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
10203 | 10203 | 77d5d | 487 487 |
10204 | 10204 | 7b150 | 487 487 |
10205 | 10205 | 5e075 | 487 487 |
10206 | 10206 | 59d75 | 487 487 |
10207 | 10207 | e6200 | 487 487 |
10208 | 10208 | b1201 | 487 487 |
10209 | 10209 | 201fd | 487 487 |
10210 | 10210 | 326e8 | 487 487 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )