role_topics
2 rows where role = "newcomer"
This data as json, CSV (advanced)
| Link | rowid ▼ | role | topic |
|---|---|---|---|
| 1 | 1 | Newcomer newcomer | Start here start-here |
| 2 | 2 | Newcomer newcomer | Tutorials, courses and documentation sites learning |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE role_topics (role TEXT REFERENCES roles(id), topic TEXT REFERENCES topics(id));