resource_roles

3 rows where resource_id = "iiw-29"

✎ View and edit SQL

This data as json, CSV (advanced)

how 1

Link rowid ▼ resource_id role how
1322 1322 IIW 29 (Fall 2019, 1 to 3 October 2019, Mountain View) iiw-29 Marketing and communications communications derived
1323 1323 IIW 29 (Fall 2019, 1 to 3 October 2019, Mountain View) iiw-29 Business development business-development derived
1324 1324 IIW 29 (Fall 2019, 1 to 3 October 2019, Mountain View) iiw-29 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);