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