role_topics
3 rows where topic = "specifications"
This data as json, CSV (advanced)
| Link | rowid ▼ | role | topic |
|---|---|---|---|
| 4 | 4 | Developer developer | Specifications specifications |
| 11 | 11 | Security architect security-architect | Specifications specifications |
| 18 | 18 | Standards and policy standards-policy | Specifications specifications |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE role_topics (role TEXT REFERENCES roles(id), topic TEXT REFERENCES topics(id));