MySQL Create Table SQL
Table Structure: okayapi_cloud_image:/tablelist/okayapi_cloud_image.html
-- MySQL Table okayapi_cloud_image
-- From: OkayAPI.com
CREATE TABLE `okayapi_cloud_image` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`create_time` varchar(32) NULL COMMENT '创建时间',
`create_user` varchar(32) NULL COMMENT '创建用户',
`size` int(11) NULL COMMENT '镜像大小',
`okayapi_cloud_image_name` varchar(100) NULL COMMENT '镜像名称',
`repositories` varchar(100) NULL COMMENT '所属仓库',
`repositories_group` varchar(100) NULL COMMENT '镜像仓库组',
`image_type` varchar(20) NULL COMMENT '镜像类型,分为共有和私有',
`tag_number` int(11) NULL COMMENT '版本数量',
`access` varchar(100) NULL COMMENT '访问方式',
`layers_number` int(11) NULL COMMENT '镜像层数',
`tags` text NULL COMMENT '',
`download` int(11) NULL COMMENT '下载次数',
KEY `create_time` (`create_time`),
KEY `create_user` (`create_user`),
KEY `size` (`size`),
KEY `okayapi_cloud_image_name` (`okayapi_cloud_image_name`),
KEY `repositories` (`repositories`),
KEY `repositories_group` (`repositories_group`),
KEY `image_type` (`image_type`),
KEY `tag_number` (`tag_number`),
KEY `access` (`access`),
KEY `layers_number` (`layers_number`),
KEY `tags` (`tags`),
KEY `download` (`download`),
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-12 of 12 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
create_time | varchar(32) | 是 | 创建时间 | |||
create_user | varchar(32) | 是 | 创建用户 | |||
size | int(11) | 是 | 镜像大小 | |||
okayapi_cloud_image_name | varchar(100) | 是 | 镜像名称 | |||
repositories | varchar(100) | 是 | 所属仓库 | |||
repositories_group | varchar(100) | 是 | 镜像仓库组 | |||
image_type | varchar(20) | 是 | 镜像类型,分为共有和私有 | |||
tag_number | int(11) | 是 | 版本数量 | |||
access | varchar(100) | 是 | 访问方式 | |||
layers_number | int(11) | 是 | 镜像层数 | |||
tags | text | 是 | ||||
download | int(11) | 是 | 下载次数 |