+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_log_data_source:/tablelist/okayapi_log_data_source.html


-- MySQL Table okayapi_log_data_source
-- From: OkayAPI.com
CREATE TABLE `okayapi_log_data_source` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `create_user` varchar(32) NULL COMMENT '',
    `okayapi_log_data_source_name` varchar(132) NULL COMMENT '数据源名称',
    `address` varchar(232) NULL COMMENT '数据源地址',
    `description` varchar(300) NULL COMMENT ' 描述信息',
    `create_time` varchar(32) NULL COMMENT '',
    `cluster_name` varchar(232) NULL COMMENT '',
    `driver_type` varchar(232) NULL COMMENT '数据驱动类型,有es,kafka',
    `data_type` varchar(232) NULL COMMENT '日志读取或者写入',
    `ent` varchar(132) NULL COMMENT '',
    KEY `create_user` (`create_user`),
    KEY `okayapi_log_data_source_name` (`okayapi_log_data_source_name`),
    KEY `address` (`address`),
    KEY `description` (`description`),
    KEY `create_time` (`create_time`),
    KEY `cluster_name` (`cluster_name`),
    KEY `driver_type` (`driver_type`),
    KEY `data_type` (`data_type`),
    KEY `ent` (`ent`),
    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-9 of 9 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
create_uservarchar(32)
okayapi_log_data_source_namevarchar(132)数据源名称
addressvarchar(232)数据源地址
descriptionvarchar(300) 描述信息
create_timevarchar(32)
cluster_namevarchar(232)
driver_typevarchar(232)数据驱动类型,有es,kafka
data_typevarchar(232)日志读取或者写入
entvarchar(132)

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