Icehouse版keystone数据库结构

  在安装完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

Icehouse版keystone数据库结构

上一篇:oracle 判断中文函数


下一篇:查询sybase DB中占用空间最多的前20张表