This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 30047 | 30047 | cc5ed | 1999 1999 |
| 30048 | 30048 | d6ade | 1999 1999 |
| 30049 | 30049 | 8e7b3 | 1999 1999 |
| 30050 | 30050 | 313af | 1999 1999 |
| 30051 | 30051 | ebe26 | 1999 1999 |
| 30052 | 30052 | a0f55 | 1999 1999 |
| 30053 | 30053 | cdb88 | 1999 1999 |
| 30054 | 30054 | 371f0 | 1999 1999 |
| 30055 | 30055 | e6200 | 1999 1999 |
| 30056 | 30056 | b1201 | 1999 1999 |
| 30057 | 30057 | 902e5 | 1999 1999 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)