+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_cloud_oper_log:/tablelist/okayapi_cloud_oper_log.html


-- MySQL Table okayapi_cloud_oper_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_cloud_oper_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_cloud_oper_log_time` varchar(32) NULL COMMENT '操作时间',
    `okayapi_cloud_oper_log_user` varchar(32) NULL COMMENT '操作用户',
    `messages` text NULL COMMENT '操作信息',
    `cluster` varchar(200) NULL COMMENT '在哪个集群操作的',
    `ip` varchar(32) NULL COMMENT '操作IP地址',
    KEY `okayapi_cloud_oper_log_time` (`okayapi_cloud_oper_log_time`),
    KEY `okayapi_cloud_oper_log_user` (`okayapi_cloud_oper_log_user`),
    KEY `messages` (`messages`),
    KEY `cluster` (`cluster`),
    KEY `ip` (`ip`),
    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-5 of 5 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
okayapi_cloud_oper_log_timevarchar(32)操作时间
okayapi_cloud_oper_log_uservarchar(32)操作用户
messagestext操作信息
clustervarchar(200)在哪个集群操作的
ipvarchar(32)操作IP地址

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 ↑