resource_roles

3 rows where resource_id = "hardman-the-shape-of-delegated-authority"

✎ View and edit SQL

This data as json, CSV (advanced)

how 1

Link rowid ▼ resource_id role how
1015 1015 The Shape of Delegated Authority hardman-the-shape-of-delegated-authority Security architect security-architect derived
1016 1016 The Shape of Delegated Authority hardman-the-shape-of-delegated-authority Standards and policy standards-policy derived
1017 1017 The Shape of Delegated Authority hardman-the-shape-of-delegated-authority Researcher researcher derived

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE resource_roles (resource_id TEXT REFERENCES resources(id), role TEXT REFERENCES roles(id), how TEXT);