resource_roles
3 rows where resource_id = "hardman-canonical-quoted-text-cqt"
This data as json, CSV (advanced)
role 3
how 1
- derived 3
| Link | rowid ▼ | resource_id | role | how |
|---|---|---|---|---|
| 1086 | 1086 | Canonical Quoted Text (CQT) hardman-canonical-quoted-text-cqt | Developer developer | derived |
| 1087 | 1087 | Canonical Quoted Text (CQT) hardman-canonical-quoted-text-cqt | Security architect security-architect | derived |
| 1088 | 1088 | Canonical Quoted Text (CQT) hardman-canonical-quoted-text-cqt | Standards and policy standards-policy | derived |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE resource_roles (resource_id TEXT REFERENCES resources(id), role TEXT REFERENCES roles(id), how TEXT);