This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
33019 | 33019 | ec3ac | 1555 1555 |
33020 | 33020 | 371f0 | 1555 1555 |
33021 | 33021 | e6200 | 1555 1555 |
33022 | 33022 | b1201 | 1555 1555 |
33023 | 33023 | e650b | 1555 1555 |
33024 | 33024 | 7b676 | 1555 1555 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )