+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_cloud_cluster_hosts:/tablelist/okayapi_cloud_cluster_hosts.html


-- MySQL Table okayapi_cloud_cluster_hosts
-- From: OkayAPI.com
CREATE TABLE `okayapi_cloud_cluster_hosts` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `host_ip` varchar(32) NULL COMMENT '主机IP',
    `host_label` varchar(100) NULL COMMENT '主机标签',
    `okayapi_cloud_cluster_hosts_status` varchar(10) NULL COMMENT '状态',
    `create_method` varchar(32) NULL COMMENT '创建方法',
    `pod_num` int(11) NULL COMMENT 'pod数量',
    `cpu_num` int(11) NULL COMMENT 'cpu数量',
    `mem_size` varchar(32) NULL COMMENT '内存大小',
    `host_type` varchar(32) NULL COMMENT '主机类型',
    `create_time` varchar(32) NULL COMMENT '创建时间',
    `create_user` varchar(32) NULL COMMENT '创建用户',
    `last_modify_time` varchar(32) NULL COMMENT '最近修改时间',
    `last_modify_user` varchar(32) NULL COMMENT '最近修改时间',
    `is_valid` int(11) NULL COMMENT '是否有效',
    `container_num` int(11) NULL COMMENT '容器数量',
    `mem_free` varchar(32) NULL COMMENT '内存剩余量',
    `cpu_free` varchar(32) NULL COMMENT 'cpu剩余量',
    `mem_percent` varchar(10) NULL COMMENT '内使用百分比',
    `cpu_percent` varchar(10) NULL COMMENT 'cpu使用百分比',
    `cluster_name` varchar(36) NULL COMMENT '所属集群',
    `api_port` varchar(8) NULL DEFAULT '0' COMMENT 'k8s集群api端口',
    `image_num` int(11) NULL COMMENT '',
    KEY `host_ip` (`host_ip`),
    KEY `host_label` (`host_label`),
    KEY `okayapi_cloud_cluster_hosts_status` (`okayapi_cloud_cluster_hosts_status`),
    KEY `create_method` (`create_method`),
    KEY `pod_num` (`pod_num`),
    KEY `cpu_num` (`cpu_num`),
    KEY `mem_size` (`mem_size`),
    KEY `host_type` (`host_type`),
    KEY `create_time` (`create_time`),
    KEY `create_user` (`create_user`),
    KEY `last_modify_time` (`last_modify_time`),
    KEY `last_modify_user` (`last_modify_user`),
    KEY `is_valid` (`is_valid`),
    KEY `container_num` (`container_num`),
    KEY `mem_free` (`mem_free`),
    KEY `cpu_free` (`cpu_free`),
    KEY `mem_percent` (`mem_percent`),
    KEY `cpu_percent` (`cpu_percent`),
    KEY `cluster_name` (`cluster_name`),
    KEY `api_port` (`api_port`),
    KEY `image_num` (`image_num`),
    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-21 of 21 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
host_ipvarchar(32)主机IPNormal Index
host_labelvarchar(100)主机标签
okayapi_cloud_cluster_hosts_statusvarchar(10)状态
create_methodvarchar(32)创建方法
pod_numint(11)pod数量
cpu_numint(11)cpu数量
mem_sizevarchar(32)内存大小
host_typevarchar(32)主机类型
create_timevarchar(32)创建时间
create_uservarchar(32)创建用户
last_modify_timevarchar(32)最近修改时间
last_modify_uservarchar(32)最近修改时间
is_validint(11)是否有效
container_numint(11)容器数量
mem_freevarchar(32)内存剩余量
cpu_freevarchar(32)cpu剩余量
mem_percentvarchar(10)内使用百分比
cpu_percentvarchar(10)cpu使用百分比
cluster_namevarchar(36)所属集群
api_portvarchar(8)0k8s集群api端口0
image_numint(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_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 ↑