+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_qi_ace_sys_oauth_client_details:/tablelist/okayapi_qi_ace_sys_oauth_client_details.html


-- MySQL Table okayapi_qi_ace_sys_oauth_client_details
-- From: OkayAPI.com
CREATE TABLE `okayapi_qi_ace_sys_oauth_client_details` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `client_id` varchar(32) NULL COMMENT '',
    `resource_ids` varchar(256) NULL COMMENT '',
    `client_secret` varchar(256) NULL COMMENT '',
    `scope` varchar(256) NULL COMMENT '',
    `authorized_grant_types` varchar(256) NULL COMMENT '',
    `web_server_redirect_uri` varchar(256) NULL COMMENT '',
    `authorities` varchar(256) NULL COMMENT '',
    `access_token_validity` int(11) NULL COMMENT '',
    `refresh_token_validity` int(11) NULL COMMENT '',
    `additional_information` varchar(4096) NULL COMMENT '',
    `autoapprove` varchar(256) NULL COMMENT '',
    KEY `client_id` (`client_id`),
    KEY `resource_ids` (`resource_ids`),
    KEY `client_secret` (`client_secret`),
    KEY `scope` (`scope`),
    KEY `authorized_grant_types` (`authorized_grant_types`),
    KEY `web_server_redirect_uri` (`web_server_redirect_uri`),
    KEY `authorities` (`authorities`),
    KEY `access_token_validity` (`access_token_validity`),
    KEY `refresh_token_validity` (`refresh_token_validity`),
    KEY `additional_information` (`additional_information`),
    KEY `autoapprove` (`autoapprove`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'qi后台管理系统-终端信息表';

After replication, you can go to the database to create the database table.


MySQL database table structure design

Displaying 1-11 of 11 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
client_idvarchar(32)
resource_idsvarchar(256)
client_secretvarchar(256)
scopevarchar(256)
authorized_grant_typesvarchar(256)
web_server_redirect_urivarchar(256)
authoritiesvarchar(256)
access_token_validityint(11)
refresh_token_validityint(11)
additional_informationvarchar(4096)
autoapprovevarchar(256)

Guess You Like

MySQL Table Design okayapi_qi_ace_sys_dept_relation

MySQL Table Design okayapi_qi_ace_sys_role_menu

MySQL Table Design okayapi_qi_ace_base_group

MySQL Table Design okayapi_qi_ace_base_group_leader

MySQL Table Design okayapi_qi_ace_base_group_member

MySQL Table Design okayapi_qi_ace_base_group_type

MySQL Table Design okayapi_qi_ace_base_menu

MySQL Table Design okayapi_qi_ace_base_resource_authority

MySQL Table Design okayapi_qi_ace_base_user

MySQL Table Design okayapi_qi_ace_gate_log

MySQL Table Design okayapi_qi_ace_auth_client

MySQL Table Design okayapi_qi_ace_auth_client_service

MySQL Table Design okayapi_qi_ace_sys_dict

MySQL Table Design okayapi_qi_ace_sys_dict_item

MySQL Table Design okayapi_qi_ace_sys_log

MySQL Table Design okayapi_qi_ace_sys_menu

TOP ↑