Icehouse版keystone数据库结构
时间：2022-03-10 18:01
在安装完keystone并利用keystone-manage命令同步数据库后，mysql（我使用的存储后端）中新加了如下表：
assignment:
type enum(‘UserProject‘,‘GroupProject‘,‘UserDomain‘,‘GroupDomain‘) actor_id varchar(64) target_id varchar(64) role_id varchar(64) inherited tinyint(1)
credential:
id varchar(64) user_id varchar(64) project_id varchar(64) blob text type varchar(255) extra text
domain:
id varchar(64) name varchar(64) enabled tinyint(1) extra text
endpoint
id varchar(64) legacy_endpoint_id varchar(64) interface varchar(8) region varchar(255) service_id varchar(64) url text extra text enabled tinyint(1)
federation_protocol:
id varchar(64) idp_id varchar(64) mapping_id varchar(64)
group:
不知道为什么这张表始终无法查看，是因为与mysql系统关键字重复了吗？
identity_provider:
id varchar(64)
enabled tinyint(1)
description text
mapping:
id varchar(64) rules text
migrate_version
repository_id varchar(250) repository_path text version int(11)
policy:
id varchar(64) type varchar(255) blob text extra text
project
id varchar(64) name varchar(64) extra text description text enabled tinyint(1) domain_id varchar(64)
region:
id varchar(64) description varchar(255) parent_region_id varchar(64) extra text
role:
id varchar(64) name varchar(255) extra text
service
id varchar(64) type varchar(255) extra mediumtext enabled tinyint(1)
token:
id varchar(64) expires datetime extra mediumtext valid tinyint(1) trust_id varchar(64) user_id varchar(64)
trust
id varchar(64) trustor_user_id varchar(64) trustee_user_id varchar(64) project_id varchar(64) impersonation tinyint(1) deleted_at datetime expires_at datetime extra text remaining_uses int(11)
trust_role
trust_id varchar(64) role_id varchar(64)
user:
id varchar(64) name varchar(255) extra ` text password varchar(128) enabled tinyint(1) domian_id varchar(64) default_project_id varchar(64)
user_group_membership:
user_id varchar(64) group_id varchar(64)
Icehouse版keystone数据库结构,布布扣,bubuko.com
