This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
32143 | 32143 | b08d4 | 103 103 |
32144 | 32144 | 74353 | 103 103 |
32145 | 32145 | 27176 | 103 103 |
32146 | 32146 | ebe26 | 103 103 |
32147 | 32147 | 371f0 | 103 103 |
32148 | 32148 | e6200 | 103 103 |
32149 | 32149 | b1201 | 103 103 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )