This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
32071 | 32071 | 508a5 | 57 57 |
32072 | 32072 | eaba0 | 57 57 |
32073 | 32073 | 37b6b | 57 57 |
32074 | 32074 | 40ff5 | 57 57 |
32075 | 32075 | 6fba5 | 57 57 |
32076 | 32076 | 1c31d | 57 57 |
32077 | 32077 | 5e075 | 57 57 |
32078 | 32078 | 59d75 | 57 57 |
32079 | 32079 | e6200 | 57 57 |
32080 | 32080 | b1201 | 57 57 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )