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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
username | varchar(100) | 是 | ||||
resource_type | varchar(100) | 是 | ||||
group_name | varchar(200) | 是 | ||||
okayapi_cloud_user_perm_detail_name | varchar(200) | 是 | ||||
cluster_name | varchar(200) | 是 | ||||
ent | varchar(200) | 是 |