+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_log_show_filter:/tablelist/okayapi_log_show_filter.html


-- MySQL Table okayapi_log_show_filter
-- From: OkayAPI.com
CREATE TABLE `okayapi_log_show_filter` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `appname` varchar(232) NULL COMMENT '',
    `env` varchar(32) NULL COMMENT '',
    `hostname` varchar(232) NULL COMMENT '',
    `ip` varchar(32) NULL COMMENT '',
    `create_time` varchar(32) NULL COMMENT '',
    `create_user` varchar(32) NULL COMMENT '',
    `okayapi_log_show_filter_query` varchar(240) NULL COMMENT '',
    `click` int(11) NULL COMMENT '',
    KEY `appname` (`appname`),
    KEY `env` (`env`),
    KEY `hostname` (`hostname`),
    KEY `ip` (`ip`),
    KEY `create_time` (`create_time`),
    KEY `create_user` (`create_user`),
    KEY `okayapi_log_show_filter_query` (`okayapi_log_show_filter_query`),
    KEY `click` (`click`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'k8s管理-IP显示过滤';

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


MySQL database table structure design

Displaying 1-8 of 8 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
appnamevarchar(232)Normal Index
envvarchar(32)
hostnamevarchar(232)
ipvarchar(32)
create_timevarchar(32)
create_uservarchar(32)
okayapi_log_show_filter_queryvarchar(240)
clickint(11)

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_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

MySQL Table Design okayapi_cloud_cluster

TOP ↑