This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
4704 | 4704 | ec3ac | 671 671 |
4705 | 4705 | eed19 | 671 671 |
4706 | 4706 | 84f2d | 671 671 |
4707 | 4707 | 4e9d2 | 671 671 |
4708 | 4708 | 6816d | 671 671 |
4709 | 4709 | 6f57d | 671 671 |
4710 | 4710 | 0b2ab | 671 671 |
4711 | 4711 | 371f0 | 671 671 |
4712 | 4712 | 5e075 | 671 671 |
4713 | 4713 | 59d75 | 671 671 |
4714 | 4714 | e6200 | 671 671 |
4715 | 4715 | b1201 | 671 671 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )