resource_roles
3 rows where resource_id = "cesr-spec"
This data as json, CSV (advanced)
role 3
how 1
- derived 3
| Link | rowid ▼ | resource_id | role | how |
|---|---|---|---|---|
| 7 | 7 | CESR specification v1.0 cesr-spec | Developer developer | derived |
| 8 | 8 | CESR specification v1.0 cesr-spec | Security architect security-architect | derived |
| 9 | 9 | CESR specification v1.0 cesr-spec | 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);