+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_cloud_user_perm_detail:/tablelist/okayapi_cloud_user_perm_detail.html


-- MySQL Table okayapi_cloud_user_perm_detail
-- From: OkayAPI.com
CREATE TABLE `okayapi_cloud_user_perm_detail` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `username` varchar(100) NULL COMMENT '',
    `resource_type` varchar(100) NULL COMMENT '',
    `group_name` varchar(200) NULL COMMENT '',
    `okayapi_cloud_user_perm_detail_name` varchar(200) NULL COMMENT '',
    `cluster_name` varchar(200) NULL COMMENT '',
    `ent` varchar(200) NULL COMMENT '',
    KEY `username` (`username`),
    KEY `resource_type` (`resource_type`),
    KEY `group_name` (`group_name`),
    KEY `okayapi_cloud_user_perm_detail_name` (`okayapi_cloud_user_perm_detail_name`),
    KEY `cluster_name` (`cluster_name`),
    KEY `ent` (`ent`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'k8s管理-用户证书详情';

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


MySQL database table structure design

Displaying 1-6 of 6 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
usernamevarchar(100)
resource_typevarchar(100)
group_namevarchar(200)
okayapi_cloud_user_perm_detail_namevarchar(200)
cluster_namevarchar(200)
entvarchar(200)

Guess You Like

MySQL Table Design okayapi_cloud_api_resource

MySQL Table Design okayapi_cloud_app

MySQL Table Design okayapi_cloud_app_configure

MySQL Table Design okayapi_cloud_app_service

MySQL Table Design okayapi_log_show_appname

MySQL Table Design okayapi_log_show_ip

MySQL Table Design okayapi_log_show_filter

MySQL Table Design okayapi_log_data_source

MySQL Table Design okayapi_log_show_history

MySQL Table Design okayapi_cloud_app_template

MySQL Table Design okayapi_cloud_authority_user

MySQL Table Design okayapi_cloud_auto_scale

MySQL Table Design okayapi_cloud_auto_scale_log

MySQL Table Design okayapi_cloud_build_job

MySQL Table Design okayapi_cloud_build_job_history

MySQL Table Design okayapi_cloud_ci_dockerfile

MySQL Table Design okayapi_cloud_ci_perm

MySQL Table Design okayapi_cloud_ci_release_history

MySQL Table Design okayapi_cloud_ci_release_log

MySQL Table Design okayapi_cloud_ci_service

TOP ↑