resource_roles

4 rows where resource_id = "papers-revocation"

✎ View and edit SQL

This data as json, CSV (advanced)

how 1

Link rowid ▼ resource_id role how
978 978 Revocation papers-revocation Security architect security-architect derived
979 979 Revocation papers-revocation Standards and policy standards-policy derived
980 980 Revocation papers-revocation Business development business-development derived
981 981 Revocation papers-revocation 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);