resource_roles

2 rows where resource_id = "hardman-security-silos-and-sovereignty"

✎ View and edit SQL

This data as json, CSV (advanced)

how 1

Link rowid ▼ resource_id role how
1044 1044 Security, Silos, and Sovereignty hardman-security-silos-and-sovereignty Marketing and communications communications derived
1045 1045 Security, Silos, and Sovereignty hardman-security-silos-and-sovereignty 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);