query-5b5e4e7e52166d34b999ba5d9c949d1634a227d2d40f77f81477225a15c6d5a7.json
1 { 2 "db_name": "PostgreSQL", 3 "query": "\nSELECT cs.id, cs.client_id, cs.scope as \"scope: _\", cs.created_at\nFROM client_scope cs\nJOIN user_client_consented_scope consented_scope ON consented_scope.client_scope_id = cs.id\nWHERE consented_scope.user_client_consent_id = $1\nAND cs.client_id = $2\n ", 4 "describe": { 5 "columns": [ 6 { 7 "ordinal": 0, 8 "name": "id", 9 "type_info": "Uuid" 10 }, 11 { 12 "ordinal": 1, 13 "name": "client_id", 14 "type_info": "Uuid" 15 }, 16 { 17 "ordinal": 2, 18 "name": "scope: _", 19 "type_info": { 20 "Custom": { 21 "name": "oauth_scope", 22 "kind": { 23 "Enum": [ 24 "email", 25 "openid", 26 "profile" 27 ] 28 } 29 } 30 } 31 }, 32 { 33 "ordinal": 3, 34 "name": "created_at", 35 "type_info": "Timestamptz" 36 } 37 ], 38 "parameters": { 39 "Left": [ 40 "Uuid", 41 "Uuid" 42 ] 43 }, 44 "nullable": [ 45 false, 46 false, 47 false, 48 false 49 ] 50 }, 51 "hash": "5b5e4e7e52166d34b999ba5d9c949d1634a227d2d40f77f81477225a15c6d5a7" 52 }