resource_topics
2 rows where resource_id = "rootsid"
This data as json, CSV (advanced)
| Link | rowid ▼ | resource_id | topic |
|---|---|---|---|
| 1616 | 1616 | RootsID rootsid | Products and production deployments deployments |
| 1617 | 1617 | RootsID rootsid | People and organizations roles |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE resource_topics (resource_id TEXT REFERENCES resources(id), topic TEXT REFERENCES topics(id));