This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
3757 | 3757 | 1ef30 | 54 54 |
3758 | 3758 | c448c | 54 54 |
3759 | 3759 | 69e43 | 54 54 |
3760 | 3760 | 18d8d | 54 54 |
3761 | 3761 | 6fba5 | 54 54 |
3762 | 3762 | 371f0 | 54 54 |
3763 | 3763 | 5e075 | 54 54 |
3764 | 3764 | 59d75 | 54 54 |
3765 | 3765 | e6200 | 54 54 |
3766 | 3766 | b1201 | 54 54 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )