resource_roles

4 rows where resource_id = "kerione-definitely-identity-episode-14-with-sam-smith"

✎ View and edit SQL

This data as json, CSV (advanced)

how 1

Link rowid ▼ resource_id role how
539 539 Definitely Identity Episode 14 with Sam Smith kerione-definitely-identity-episode-14-with-sam-smith Newcomer newcomer derived
540 540 Definitely Identity Episode 14 with Sam Smith kerione-definitely-identity-episode-14-with-sam-smith Product owner or designer product derived
541 541 Definitely Identity Episode 14 with Sam Smith kerione-definitely-identity-episode-14-with-sam-smith Marketing and communications communications derived
542 542 Definitely Identity Episode 14 with Sam Smith kerione-definitely-identity-episode-14-with-sam-smith 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);