This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
1752 | 1752 | a2b0d | 2983 2983 |
2187 | 2187 | a2b0d | 2982 2982 |
6830 | 6830 | a2b0d | 2980 2980 |
7651 | 7651 | a2b0d | 2981 2981 |
19341 | 19341 | a2b0d | 3393 3393 |
29511 | 29511 | a2b0d | 2984 2984 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )