+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_cloud_image_sync:/tablelist/okayapi_cloud_image_sync.html


-- MySQL Table okayapi_cloud_image_sync
-- From: OkayAPI.com
CREATE TABLE `okayapi_cloud_image_sync` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `cluster_name` varchar(100) NOT NULL COMMENT '',
    `target_cluster` varchar(100) NOT NULL COMMENT '',
    `target_registry` varchar(100) NOT NULL COMMENT '',
    `registry_group` varchar(100) NOT NULL COMMENT '',
    `version` varchar(100) NOT NULL COMMENT '版本号',
    `image_name` varchar(200) NOT NULL COMMENT '镜像名称',
    `target_entname` varchar(100) NOT NULL COMMENT '',
    `entname` varchar(100) NOT NULL COMMENT '',
    `create_time` varchar(32) NOT NULL COMMENT '创建时间',
    `create_user` varchar(32) NOT NULL COMMENT '创建用户',
    `last_modify_time` varchar(32) NOT NULL COMMENT '最近修改时间',
    `last_modify_user` varchar(32) NOT NULL COMMENT '最近修改用户',
    `description` varchar(100) NOT NULL COMMENT '备注信息',
    `approved_by` varchar(100) NOT NULL COMMENT '审批人',
    `approved_time` varchar(32) NOT NULL COMMENT '审批时间',
    `okayapi_cloud_image_sync_status` varchar(10) NOT NULL COMMENT '同步状态',
    `registry` varchar(100) NOT NULL COMMENT '',
    KEY `cluster_name` (`cluster_name`),
    KEY `target_cluster` (`target_cluster`),
    KEY `target_registry` (`target_registry`),
    KEY `registry_group` (`registry_group`),
    KEY `version` (`version`),
    KEY `image_name` (`image_name`),
    KEY `target_entname` (`target_entname`),
    KEY `entname` (`entname`),
    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 `description` (`description`),
    KEY `approved_by` (`approved_by`),
    KEY `approved_time` (`approved_time`),
    KEY `okayapi_cloud_image_sync_status` (`okayapi_cloud_image_sync_status`),
    KEY `registry` (`registry`),
    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-17 of 17 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
cluster_namevarchar(100)
target_clustervarchar(100)
target_registryvarchar(100)
registry_groupvarchar(100)
versionvarchar(100)版本号
image_namevarchar(200)镜像名称
target_entnamevarchar(100)
entnamevarchar(100)
create_timevarchar(32)创建时间
create_uservarchar(32)创建用户
last_modify_timevarchar(32)最近修改时间
last_modify_uservarchar(32)最近修改用户
descriptionvarchar(100)备注信息
approved_byvarchar(100)审批人
approved_timevarchar(32)审批时间
okayapi_cloud_image_sync_statusvarchar(10)同步状态
registryvarchar(100)

Guess You Like

MySQL Table Design okayapi_mall_ums_member_receive_address

MySQL Table Design okayapi_mall_ums_member_rule_setting

MySQL Table Design okayapi_mall_ums_member_statistics_info

MySQL Table Design okayapi_mall_ums_role_permission_relation

MySQL Table Design okayapi_hc_act_re_model

MySQL Table Design okayapi_hc_group_buy

TOP ↑