This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 10101 | 10101 | cc5ed | 1913 1913 |
| 10102 | 10102 | d1e7b | 1913 1913 |
| 10103 | 10103 | 3502d | 1913 1913 |
| 10104 | 10104 | f4d0c | 1913 1913 |
| 10105 | 10105 | bb3a2 | 1913 1913 |
| 10106 | 10106 | 2095d | 1913 1913 |
| 10107 | 10107 | ea3bd | 1913 1913 |
| 10108 | 10108 | 6db25 | 1913 1913 |
| 10109 | 10109 | 40a0a | 1913 1913 |
| 10110 | 10110 | a52bd | 1913 1913 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)