This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
4733 | 4733 | ec3ac | 670 670 |
4734 | 4734 | eed19 | 670 670 |
4735 | 4735 | 84f2d | 670 670 |
4736 | 4736 | 0b2ab | 670 670 |
4737 | 4737 | 371f0 | 670 670 |
4738 | 4738 | 5e075 | 670 670 |
4739 | 4739 | 59d75 | 670 670 |
4740 | 4740 | e6200 | 670 670 |
4741 | 4741 | b1201 | 670 670 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )