This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
2506 | 2506 | ec3ac | 506 506 |
2507 | 2507 | 0b28b | 506 506 |
2508 | 2508 | 72f3e | 506 506 |
2509 | 2509 | 371f0 | 506 506 |
2510 | 2510 | e6200 | 506 506 |
2511 | 2511 | b1201 | 506 506 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )