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