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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
client_id | varchar(32) | 否 | ||||
resource_ids | varchar(256) | 是 | ||||
client_secret | varchar(256) | 是 | ||||
scope | varchar(256) | 是 | ||||
authorized_grant_types | varchar(256) | 是 | ||||
web_server_redirect_uri | varchar(256) | 是 | ||||
authorities | varchar(256) | 是 | ||||
access_token_validity | int(11) | 是 | ||||
refresh_token_validity | int(11) | 是 | ||||
additional_information | varchar(4096) | 是 | ||||
autoapprove | varchar(256) | 是 |