This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
6902 | 6902 | 662b5 | 2976 2976 |
7028 | 7028 | 662b5 | 2978 2978 |
7095 | 7095 | 662b5 | 2979 2979 |
7227 | 7227 | 662b5 | 2977 2977 |
7549 | 7549 | 662b5 | 2975 2975 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )