Icehouse Version Keystone Database structure

After installing Keystone and synchronizing the database with the Keystone-manage command, MySQL (the storage backend I used) added the following table:

Assignment:

Type         enum ('userproject','groupproject',' UserDomain ','groupdomain') actor_id     varchar (+) target_id    varchar (role_id)      varchar (inherited    ) tinyint (1)

Credential:

ID           varchar (user_id)      varchar(project_id   ) varchar (+) Blob         texttype         varchar (255) extra        text

Domain

ID          varchar (+) name        varchar (1)enabled     tinyint ) Extra       text

Endpoint

ID                    varchar (legacy_endpoint_id)    varchar(             interface)varchar (8  ) Region                varchar (255) service_id            varchar (+) URL                   Textextra                 textenabled               tinyint (1)

Federation_protocol:

ID            varchar (idp_id)        varchar(mapping_id    ) varchar (+)

Group

Do not know why this table is always unable to view, because the MySQL system keyword is repeated?

Identity_provider:

ID             varchar (64)
Enabled        tinyint (1)
Description    Text

Mapping

ID        varchar (+) Rules     text

Migrate_version

repository_id      varchar (repository_path)    textversion            int(one)

Policy

ID       varchar (+) type     varchar (255) blob     textextra    text

Project

ID            varchar (+) name          varchar (extra)         textdescription   textenabled       tinyint (1) domain_id     varchar (+)

Region

ID                  varchar (description         )varchar (255) parent_region_id    varchar (  () extra               text

Role

ID        varchar (+) name      varchar (255) extra     text

Service

ID        varchar (+) type      varchar (255) extra     mediumtextenabled   tinyint (1)

Token

ID          varchar (expires)     Datetimeextra       mediumtextvalid       tinyint (1) trust_id    varchar (user_id)     varchar (+)

Trust

ID                 varchar (trustor_user_id    ) varchar (trustee_user_id     ) varchar ( ) project_id         varchar (impersonation)      tinyint (1  ) deleted_at         datetimeexpires_at         datetimeextra              textremaining_uses     int(  one)

Trust_role

trust_id        varchar (role_id)         varchar (64)

User

ID                    varchar (+) name                  varchar (255) extra    '            textpassword              varchar (  - ) enabled               tinyint (1) domian_id             varchar (default_) project_id    varchar (+)

User_group_membership:

user_id              varchar (group_id)             varchar (+)