keycloak

Tables (8)

associated_policy (정책(policy)-권한(permission) mapping)

  • policy_id (권한 (permission) id) — varchar(36) — Foreign key → resource_server_policy.id — NOT NULL
  • associated_policy_id (정책 (policy) id) — varchar(36) — Foreign key → resource_server_policy.id — NOT NULL

keycloak_role (role 정보)

  • id — varchar(36) — Primary key — NOT NULL
  • client_role (client role 여부) — bit(1)
  • name (role name) — varchar(255)
  • description (role description) — varchar(255)
  • realm_id — varchar(255)
  • client (client 의 key(id)) — varchar(36)

policy_config (Authorization-정책/권한의 상세 설정)

  • policy_id (resource_server_policy.id) — varchar(36) — Foreign key → resource_server_policy.id — NOT NULL
  • name (설정 name (type)) — varchar(255)
  • value (설정 상세 값) — longtext

resource_scope (resource-scope mapping)

  • resource_id (resource id) — varchar(36) — Foreign key → resource_server_resource.id — NOT NULL
  • scope_id (scope id) — varchar(36) — Foreign key → resource_server_scope.id — NOT NULL

resource_server_policy (Authorization-정책 및 권한)

  • id — varchar(36) — Primary key — NOT NULL
  • name (정책/권한 이름) — varchar(255)
  • description (정책/권한 description) — varchar(255)
  • type — varchar(255)
  • resource_server_id (client 의 key(id)) — varchar(36)

resource_server_resource (Authorization-resource 정보)

  • id — varchar(36) — Primary key — NOT NULL
  • name (resource name) — varchar(255)
  • type (resource type) — varchar(255)
  • resource_server_id (client 의 key(id)) — varchar(36)
  • display_name (resource display_name) — varchar(varchar(255)

resource_server_scope (Authorization-scope 정보)

  • id — varchar(36) — Primary key — NOT NULL
  • name (scope name) — varchar(255)
  • resource_server_id (client 의 key(id)) — varchar(36)
  • display_name (resource display_name) — varchar(varchar(255)

resource_uris (Authorization-resource uri 정보)

  • value (uri value) — varchar(255) — Primary key — NOT NULL
  • reseource_id (resource id) — varchar(36) — Foreign key → resource_server_resource.id — NOT NULL