home / kskb

resource_roles

3 rows where resource_id = "hardman-canonical-quoted-text-cqt"

✎ View and edit SQL

This data as json, CSV (advanced)

role 3

  • Developer 1
  • Security architect 1
  • Standards and policy 1

how 1

  • derived 3
Link rowid ▼ resource_id role how
1086 1086 Canonical Quoted Text (CQT) hardman-canonical-quoted-text-cqt Developer developer derived
1087 1087 Canonical Quoted Text (CQT) hardman-canonical-quoted-text-cqt Security architect security-architect derived
1088 1088 Canonical Quoted Text (CQT) hardman-canonical-quoted-text-cqt Standards and policy standards-policy 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);
Powered by Datasette · Queries took 203.124ms