This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
11968 | 11968 | ec3ac | 626 626 |
11969 | 11969 | 371f0 | 626 626 |
11970 | 11970 | e6200 | 626 626 |
11971 | 11971 | b1201 | 626 626 |
11972 | 11972 | 022da | 626 626 |
11973 | 11973 | 4e13d | 626 626 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )